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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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