Oracle Database

Table 1-300 Supported Configuration Metrics for Oracle Database

Metric Group Name Unit Description
Parameter Instance ID NA Instance Identifier
Parameter Container ID NA Pluggable Database Identifier or the Root Container Identifier
Parameter Parameter Name NA Initialization Parameter Name
Parameter Parameter Value NA Initialization Parameter Value
CharacterSet Character Set NA Oracle Database character set
High Availability (General Information) Database ID NA Database ID
High Availability (General Information) High Availability Log Mode NA Log mode of the database.
High Availability (General Information) Force Logging NA Whether force logging is enabled.
High Availability (General Information) Database Role NA The role of the database (primary or standby).
High Availability (General Information) High Availability Flashback On NA Whether flashback database is enabled.
High Availability (General Information) Supplemental Logging NA Whether supplemental logging is enabled.
High Availability (General Information) Recovery Appliance Destination Count NA The number of archived log destinations configured to a Recovery Appliance.
High Availability (RMAN Configuration) Name NA Configuration name.
High Availability (RMAN Configuration) Value NA Configuration value.
High Availability (RMAN Configuration) Configuration Number NA The unique key to identify the configuration record.
High Availability Data Guard Summary Source Type NA The role (Primary or Standby) of the database that was the source of the data row.
High Availability Data Guard Summary Row Type NA The role (Primary or Standby) of the database to which the data in the row pertains.
High Availability Data Guard Summary Managed by Data Guard Broker NA Whether the Data Guard configuration for the database specified by the row is managed by Data Guard broker.
High Availability Data Guard Summary Active Standby NA Whether the database specified by the row is an Active Data Guard standby database.
High Availability Data Guard Summary Database Unique Name NA The value of the DB_UNIQUE_NAME initialization parameter for the database specified by the row.
High Availability Data Guard Summary Database ID NA The value of DBID (as found in v$database) of the database specified by the row.
High Availability Data Guard Summary Primary Database Unique Name NA The Database Unique Name of the primary database associated with the database specified by the row (if the database is a standby database).
High Availability Data Guard Summary Primary Database ID NA The Database ID of the primary database associated with the database specified by the row.
High Availability Data Guard Summary Database Role NA The Data Guard role of the database specified by the row.
High Availability Data Guard Summary Standby Database List NA The list of standby databases associated with the database specified by the row (if the database is a primary database).
High Availability Data Guard Summary Protection Mode NA The protection mode for the database specified by the row.
High Availability Data Guard Summary Fast-Start Failover Status NA The Fast-Start Failover status for the database specified by the row.
High Availability Data Guard Summary Data Guard Status NA The Data Guard status for the database specified by the row.
High Availability Data Guard Summary Redo Source NA The Database Unique Name of the database that is shipping redo to the database specified by the row.
High Availability Data Guard Summary Data Guard Connect Identifier NA Net connect identifier used to reach the database.
Remote Log Archive Destinations Parameter Identifier NA Log archive destination parameter identifier.
Remote Log Archive Destinations Remote Destination NA Log archive destination parameter name.
Remote Log Archive Destinations Registered with Destination NA Indicates whether the archived redo log is registered in the remote destination control file or not.
Remote Log Archive Destinations Destination Database Type NA Indicates whether the archived log destination definition is PUBLIC or PRIVATE.
OMC ITA Data Collection Configuration and Status Metric Name NA Metric Name
OMC ITA Data Collection Configuration and Status Metric Value NA Metric Value
Database Options Option Name NA Database Option Name
Database Options Selected NA Database Option Selection Status

Table 1-301 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.
Lookup Config Metrics Value NA Value

Table 1-302 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-303 Supported Status and Performance Metrics for Oracle Database

