Dynatrace Hub
Oracle DatabaseOracle Database
Observe, analyze and optimize the usage, health and performance of your database
Extension by Dynatrace
- Product information
- Release notes
Overview
Dynatrace automatically detects all applications and microservices deployed in your system and how your system uses Oracle Database. This extension provides automatic end-to-end tracing down to individual SQL statements, Oracle Server metrics, and log insights. Dynatrace diagnoses anomalies in real time with AI and pinpoints the root cause in slow-performing or erroneous SQL statements. Deep code-level insights combined with cloud-native database server monitoring help you ensure a robust production environment.
Get started
Get started for Oracle Database clients:
If the application that connects to the Oracle Database server runs on a virtual machine or bare-metal, install OneAgent on it to get started.
If the application that connects to the Oracle Database server runs as a workload in Kubernetes or OpenShift, set up Dynatrace on Kubernetes or OpenShift.
Activate the following OneAgent features to get full tracing insight:
- Node.js Oracle DB
- PHP Oracle
Get started with Oracle Database servers:
If your Oracle Database server runs on a virtual machine or bare-metal, install OneAgent on it to get started with system performance metrics.
Activate the Oracle Database extension to get full insight into the Oracle Database server's health and performance combined with metrics and events. A dedicated user account is recommended for monitoring, with either:
CREATE_SESSIONSELECT_CATALOG_ROLE
roles granted, or set of SELECT permissions on the following performance views:
V$ASM_Disk_StatV$DatabaseV$InstanceV$LibraryCacheV$MetricV$MetricGroupV$ParameterV$PGAStatV$ServicesV$SessionV$SGAStatV$SQLAreaV$SysStatV$System_EventV$System_Wait_ClassV$Sys_Time_ModelV$TablespaceDBA_Data_FilesDBA_Free_SpaceDBA_Lmt_Free_SpaceDBA_TablespacesDBA_Temp_Free_Space
Depending on the level of detail, additional privileges might be required, such as SYSDBA or SYSASM privileges, to view certain ASM statistics. These privileges are typically granted by an ASM administrator.
Activate log monitoring to get full log insight.
Note:
Enabling Most time consuming queries’ performance may expose sensitive data in reported queries.
Use cases
- Understand all database dependencies of your applications, which database statements are executed, and their performance.
- Improve the performance of your application by reducing or optimizing typical database patterns like the 1+N query problem
- Understand the resource impact that your applications have on your database.
- Understand the impact that resource shortages or other database issues have on your application by observing the database server itself.
- Track the health and performance of Oracle Database servers (either standalone or multi-tenant)
- Track the most time consuming queries performance
- Speed up application-problem diagnosis when issues are caused by the database
Compatibility information
The extension supports following Oracle versions:
- Oracle standalone servers
- Oracle Multitenant (CDB/PDB)
- Only monitoring of instances and PDB is supported. CDB monitoring is not in scope of this extension
- Oracle DB 12.2+
- Oracle AWS RDS
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 metrics can be activated and deactivated by your administrator during configuration.