Skip to technology filters Skip to main content
Dynatrace Hub

Extend the platform,
empower your team.

Popular searches:
Home hero bg
Oracle Autonomous Database on OCIOracle Autonomous Database on OCI
Oracle Autonomous Database on OCI

Oracle Autonomous Database on OCI

Monitor health and performance of the Oracle Autonomous Database.

Extension
Free trial
Oracle Autonomous Database on Oracle Cloud Infrastructure - a sample dashboardOracle Autonomous Database on Oracle Cloud Infrastructure - a Unified Analysis screen
  • 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 the minimum permissions listed below to collect metrics for all feature sets.

- Allow group <group name> to read metrics in compartment <compartment name>

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:

  • OCI API concepts
  • API signing key handling
  • Overview of OCI monitoring

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: Does this extension support proxy for monitoring API acceess?

A: Yes. See Oracle Cloud Infrastructure hub tile for details on how proxy support works with OCI.

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.

Dynatrace
More Information
By Dynatrace
Dynatrace support center
Subscribe to new releases
Copy to clipboard

Extension content

Content typeNumber of items included
metric metadata
40
alerts
3
generic relationship
1
dashboards
1
screen layout
1
screen chart groups
4
list screen layout
1
generic type
2
screen entities lists
1

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 nameMetric keyDescriptionUnit
APEX Page Eventscloud.oci.database.autonomous.apex_page_eventsNumber of APEX page events.Count
APEX Page Load Timecloud.oci.database.autonomous.apex_page_load_timeAverage APEX page execution time.Second
Active APEX Applicationscloud.oci.database.autonomous.apex_active_applicationsNumber of APEX applications with activity.Count
APEX Workspace Countcloud.oci.database.autonomous.apex_workspacesTotal number of user-created workspaces.Count
Metric nameMetric keyDescriptionUnit
Sessionscloud.oci.database.autonomous.sessionsNumber of sessions in the database.Count
Execute Countcloud.oci.database.autonomous.executesNumber of user and recursive calls that executed SQL statements.Count
Running Statementscloud.oci.database.autonomous.running_statementsNumber of running SQL statements aggregated accross all consumer groups.Count
Queued Statementscloud.oci.database.autonomous.queued_statementsNumber of queued SQL statements aggregated accross all consumer groups.Count
Transaction Countcloud.oci.database.autonomous.transactionsCombined number of user commits and user rollbacks.Count
Current Logonscloud.oci.database.autonomous.current_logonsNumber of successful logons.Count
User Callscloud.oci.database.autonomous.user_callsCombined number of logons, parses, and execute calls.Count
Total Parse Countcloud.oci.database.autonomous.parsesNumber of hard and soft parses.Count
Failed Logonscloud.oci.database.autonomous.failed_logonsNumber of logons that failed due to an invalid username and/or password.Count
Failed Connectionscloud.oci.database.autonomous.failed_connectionsNumber of failed database connections.Count
User Commitscloud.oci.database.autonomous.user_commitsNumber of user commits.Count
User Rollbackscloud.oci.database.autonomous.user_rollbacksNumber of times users manually issue the ROLLBACK statement or an error occurs during user's transactions.Count
Redo Sizecloud.oci.database.autonomous.redo_sizeAmount of redo generated in bytes.Count
Hard Parse Countcloud.oci.database.autonomous.hard_parsesNumber of parse calls (real parses).Count
Failures Parse Countcloud.oci.database.autonomous.failed_parsesNumber of parse failures.Count
Bytes Received via SQL*Net from DBLinkcloud.oci.database.autonomous.sql_net_bytes_from_dblinkNumber of bytes received from a database link over Oracle Net Services.Count
Bytes Sent via SQL*Net to DBLinkcloud.oci.database.autonomous.sql_net_bytes_to_dblinkNumber of bytes sent over a database link over Oracle Net Services.Count
Bytes Received via SQL*Net from Clientcloud.oci.database.autonomous.sql_net_bytes_from_clientNumber of bytes received from the client over Oracle Net Services.Count
Bytes Sent via SQL*Net to Clientcloud.oci.database.autonomous.sql_net_bytes_to_clientNumber of bytes sent to the client from the foreground processes.Count
Metric nameMetric keyDescriptionUnit
CPU Utilizationcloud.oci.database.autonomous.cpu_utilCPU utilization aggregated across all consumer groups.Percent
Storage Utilizationcloud.oci.database.autonomous.storage_utilPercentage of provisioned storage capacity currently in use.Percent
Maximum Storage Spacecloud.oci.database.autonomous.max_storage_spaceMaximum amount of storage reserved for the database.GigaByte
Storage Space Allocatedcloud.oci.database.autonomous.storage_space_allocatedSpace allocated to the database.GigaByte
Storage Space Usedcloud.oci.database.autonomous.storage_space_usedSpace used by the database.GigaByte
DB Timecloud.oci.database.autonomous.db_timeRate of accumulation of database time (CPU + Wait) by foreground sessions.Second
Wait Timecloud.oci.database.autonomous.wait_timeAverage rate of accumulation of non-idle wait time by foreground sessions.Second
CPU Timecloud.oci.database.autonomous.cpu_timeRate of accumulation of CPU time by foreground sessions.Second
Database Availabilitycloud.oci.database.autonomous.database_availabilityDatabase availability for connections (1 = DB Available, 0 = DB Unavailable).Count
Connection Latencycloud.oci.database.autonomous.connection_latencyTime taken to connect to a ADB-S database in each region from a VM in the same region.MilliSecond
Query Latencycloud.oci.database.autonomous.query_latencyTime taken to display results of a simple query.MilliSecond
Session Logical Readscloud.oci.database.autonomous.session_logical_readsSum of "db block gets" plus "consistent gets".Count
DB Block Changescloud.oci.database.autonomous.db_block_changesNumber of changes that where part of an update or delete operation to all blocks in SGA.Count
Physical Readscloud.oci.database.autonomous.physical_readsNumber of data blocks read from disk.Count
Physical Writescloud.oci.database.autonomous.physical_writesNumber of data blocks written to disk.Count
Physical Read Total Bytescloud.oci.database.autonomous.physical_read_bytesSize in bytes of disk reads by all database instance activity.Count
Physical Write Total Bytescloud.oci.database.autonomous.physical_write_bytesSize in bytes of disk writes by all database instance activity.Count

