Oracle Database

Table 1-302 Supported Configuration Metrics for Oracle Database

Metric Group Name Unit Description
Parameter Instance ID N/A Instance Identifier
Parameter Container ID N/A Pluggable Database Identifier or the Root Container Identifier
Parameter Parameter Name N/A Initialization Parameter Name
Parameter Parameter Value N/A Initialization Parameter Value
Character Set Character Set N/A Oracle Database character set

Table 1-303 Supported Configuration Metrics for Relational Database

Metric Group Name Unit Description
Creation Date Creation Date N/A Date when the database was created
Total Memory Capacity Host Memory GB Total host memory capacity in GB
Resource Allocation Instance Name N/A RDB Instance
Resource Allocation Host Name N/A Host name of the instance
Resource Allocation Total CPUs N/A total number of CPUs allocated or available in this instance
Resource Allocation Total Memory GB Total amount of usable Physical RAM allocated or available to this instance.

Table 1-304 Supported Configuration Metrics for Hosted Target

Metric Group Name Unit Description
Resource Allocation Total CPUs N/A Total number of CPUs allocated or available to the entity
Resource Allocation Total Memory GB Total amount of usable Physical RAM allocated or available to the entity

Table 1-305 Supported Status and Performance Metrics for Oracle Databases

Metric Group Category Name Unit Description

Top SQL Executions

Load

SQL ID

NA

Unique Identifier for the SQL statement

Top SQL Executions

 

Plan Hash Value

NA

Numerical representation of the SQL plan for the cursor

Top SQL Executions

Response

CPU Time

ms

Amount of CPU time used to execute the SQL statement

Top SQL Executions

Response

Elapsed Time

ms

Total time used to execute the SQL statement. This includes CPU time and wait time

Top Wait Events

Load

Wait Event Name

NA

Name of the Wait Event

Top Wait Events

Load

Wait Class Name

NA

Name of the class of the Wait Event

Top Wait Events

Load

Total Waits

NA

Total number of waits for the event

Top Wait Events

Load

Total Wait Time

ms

Total amount of time spent waiting for the event

Top Wait Events

Load

Average Wait Time

ms

Average amount of time spent waiting for the event

Top Wait Events

Load

Total Foreground Waits

NA

Total Number of waits for the event from the foreground sessions

Top Wait Events

Load

Total Foreground Wait Time

ms

Total amount of time that the foreground sessions spent waiting for the event

Top Wait Events

Load

Average Foreground Wait Time

ms

Average amount of time that the foreground sessions spent waiting for the event

Load

Load

Average Active Sessions

NA

Average number of sessions which working or waiting

Efficiency

Utilization

Sorts in Memory

%

Percentage of total sorts that were performed in memory

Efficiency

Utilization

Soft Parses

%

Percentage of total parse requests where the SQL Statement was already in the cursor cache

Instance Efficiency

Utilization

InstanceID

NA

Instance Identifier

Instance Efficiency

Utilization

PGA Cache Hit Percent

%

Percentage of bytes processed in the PGA without requiring extra passes to read from or write to storage device

Instance Efficiency

Utilization

Buffer Cache Hit Percent

%

Percentage of Buffer Cache Hit

Resource Limit Utilization

Utilization

Process Limit Utilization

%

The number of operating system user processes including background processes connected simultaneously to the database, as a percentage of the limit set in the PROCESSES initialization parameter

Resource Limit Utilization

Utilization

Session Limit Utilization

%

The number of sessions, including those by background processes, as a percentage of the limit set in the SESSIONS initialization parameter

Instance Response

Availability

InstanceID

NA

Instance Identifier

Instance Response

Availability

Status

NA

Status of the database instance

Memory Component Sizes

 

Instance ID

NA

Database Instance ID

Memory Component Sizes

 

Host Name

NA

Host Name for Instance

Memory Component Sizes

 

Memory Type

NA

Memory Type

Memory Component Sizes

 

Memory Pool Name

NA

Memory Pool Name

Memory Component Sizes

Load

Allocated Size

bytes

Allocated memory size in bytes

Interconnect Usage Statistics

 

Instance ID

NA

Database Instance ID

Interconnect Usage Statistics

 

Host Name

NA

Host Name for Instance

Interconnect Usage Statistics

Load

Bytes Sent

bytes

