Autonomous Data Warehouse
Metrics for Autonomous Data Warehouse
Table 1-40 Supported Configuration Metrics for Relational Database
Metric Group | Name | Unit | Description |
---|---|---|---|
Creation Date | Creation Date | NA | Date when the database was created |
Table 1-41 Supported Configuration Metrics for Hosted Target
Metric Group | Name | Unit | Description |
---|---|---|---|
Resource Allocation | Total CPUs | NA | Total number of CPUs allocated or available to the entity |
Table 1-42 Supported Configuration Metrics for Target
Metric Group | Name | Unit | Description |
---|---|---|---|
Product | Vendor | NA | Vendor of the product |
Product | Product | NA | Name of the product |
Product | Version | NA | Version of the product |
Table 1-43 Supported Status and Performance Metrics for Oracle Database Server Interface
Metric Group | Category | Name | Unit | Description |
---|---|---|---|---|
Latency | Response | SQL Service Response Time | centisec/request | Average Response Time across all SQL statements in centiseconds per call |
Latency | Response | Avg Synchronous Single-Block Read Latency | ms | Average latency for single block synchronous reads in milliseconds |
Database Activity | Load | DB Time | sec | Amount of elapsed time (in seconds) spent on performing database user-level calls |
Database Activity | Load | Background CPU | sec | Amount of CPU time (in seconds) consumed by database background processes |
Database Activity | Load | SQL Execution | sec | Amount of elapsed time (in seconds) SQL statements are executing |
Instance Load | Load | User Calls | NA | User Calls |
Instance Load | Load | Physical Read I/O Requests | NA | Physical Read I/O Requests |
Instance Load | Load | Physical Read Bytes | bytes | Physical Read Bytes |
Instance Load | Load | Physical Write I/O Requests | NA | Physical Write I/O Requests |
Instance Load | Load | Physical Write Bytes | bytes | Physical Write Bytes |
Instance Load | Load | Redo Bytes | bytes | Redo Bytes |
Instance Load | Load | Redo Writes | NA | Redo Writes |
SQL Statistics | Load | Disk Reads | NA | Total number of disk reads |
SQL Statistics | Load | Buffer Gets | NA | Total number of buffer gets |
SQL Statistics | Response | CPU Time | ms | Total time (in milliseconds) spent on CPU |
SQL Statistics | Response | User I/O Wait | ms | Total time (in milliseconds) spent waiting for events in the User I/O class |
SQL Statistics | Response | Cluster Wait | ms | Total time (in milliseconds) spent waiting for events in the Cluster class |
SQL Statistics | Response | Application Wait | ms | Total time (in milliseconds) spent waiting for events in the Application class |
SQL Statistics | Response | Concurrency Wait | ms | Total time (in milliseconds) spent waiting for events in the Concurrency class |
SQL Statistics | Load | Direct Writes | NA | Number of direct writes |
SQL Statistics | Load | Physical Read Requests | NA | Number of physical read I/O requests issued by the SQL |
SQL Statistics | Load | Physical Read Bytes | bytes | Number of bytes read from disks by the SQL |
SQL Statistics | Load | Physical Write Requests | NA | Number of physical write I/O requests issued by the SQL |
SQL Statistics | Load | Physical Write Bytes | bytes | Number of bytes written to disks by the SQL |
SQL Statistics from ASH | . | SQL ID | NA | SQL ID |
SQL Statistics from ASH | . | Plan Hash Value | NA | Numerical representation of the SQL plan for the cursor |
SQL Statistics from ASH | . | Bucket Id | NA | SQL fall under the bucket (Possible Values : lessthan 3 secs, 4-10sec, 11-60sec, 1-5min, 5min or more) |
SQL Statistics from ASH | Load | Executions | NA | Number of times the SQL statement was executed in last 30 minutes in the bucket pointed by Bucket ID |
SQL Statistics from ASH | Response | Total Time | sec | Total time (in seconds) spent on CPU and all other waits in last 30 minutes in the bucket pointed by Bucket ID |
SQL Statistics from ASH | Response | CPU Time | sec | Total time (in seconds) spent waiting for CPU in last 30 minutes in the bucket pointed by Bucket ID |
SQL Statistics from ASH | Response | User I/O Wait | sec | Total time (in seconds) spent waiting for events in the User I/O class in last 30 minutes in the bucket pointed by Bucket ID |
SQL Statistics from ASH | Response | Other Wait Time | sec | Total time (in seconds) spent on all other waits except I/O in last 30 minutes in the bucket pointed by Bucket ID |
System Wait Classes | . | Instance ID | NA | Database Instance ID |
System Wait Classes | . | Host Name | NA | Host Name for Instance |
System Wait Classes | . | Wait Class | NA | Wait Class |
System Wait Classes | Response | Time Waited | sec | Total time waited in seconds by both foreground and background sessions |
System Wait Classes | Response | Time Waited Foreground | sec | Total time waited in seconds by foreground sessions only |
System Wait Classes | . | Interval | sec | Interval of metric collection |
Table 1-44 Supported Status and Performance Metrics for Relational Database
Metric Group | Category | Name | Unit | Description |
---|---|---|---|---|
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 Rate | logons/sec | Number of logons per second during the last collection interval |
Load | Load | Transactions Rate | txns/sec | Number of transactions per second 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 Rate | bytes/sec | Network I/O in bytes/second during the last collection interval |
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 | 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 |
I/O Per Second Instance Level | Load | Instance ID | NA | RDB 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 | Load | Logons Rate | logons/sec | Number of logons per second 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 Rate | executions/sec | Number of executions per second 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-45 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 | Utilization | CPU Utilization | % | Percentage of CPU that was utilized |
CPU | . | Interval | sec | Interval of metric collection |
Table 1-46 Supported Status and Performance Metrics for Target
Metric Group | Category | Name | Unit | Description |
---|---|---|---|---|
Response | Availability | Status | NA | Status of the target |