Related to Oracle Autonomous Database on OCI

Oracle Database logo

Oracle Database

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

Oracle Cloud Infrastructure (OCI) logo

Oracle Cloud Infrastructure (OCI)

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:

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

Dynatrace Hub
Get data into DynatraceBuild your own app
All (774)Log Management and AnalyticsKubernetesAI and LLM ObservabilityInfrastructure ObservabilitySoftware DeliveryApplication ObservabilityApplication SecurityDigital ExperienceBusiness Analytics
Filter
Type
Built and maintained by
Deployment model
SaaS
  • SaaS
  • Managed
Partner FinderBecome a partnerDynatrace Developer

Discover recent additions to Dynatrace

Problems logo

Problems

Analyze abnormal system behavior and performance problems detected by Davis AI.

Logs logo

Logs

Explore all your logs without writing a single query.

Security Investigator logo

Security Investigator

Fast and precise forensics for security and logs on Grail data with DQL queries.

Business Flow logo

Business Flow

Track, analyze, and optimize your critical business processes.

Cost & Carbon Optimization logo

Cost & Carbon Optimization

Track, analyze, and optimize your IT carbon footprint and public cloud costs.

Davis Anomaly Detection logo

Davis Anomaly Detection

Detect anomalies in timeseries using the Davis AI

Analyze your data

Understand your data better with deep insights and clear visualizations.

Notebooks logo

Notebooks

Create powerful, data-driven documents for custom analytics and collaboration.

Dashboards logo

Dashboards

Transform complex data into clear visualizations with custom dashboards.

Automate your processes

Turn data and answers into actions, securely, and at scale.

Workflows logo

Workflows

Automate tasks in your IT landscape, remediate problems, and visualize processes

Jira logo

Jira

Create, query, comment, transition, and resolve Jira tickets within workflows.

Slack logo

Slack

Automate Slack messaging for security incidents, attacks, remediation, and more.

Secure your cloud application

See vulnerabilities and attacks in your environment.

Security Overview logo

Security Overview

Get a comprehensive overview of the security of your applications.

Code-Level Vulnerabilities logo

Code-Level Vulnerabilities

Detect vulnerabilities in your code in real time.

Threats & Exploits logo

Threats & Exploits

Understand, triage, and investigate application security findings and alerts.

Are you looking for something different?

We have hundreds of apps, extensions, and other technologies to customize your environment

Leverage our newest innovations of Dynatrace Saas

Kick-start your app creation

Kick-start your app creation

Whether you’re a beginner or a pro, Dynatrace Developer has the tools and support you need to create incredible apps with minimal effort.
Go to Dynatrace Developer
Upgrading from Dynatrace Managed to SaaS

Upgrading from Dynatrace Managed to SaaS

Drive innovation, speed, and agility in your organization by seamlessly and securely upgrading.
Learn More
Log Management and Analytics

Log Management and Analytics

Innovate faster and more efficiently with unified log management and log analytics for actionable insights and automation.
Learn more