Oracle Database
Table 1-317 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-318 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-319 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-320 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-321 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-322 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-323 Status and Performance Metrics for Generic Target
Metric Group | Category | Name | Unit | Description |
---|---|---|---|---|
Response | Availability | Status | N/A | Status of the target |