Oracle Database
Oracle Database
Overview
The Oracle Database integration with Motadata AIOps captures health, performance, capacity, availability, and replication KPIs across single-instance and RAC environments. It includes SGA/PGA memory utilization, buffer/cache efficiency, redo/undo activity, datafile and tablespace usage, SQL workload, ASM disk groups, jobs/backups, session analytics, and fast recovery area utilization.
Prerequisites
Ensure the following prerequisites are met:
- Oracle listener reachable from Motadata AIOps.
- Monitoring user with required dictionary views (SELECT_CATALOG_ROLE recommended).
- If using RAC/ASM, grant access to GV$ views and ASM views.
- Network access allowed to SQL*Net/TCPS ports and OS-level exporters (if used).
List of Supported KPIs
A. Instance & General
| Metric | Description | Type |
|---|---|---|
| oracle.created.time | Database creation time. | Timestamp |
| oracle.log.mode | Current log mode (ARCHIVELOG/NOARCHIVELOG). | String |
| oracle.open.mode | Database open mode (READ WRITE/READ ONLY/MOUNTED). | String |
| oracle.version | Oracle database version string. | String |
| system.tags | Key/value tags associated with this instance. | String |
| started.time.seconds | Uptime in seconds since instance start. | Seconds |
| started.time | Human-readable instance start time. | Timestamp |
| oracle.database.role | Database role (PRIMARY/STANDBY/SNAPSHOT STANDBY). | String |
| oracle.switch.over.status | Data Guard switchover status. | String |
| oracle.protection.mode | Data Guard protection mode. | String |
| oracle.force.logging | Whether FORCE LOGGING is enabled. | Boolean |
| oracle.guard.status | Database guard status. | String |
| oracle.open.reset.logs.time | Time of last RESETLOGS open. | Timestamp |
| oracle.database.current.scn | Current System Change Number. | Integer |
| oracle.maximum.allocated.datafiles | Maximum datafiles allowed. | Count |
| oracle.used.datafiles | Number of datafiles in use. | Count |
| oracle.available.datafiles | Remaining datafiles available to allocate. | Count |
| oracle.datafiles.used.percent | Percent of max datafiles used. | Percent |
| oracle.datafiles.available.percent | Percent of max datafiles available. | Percent |
B. Capacity & Space
| Metric | Description | Type |
|---|---|---|
| oracle.database.used.bytes | Space used by database objects. | Bytes |
| oracle.database.used.percent | Percentage of database space used. | Percent |
| oracle.database.capacity.bytes | Total database capacity. | Bytes |
| oracle.database.allocated.bytes | Space allocated to database. | Bytes |
| oracle.database.occupied.bytes | Occupied space including overhead. | Bytes |
| oracle.database.free.bytes | Free space available. | Bytes |
| oracle.database.free.percent | Percent free space. | Percent |
| oracle.database.block.size.bytes | Database block size. | Bytes |
C. Workload & Waits
| Metric | Description | Type |
|---|---|---|
| oracle.avg.executions | Average executions per statement/interval. | Count |
| oracle.consistent.gets | Logical reads (consistent gets). | Count |
| oracle.buffer.busy.waits | Buffer busy waits count. | Count |
| oracle.free.buffer.waits | Free buffer waits count. | Count |
| oracle.write.complete.waits | Write complete waits count. | Count |
| oracle.database.block.gets | Current reads (db block gets). | Count |
| oracle.database.physical.reads | Physical reads. | Count |
| oracle.database.physical.writes | Physical writes. | Count |
| oracle.enqueue.timeouts | Enqueue operation timeouts. | Count |
| oracle.enqueue.waits | Enqueue waits. | Count |
| oracle.logins | Successful logins count. | Count |
| oracle.enqueue.deadlocks | Deadlock occurrences. | Count |
| oracle.enqueue.requests | Enqueue requests. | Count |
| oracle.enqueue.conversations | Enqueue conversations. | Count |
| oracle.enqueue.releases | Enqueue releases. | Count |
| oracle.table.scans | Full table scan operations. | Count |
| oracle.index.scans | Index scan operations. | Count |
| oracle.average.response.time.ms | Average database response time. | Milliseconds |
| oracle.database.cpu.time.ratio | Ratio of DB time spent on CPU. | Percent |
| oracle.sql.net.transferred.bytes | SQL*Net bytes transferred. | Bytes |
D. Cursor & Library/Dictionary Cache
| Metric | Description | Type |
|---|---|---|
| oracle.cursor.hit.ratio.percent | Cursor cache hit ratio. | Percent |
| oracle.cursor.miss.ratio.percent | Cursor miss ratio. | Percent |
| oracle.cursor.cache.bytes | Cursor cache memory used. | Bytes |
| oracle.sql.cache.hit.ratio.percent | SQL cache hit ratio. | Percent |
| oracle.library.cache.hit.ratio.percent | Library cache hit ratio. | Percent |
| oracle.library.cache.used.bytes | Library cache memory used. | Bytes |
| oracle.sql.area.used.bytes | SQL area memory used. | Bytes |
| oracle.data.dictionary.cache.hit.ratio.percent | Data dictionary cache hit ratio. | Percent |
| oracle.data.dictionary.cache.used.bytes | Data dictionary cache memory used. | Bytes |
| oracle.parse.ratio.percent | Soft parse ratio (parse efficiency). | Percent |
E. Sessions & Processes
| Metric | Description | Type |
|---|---|---|
| oracle.waiting.sessions | Number of sessions waiting. | Count |
| oracle.blocking.sessions | Number of sessions blocking others. | Count |
| oracle.idle.sessions | Idle sessions count. | Count |
| oracle.sessions | Total sessions. | Count |
| oracle.active.sessions | Active sessions count. | Count |
Session Detail
| Metric | Description | Type |
|---|---|---|
| oracle.session | Session identifier. | String |
| oracle.waiting.session | Waiting session identifier. | String |
| oracle.blocked.session | Blocked session identifier. | String |
| oracle.session.id | SID of session. | Integer |
| oracle.session.command | Current command ID. | Integer |
| oracle.session.status | Session status (ACTIVE/INACTIVE). | String |
| oracle.session.remote.client | Remote client address. | String |
| oracle.session.device.sessions | Number of device sessions. | Count |
| oracle.session.user | Database user for session. | String |
| oracle.session.query | Current/last SQL text (sanitized). | String |
| oracle.session.application | Client application name. | String |
| oracle.session.duration.seconds | Session duration in seconds. | Seconds |
| oracle.session.duration | Human-readable session duration. | String |
| oracle.session.logon.time | Logon timestamp. | Timestamp |
| oracle.session.cpu.time.ms | CPU time consumed by session. | Milliseconds |
| oracle.session.memory.sorts | Memory sorts performed. | Count |
| oracle.session.disk.sorts | Disk sorts performed. | Count |
| oracle.session.table.sorts | Table sorts performed. | Count |
| oracle.session.physical.reads | Physical reads by session. | Count |
| oracle.session.logical.reads | Logical reads by session. | Count |
| oracle.session.commits | Commits by session. | Count |
| oracle.session.cursors | Open cursors for session. | Count |
| oracle.connected.sessions | Connected sessions (current). | Count |
| oracle.active.sessions | Active sessions (current). | Count |
| oracle.idle.sessions | Idle sessions (current). | Count |
| oracle.session.blocking.id | SID of blocking session. | Integer |
| oracle.session.serial.id | SERIAL# of session. | Integer |
| oracle.waiting.session.id | SID of waiting session. | Integer |
| oracle.session.blocking.user | Username of blocking session. | String |
| oracle.session.wait.duration.seconds | Wait duration seconds. | Seconds |
| oracle.blocked.sessions | Total blocked sessions. | Count |
| oracle.blocked.session.id | Blocked session SID. | Integer |
| oracle.session.blocked.id | Blocked session identifier. | String |
| oracle.session.blocked.user | Blocked session username. | String |
| oracle.session.blocking.program | Program of blocking session. | String |
| oracle.session.blocked.program | Program of blocked session. | String |
| oracle.session.blocking.host | Hostname of blocking session. | String |
| oracle.session.blocked.host | Hostname of blocked session. | String |
| oracle.session.lock.type | Lock type held/requested. | String |
| oracle.session.blocking.lock.mode | Blocking lock mode. | String |
| oracle.session.blocked.lock.mode | Requested/blocked lock mode. | String |
| oracle.session.lock.id2 | Lock ID2 value. | String |
| oracle.session.lock.id1 | Lock ID1 value. | String |
| oracle.session.buffer.cache.hit.ratio | Session buffer cache hit ratio. | Percent |
| oracle.session.event | Current wait event. | String |
| oracle.session.state | Session wait state. | String |
| oracle.session.wait.time.ms | Session wait time in ms. | Milliseconds |
| oracle.session.events | Session events summary. | String |
User Accounts
| Metric | Description | Type |
|---|---|---|
| oracle.user | Username. | String |
| oracle.user.expiry.date | Password/account expiry date. | Timestamp |
| oracle.user.days.to.expiry | Days remaining to expiry. | Days |
| oracle.user.status | Account status (OPEN/LOCKED). | String |
| oracle.user.profile | Assigned profile. | String |
F. Memory (SGA/PGA)
| Metric | Description | Type |
|---|---|---|
| oracle.pga.used.bytes | PGA used memory. | Bytes |
| oracle.pga.allocated.bytes | PGA allocated memory. | Bytes |
| oracle.pga.processes | Current PGA processes. | Count |
| oracle.pga.max.processes | Max PGA processes observed. | Count |
| oracle.pga.cache.hit.ratio.percent | PGA cache hit ratio. | Percent |
| oracle.pga.max.allocated.bytes | Max PGA allocated bytes. | Bytes |
| oracle.pga.reclaimable.bytes | Reclaimable PGA bytes. | Bytes |
| oracle.pga.freed.os.bytes | Bytes returned to OS from PGA. | Bytes |
| oracle.pga.free.bytes | Free PGA bytes. | Bytes |
| oracle.pga.used.percent | PGA usage percent. | Percent |
| oracle.fixed.sga.used.bytes | Fixed SGA used memory. | Bytes |
| oracle.redo.buffers | Redo buffers size. | Bytes |
| oracle.streams.pool.used.bytes | Streams pool used memory. | Bytes |
| oracle.buffer.cache.used.bytes | Buffer cache used memory. | Bytes |
| oracle.shared.pool.used.bytes | Shared pool used memory. | Bytes |
| oracle.shared.io.pool.used.bytes | Shared I/O pool used memory. | Bytes |
| oracle.large.pool.used.bytes | Large pool used memory. | Bytes |
| oracle.java.pool.used.bytes | Java pool used memory. | Bytes |
| oracle.sga.memory.free.bytes | Free SGA memory. | Bytes |
| oracle.sga.used.bytes | SGA used bytes (alias). | Bytes |
| oracle.sga.memory.used.bytes | SGA memory used. | Bytes |
| oracle.sga.used.percent | SGA usage percent. | Percent |
Process-level PGA
| Metric | Description | Type |
|---|---|---|
| oracle.process | Process identifier. | String |
| oracle.process.pid | Oracle PID. | Integer |
| oracle.process.spid | OS SPID. | Integer |
| oracle.process.program | Process program name. | String |
| oracle.process.pga.used.bytes | Process PGA used. | Bytes |
| oracle.process.pga.allocated.bytes | Process PGA allocated. | Bytes |
| oracle.process.pga.free.bytes | Process PGA free. | Bytes |
| oracle.process.pga.max.bytes | Process PGA max observed. | Bytes |
G. Logging & Data Guard Destinations
| Metric | Description | Type |
|---|---|---|
| oracle.last.log.sequence.created.primary.server | Last archived log sequence created on primary. | Integer |
| oracle.last.log.sequence.synced.secondary.server | Last log sequence synced to standby. | Integer |
| oracle.log.apply.gap | Apply lag/gap between standby and primary. | Integer |
| oracle.log.destination.id | Destination ID. | Integer |
| oracle.log.destination | Destination name/alias. | String |
| oracle.log.destination.status | Destination status. | String |
| oracle.log.destination.type | Destination type (LOCAL/REMOTE). | String |
| oracle.log.destination.path | Destination path/URI. | String |
| oracle.log.destination.protection.mode | Destination protection mode. | String |
| oracle.log.destination.recovery.mode | Destination recovery mode. | String |
| oracle.log.destination.affirm | AFFIRM/NOAFFIRM setting. | String |
| oracle.log.destination.sequence | Current sequence at destination. | Integer |
| oracle.log.destination.timeout.seconds | Destination timeout seconds. | Seconds |
| oracle.log.destination.fail.sequence | Failed sequence number. | Integer |
| oracle.log.destination.archived.sequence | Last archived sequence. | Integer |
| oracle.log.destination.applied.sequence | Last applied sequence. | Integer |
| oracle.log.destination.delay.seconds | Transport/apply delay. | Seconds |
| oracle.log.destination.error | Last destination error. | String |
Redo Log Internals
| Metric | Description | Type |
|---|---|---|
| oracle.redo.log.buffer.allocation.retries.ratio | Buffer allocation retry ratio. | Percent |
| oracle.redo.log.space.request.ratio | Redo space request ratio. | Percent |
| oracle.redo.log.space.wait.ratio | Redo space wait ratio. | Percent |
| oracle.redo.log.buffer.size.bytes | Redo buffer size. | Bytes |
| oracle.redo.log.switches.hour | Log switches per hour. | Count |
| oracle.redo.log.current.usage.percent | Current log usage percent. | Percent |
| oracle.redo.log.member | Redo log member identifier. | String |
| oracle.redo.log.member.name | Log member file name. | String |
| oracle.redo.log.member.group | Group number of member. | Integer |
| oracle.redo.log.member.type | Member type (ONLINE/STANDBY). | String |
| oracle.redo.log.member.state | Member state (VALID/INVALID). | String |
| oracle.redo.log.group | Redo log group identifier. | String |
| oracle.redo.log.group.id | Redo log group ID. | Integer |
| oracle.redo.log.group.thread | Thread number. | Integer |
| oracle.redo.log.group.size.bytes | Log file size. | Bytes |
| oracle.redo.log.group.members | Members per group. | Count |
| oracle.redo.log.group.archive.status | Archive status for group. | String |
| oracle.redo.log.group.status | Group status (CURRENT/INACTIVE/etc.). | String |
H. Fast Recovery Area (FRA)
| Metric | Description | Type |
|---|---|---|
| oracle.fast.recovery.area | FRA location identifier. | String |
| oracle.fast.recovery.area.space.capacity.bytes | Total FRA capacity. | Bytes |
| oracle.fast.recovery.area.space.used.bytes | FRA space used. | Bytes |
| oracle.fast.recovery.area.used.percent | FRA usage percent. | Percent |
| oracle.fast.recovery.area.space.reclaimable.bytes | Reclaimable space in FRA. | Bytes |
| oracle.fast.recovery.area.reclaimable.percent | Reclaimable percent. | Percent |
| oracle.fast.recovery.area.actual.used.percent | Actual used percent after reclaim. | Percent |
| oracle.fast.recovery.area.filetype | FRA file type. | String |
| oracle.fast.recovery.area.filetype.used.percent | Usage percent by file type. | Percent |
| oracle.fast.recovery.area.filetype.reclaimable.percent | Reclaimable percent by file type. | Percent |
| oracle.fast.recovery.area.filetype.files | File count by file type. | Count |
I. ASM Disk Groups
| Metric | Description | Type |
|---|---|---|
| oracle.asm.disk.group.number | ASM disk group number. | Integer |
| oracle.asm.disk.group | ASM disk group name. | String |
| oracle.asm.disk.group.state | Disk group state. | String |
| oracle.asm.disk.group.type | Redundancy type (EXTERNAL/NORMAL/HIGH). | String |
| oracle.asm.disk.group.provisioned.bytes | Provisioned capacity. | Bytes |
| oracle.asm.disk.group.free.bytes | Free space in group. | Bytes |
| oracle.asm.disk.group.used.bytes | Used space in group. | Bytes |
| oracle.asm.disk.group.used.percent | Used percent. | Percent |
| oracle.asm.disk.group.free.percent | Free percent. | Percent |
J. Datafiles & Tablespaces
Data Files
| Metric | Description | Type |
|---|---|---|
| oracle.data.files | Total data files. | Count |
| oracle.data.file.id | Datafile ID. | Integer |
| oracle.data.file.tablespace | Owning tablespace. | String |
| oracle.data.file.read.time.ms | Read time for file. | Milliseconds |
| oracle.data.file.write.time.ms | Write time for file. | Milliseconds |
| oracle.data.file.size.bytes | Datafile size. | Bytes |
| oracle.data.file | Datafile path/name. | String |
| oracle.data.file.status | File status. | String |
| oracle.data.file.corrupted | Corruption flag. | Boolean |
| oracle.data.file.corruption.type | Corruption type. | String |
| oracle.data.file.corrupted.block | First corrupted block. | Integer |
| oracle.data.file.corrupted.blocks | Number of corrupted blocks. | Count |
| oracle.data.file.physical.reads | Physical reads per file. | Count |
| oracle.data.file.physical.writes | Physical writes per file. | Count |
| oracle.data.file.auto.extend | Autoextend status. | Boolean |
Tablespaces
| Metric | Description | Type |
|---|---|---|
| oracle.table.spaces | Number of tablespaces. | Count |
| oracle.table.space | Tablespace name. | String |
| oracle.table.space.size.bytes | Total size. | Bytes |
| oracle.table.space.used.bytes | Used size. | Bytes |
| oracle.table.space.free.bytes | Free size. | Bytes |
| oracle.table.space.free.percent | Free percent. | Percent |
| oracle.table.space.used.percent | Used percent. | Percent |
| oracle.table.space.blocks | Total blocks. | Count |
| oracle.table.space.free.blocks | Free blocks. | Count |
| oracle.table.space.write.time.ms | Write time aggregate. | Milliseconds |
| oracle.table.space.read.time.ms | Read time aggregate. | Milliseconds |
| oracle.table.space.data.files | Datafiles in tablespace. | Count |
| oracle.table.space.reads.rate | Reads/sec in tablespace. | Count |
| oracle.table.space.writes.rate | Writes/sec in tablespace. | Count |
| oracle.table.space.status | Status (ONLINE/OFFLINE). | String |
Temporary Tablespaces
| Metric | Description | Type |
|---|---|---|
| oracle.temp.table.space.size.bytes | Temp space size. | Bytes |
| oracle.temp.table.space.free.bytes | Temp free space. | Bytes |
| oracle.temp.table.space.used.bytes | Temp used space. | Bytes |
| oracle.temp.table.space.used.percent | Temp used percent. | Percent |
Tables
| Metric | Description | Type |
|---|---|---|
| oracle.table | Table identifier. | String |
| oracle.table.space.name | Tablespace of table. | String |
| oracle.table.status | Table status. | String |
| oracle.table.rows | Row count (approx). | Count |
| oracle.table.partitioned | Partitioned flag. | Boolean |
| oracle.table.size.bytes | Table size. | Bytes |
K. Indexes
| Metric | Description | Type |
|---|---|---|
| oracle.index | Index identifier. | String |
| oracle.index.table.name | Base table name. | String |
| oracle.index.index.type | Index type (BTREE/BITMAP/etc.). | String |
| oracle.index.uniqueness | UNIQUE/NONUNIQUE. | String |
| oracle.index.column.name | Indexed column. | String |
| oracle.indices | Total indexes count. | Count |
| oracle.database.invalid.index | Invalid index identifier. | String |
| oracle.database.invalid.index.tablespace | TS for invalid index. | String |
| oracle.database.invalid.index.owner | Owner of invalid index. | String |
| oracle.database.invalid.index.table | Table of invalid index. | String |
| oracle.database.invalid.index.status | Invalid index status. | String |
Unused Indexes
| Metric | Description | Type |
|---|---|---|
| oracle.unused.index | Unused index identifier. | String |
| oracle.unused.index.owner | Owner of unused index. | String |
| oracle.unused.index.table.name | Table for unused index. | String |
| oracle.unused.index.rows | Rows referenced by index. | Count |
| oracle.unused.index.size.bytes | Size of unused index. | Bytes |
| oracle.unused.index.constraint.name | Related constraint (if any). | String |
| oracle.unused.index.idle.time.days | Days since last usage. | Days |
| oracle.unused.indices | Count of unused indexes. | Count |
L. Links, Invalid Objects
| Metric | Description | Type |
|---|---|---|
| oracle.database.link | DB link identifier. | String |
| oracle.database.link.name | DB link name. | String |
| oracle.database.link.owner | Owner schema. | String |
| oracle.database.link.user | Remote user. | String |
| oracle.database.link.connection.url | Remote connection URL. | String |
| oracle.database.link.creation.time | DB link creation time. | Timestamp |
| oracle.database.invalid.object | Invalid object identifier. | String |
| oracle.database.invalid.object.name | Invalid object name. | String |
| oracle.database.invalid.object.owner | Owner of invalid object. | String |
| oracle.database.invalid.object.status | Status of invalid object. | String |
M. Jobs & Backups
Scheduler Jobs
| Metric | Description | Type |
|---|---|---|
| oracle.job | Job identifier. | String |
| oracle.job.last.status | Last run status. | String |
| oracle.job.current.status | Current job state. | String |
| oracle.job.last.execution.time | Timestamp of last run. | Timestamp |
| oracle.job.next.execution.time | Next scheduled run time. | Timestamp |
| oracle.job.enable | Enabled flag. | Boolean |
| oracle.job.last.execution.duration.seconds | Last run duration. | Seconds |
| oracle.job.executions | Total executions. | Count |
| oracle.job.fails | Failed executions. | Count |
| oracle.job.retries | Retry attempts. | Count |
| oracle.job.elapsed.time.seconds | Cumulated elapsed time. | Seconds |
| oracle.job.elapsed.time | Human-readable elapsed time. | String |
RMAN / Backup Jobs
| Metric | Description | Type |
|---|---|---|
| oracle.backup.job | Backup job identifier. | String |
| oracle.backup.job.type | Backup type (FULL/INCR/etc.). | String |
| oracle.backup.job.session.key | RMAN session key. | String |
| oracle.backup.job.last.backup.time | Last backup timestamp. | Timestamp |
| oracle.backup.job.status | Backup job status. | String |
| oracle.backup.job.elapsed.time.seconds | Backup elapsed time. | Seconds |
| oracle.backup.job.size.bytes | Backup size. | Bytes |
N. SQL/Query Metrics
| Metric | Description | Type |
|---|---|---|
| oracle.database.query | Query identifier. | String |
| oracle.database.query.buffer.gets | Buffer gets for query. | Count |
| oracle.database.query.executions | Executions count. | Count |
| oracle.database.query.buffer.gets.per.execution | Buffer gets per exec. | Count |
| oracle.database.query.disk.reads | Disk reads. | Count |
| oracle.database.query.disk.reads.per.execution | Disk reads per exec. | Count |
| oracle.database.query.text | SQL text (sanitized). | String |
| oracle.query.username | Username executing SQL. | String |
| oracle.query.sid | SID of executing session. | Integer |
| oracle.query.executions | Executions count. | Count |
| oracle.query.last.update.time | Last execution timestamp. | Timestamp |
| oracle.query.sql.id | SQL_ID value. | String |
| oracle.query.start.time | Start time of execution. | Timestamp |
| oracle.query.elapsed.seconds | Elapsed time seconds. | Seconds |
| oracle.query | SQL text/context. | String |
O. Resources & Limits
| Metric | Description | Type |
|---|---|---|
| oracle.resource.current.utilized.percent | Current utilization vs. limit. | Percent |
| oracle.resource.max.utilized.percent | Peak utilization vs. limit. | Percent |
| oracle.resource.limit | Resource limit name. | String |
| oracle.resource.used.percent | Used percent for resource. | Percent |
| oracle.resource | Resource identifier. | String |
P. RAC (Real Application Clusters)
RAC Instance Info
| Metric | Description | Type |
|---|---|---|
| oracle.rac.instance | RAC instance identifier. | String |
| oracle.rac.instance.database.version | DB version on instance. | String |
| oracle.rac.instance.status | Instance status. | String |
| oracle.rac.instance.host.name | Hostname for instance. | String |
RAC Cluster Overview
| Metric | Description | Type |
|---|---|---|
| oracle.rac.cluster.active.sessions | Active sessions (cluster). | Count |
| oracle.rac.cluster.waiting.sessions | Waiting sessions (cluster). | Count |
| oracle.rac.cluster.blocking.sessions | Blocking sessions (cluster). | Count |
| oracle.rac.cluster.buffer.cache.hit.ratio.percent | Buffer cache hit ratio. | Percent |
| oracle.rac.cluster.data.dictionary.cache.hit.ratio.percent | Data dictionary cache hit ratio. | Percent |
| oracle.rac.cluster.parse.ratio.percent | Parse ratio. | Percent |
| oracle.rac.cluster.sql.cache.hit.ratio.percent | SQL cache hit ratio. | Percent |
| oracle.rac.cluster.library.cache.hit.ratio.percent | Library cache hit ratio. | Percent |
| oracle.rac.cluster.library.cache.used.bytes | Library cache used. | Bytes |
| oracle.rac.cluster.sql.area.used.bytes | SQL area used. | Bytes |
| oracle.rac.cluster.sga.memory.free.bytes | Free SGA bytes. | Bytes |
| oracle.rac.cluster.sga.used.bytes | SGA used bytes. | Bytes |
| oracle.rac.cluster.sga.memory.used.bytes | SGA memory used. | Bytes |
| oracle.rac.cluster.sga.used.percent | SGA used percent. | Percent |
| oracle.rac.cluster.fixed.sga.used.bytes | Fixed SGA used. | Bytes |
| oracle.rac.cluster.redo.buffers | Redo buffers size. | Bytes |
| oracle.rac.cluster.streams.pool.used.bytes | Streams pool used. | Bytes |
| oracle.rac.cluster.buffer.cache.used.bytes | Buffer cache used. | Bytes |
| oracle.rac.cluster.shared.pool.used.bytes | Shared pool used. | Bytes |
| oracle.rac.cluster.shared.io.pool.used.bytes | Shared I/O pool used. | Bytes |
| oracle.rac.cluster.large.pool.used.bytes | Large pool used. | Bytes |
| oracle.rac.cluster.java.pool.used.bytes | Java pool used. | Bytes |
| oracle.rac.cluster.database.used.bytes | DB used bytes. | Bytes |
| oracle.rac.cluster.database.allocated.bytes | DB allocated bytes. | Bytes |
| oracle.rac.cluster.database.occupied.bytes | DB occupied bytes. | Bytes |
| oracle.rac.cluster.database.free.bytes | DB free bytes. | Bytes |
| oracle.rac.cluster.avg.executions | Avg executions. | Count |
| oracle.rac.cluster.consistent.gets | Consistent gets. | Count |
| oracle.rac.cluster.buffer.busy.waits | Buffer busy waits. | Count |
| oracle.rac.cluster.free.buffer.waits | Free buffer waits. | Count |
| oracle.rac.cluster.write.complete.waits | Write complete waits. | Count |
| oracle.rac.cluster.database.block.gets | Block gets. | Count |
| oracle.rac.cluster.database.physical.reads | Physical reads. | Count |
| oracle.rac.cluster.database.physical.writes | Physical writes. | Count |
| oracle.rac.cluster.database.block.used.bytes | Block bytes used. | Bytes |
| oracle.rac.cluster.enqueue.timeouts | Enqueue timeouts. | Count |
| oracle.rac.cluster.enqueue.waits | Enqueue waits. | Count |
| oracle.rac.cluster.logins | Logins. | Count |
| oracle.rac.cluster.user.commits | User commits. | Count |
| oracle.rac.cluster.user.rollbacks | User rollbacks. | Count |
| oracle.rac.cluster.user.calls | User calls. | Count |
| oracle.rac.cluster.opened.cursors | Opened cursors. | Count |
| oracle.rac.cluster.memory.sorts | Memory sorts. | Count |
| oracle.rac.cluster.disk.sorts | Disk sorts. | Count |
| oracle.rac.cluster.rows.sorts | Rows sorted. | Count |
| oracle.rac.cluster.enqueue.deadlocks | Deadlocks. | Count |
| oracle.rac.cluster.enqueue.requests | Enqueue requests. | Count |
| oracle.rac.cluster.enqueue.conversations | Enqueue conversations. | Count |
| oracle.rac.cluster.enqueue.releases | Enqueue releases. | Count |
| oracle.rac.cluster.table.scans | Full table scans. | Count |
| oracle.rac.cluster.index.scans | Index scans. | Count |
| oracle.rac.cluster.cursor.hit.ratio.percent | Cursor hit ratio. | Percent |
| oracle.rac.cluster.cursor.miss.ratio.percent | Cursor miss ratio. | Percent |
| oracle.rac.cluster.pga.used.bytes | PGA used. | Bytes |
| oracle.rac.cluster.pga.allocated.bytes | PGA allocated. | Bytes |
| oracle.rac.cluster.pga.processes | PGA processes. | Count |
| oracle.rac.cluster.pga.max.processes | Max PGA processes. | Count |
| oracle.rac.cluster.pga.cache.hit.ratio.percent | PGA cache hit ratio. | Percent |
| oracle.rac.cluster.pga.free.bytes | PGA free bytes. | Bytes |
| oracle.rac.cluster.pga.used.percent | PGA used percent. | Percent |
| oracle.rac.cluster.name | Cluster name. | String |
| oracle.rac.cluster.global.db.name | Global DB name. | String |
| oracle.rac.cluster.home | Oracle home path. | String |
| oracle.rac.cluster.shared.disks | Shared disks flag/count. | String |
| oracle.rac.cluster.instance | Instance identifier. | String |
| oracle.rac.cluster.instances | Instances count. | Count |
| oracle.rac.cluster.instance.name | Instance name. | String |
| oracle.rac.cluster.instance.node | Node name. | String |
| oracle.rac.cluster.instance.sessions | Sessions per instance. | Count |
| oracle.rac.cluster.instance.status | Instance status. | String |
| oracle.rac.cluster.instance.uptime | Instance uptime. | String |
| oracle.rac.cluster.asm.disk.group.number | ASM DG number. | Integer |
| oracle.rac.cluster.asm.disk.group | ASM DG name. | String |
| oracle.rac.cluster.asm.disk.group.state | ASM DG state. | String |
| oracle.rac.cluster.asm.disk.group.type | ASM DG type. | String |
| oracle.rac.cluster.asm.disk.group.provisioned.bytes | Provisioned bytes. | Bytes |
| oracle.rac.cluster.asm.disk.group.free.bytes | Free bytes. | Bytes |
| oracle.rac.cluster.asm.disk.group.used.bytes | Used bytes. | Bytes |
| oracle.rac.cluster.pluggable.database | PDB identifier. | String |
| oracle.rac.cluster.pluggable.databases | PDBs count. | Count |
| oracle.rac.cluster.pluggable.database.status | PDB status. | String |
| oracle.rac.cluster.pluggable.database.restriction.status | PDB restriction state. | String |
| oracle.rac.cluster.pluggable.database.creation.time | PDB creation time. | Timestamp |
| oracle.rac.cluster.pluggable.database.container.id | CDB container ID. | Integer |
| system.tags | Cluster tags. | String |
| oracle.rac.cluster.version | Cluster version. | String |
Q. Rollback (Undo) Segments
| Metric | Description | Type |
|---|---|---|
| oracle.rollback.segments | Number of rollback segments. | Count |
| oracle.rollback.segment.table.space | Tablespace for segment. | String |
| oracle.rollback.segment.extends | Extends count. | Count |
| oracle.rollback.segment.water.mark.size | High water mark size. | Bytes |
| oracle.rollback.segment.initial.extent.size.bytes | Initial extent size. | Bytes |
| oracle.rollback.segment.min.extent | Minimum extents. | Count |
| oracle.rollback.segment.max.extent | Maximum extents. | Count |
| oracle.rollback.segment.status | Segment status. | String |
| oracle.rollback.segment.next.extent.size.bytes | Next extent size. | Bytes |
| oracle.rollback.segment | Segment identifier. | String |
| oracle.rollback.segment.shrinks | Shrink operations. | Count |
| oracle.rollback.segment.wraps | Wraps count. | Count |
| oracle.rollback.segment.hit.ratio.percent | Hit ratio. | Percent |
| oracle.rollback.segment.current.size.bytes | Current size. | Bytes |
R. Segments (General)
| Metric | Description | Type |
|---|---|---|
| oracle.segment | Segment identifier. | String |
| oracle.segment.name | Segment name. | String |
| oracle.segment.tablespace | Segment tablespace. | String |
| oracle.segment.owner | Segment owner. | String |
| oracle.segment.type | Segment type (TABLE/INDEX/etc.). | String |
| oracle.segment.extent | Current extents. | Count |
| oracle.segment.next.extent | Next extent size/count. | String |
| oracle.segment.max.extent | Max extents. | Count |