Monitor Oracle Exadata Storage Infrastructure in OCI Database Management

April 25, 2023 | 5 minute read
Sriram Vrinda
Director of Product Management
Text Size 100%:

In addition to Database Management’s comprehensive database performance diagnostics and management capabilities for Oracle Databases, Database Management now supports the monitoring of Oracle Exadata Storage Infrastructure!

As a database administrator, you can use Database Management to discover and monitor the on-premises Exadata Infrastructure. We have included new capabilities to monitor Oracle database systems located on premises along with the Exadata Storage components. The effort required to discover the components separately has been greatly reduced. Database Management provides a single-pane-of-glass view of the components and enables identification of availability and performance issues before they impact the database. 

Database Management supports Exadata System Software version 20.1 and later. 

Post-discovery of the on-premises Exadata Infrastructure capabilities:

  • Monitor the key performance and configuration metrics of the Exadata infrastructure at the fleet level.
  • Drill down from the fleet view to a specific Exadata infrastructure.
  • Monitor the performance and availability of the storage servers and the storage server grid. 
Figure 1: Fleet-level view of the External Exadata Infrastructures
Figure 1:  Fleet-level view of the External Exadata Infrastructures

 

Database system discovery process in the on-premises Exadata Database machine.

As a first step, you need to discover the Database System in the on-premises Exadata Database Machine.  Next, discover the associated Exadata infrastructure, then register and connect to the storage servers.  Utilize the same Management Agent used to discover the database system.

The Exadata infrastructure discovery process includes the following main operations:

  1. Select a previously discovered database system residing in the same Exadata Database Machine.
  2. Configure the connectors to the storage servers that you want to monitor using Database Management.
  3. Review the associated database system and the storage servers that will be monitored using Database Management and creating the Exadata infrastructure resource.

Key features of Exadata fleet summary monitoring

After discovering the Exadata Infrastructure, resource usage and open alarms can be monitored across the fleet with a master detail layout on the Exadata fleet summary page. From the Exadata fleet summary page, the Exadata infrastructure details page filters to obtain additional insights into specific Exadata infrastructure resources.  Important details such as availability and key storage metrics of the infrastructure comprising the DB systems and the storage server grid components are readily available.

Figure 2: Exadata infrastructure details page
Figure 2:  Exadata infrastructure details page

 

Monitor database systems for component performance

From the Exadata infrastructure details page navigate to the Database system details page and view detailed information about the various components of the DB system.

  • Clusters
  • Databases
  • ASM
  • Listeners