Oracle Exadata allows enterprises to run any Oracle Database workload with the highest performance, scale, availability, and security on fully compatible cloud and on-premises infrastructure. Exadata uses a scale-out design with unique optimizations that include persistent memory, SQL query offload, and built-in resource management to optimize performance for OLTP, analytics, machine learning, and mixed workloads running in consolidated environments.

By running hundreds or thousands of optimized Autonomous Database and Exadata Database instances on Exadata Cloud or Cloud@Customer infrastructure, customers are able to minimize their infrastructure, reduce management, improve developer productivity, and lower total costs by up to 40%.

Use the Oracle Cloud integration to discover and collect metrics against the OCI Databases.

Setup

To set up the Oracle Cloud integration and discover the OCI Databases service, do the following:

  1. Create a Oracle Cloud (OCI) integration if not available in your installed integrations.

  2. You can select OCI Databases during integration or you can edit the existing integration and select OCI Databases.

  3. Scan to discover the resources at any time independent of the predefined schedule.

  4. Once the scan is completed, you can view the OCI Databases resource under Infrastructure > Resources > Oracle Cloud category.

  5. Create a template. See Create a Template for more information on how to create a template.

  6. Refer to Assign a Template on how to assign a template to a resource.

  7. Click the Metrics tab to view the monitoring data of OCI Databases as shown below:

Supported metrics

OpsRamp MetricOracle Cloud MetricMetric Display NameUnitDescriptionAggregation Type
oci_database_CpuUtilizationCpuUtilizationCPU UtilizationpercentageThe CPU utilization is expressed as a percentage, which is aggregated across all consumer groups. The utilization percentage is reported with respect to the number of CPUs the database is allowed to use, which is two times the number of OCPUs.mean
oci_database_StorageUtilizationStorageUtilizationStorage UtilizationpercentageThe percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.max
oci_database_ExecuteCountExecuteCountExecute CountcountThe number of user and recursive calls that executed SQL statements during the selected interval.sum
oci_database_BlockChangesBlockChangesBlock Changeschanges per secondThe Average number of blocks changed per second.mean
oci_database_ParseCountParseCountParse CountcountThe number of hard and soft parses during the selected interval.mean
oci_database_CurrentLogonsCurrentLogonsCurrent LogonscountThe number of successful logons during the selected interval.mean