Oracle Autonomous Database on OCIOracle Autonomous Database on OCI
Monitor health and performance of the Oracle Autonomous Database.
Extension
- Product information
- Release notes
Overview
This extension monitors basics of the Oracle Autonomous Database, providing server-side observability on the database engine availability and performance level. This extension provides a light alternative to the Oracle Database monitoring extension that is compatible with OCI Autonomous DB.
Use cases
- Monitor availability of the Autonomous DB and the underlying Oracle Cloud Infrastructure health.
- Track usage of the database storage and network resources.
- Track database usage in terms of users, logins, sessions, number of queries executed.
- Understand the resource impact that your applications have on the Autonomous DB, including wait times.
- Understand the impact that databse-side resource shortages have on your application.
Get started
This extension is executed by the ActiveGate (remote monitoring). You must have an ActiveGate provisioned in your environment and networking set up so the ActiveGate can connect to the subject OCI tenant containing the Autonomous Database you are about to monitor.
To start, activate the extension in your environment using the in-product Hub. Then provide your OCI monitoring endpoint whereabouts. You will need to provide:
- Compartment ID
- Tenancy
- User
- Fingerprint
- Region
- Path location of a PEM key file which extension will use to sign OCI monitoring API requests
Note: The User account provided in the configuration must also have permissions to read all OCI settings & resources.
The PEM key file will need to be placed on any ActiveGate that is running the extension, in a location that is accessible to the extension. The recommended default location for the PEM file is:
- Linux:
<CONFIG>/remotepluginmodule/agent/conf/certificates/ (default: /var/lib/dynatrace/remotepluginmodule/agent/conf/certificates/) - Windows:
%PROGRAMDATA%\dynatrace\remotepluginmodule\agent\conf\certificates
Refer to Oracle documentation for details on how to set up the monitoring endpoint access:
Details
This extension is built on top of the Extension Framework 2.0 and delivers:
- Metrics retrieved from the OCI API (extension internally uses Python to connect to the OCI API)
- A Dashboard
- Topology definition
- Unified Analysis screens
Compatibility information
- OCI API access from ActiveGate is required
Q&A
Q: How does this extension stack versus the Oracle Database monitoring extension?
A: This extension offers a lightweight, limited alternative to the Oracle Database monitoring extension, specifically for the Autonomous DB on OCI.
This extension lets you monitor basics of the database performance, using alternative REST API source of metrics provided by the Oracle Cloud Infrastructure APIs.
Q: Can I use the regular Oracle DB extension to monitor my Autonomous DB?
A: Oracle Database monitoring extension does not support Autonomous DB on OCI. This limitation roots down to the Oracle SQL data source that doesn't support certificate-based authentication, which OCI requires.
Q: Can I monitor SQL query performance on my Autonomous DB?
A: Query-level statistics are not available in this extension. Use OneAgent on your app servers to obtain insight into SQL queries that your app servers execute against the Autonomous DB.
Q: Should I use both Oracle Database monitoring extension and this extension together for complete Autonomous DB monitoring?
A: No. This extension provides a subset of metrics that the Oracle Database extension offers.
Q: What is the DDU Consumption of this extension?
A: Metric to DDU consumption multiplier for each Autonomous Database monitored is:
40 * 525.6 DDUs/year
DDU cost above does not include any possible Log events or Custom events triggered by the extension. For more information on this, please visit the DDU log event cost and DDU custom event cost pages.
Extension content
Feature sets
Below is a complete list of the feature sets provided in this version. To ensure a good fit for your needs, individual feature sets can be activated and deactivated by your administrator during configuration.
| Metric name | Metric key | Description | Unit |
|---|---|---|---|
| APEX Page Events | cloud.oci.database.autonomous.apex_page_events | Number of APEX page events. | Count |
| APEX Page Load Time | cloud.oci.database.autonomous.apex_page_load_time | Average APEX page execution time. | Second |
| Active APEX Applications | cloud.oci.database.autonomous.apex_active_applications | Number of APEX applications with activity. | Count |
| APEX Workspace Count | cloud.oci.database.autonomous.apex_workspaces | Total number of user-created workspaces. | Count |
| Metric name | Metric key | Description | Unit |
|---|---|---|---|
| Sessions | cloud.oci.database.autonomous.sessions | Number of sessions in the database. | Count |
| Execute Count | cloud.oci.database.autonomous.executes | Number of user and recursive calls that executed SQL statements. | Count |
| Running Statements | cloud.oci.database.autonomous.running_statements | Number of running SQL statements aggregated accross all consumer groups. | Count |
| Queued Statements | cloud.oci.database.autonomous.queued_statements | Number of queued SQL statements aggregated accross all consumer groups. | Count |
| Transaction Count | cloud.oci.database.autonomous.transactions | Combined number of user commits and user rollbacks. | Count |
| Current Logons | cloud.oci.database.autonomous.current_logons | Number of successful logons. | Count |
| User Calls | cloud.oci.database.autonomous.user_calls | Combined number of logons, parses, and execute calls. | Count |
| Total Parse Count | cloud.oci.database.autonomous.parses | Number of hard and soft parses. | Count |
| Failed Logons | cloud.oci.database.autonomous.failed_logons | Number of logons that failed due to an invalid username and/or password. | Count |
| Failed Connections | cloud.oci.database.autonomous.failed_connections | Number of failed database connections. | Count |
| User Commits | cloud.oci.database.autonomous.user_commits | Number of user commits. | Count |
| User Rollbacks | cloud.oci.database.autonomous.user_rollbacks | Number of times users manually issue the ROLLBACK statement or an error occurs during user's transactions. | Count |
| Redo Size | cloud.oci.database.autonomous.redo_size | Amount of redo generated in bytes. | Count |
| Hard Parse Count | cloud.oci.database.autonomous.hard_parses | Number of parse calls (real parses). | Count |
| Failures Parse Count | cloud.oci.database.autonomous.failed_parses | Number of parse failures. | Count |
| Bytes Received via SQL*Net from DBLink | cloud.oci.database.autonomous.sql_net_bytes_from_dblink | Number of bytes received from a database link over Oracle Net Services. | Count |
| Bytes Sent via SQL*Net to DBLink | cloud.oci.database.autonomous.sql_net_bytes_to_dblink | Number of bytes sent over a database link over Oracle Net Services. | Count |
| Bytes Received via SQL*Net from Client | cloud.oci.database.autonomous.sql_net_bytes_from_client | Number of bytes received from the client over Oracle Net Services. | Count |
| Bytes Sent via SQL*Net to Client | cloud.oci.database.autonomous.sql_net_bytes_to_client | Number of bytes sent to the client from the foreground processes. | Count |
| Metric name | Metric key | Description | Unit |
|---|---|---|---|
| CPU Utilization | cloud.oci.database.autonomous.cpu_util | CPU utilization aggregated across all consumer groups. | Percent |
| Storage Utilization | cloud.oci.database.autonomous.storage_util | Percentage of provisioned storage capacity currently in use. | Percent |
| Maximum Storage Space | cloud.oci.database.autonomous.max_storage_space | Maximum amount of storage reserved for the database. | GigaByte |
| Storage Space Allocated | cloud.oci.database.autonomous.storage_space_allocated | Space allocated to the database. | GigaByte |
| Storage Space Used | cloud.oci.database.autonomous.storage_space_used | Space used by the database. | GigaByte |
| DB Time | cloud.oci.database.autonomous.db_time | Rate of accumulation of database time (CPU + Wait) by foreground sessions. | Second |
| Wait Time | cloud.oci.database.autonomous.wait_time | Average rate of accumulation of non-idle wait time by foreground sessions. | Second |
| CPU Time | cloud.oci.database.autonomous.cpu_time | Rate of accumulation of CPU time by foreground sessions. | Second |
| Database Availability | cloud.oci.database.autonomous.database_availability | Database availability for connections (1 = DB Available, 0 = DB Unavailable). | Count |
| Connection Latency | cloud.oci.database.autonomous.connection_latency | Time taken to connect to a ADB-S database in each region from a VM in the same region. | MilliSecond |
| Query Latency | cloud.oci.database.autonomous.query_latency | Time taken to display results of a simple query. | MilliSecond |
| Session Logical Reads | cloud.oci.database.autonomous.session_logical_reads | Sum of "db block gets" plus "consistent gets". | Count |
| DB Block Changes | cloud.oci.database.autonomous.db_block_changes | Number of changes that where part of an update or delete operation to all blocks in SGA. | Count |
| Physical Reads | cloud.oci.database.autonomous.physical_reads | Number of data blocks read from disk. | Count |
| Physical Writes | cloud.oci.database.autonomous.physical_writes | Number of data blocks written to disk. | Count |
| Physical Read Total Bytes | cloud.oci.database.autonomous.physical_read_bytes | Size in bytes of disk reads by all database instance activity. | Count |
| Physical Write Total Bytes | cloud.oci.database.autonomous.physical_write_bytes | Size in bytes of disk writes by all database instance activity. | Count |
Full version history
Full version history
Patch level changes
- Resiliency improvements to handle minor API response inconsistencies
- Minor bug fixes
Full version history
Initial release of the Oracle Autonomous Database on Oracle Cloud Infrastructure monitoring extension.