Oracle 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.

Subscribe to new releases

Copy to clipboard

Extension content

Content typeNumber of items included

metric metadata

alerts

generic relationship

dashboards

screen layout

screen chart groups

list screen layout

generic type

screen entities lists

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

Related to Oracle Autonomous Database on OCI

Oracle Database

Observe, analyze and optimize the usage, health and performance of your database

Oracle Cloud Infrastructure

Monitor health and performance of the Oracle Cloud Infrastructure.

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

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.

4 Results

Found in 'All' filtered by:

Oracle Exadata

Monitor Oracle Exadata systems for performance, usage and availability

Extension

oracle
database
exadata

Oracle Database

Observe, analyze and optimize the usage, health and performance of your database

Extension

oracle
database
full-stack
log-analytics
logs
monitoring
performance

Oracle Cloud Infrastructure

Monitor health and performance of the Oracle Cloud Infrastructure.

Extension

oracle
cloud
cloud-and-infrastructure