Oracle Database

Supported by Dynatrace

Automatically and intelligently observe, analyze and optimize the usage, health and performance of your Oracle database.

Overview
Get started
Metrics
Versions
Screenshots

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.

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)
Oracle DB 12.2+
Oracle AWS RDS

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_SESSION
SELECT_CATALOG_ROLE

roles granted, or set of SELECT permissions on the following performance views:

V$Metric
V$MetricGroup
V$SysStat
V$System_Event
V$System_Wait_Class
V$Parameter
V$PGAStat
V$SGAStat
V$LibraryCache
V$Sys_Time_Model
V$Session
V$Tablespace
V$Sqlarea
DBA_Data_Files
DBA_Lmt_Free_Space
DBA_Tablespaces
DBA_Temp_Free_Space

Activate log monitoring to get full log insight.

Note:
Enabling Most time consuming queries’ performance may expose sensitive data in reported queries.

Metrics

Name	Metric key	Unit	Description
Total space	com.dynatrace.extension.sql-oracle.tablespaces.totalSpace	Byte	Total size of tablespace
Free space	com.dynatrace.extension.sql-oracle.tablespaces.freeSpace	Byte	Free space in tablespace
Total space used	com.dynatrace.extension.sql-oracle.tablespaces.totalSpaceUsed	Byte	Total space used in tablespace
Used space ratio	com.dynatrace.extension.sql-oracle.tablespaces.usedSpaceRatio	Percent	Used space ratio

Name	Metric key	Unit	Description
ASM - Free space	com.dynatrace.extension.sql-oracle.asm.free_mb	MegaByte	Free disk space available on this Oracle ASM Disk
ASM - Total space	com.dynatrace.extension.sql-oracle.asm.total_mb	MegaByte	Total disk space available on this Oracle ASM Disk
ASM - Used space	com.dynatrace.extension.sql-oracle.asm.used_pct	Percent	Percentage of disk space used on this Oracle ASM Disk
ASM - Reads	com.dynatrace.extension.sql-oracle.asm.reads	Count	Number of reads from this Oracle ASM Disk
ASM - Writes	com.dynatrace.extension.sql-oracle.asm.writes	Count	Number of writes to this Oracle ASM Disk

Name	Metric key	Unit	Description
PGA aggregate limit	com.dynatrace.extension.sql-oracle.memory.pga.size.pgaAggregateLimit	Byte	Limit on the aggregate PGA memory consumed by the instance
PGA aggregate target	com.dynatrace.extension.sql-oracle.memory.pga.size.pgaAggregateTarget	Byte	Target aggregate PGA memory available to all server processes attached to the instance
PGA memory used	com.dynatrace.extension.sql-oracle.memory.pga.used	Byte	PGA memory consumed by work areas
Allocated PGA	com.dynatrace.extension.sql-oracle.memory.pga.allocated	Byte	Current amount of PGA memory allocated by the instance
Shared pool free	com.dynatrace.extension.sql-oracle.memory.sga.cacheBuffer.sharedPoolFree	Percent	Amount of free system global area (SGA) memory available in shared pool
-	com.dynatrace.extension.sql-oracle.memory.sga.redoBuffer.redoLogSpaceWaitTime	-	-
-	com.dynatrace.extension.sql-oracle.memory.sga.redoBuffer.redoSizeIncrease	-	-
-	com.dynatrace.extension.sql-oracle.memory.sga.redoBuffer.redoWriteTime	-	-
-	com.dynatrace.extension.sql-oracle.memory.sessionLogicalReads	-	-
-	com.dynatrace.extension.sql-oracle.memory.physicalReads	-	-
-	com.dynatrace.extension.sql-oracle.memory.physicalReadsDirect	-	-
-	com.dynatrace.extension.sql-oracle.memory.memorySorts	-	-
-	com.dynatrace.extension.sql-oracle.memory.diskSorts	-	-
Library cache hit ratio	com.dynatrace.extension.sql-oracle.memory.libraryCacheHitRatio	Percent	Library cache hit ratio

Name	Metric key	Unit	Description
Active Sessions	com.dynatrace.extension.sql-oracle.sessions.active	Unspecified	Active sessions count
Total sessions	com.dynatrace.extension.sql-oracle.sessions.all	Unspecified	Total sessions count
-	com.dynatrace.extension.sql-oracle.sessions.userCalls	-	-

Name	Metric key	Unit	Description
CPU cores	com.dynatrace.extension.sql-oracle.cpu.cores	Unspecified	Number of CPU cores
Background CPU	com.dynatrace.extension.sql-oracle.cpu.backgroundTotal	Percent	Total background CPU usage
Foreground CPU	com.dynatrace.extension.sql-oracle.cpu.foregroundTotal	Percent	Total foreground CPU usage
Host CPU usage	com.dynatrace.extension.sql-oracle.cpu.hostTotal	Percent	Total host CPU usage

Name	Metric key	Unit	Description
-	com.dynatrace.extension.sql-oracle.io.bytesRead	-	-
-	com.dynatrace.extension.sql-oracle.io.bytesWritten	-	-
-	com.dynatrace.extension.sql-oracle.io.wait	-	-

No matching metrics...

Name	Metric key	Unit	Description
-	com.dynatrace.extension.sql-oracle.wait.count	-	-
-	com.dynatrace.extension.sql-oracle.wait.time	-	-

Name	Metric key	Unit	Description
-	com.dynatrace.extension.sql-oracle.queries.connectionManagement	-	-
-	com.dynatrace.extension.sql-oracle.queries.plSqlExec	-	-
-	com.dynatrace.extension.sql-oracle.queries.sqlExec	-	-
-	com.dynatrace.extension.sql-oracle.queries.sqlParse	-	-
-	com.dynatrace.extension.sql-oracle.queries.dbTime	-	-
-	com.dynatrace.extension.sql-oracle.queries.cpuTime	-	-

Name	Metric key	Unit	Description
Sessions limit	com.dynatrace.extension.sql-oracle.limits.sessions	Unspecified	Sessions initialization parameter limit
Processes limit	com.dynatrace.extension.sql-oracle.limits.processes	Unspecified	Processes initialization parameter limit