Relational Database (Generic)
Table 1-456 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-457 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-458 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-459 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-460 Status and Performance Metrics for Generic Target
| Metric Group | Category | Name | Unit | Description |
|---|---|---|---|---|
| Response | Availability | Status | N/A | Status of the target |