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.
Compatibility information
- OCI API access from ActiveGate is required
Extension content
Content typeNumber of items included
metric metadata
40
alerts
3
screen layout
2
generic relationship
1
document dashboard
1
dashboards
1
list screen layout
1
generic type
2
screen entities lists
1
screen chart groups
8
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.
Feature setsNumber of metrics included
| 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
To have more information on how to install the downloaded package, please follow the instructions on this page.
ReleaseDate
Full version history
Patch level changes
- Improvements to avoid hitting OCI API rate limit wherever possible.
Full version history
⚠️IMPORTANT CHANGE: This extension release requires Dynatrace cluster version 1.313 or later.
New features:
- The
dt.security_contextattribute is now propagated to all entities created by the extension. When enabling entity access control based ondt.security_contextensure you set the Grail security context destination property todt.security_context - Enabled the extension to present the Dynatrace Platform (a.k.a. Gen3) entity details screens in the future platform apps that will expect these screens
Full version history
Patch level changes:
- Oracle SDK currency updates
Full version history
New features:
- Added possibility of an explicit proxy configuration for the API connection. Note that OCI SDK may still use OS-level environment proxy setting. See Q&A for more information on proxy support.
Patch level changes:
- Updated support for Oracle Cloud sovereign regions, to include recently rolled out new regions.
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.
