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:
Create a Oracle Cloud (OCI) integration if not available in your installed integrations.
You can select
OCI Databases
during integration or you can edit the existing integration and selectOCI Databases
.Scan to discover the resources at any time independent of the predefined schedule.
Once the scan is completed, you can view the OCI Databases resource under Infrastructure > Resources > Oracle Cloud category.
Create a template. See Create a Template for more information on how to create a template.
Refer to Assign a Template on how to assign a template to a resource.
Click the Metrics tab to view the monitoring data of OCI Databases as shown below:
Supported metrics
OpsRamp Metric | Oracle Cloud Metric | Metric Display Name | Unit | Description | Aggregation Type |
---|---|---|---|---|---|
oci_database_CpuUtilization | CpuUtilization | CPU Utilization | percentage | The 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_StorageUtilization | StorageUtilization | Storage Utilization | percentage | The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces. | max |
oci_database_ExecuteCount | ExecuteCount | Execute Count | count | The number of user and recursive calls that executed SQL statements during the selected interval. | sum |
oci_database_BlockChanges | BlockChanges | Block Changes | changes per second | The Average number of blocks changed per second. | mean |
oci_database_ParseCount | ParseCount | Parse Count | count | The number of hard and soft parses during the selected interval. | mean |
oci_database_CurrentLogons | CurrentLogons | Current Logons | count | The number of successful logons during the selected interval. | mean |