This blog introduces the new support for Exadata Warehouse in Oracle Cloud Infrastructure (OCI) Operations Insights for Oracle Engineered Systems like Exadata Database Machine and Zero Data Loss Recovery Appliance (ZDLRA) monitored via Oracle Enterprise Manager (EM). It provides a platform for long-term retention of fine-grained historical and forecast data for performance and capacity analysis and planning.
The OCI Operations Insights service enables business executives, database administrators, and DevOps personnel to make informed, data-driven decisions on compute resource and performance management related issues.
With the introduction of Exadata Warehouse, resource utilization of the Exadata systems can be analyzed to identify spare capacity for new workloads. This feature is available for Exadata systems that are managed by Oracle Enterprise Manager (EM) 13c Release 5 Update 7 (220.127.116.11) and above. The use of Exadata Warehouse features requires OCI Operations Insights service license subscription.
Oracle EM allows Operations Insights' Exadata Warehouse to easily utilize target-level data managed by EM. EM enables the transfer of data from EM targets and Oracle Management Repository (OMR) to OCI Object Storage, where it is easily accessed by one or more cloud-native services such as Operations Insights and Logging Analytics.
Once OCI connectivity is set up, the target data is automatically uploaded at frequent intervals to Object Storage so that OCI cloud services are always working with the most recent target data.
Data retention settings:
Exadata Warehouse collects metrics from ASM Cluster, Exadata Storage Server and Exadata Compute Nodes and provides coverage for the areas below:
Exadata Storage Server
Exadata Compute Nodes
Sparse Disk Group
Detect “noisy-neighbor” target problems scenario:
Typically, in a shared resource host environment, CPUs are over-allocated across databases. This assumes that not all DBs will fully utilize allocated resources at the same time. Noisy neighbor issue(s) occur when load increases and one neighbor hogs all the shared resources.
Goal: Fleet view of hosts correlating performance and configuration data and highlight the problematic targets.
Exadata Warehouse can help with enterprise-wide analysis of resource utilization and capacity planning for Exadata:
Trend and forecast IOPS utilization:
Track and trend the throughput usage and utilization percentage and plot the latency and Flash Input Output Resource Manager (IORM) waits to answer:
The Exadata Warehouse data can be visualized to build reports in Oracle Analytics Cloud and interpret the workload distribution and basis which can be chosen to change an IORM strategy.
Operations Insights integrates with Oracle EM and simplifies onboarding for existing customers using automated collection of EM data and advanced analytics for EM targets. Exadata Warehouse for EM-managed systems aids in consolidation and troubleshooting.
Sign up for an Oracle Cloud Infrastructure trial account!
For more information about this feature and how to use it, see the documentation.
Sriram Vrinda is an experienced Product Manager with a demonstrated history of working in the information technology and services industry. Strong product management professional skilled in Oracle Database, Autonomous Databases, MySQL Databases, IT Service Management, Solution Architect, and Pre-sales. He has helped various customers with Oracle solutions specifically around performance, availability, and scalability aspects for about 20 years.