Oracle Autonomous Data Warehouse Reviews & Product Details

It's really fast to set up (like 2 minutes to create a new database) It's cheap, and its costs are based on dedicated resources (RAM and CPUs) It can be easily turned off Disaster recovery is granted thanks to fault domains provided by Oracle Resources (RAM and CPUs) can be increased or decreased at run-time Oracle automatically performs patching and release upgrades at scheduled times Backups are automatically performed and very easy to restore User friendly Review collected by and hosted on G2.com.

It's really limited from a DBA point of view There is only one tablespace associated with all the users you create on the database The cost (license and monthly fees) are not always very clear The loading of data on the cloud is subjected to network speed, so vast amounts of data may take a lot of time to be loaded on the database More data connections to different applications can be introduced It can get expensive with options and additional features Do not have a provision to control the database instance and configuration. Review collected by and hosted on G2.com.

The elements that are most helpful to a traditional 'techie' is the automation of the platform and infrastructure, e.g. patching and upgrades now all sorted. It's biggest draw against its competitors is the performance of the underlying platform, making it pound for pound super competitive. Finally the lastest enhancements in terms of the UI for data ingesting, loading, charting and data gives it a complete SaaS feel. Review collected by and hosted on G2.com.

Historically the issue was the lack of integration into existing OCI cloud services and networking constructs however this has been resolved. Ideally, more flexibility on the sizing of the autonomous DR would be a good improvement, i.e. pilot light capability. Review collected by and hosted on G2.com.

Autoscaling of Autonomous Database computing resources - completely automated, no user intervention required, and per-second billing. True capacity-on-demand, and very flexible. Review collected by and hosted on G2.com.

The requirement to have a multi-tenancy license to use BYOL for ADB. Most customers do not own multi-tenancy licenses but hold EE licenses. Maybe create a new tier where up to 4 OCPU ADW does not require multi-tenancy. Review collected by and hosted on G2.com.

What's not to like about ADW? It doesn't require a DBA to provision or manage, It runs on the Oracle Exadata infrastructure, tunes itself, can scale OCPUs automatically, and comes with a wide variety of enterprise-level data management and analysis tools. Review collected by and hosted on G2.com.

There isn't anything that I dislike, and I would only suggest that they continue to add more tools and functionality to the integrated toolset. Review collected by and hosted on G2.com.

Not only a performant, fully-managed Data Warehouse/Lakehouse service, but one that does bring all the features of a mature converged RDBMS to the table. Competing services don't offer services like model-based data consistency for example. Review collected by and hosted on G2.com.

A major advantage is that the service is available in the Oracle Cloud only. Many of our customers still try to carry out a single Cloud strategy since setting up Cloud environments is highly complex and expensive regarding required manpower, time spent, and network cost. Therefore customers dismiss ADW, not on the grounds of limited performance or missing features, but because of lacking multi-Cloud platform availability. Review collected by and hosted on G2.com.

Security and performance. Data retrieval is smooth. Review collected by and hosted on G2.com.

The user friendliness is not up to the mark. Review collected by and hosted on G2.com.

The fastest existing data warehouse with the highest possible level of automation. Review collected by and hosted on G2.com.

No DBA access and no operating system access Review collected by and hosted on G2.com.

The flexibility to increase or decrease the resources without downtime, the ability to start with a very small database and make it grow as needed. The fact that all upgrades and patches are applied by Oracle. The guaranty that a database server as Oracle and a powerful hardware as Exadata are under the hood. Review collected by and hosted on G2.com.

The cost can be thought as high but since you can adapt the resources to what you actually need at every moment, the price can be lower than other products where you cannot modify the resources. Review collected by and hosted on G2.com.

Ease of use and flexibility concerning scalability etc. Review collected by and hosted on G2.com.

The pricing model from Oracle from time to time confusing Review collected by and hosted on G2.com.

Flexibility, support of CI/CD pipeline for development systems. Review collected by and hosted on G2.com.

To use it, as it is a PaaS system, changes must be made. Review collected by and hosted on G2.com.