Number of bytes sent over interconnect

Interconnect Usage Statistics

Load

Bytes Received

bytes

Number of bytes received over interconnect

Interconnect Usage Statistics

 

Interval

sec

Interval of metric collection

OS Statistics

 

Instance ID

NA

RDB instance

OS Statistics

 

Host Name

NA

Host name of the instance

OS Statistics

Capacity

Total CPUs

NA

Total number of CPUs allocated or available in this instance

OS Statistics

Capacity

Total Memory

GB

Total amount of usable Physical RAM allocated or available to this instance

OS Statistics

Load

Current OS Load

NA

Current OS load on the host for this instance

OS Statistics

Load

Host CPU Usage

per sec

Host CPU usage in centiseconds per second for this instance

OS Statistics

Capacity

Total CPU Cores

NA

Total number of CPU cores available on this instance host

OS Statistics

Capacity

CPU Limit

NA

Maximum number of CPUs allocated or available to this instance

OS Statistics

Capacity

Total CPU sockets

NA

Total number of CPU sockets available on this instance host

OS Statistics

 

Interval

sec

Interval of metric collection

High Availability Backup

Availability

Session Key

NA

The session key of the RMAN session for the backup operation.

High Availability Backup

Availability

Session RECID

NA

The record ID of the RMAN session for the backup operation.

High Availability Backup

Availability

Session Stamp

NA

The session stamp of the RMAN session for the backup operation.

High Availability Backup

Availability

End Time

NA

The end time of the backup operation.

High Availability Backup

Availability

Status

NA

The status of the backup operation.

High Availability Backup

Availability

Command Id

NA

The ID of the command run for the backup operation.

High Availability Backup

Availability

Start Time

NA

The start time of the backup operation.

High Availability Backup

Availability

Elapsed Seconds

sec

The amount of time taken for the backup operation.

High Availability Backup

Availability

Input Type

NA

The input type assigned by RMAN to the backup operation.

High Availability Backup

Availability

Output Device Type

NA

The output device type (disk, non-disk media, or both).

High Availability Backup

Availability

Input Size

bytes

Sum of all input file sizes for this backup operation.

High Availability Backup

Availability

Output Size

bytes

Output size of all pieces generated by this backup operation.

High Availability Backup

Availability

Output Rate

bytes/sec

Output write rate (bytes per second).

High Availability Disk Backup

Availability

Last Successful Full Disk Backup Date

NA

Date of last successful full disk backup.

High Availability Disk Backup

Availability

Time Since Last Successful Full Disk Backup

hrs

Time since last successful full disk backup.

High Availability Disk Backup

Availability

Last Successful Full Disk Backup Size

bytes

Size of last successful full disk backup.

High Availability Disk Backup

Availability

Last Executed Full Disk Backup Date

NA

Date of last executed full disk backup.

High Availability Disk Backup

Availability

Last Executed Full Disk Backup Status

NA

Status of last executed full disk backup.

High Availability Disk Backup

Availability

Last Successful Incremental Disk Backup Date

NA

Date of last successful incremental disk backup.

High Availability Disk Backup

Availability

Time Since Last Successful Incremental Disk Backup

hrs

Time since last successful incremental disk backup.

High Availability Disk Backup

Availability

Last Successful Incremental Disk Backup Size

bytes

Size of last successful incremental disk backup.

High Availability Disk Backup

Availability

Last Executed Incremental Disk Backup Date

NA

Date of last executed incremental disk backup.

High Availability Disk Backup

Availability

Last Executed Incremental Disk Backup Status

NA

Status of last executed incremental disk backup.

High Availability Disk Backup

Availability

Last Successful Archived Log Disk Backup Date

NA

Date of last successful archived log disk backup.

High Availability Disk Backup

Availability

Time Since Last Successful Archived Log Disk Backup

min

Time since last successful archived log disk backup.

High Availability Disk Backup

Availability

Last Successful Archived Log Disk Backup Size

bytes

Size of last successful incremental disk backup.

High Availability Disk Backup

Availability

Last Executed Archived Log Disk Backup Date

NA

Date of last executed archived log disk backup.

High Availability Disk Backup

Availability

Last Executed Archived Log Disk Backup Status

NA

Status of last executed archived log disk backup.

High Availability Media Backup

Availability