Metric Group Category Name Unit
Top SQL Executions Load SQL ID NA
Top SQL Executions . Plan Hash Value NA
Top SQL Executions Response CPU Time ms
Top SQL Executions Response Elapsed Time ms
Top Wait Events Load Wait Event Name NA
Top Wait Events Load Wait Class Name NA
Top Wait Events Load Total Waits NA
Top Wait Events Load Total Wait Time ms
Top Wait Events Load Average Wait Time ms
Top Wait Events Load Total Foreground Waits NA
Top Wait Events Load Total Foreground Wait Time ms
Top Wait Events Load Average Foreground Wait Time ms
Load Load Average Active Sessions NA
Efficiency Utilization Sorts in Memory %
Efficiency Utilization Soft Parses %
Instance Efficiency Utilization InstanceID NA
Instance Efficiency Utilization PGA Cache Hit Percent %
Instance Efficiency Utilization Buffer Cache Hit Percent %
Resource Limit Utilization Utilization Process Limit Utilization %
Resource Limit Utilization Utilization Session Limit Utilization %
Instance Response Availability InstanceID NA
Instance Response Availability Status NA
Memory Component Sizes . Instance ID NA
Memory Component Sizes . Host Name NA
Memory Component Sizes . Memory Type NA
Memory Component Sizes . Memory Pool Name NA
Memory Component Sizes Load Allocated Size bytes
Interconnect Usage Statistics . Instance ID NA
Interconnect Usage Statistics . Host Name NA
Interconnect Usage Statistics Load Bytes Sent bytes
Interconnect Usage Statistics Load Bytes Received bytes
Interconnect Usage Statistics . Interval sec
OS Statistics . Instance ID NA
OS Statistics . Host Name NA
OS Statistics Capacity Total CPUs NA
OS Statistics Capacity Total Memory GB
OS Statistics Load Current OS Load NA
OS Statistics Load Host CPU Usage per sec
OS Statistics Capacity Total CPU Cores NA
OS Statistics Capacity CPU Limit NA
OS Statistics Capacity Total CPU sockets NA
OS Statistics . Interval sec
High Availability Backup Availability Session Key NA
High Availability Backup Availability Session RECID NA
High Availability Backup Availability Session Stamp NA
High Availability Backup Availability Command ID NA
High Availability Backup Availability Backup Status NA
High Availability Backup Availability Input Type NA
High Availability Backup Availability Output Device Type NA
High Availability Backup Availability Start Time NA
High Availability Backup Availability End Time NA
High Availability Backup Availability Elapsed Seconds sec
High Availability Backup Availability Input Size bytes
High Availability Backup Availability Output Size bytes
High Availability Backup Availability Output Bytes bytes/sec
High Availability Disk Backup Availability Last Successful Full Disk Backup Date NA
High Availability Disk Backup Availability Time Since Last Successful Full Disk Backup hrs
High Availability Disk Backup Availability Last Successful Full Disk Backup Size bytes
High Availability Disk Backup Availability Last Executed Full Disk Backup Date NA
High Availability Disk Backup Availability Last Executed Full Disk Backup Status NA
High Availability Disk Backup Availability Last Successful Incremental Disk Backup Date NA
High Availability Disk Backup Availability Time Since Last Successful Incremental Disk Backup hrs
High Availability Disk Backup Availability Last Successful Incremental Disk Backup Size bytes
High Availability Disk Backup Availability Last Executed Incremental Disk Backup Date NA
High Availability Disk Backup Availability Last Executed Incremental Disk Backup Status NA
High Availability Disk Backup Availability Last Successful Archived Log Disk Backup Date NA
High Availability Disk Backup Availability Time Since Last Successful Archived Log Disk Backup min
High Availability Disk Backup Availability Last Successful Archived Log Disk Backup Size bytes
High Availability Disk Backup Availability Last Executed Archived Log Disk Backup Date NA
High Availability Disk Backup Availability Last Executed Archived Log Disk Backup Status NA
High Availability Media Backup Availability Last Successful Full Non-Disk Media Backup Date NA
High Availability Media Backup Availability Time Since Last Successful Full Non-Disk Media Backup hrs
High Availability Media Backup Availability Last Successful Full Non-Disk Media Backup Size bytes
High Availability Media Backup Availability Last Successful Full Backup Media NA
High Availability Media Backup Availability Last Executed Full Non-Disk Media Backup Date NA
High Availability Media Backup Availability Last Executed Full Non-Disk Media Backup Status NA
High Availability Media Backup Availability Last Successful Incremental Non-Disk Media Backup Date NA
High Availability Media Backup Availability Time Since Last Successful Incremental Non-Disk Media Backup hrs
High Availability Media Backup Availability Last Successful Incremental Non-Disk Media Backup Size bytes
High Availability Media Backup Availability Last Successful Incremental Non-Disk Backup Media NA
High Availability Media Backup Availability Last Executed Incremental Non-Disk Media Backup Date NA
High Availability Media Backup Availability Last Executed Incremental Non-Disk Media Backup Status NA
High Availability Media Backup Availability Last Successful Archived Log Non-Disk Media Backup Date NA
High Availability Media Backup Availability Time Since Last Successful Archived Log Non-Disk Media Backup min
High Availability Media Backup Availability Last Successful Archived Log Non-Disk Media Backup Size bytes
High Availability Media Backup Availability Last Successful Archived Log Non-Disk Backup Media NA
High Availability Media Backup Availability Last Executed Archived Log Non-Disk Media Backup Date NA
High Availability Media Backup Availability Last Executed Archived Log Non-Disk Media Backup Status NA
High Availability Client Recovery Window Availability Last Complete Disk Backup Date NA
High Availability Client Recovery Window Availability Disk Recovery Window sec
High Availability Client Recovery Window Availability Disk Unprotected Data Window sec
High Availability Client Recovery Window Availability Last Complete Media Backup Date NA
High Availability Client Recovery Window Availability Media Recovery Window sec
High Availability Client Recovery Window Availability Media Unprotected Data Window sec
High Availability Client Recovery Window Availability Recovery Window Goal sec
HA AutoBackupSettings Availability Disk Recovery Window Goal sec
HA AutoBackupSettings Availability Media Recovery Window Goal sec
HA AutoBackupSettings Availability Disk Unprotected Data Threshold sec
HA AutoBackupSettings Availability Media Unprotected Data Threshold sec
High Availability Backup History Availability Session Key NA
High Availability Backup History Availability Session RECID NA
High Availability Backup History Availability Session Stamp NA
High Availability Backup History Availability Tag NA
High Availability Backup History Availability Command ID NA
High Availability Backup History Availability Status NA
High Availability Backup History Availability Input Type NA
High Availability Backup History Availability Output Device Type NA
High Availability Backup History Availability Start Time NA
High Availability Backup History Availability End Time NA
High Availability Backup History Availability Elapsed Seconds sec
High Availability Backup History Availability Input Size bytes
High Availability Backup History Availability Output Size bytes
High Availability Backup History Availability Media NA
High Availability Backup History Availability Keep Until Date NA
High Availability Backup History Availability Keep NA
High Availability Backup History Availability Keep Options NA
High Availability Backup History Availability Compression Ratio NA
High Availability Backup History Availability Incremental Level NA
High Availability Backup History Availability Compressed NA
High Availability Backup History Availability Encrypted NA
High Availability Backup History Availability Output Bytes bytes/sec
High Availability Backup History Availability Container ID NA
Fast Recovery Availability Fast Recovery Log Mode NA
Fast Recovery Availability Fast Recovery Area NA
Fast Recovery Capacity Usable Fast Recovery Area %
Fast Recovery Utilization Reclaimable Fast Recovery Area %
Fast Recovery Utilization Non-reclaimable Fast Recovery Area %
Fast Recovery Availability Fast Recovery Flashback On NA
Fast Recovery Availability Oldest Flashback Time NA
Fast Recovery Capacity Fast Recovery Area Size bytes
Primary Database Unique Name Availability Primary Database Unique Name NA
Data Guard Performance Availability Redo Generated KB
Data Guard Performance Availability Redo Generation Rate KB/sec
Data Guard Fast-Start Failover Observer Availability Observer Status NA
Data Guard Standby Performance Response Estimated Failover Time sec
Data Guard Standby Performance Response Apply Lag sec
Data Guard Standby Performance Response Transport Lag sec
Data Guard Standby Performance Load Redo Applied KB
Data Guard Standby Performance Load Redo Apply Rate KB/sec
Data Guard Standby Performance Response Apply Lag Data Refresh Time NA
Data Guard Standby Performance Response Transport Lag Data Refresh Time NA
Data Guard Status Availability Database Name NA
Data Guard Status Availability Data Guard Status NA
Cluster Managed Database Services Availability Database Name NA
Cluster Managed Database Services Availability Service Name NA
Cluster Managed Database Services Availability Minimum Response Time (in last 5 min) ms/request
Cluster Managed Database Services Availability Maximum Response Time (in last 5 min) ms/request
Cluster Managed Database Services Availability Average Response Time (in last 5 min) ms/request
Cluster Managed Database Services Utilization CPU Time Load (in last 5 min) %
Cluster Managed Database Services Availability Instance with Minimum Response Time NA
Cluster Managed Database Services Availability Instance with Maximum Response Time NA
Cluster Managed Database Services Availability Service Status NA
Cluster Managed Database Services Availability Running Instances NA
Tablespace Status . Tablespace Name NA
Tablespace Status . Tablespace Status NA
Data Files Status . Data File Name NA
Data Files Status . Data File Status NA
Blocking Sessions . Blocking Session ID NA
Blocking Sessions . Blocking Session Wait Class NA
Blocking Sessions . Blocking Session Wait Time NA
Blocking Sessions . Blocking Session ID NA
Blocking Sessions . Blocking Session Wait Class NA
Blocking Sessions . Blocking Session Seconds in Wait NA
Storage Tablespace Full . Storage Tablespace Name NA
Storage Tablespace Full Capacity Total Space Allocated GB
Storage Tablespace Full Utilization Space Utilization Percentage %
Storage Tablespace Full Utilization Space Used GB
Storage Tablespace Full (Temp) . Storage Tablespace Name (Temp) NA
Storage Tablespace Full (Temp) Capacity Total Space Allocated (Temp) GB
Storage Tablespace Full (Temp) Utilization Space Utilization Percentage (Temp) %
Storage Tablespace Full (Temp) Utilization Space Used (Temp) GB
Job Status . Broken Job Count NA
Job Status . Failed Job Count NA
Storage Tablespace Full (Undo) . Storage Tablespace Name (Undo) NA
Storage Tablespace Full (Undo) Capacity Total Space Allocated (Undo) GB
Storage Tablespace Full (Undo) Utilization Space Utilization Percentage (Undo) %
Storage Tablespace Full (Undo) Utilization Space Used (Undo) GB
Invalid Objects by Schema . Invalid Object Owner NA
Invalid Objects by Schema Error Invalid Objects NA

Table 1-304 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 . Plan Hash Value NA Numerical representation of the SQL plan for the cursor
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 Performance Load I/O Per Second IOPS I/O per second.
I/O Performance 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 . Interval sec Interval of metric collection

Table 1-305 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-306 Status and Performance Metrics for Generic Target

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