6 Autonomous Database
This chapter provides information about the Autonomous Database metrics.
| Metric Category | Metric Name | Unit | Collection Frequency | Description |
|---|---|---|---|---|
| CPU Usage | CPU Utilization | Percentage | Every 5 minutes |
The CPU utilization aggregated across all consumer groups. This metric is reported based on the number of CPUs the database is allowed to use, which is two times the number of OCPUs. |
| CPU Usage | CPU Usage Seconds | Seconds | Every 5 minutes | The average rate of accumulation of CPU time by foreground sessions in the database over the time interval. The CPU time component of Average Active Sessions. |
| CPU Utilization by Consumer Group | CPU Utilization by Consumer Group | Percentage | Every 5 minutes | The CPU utilization in each consumer group. |
| CPU Utilization by Consumer Group | Queued Statements | NA | Every 5 minutes | The number of queued SQL statements aggregated across all consumer groups, during the selected interval. |
| CPU Utilization by Consumer Group | Running Statements | NA | Every 5 minutes | The number of running SQL statements aggregated across all consumer groups, during the selected interval. |
| Database Load Profile | Average Active Session | NA | Every 5 minutes | The average rate of accumulation of database time (CPU + Wait) by foreground sessions in the database over the time interval. This is also known as Average Active Sessions. |
| Database Load Profile | DB Time | Seconds | Every 5 minutes | The amount of time spent in performing database user-level calls. |
| Database Load Profile | Parse Elapsed Time | Seconds | Every 5 minutes | The amount of time spent parsing SQL statements. |
| Database Load Profile | Transaction Response Time | Seconds | Every 5 minutes | The amount of time spent in database operations per transaction. It is derived from the total time that user calls spend in the database (DB time) and the number of commits and rollbacks performed. |
| Database Throughput | Executions per second | NA | Every 5 minutes | The number of user and recursive calls that executed SQL statements per second. |
| Database Throughput | Logons per second | NA | Every 5 minutes | The number of successful logons per second. |
| Database Throughput | Total Parse Count per second | NA | Every 5 minutes | The number of hard and soft parses per second. |
| Database Throughput | Transactions per second | NA | Every 5 minutes | The number of transactions per second. |
| Database Throughput | User Calls per second | NA | Every 5 minutes | The number of logins, parses, or execute calls per second. |
| SQL Execution Time | SQL Execution Time | Seconds | Every 5 minutes | The amount of time spent in executing SQL statements. |
| Storage | Storage Total | Terabytes | Every 1 hour | The maximum amount of space allocated to the database during the interval. |
| Storage | Storage Used | Terabytes | Every 1 hour | The amount of storage space used. |
| Storage | Storage Used | Percentage | Every 1 hour | The percentage of storage space used. |
| Wait Count | Active Sessions : CPU | NA | Every 5 minutes | The active sessions using CPU. |
| Wait Count | Active Sessions : I/O | NA | Every 5 minutes | The active sessions using I/O. |
| Wait Count | Active Sessions : Other | NA | Every 5 minutes | The active sessions that are neither idle nor using CPU or I/O. |
| Waits by Wait Class | Foreground Wait Time | Seconds | Every 5 minutes | The average rate of accumulation of non-idle wait time by foreground sessions in the database over the time interval. The wait time component of Average Active Sessions. |
Configuration Metric
| Metric Category | Metric Name | Unit | Collection Frequency | Description |
|---|---|---|---|---|
| Other Collected Items | Initialization Parameters | NA | Every 24 hours | Oracle Enterprise Manager collects Initialization
Parameter configuration information for Autonomous Databases,
thereby allowing you to compare and monitor configuration history
for changes. This also helps in performing root cause analysis and
impact analysis by comparing the changes.
To manage configuration information, click <Autonomous Database Type> menu > Configuration. |