Last Successful Full Non-Disk Media Backup Date

NA

Date of last executed full non-disk media backup.

High Availability Media Backup

Availability

Time Since Last Successful Full Non-Disk Media Backup

hrs

Time since last successful full non-disk media backup.

High Availability Media Backup

Availability

Last Successful Full Non-Disk Media Backup Size

bytes

Size of last successful full non-disk media backup.

High Availability Media Backup

Availability

Last Successful Full Backup Media

NA

Last full non-disk backup media (Recovery Appliance, Oracle Storage Service, tape, etc.)

High Availability Media Backup

Availability

Last Executed Full Non-Disk Media Backup Date

NA

Date of last executed full non-disk media backup.

High Availability Media Backup

Availability

Last Executed Full Non-Disk Media Backup Status

NA

Status of last executed full non-disk media backup.

High Availability Media Backup

Availability

Last Successful Incremental Non-Disk Media Backup Date

NA

Date of last successful incremental non-disk media backup.

High Availability Media Backup

Availability

Time Since Last Successful Incremental Non-Disk Media Backup

hrs

Time since last successful incremental non-disk media backup.

High Availability Media Backup

Availability

Last Successful Incremental Non-Disk Media Backup Size

bytes

Size of last successful incremental non-disk media backup.

High Availability Media Backup

Availability

Last Successful Incremental Non-Disk Backup Media

NA

Last incremental non-disk backup media (Recovery Appliance, OSS, tape, etc.)

High Availability Media Backup

Availability

Last Executed Incremental Non-Disk Media Backup Date

NA

Date of last executed incremental non-disk media backup.

High Availability Media Backup

Availability

Last Executed Incremental Non-Disk Media Backup Status

NA

Status of last executed incremental non-disk media backup.

High Availability Media Backup

Availability

Last Successful Archived Log Non-Disk Media Backup Date

NA

Date of last executed archived log non-disk media backup.

High Availability Media Backup

Availability

Time Since Last Successful Archived Log Non-Disk Media Backup

min

Time since last successful archived non-disk media backup.

High Availability Media Backup

Availability

Last Successful Archived Log Non-Disk Media Backup Size

bytes

Size of last successful archived log non-disk media backup.

High Availability Media Backup

Availability

Last Successful Archived Log Non-Disk Backup Media

NA

Last archived log non-disk backup media (Recovery Appliance, Oracle Storage Service, tape, etc.)

High Availability Media Backup

Availability

Last Executed Archived Log Non-Disk Media Backup Date

NA

Date of last successful archived log non-disk media backup.

High Availability Media Backup

Availability

Last Executed Archived Log Non-Disk Media Backup Status

NA

Date of last executed archived log non-disk media backup.

High Availability Client Recovery Window

Availability

Last Complete Disk Backup Date

NA

The latest point in time for which a complete disk backup is available for all datafiles in this database.

High Availability Client Recovery Window

Availability

Disk Recovery Window

sec

The recovery window for disk backups.

High Availability Client Recovery Window

Availability

Disk Unprotected Data Window

sec

The current amount of potential data loss for disk backups.

High Availability Client Recovery Window

Availability

Last Complete Media Backup Date

NA

The latest point in time for which a complete non-disk media backup is available for all datafiles in this database.

High Availability Client Recovery Window

Availability

Media Recovery Window

sec

The recovery window for non-disk media backups.

High Availability Client Recovery Window

Availability

Media Unprotected Data Window

sec

The current amount of potential data loss for non-disk media backups.

High Availability Client Recovery Window

Availability

Recovery Window Goal

sec

The recovery window goal corresponding to the RMAN retention policy setting.

HA AutoBackupSettings

Availability

Disk Recovery Window Goal

sec

The recovery window goal for disk backups.

HA AutoBackupSettings

Availability

Media Recovery Window Goal

sec

The recovery window goal for non-disk media backups.

HA AutoBackupSettings

Availability

Disk Unprotected Data Threshold

sec

The unprotected data threshold for disk backups.

HA AutoBackupSettings

Availability

Media Unprotected Data Threshold

sec

The unprotected data threshold for non-disk media backups.

High Availability Backup History

Availability

Session Key

NA

The session key of the RMAN session for the backup operation.

High Availability Backup History

Availability

Session RECID

NA

The record ID of the RMAN session for the backup operation.

