Overall Satisfaction with Oracle Autonomous Database
Oracle Autonomous Database is used by our central IT organization to support a number of enterprise / administrative systems. It provides a managed cloud solution to provision, manage, backup and patch the DBs. It can also scale up or down easily to meet workloads. The idea is to free up DBA resources from doing operational tasks and provides a high of level of consistency and availability across our environment.
- Significantly reduces the amount to provision a new database
- All routine tasks (installation / patching / backup / scaling) are handled by the DB-as-a-service.
- Built-in security framework that prevents unauthorized access.
- Provide out-of-the box High Availability and DR.
- There is no access to the physical host of the DB. This is expected from a managed DB. Everything must be done through the console or via API calls. This is a new learning curve for the DBAs.
- Due to the lack of physical host access, certain features are not supported, such as Transportable tablespaces and Oracle LogMiner.
- Certain special data types, (such as XMLType) are not allowed; be sure the app vendor certifies their product on this platform.
- Managing more with existing staff.
- Freeing up DBA resources to align with projects that adds value the business.
- Significantly faster provisioning and deployments of resources.
[Oracle Autonomous Database] is well suited if you already have an vested interest in the Oracle Cloud, since Autonomous Database will closely integrate into the Oracle Cloud. It will able to deliver faster, simplified, and consistent Oracle deployments. On the other hand, if you're currently using another Cloud provider such as AWS or Microsoft Azure and has no plan to change in the near-term, it's probably not a good idea to invest in the Oracle Cloud. Multi-Cloud integration strategies are often more costly and often have architectural design issues and/or incompatibilities that will be difficult to overcome.