Preview
We're still working on this feature, but we'd love for you to try it out!
This feature is currently provided as part of a preview pursuant to our pre-release policies.
Monitor your Oracle Database performance with comprehensive metrics collected by the NRDOT Collector. The following metrics are available for Oracle Database monitoring with NRDOT. Enable the relevant scrapers in your configuration to collect them.
Available metrics
Metric name | Description |
|---|---|
| Cumulative CPU time, in seconds |
| Number of times that a process detected a potential deadlock when exchanging two buffers and raised an internal, restartable error |
| Total number of calls (user and recursive) that executed SQL statements |
| Number of hard parses |
| Number of logical reads |
| Total number of parse calls |
| Session PGA (Program Global Area) memory |
| Number of physical reads |
| Count of active sessions |
| Maximum size of tablespace in bytes, -1 if unlimited |
| Used tablespace in bytes |
| Number of user commits. When a user commits a transaction, the redo generated that reflects the changes made to database blocks must be written to disk |
| Number of times users manually issue the ROLLBACK statement or an error occurs during a user's transactions |
| Number of times a consistent read was requested for a block from the buffer cache |
| Data dictionary cache hit ratio from v$rowcache |
| Number of times a current block was requested from the buffer cache |
| Number of DDL statements that were executed in parallel |
| Number of DML statements that were executed in parallel |
| Number of logon operations |
| Number of times parallel execution was requested and the degree of parallelism was reduced down to 1-25% because of insufficient parallel execution servers |
| Number of times parallel execution was requested and the degree of parallelism was reduced down to 25-50% because of insufficient parallel execution servers |
| Number of times parallel execution was requested and the degree of parallelism was reduced down to 50-75% because of insufficient parallel execution servers |
| Number of times parallel execution was requested and the degree of parallelism was reduced down to 75-99% because of insufficient parallel execution servers |
| Number of times parallel execution was requested but execution was serial because of insufficient parallel execution servers |
| Number of times parallel execution was executed at the requested degree of parallelism |
| Number of physical writes from the buffer cache to disk by DBWR. Sourced from v$sysstat name physical writes from cache |
| Number of physical I/O requests issued to storage. Sourced from v$sysstat names physical read/write total IO requests and physical read/write total multi block requests |
| Total physical I/O bytes transferred between Oracle and storage. Sums across all data files. Sourced from v$sysstat names physical read/write bytes and physical read/write total bytes |
| Number of read requests for application activity |
| Number of reads directly from disk, bypassing the buffer cache |
| Number of write requests for application activity |
| Number of physical writes |
| Number of writes directly to disk, bypassing the buffer cache |
| Number of SELECT statements executed in parallel |
| Total size of the recycle bin |
| Maximum size of the System Global Area (SGA) in bytes as reported by |
| Size in bytes of each component of the System Global Area (SGA) as reported by |
| Bytes transferred via SQLNet between Oracle and clients/dblinks. Sourced from |
| Used database storage size from dba_data_files and dba_free_space |
| Fraction of allocated database storage that is used |
| Maximum limit of active DML (Data Manipulation Language) locks, -1 if unlimited. Not supported in RDS. |
| Current count of active DML (Data Manipulation Language) locks. Not supported in RDS. |
| Total number of deadlocks between table or row locks in different sessions |
| Maximum limit of active enqueue locks, -1 if unlimited. Not supported in RDS. |
| Current count of active enqueue locks. Not supported in RDS. |
| Maximum limit of active enqueue resources, -1 if unlimited. Not supported in RDS. |
| Current count of active enqueue resources. Not supported in RDS. |
| Maximum limit of active processes, -1 if unlimited. Not supported in RDS. |
| Current count of active processes. Not supported in RDS. |
| Maximum limit of active sessions, -1 if unlimited. Not supported in RDS. |
| Fraction of the shared pool that is currently free, as computed by Oracle |
| Fraction of sorts performed in memory vs disk, as computed by Oracle |
| Average SQL service response time in seconds, converted from centiseconds as reported by Oracle |
| Fraction of redo allocations that succeeded without space contention, as computed by Oracle |
| Rate of parse operations per second broken down by result, as computed by Oracle |
| Fraction of parse calls that were soft parses, as computed by Oracle |
| Fraction of executions that did not require a parse, as computed by Oracle |
| Fraction of host CPU time in use, as computed by Oracle |
| Fraction of library cache pin requests that found the object already cached, as computed by Oracle |
| Fraction of total database time spent on CPU, as computed by Oracle |
| Fraction of total database time spent waiting on I/O, locks, or latches, as computed by Oracle |
| Maximum limit of active transactions, -1 if unlimited. Not supported in RDS. |
| Current count of active transactions. Not supported in RDS. |
| Fraction of logical reads served from the buffer cache without physical I/O, as computed by Oracle |
All 5 metrics are disabled by default (opt-in). Requires the V_$ASM_DISKGROUP_STAT and V_$ASM_DISK_STAT grants.
Metric name | Description |
|---|---|
| Free space in an ASM diskgroup. |
| Total space in an ASM diskgroup. |
| Free space that can safely be used for files after accounting for ASM redundancy and required mirror recovery capacity. |
| Count of disks currently offline within an ASM diskgroup. |
| Count of I/O errors on an ASM disk. |
Per-session active query samples. Captures the current execution state of active Oracle sessions at collection time.
Attribute name | Description |
|---|---|
| The text of the database query being executed |
| The database management system (DBMS) product as identified by the client instrumentation |
| Database user name under which a session is connected to |
| The database name |
| The Oracle service name associated with the database connection |
| Hostname or address of the client |
| TCP port used by the client |
| IP address of the peer client |
| TCP port used by the peer client |
| Binary hash value calculated on the query execution plan, reported in HEX format |
| The SQL ID of the query |
| The child number of the query |
| Address of the child cursor |
| ID of the Oracle Server session |
| Serial number associated with a session |
| The operating system process ID (PID) associated with a session |
| Oracle schema under which SQL statements are being executed |
| Name of the client program or tool that initiated the Oracle database session |
| Logical module name of the client application that initiated a query or session |
| Execution state or result of a database query or session |
| Current state of the query or the session executing it |
| The category of wait events a query or session is currently experiencing in Oracle Database |
| The specific wait event that a query or session is currently experiencing |
| The wait time in seconds. Returns 0 if the session is not currently waiting |
| The identifier of the stored procedure or function being executed by the query |
| Name of the database object that a query is accessing |
| Type of the database object that a query is accessing |
| Name of the operating system user that initiated or is running the Oracle database session |
| Total time taken by a database query to execute |
| Filtered SQL query comments extracted from leading block comments. Contains comma-separated key=value pairs for correlation with APM traces |
| New Relic service GUID extracted from db.query.comment_tags. Used for correlation with APM traces |
| The timestamp when the SQL statement started execution, in ISO 8601 format (UTC) |
| The timestamp when the session logged on, in ISO 8601 format (UTC) |
| The total time in seconds that the session has been connected |
| The session ID (SID) of the immediate blocker of this session. Empty when not blocked |
| The session ID (SID) of the root/head blocker at the top of the blocking chain |
| The status of the blocking session relationship (e.g. VALID, NOT IN WAIT, GLOBAL, NO HOLDER, UNKNOWN) |
| Estimated UTC timestamp of when the blocking wait began. RFC3339 format |
| The number of seconds this session has been waiting for the current wait event |
| The lock mode being requested by the blocked session (e.g., ROW SHARE, ROW EXCLUSIVE, SHARE, EXCLUSIVE) |
| The type of enqueue lock the session is waiting on (e.g., TX for row lock, TM for table lock) |
| The owner (schema) of the database object the session is waiting to lock |
| The name of the database object the session is waiting to lock |
| MD5 hash of normalized SQL query |
Per-session wait event statistics. Captures wait duration counts and durations per session.
Attribute name | Description |
|---|---|
| ID of the Oracle Server session |
| Serial number associated with a session |
| The specific wait event that a query or session is currently experiencing |
| The category of wait events a query or session is currently experiencing in Oracle Database |
| Total number of waits for the wait event across all sessions |
| Total time waited in seconds for the wait event |
Collection of event metrics for top N queries, filtered based on the highest elapsed time consumed in the collection interval.
Attribute name | Description |
|---|---|
| The database management system (DBMS) product as identified by the client instrumentation |
| The name of the server hosting the database |
| The database name |
| The Oracle service name associated with the database connection |
| The text of the database query being executed |
| The query execution plan used by the SQL Server |
| The SQL ID of the query |
| The child number of the query |
| Address of the child cursor |
| Total time (in seconds) a query spent waiting on the application before it could proceed |
| Number of logical reads (buffer cache accesses) performed by a query |
| Total time (in seconds) that a query waited due to Oracle RAC coordination |
| Command type of the query |
| Total time (in seconds) a query spent waiting on concurrency-related events |
| Total time (in seconds) that the CPU spent actively processing a query, excluding wait time |
| Number of direct path reads performed by a query — data blocks read directly from disk into session memory |
| Number of direct path write operations, where data is written directly to disk from user memory |
| Number of physical reads a query performs — data blocks read from disk |
| Total time (in seconds) taken by a query from start to finish, including CPU time and all types of waits |
| Number of times a specific SQL query has been executed |
| Total number of bytes read from disk by a query |
| Number of physical I/O read operations performed by a query |
| Total number of bytes written to disk by a query |
| Number of times a query requested to write data to disk |
| Total number of rows that a query has read, returned, or affected during execution |
| Total time (in seconds) a query spent waiting for user I/O operations |
| Number of times the stored procedure has been executed (reporting delta, best effort) |
| The identifier of the stored procedure or function being executed by the query |
| Name of the database object that a query is accessing |
| Type of the database object that a query is accessing |
| Filtered SQL query comments extracted from leading block comments. Contains comma-separated key=value pairs for correlation with APM traces |
| New Relic service GUID extracted from db.query.comment_tags. Used for correlation with APM traces |
| Binary hash value calculated on the query execution plan, reported in HEX format |
| Time at which the plan was first loaded into the library cache, in server's local timezone. Format: YYYY-MM-DD/HH:MM:SS |
| Plan load time in server's local timezone. Format: YYYY-MM-DD/HH:MM:SS |
| MD5 hash of normalized SQL query following New Relic Java agent normalization logic. Used for correlation with APM slow query traces |