High Availability Backup History

Availability

Session Stamp

NA

The session stamp of the RMAN session for the backup operation.

High Availability Backup History

Availability

Tag

NA

The tag assigned to this backup.

High Availability Backup History

Availability

Command ID

NA

The ID of the command run for the backup operation.

High Availability Backup History

Availability

Status

NA

The status of the backup operation.

High Availability Backup History

Availability

Input Type

NA

The input type assigned by RMAN to the backup operation.

High Availability Backup History

Availability

Output Device Type

NA

The output device type (disk, non-disk media, or both).

High Availability Backup History

Availability

Start Time

NA

The start time of the backup operation.

High Availability Backup History

Availability

End Time

NA

The end time of the backup operation.

High Availability Backup History

Availability

Elapsed Seconds

sec

The amount of time taken for the backup operation.

High Availability Backup History

Availability

Input Size

bytes

Sum of all input file sizes for this backup operation.

High Availability Backup History

Availability

Output Size

bytes

Output size of all pieces generated by this backup operation.

High Availability Backup History

Availability

Media

NA

The media type on which the backup resides.

High Availability Backup History

Availability

Keep Until Date

NA

The date at which the backup becomes obsolete.

High Availability Backup History

Availability

Keep

NA

Whether this backup will be retained for a time period outside of the configured retention policy.

High Availability Backup History

Availability

Keep Options

NA

Additional retention options for this backup.

High Availability Backup History

Availability

Compression Ratio

NA

Compression ratio for this backup.

High Availability Backup History

Availability

Incremental Level

NA

The incremental level of this backup.

High Availability Backup History

Availability

Compressed

NA

Whether the backup is compressed.

High Availability Backup History

Availability

Encrypted

NA

Whether the backup is encrypted.

Fast Recovery

Availability

Log Mode

NA

The log mode of the database.

Fast Recovery

Availability

Fast Recovery Area

NA

The fast recovery area location.

Fast Recovery

Capacity

Usable Fast Recovery Area

%

The percentage of usable space in the fast recovery area.

Fast Recovery

Utilization

Reclaimable Fast Recovery Area

%

The percentage of reclaimable space in the fast recovery area.

Fast Recovery

Utilization

Non-reclaimable Fast Recovery Area

%

The percentage of non-reclaimable space (used minus reclaimable) in the fast recovery area.

Fast Recovery

Availability

Flashback On

NA

Whether flashback database is enabled.

Fast Recovery

Availability

Oldest Flashback Time

NA

The oldest point-in-time to which the database can be flashed back.

Fast Recovery

Capacity

Fast Recovery Area Size

bytes

The size of the fast recovery area.

Primary Database Unique Name

Availability

Primary Database Unique Name

NA

The Database Unique Name of the primary database associated with this database (if the database is a standby database).

Data Guard Performance

Availability

Redo Generated

KB

Redo generated.

Data Guard Performance

Availability

Redo Generation Rate

KB/sec

Redo Generation Rate (KB/second)

Data Guard Fast-Start Failover Observer

Availability

Observer Status

NA

Observer status.

Data Guard Standby Performance

Availability

Estimated Failover Time

sec

Estimated Failover Time (seconds).

Data Guard Standby Performance

Availability

Apply Lag

sec

Apply Lag (seconds).

Data Guard Standby Performance

Availability

Transport Lag

sec

Transport Lag (seconds).

Data Guard Standby Performance

Availability

Redo Applied

KB

Redo Applied (blocks).

Data Guard Standby Performance

Availability

Redo Apply Rate

KB/sec

Redo Apply Rate (KB/second).

Data Guard Standby Performance

Availability

Apply Lag Data Refresh Time

NA

Apply lag data refresh time.

Data Guard Standby Performance

Availability

Transport Lag Data Refresh Time

NA

Transport lag data refresh time.

Data Guard Status

Availability

Database Name

NA

The Data Guard broker name of the database.

Data Guard Status

Availability

Data Guard Status

NA

The Data Guard status for the database.

Cluster Managed Database Services

Availability

Database Name

NA

The name of the database

Cluster Managed Database Services

Availability

Service Name

NA

The name of the Service

Cluster Managed Database Services

Availability

Minimum Response Time (in last 5 min)

ms/request

Minimum Response Time (in last 5 min)

