Initially when provisioning; the customer will enter the details like datacenter location, CPU and memory requirements, login credentials. Once Provisioned data is loaded. The data is automatically compressed, and all the statistics for the data is created. There is no need to set up infrastructure and manage database tablespace manually. It performs all OS and SYSDBA operations. The errors in SQL are rectified and run automatically. The database is fully secured, protected and encrypted. There will be an auto recovery in case of failure such as storage, networking and compute failures. Example: In the case of SQL query failure, recovery window is provided for manual restore.
ADW has the ability to scale‐up /scale down with automated steps. The pricing is based upon CPU ($/CPU/Hour) and storage ($/TB/Months).Compression
Everything in ADW is Compressed using HCC (facts and dimensions). 3.5 to 5 times compression as compared to Amazon RDS as Amazon uses columnar instead of HCC compression. ADW enables huge results caching. Autonomous database results in fewer indexes (by up to 60%) to yield better concurrency support.Cluster Advisor/Manager
Oracle cluster health advisor continuously monitors Real Application Clusters(RAC) databases for performance and availability issues.Memory Guard
Memory Guard is an Oracle Real Application Clusters (Oracle RAC) environment feature to monitor the cluster nodes and prevent node stress caused by the lack of memory.Hang Manager
Hang Manager is an Oracle Real Application Clusters (Oracle RAC) environment feature that autonomously and reliably detects and resolves hangs and deadlocks. It keeps the resources available. Hang Manager is enabled by default.Quality of Service
Oracle Database Quality of Service (QoS) Management adjusts the system configuration to keep the applications running at the performance levels needed by your business. It monitors and delivers Key Performance Indicators. It provides cluster-wide dashboard and phase in with the measure.Cluster verification(Cluster Configuration)
Use configuration audit tools Oracle ORAchk and Oracle EXAchk to assess your Oracle Engineered Systems and non-Engineered Systems for known configuration problems and best practices.Data Lake
Data from different sources and different formats (structured and unstructured) can be processed. ADW workloads- Data warehouse, Data Mart, Data Lake, Machine Learning.
Founded in the year 2004, Vast Edge is a leading IT Consulting Company and Global Service provider of Business Intelligence, big data analytics, cloud ERP, IoT platform, enterprise backup, and disaster recovery, Blockchain, Cassandra, AI/ML, and Integration solutions. We perform Application modernization, follow continuous change management, and implement advanced practices while working on the key areas of enhancing methodologies of project development.
Get a Free Assessment from our ADW experts.