Cluster Managed Database Services

Availability

Maximum Response Time (in last 5 min)

ms/request

Maximum Response Time (in last 5 min)

Cluster Managed Database Services

Availability

Average Response Time (in last 5 min)

ms/request

Average Response Time (in last 5 min)

Cluster Managed Database Services

Utilization

CPU Time Load (in last 5 min)

%

Percentage CPU Time Load (in last 5 min)

Cluster Managed Database Services

Availability

Instance with Minimum Response Time

NA

Instance with Minimum Response Time

Cluster Managed Database Services

Availability

Instance with Maximum Response Time

NA

Instance with Maximum Response Time

Cluster Managed Database Services

Availability

Service Status

NA

The status of the Service

Cluster Managed Database Services

Availability

Running Instances

NA

The list of the running instances

Tablespace Status

.

Tablespace Name

NA

Tablespace Name

Tablespace Status

.

Tablespace Status

NA

Tablespace Status

Data Files Status

.

Data File Name

NA

Data File Name

Data Files Status

.

Data File Status

NA

Data File Status

Blocking Sessions

.

Blocking Session ID

NA

Blocking Session ID

Blocking Sessions

.

Blocking Session Wait Class

NA

Blocking Session Wait Class

Blocking Sessions

.

Blocking Session Seconds in Wait

NA

Blocking Session Seconds in Wait

Table 1-306 Supported Status and Performance Metrics for Relational Database

Metric Group Category Name Unit Description

Database Resource Stats

 

Instance ID

NA

RDB instance

Database Resource Stats

 

Host Name

NA

Host name of the instance

Database Resource Stats

Response

RDB Instance CPU Time

sec

CPU time used by the instance

Database Resource Stats

 

RDB Instance CPU collection Interval

sec

collection interval

Database Resource Stats

Response

RDB Aggregated CPU Time

sec

Aggregated CPU time used by DB

Database Resource Stats

 

RDB Aggregated CPU interval

sec

collection interval time

Database Resource Stats

Load

RDB Instance Memory

GB

Memory consumed by instance in GB

Database Resource Stats

 

RDB Instance Memory interval

sec

Memory Collection interval

Database Resource Stats

Load

Aggregated RDB Memory

GB

Aggregated memory consumed by DB in GB

Database Resource Stats

 

Aggregated RDB Memory interval

sec

Aggregated memory usage collection interval

Database Resource Stats

Load

RDB Instance I/O Bandwidth Usage

MB/sec

I/O bandwidth usage for db instance

Database Resource Stats

Load

RDB Instance I/O Per Second

IOPS

I/O per second rate for instance.

Database Resource Stats

Load

RDB Instance I/O interval

sec

IO rate collection interval

Database Resource Stats

Load

Aggregated DB I/O Bandwidth Usage

MB/sec

Aggregated I/O bandwidth usage for DB

Database Resource Stats

Load

Aggregated DB I/O Per Second

IOPS

Aggregated IO per second rate for DB

Storage Usage By Tablespace

 

Storage Tablespace Name

NA

Tablespace Name

Storage Usage By Tablespace

Capacity

Total Space Allocated

GB

Total size of a tablespace's datafiles in GB

Storage Usage By Tablespace

Utilization

Space Utilization Percentage

%

Percent of storage space utilized

Storage Usage By Tablespace

Load

Space Used

GB

Tablespace used in GB

Storage Space Usage

Utilization

Storage Space Allocated

GB

Storage space allocated in GB

Storage Space Usage

Utilization

Storage Space Utilization

%

Percent of storage space utilized

Storage Space Usage

Load

Space Used

GB

Storage space used in GB

Load

Load

Logons

NA

The number of logons during the last collection interval

Load

Load

Logons Rate

logons/sec

Number of logons per second during the last collection interval

Load

Load

Transactions

NA

Number of transactions during the last collection interval

Load

Load

Transactions Rate

txns/sec

Number of transactions per second during the last collection interval

Load

Load

Executions

NA

Number of executions during the last collection interval

Load

Load

Execution Rate

executions/sec

Number of executions per second during the last collection interval

Load

Load

Network I/O

bytes

Number of bytes sent and received over the network during the last collection interval

Load

Load

Network I/O Rate

bytes/sec

Network I/O in bytes/second during the last collection interval

Top SQL Executions

Load

SQL ID

NA

Unique Identifier for the SQL statement

Top SQL Executions

Load

Top SQL Text

NA

SQL text of the top-ranked SQL

Top SQL Executions

Response

Execution Count

NA

Execution Count of the top-ranked SQL

Top SQL Executions

Response

Total Elapsed Time

ms

Total time used to execute the SQL statement. This includes CPU time and wait time

I/O Per Second

Load

I/O Per Second

IOPS

I/O per second.

I/O Per Second

Load

I/O Bandwidth Usage

MB/sec

I/O bandwidth usage during the last collection interval

Instance CPU

Utilization

Instance ID

NA

RDB instance

Instance CPU

Utilization

Host Name

NA

Host name of the instance

Instance CPU

Utilization

CPU Usage

sec

All CPUs usage during the interval for this instance

Instance CPU

Utilization

CPU Utilization

%

Percentage of CPU that was utilized in this instance

Instance CPU

 

Interval

sec

Interval of metric collection

Instance Memory Usage

Utilization

Instance ID

NA

RDB instance

Instance Memory Usage

Utilization

Host Name

NA

Host name of the instance

Instance Memory Usage

Utilization

Instance Memory Usage

GB

Memory used in GB

Instance Memory Usage

Utilization

Memory Utilization

%

Percentage of memory that is utilized in this instance

Instance Memory Usage

 

Interval

sec

Interval of metric collection

I/O Per Second Instance Level

Load

Instance ID

NA

RDB instance

I/O Per Second Instance Level

Load

Host Name

NA

Host name of the instance

I/O Per Second Instance Level

Load

I/O Per Second

IOPS

I/O per second for this instance

I/O Per Second Instance Level

Load

I/O Bandwidth Usage

MB/sec

I/O bandwidth usage during the last collection interval for this instance

I/O Per Second Instance Level

 

Interval

sec

Interval of metric collection

Database Activity

 

Instance ID

NA

RDB instance

Database Activity

 

Host Name

NA

Host name of the instance

Database Activity

Load

CPU Time

sec

CPU time (in seconds) of foreground sessions

Database Activity

Load

Wait Time

sec

Wait time (in seconds) of foreground sessions

Database Activity

Load

I/O Time

sec

I/O time (in seconds) of foreground sessions

Database Activity

 

Interval

sec

Interval of metric collection

Instance Load

 

Instance ID

NA

RDB instance

Instance Load

 

Host Name

NA

Host name of the instance

Instance Load

Load

Logons

NA

The number of logons during the last collection interval

Instance Load

Load

Logons Rate

logons/sec

Number of logons per second during the last collection interval

Instance Load

Load

Transactions

NA

Number of transactions during the last collection interval

Instance Load

Load

Transactions Rate

txns/sec

Number of transactions per second during the last collection interval

Instance Load

Load

Executions

NA

Number of executions during the last collection interval

Instance Load

Load

Executions Rate

executions/sec

Number of executions per second during the last collection interval

Instance Load

Load

Network I/O

bytes

Number of bytes sent and received over the network during the last collection interval

Instance Load

Load

Network I/O Rate

bytes/sec

Network I/O in bytes/second during the last collection interval

Instance Load

 

Interval

sec

Interval of metric collection

SQL Statistics

 

SQL ID

NA

SQL ID

SQL Statistics

 

Plan Hash Value

NA

Numerical representation of the SQL plan for the cursor

SQL Statistics

Load

Executions

NA

Number of times the SQL statement was executed

SQL Statistics

Response

Elapsed Time

ms

Total time (in milliseconds) used by this SQL for parsing, executing and fetching

SQL Statistics

N/A

Interval

sec

Interval of metric collection

Table 1-307 Supported Status and Performance Metrics for Hosted Target

Metric Group Category Name Unit Description
CPU Utilization CPU Usage sec All CPUs usage during the interval
CPU N/A CPU Utilization % Percentage of CPU that was utilized
CPU N/A Interval sec Interval of metric collection
Memory Load Memory Usage GB Memory used in GB
Memory Utilization Memory Utilization % Percentage of memory that is utilized
Memory N/A Interval sec Interval of metric collection

Table 1-308 Status and Performance Metrics for Generic Target

Metric Group Category Name Unit Description
Response Availability Status N/A Status of the target