An autonomous database is a fully managed, pre-configured cloud database environment that uses machine learning and Internet of Things (IoT) to perform tasks without any human intervention. It automates tasks associated with database tuning, security, backups, updates, etc. that are traditionally performed by database administrators (DBAs) and helps you in creating the database and performs maintenance tasks such as backing up, patching, upgrading and tuning the database with ease.
Prerequisites for monitoring Oracle Autonomous DB metrics: Click here
Go to the Monitors Category View by clicking the Monitors tab. Click on the Autonomous Database instance available under Oracle Cloud in the Cloud Apps section. Displayed is the Oracle Autonomous Database bulk configuration view distributed into three tabs:
On clicking a monitor from the list, you'll be taken to the Oracle Autonomous Database dashboard. It has 6 tabs:
| Parameter | Description |
|---|---|
| UTILIZATION: | |
| CPU Utilization | Amount of CPU utilized by the autonomous database (in percentage). |
| Storage Utilization | Amount of storage capacity utilized by the autonomous database (in percentage). |
| CONNECTION STATISTICS: | |
| DB Connection Time | Time taken to connect to the database (in seconds). |
| SESSION DETAILS: | |
| Sessions | The number of sessions running in the autonomous database. |
| Current Logons | The number of successful logons occurred during the selected time interval. |
| User Calls | The combined number of logons, parses, and execute calls during the selected time interval. |
| QUEUED STATEMENTS THROUGHPUT: | |
| Running Statements | The number of running SQL statements aggregated across all consumer groups. |
| Queued Statements | The number of queued SQL statements aggregated across all consumer groups. |
| TRANSACTIONS: | |
| Execute Count | The number of user and recursive calls that executed SQL statements. |
| Total Parse Count | The number of hard and soft parses occurred. |
| Transaction Count | The combined number of user commits and user rollbacks. |
| FAILED LOGONS & CONNECTIONS THROUGHPUT: | |
| Failed Connections | The number of failed database connections occurred. |
| Failed Logons | The number of failed logons occurred. |
| Parameter | Description |
|---|---|
| Tablespace Details: | |
| Tablespace Name | Name of the tablespace. |
| Allocated Bytes | Allocated size of the tablespace (in GB). |
| Total Allocated Bytes | The total allocated size of the tablespace (in GB). |
| Used Bytes | The amount of storage that have been used in the tablespace (in GB). |
| Free Bytes | The remaining amount of storage that is free in the tablespace (in GB). |
| Used Bytes (%) | The amount of storage that have been used in the tablespace (in percentage). |
| Free Bytes (%) | The remaining amount of storage that is free in the tablespace (in percentage). |
| Allocated Blocks | The number of data blocks allocated to the tablespace. |
| Free Blocks | The number of free data blocks available in the tablespace. |
| Tablespace Status: | |
| Tablespace Name | Name of the tablespace. |
| Tablespace Status | The status of the tablespace. (ONLINE, OFFLINE or INVALID) |
| Data Files | The number of data files available in the tablespace. |
| Read Rate | Number of read operations that have occurred in the tablespace per minute. |
| Write Rate | Number of write operations that have occurred in the tablespace per minute. |
| Read Time | Time taken for a single read from the tablespace (in seconds). |
| Write Time | Time taken for a single write to the tablespace (in seconds). |
| Performance of DataFiles: | |
| DataFile Name | Name of the data file along with its location. |
| Tablespace Name | Name of the tablespace. |
| Status | The status of the data file. |
| AutoExtend | Denotes whether AutoExtend is enabled for this data file or not. |
| Created Bytes | The size of the data file (in MB). |
| Reads | Number of reads occurred from the data file. |
| Writes | Number of writes occurred to the data file. |
| Average Read Time | The average time taken for read operations to occur. (in millisecond) |
| Average Write Time | The average time taken for write operations to occur. (in millisecond) |
| Objects Approaching MAX Extents: | |
| Owner | Owner name of the table space. |
| Tablespace Name | Name of the tablespace. |
| Segment Name | Name of the segment approaching maximum extents. |
| Segment Type | The type of segment approaching maximum extents. |
| Extents | Number of extents allocated to the segment. |
| Max Extents | Maximum allowed extents that can be filled in a segment. |
| Next Extents | Size of the next extent (in megabytes). |
| Parameter | Description |
|---|---|
| Session Details: | |
| ID | Session Identifier for the connected session. |
| Status | Current status of the session. (ONLINE, OFFLINE or INVALID) |
| Machine | Name of the operating system. |
| User Name | Name of the Oracle process user. |
| Elapsed Time | Amount of time elapsed after the user has logged into the Oracle server (in seconds). |
| CPU Time | Amount of time the CPU was in use by the session. |
| Memory Sorts | Number of memory sorts used by the session. |
| Table Scans | Number of table scans performed. |
| Physical Reads | Number of physical reads occurred for the session. |
| Logical Reads | Number of physical reads occurred for the session. |
| Commits | Number of commits made by the user in a second. |
| Cursor | Number of cursors that are currently in use. |
| Buffer Cache Hit Ratio | Denotes the amount of session logical reads taking place from the buffer (in percentage). |
| Sessions Summary: | |
| Machine Name | Name of the machine hosting the session. |
| Program | Name of the program which is causing the session. |
| Session Status | Current status of the session. (ACTIVE or INACTIVE) |
| Session Count | Denotes the number of sessions that are running. |
| Session Waits: | |
| Session ID | Session Identifier for the connected session. |
| User | Name of the Oracle process user. |
| Event | Resource or event for which the session is waiting. |
| State | The state of the session. |
| Wait Time | The wait time for the session. If the value is 0, it means the session is currently waiting. |
| Seconds in Wait | Denotes the amount of time spent for the current wait condition (in seconds). |
| Number of Event Occurrence | The number of events occurred during that session. |
| Users: | |
| Username | The username assigned to the user. |
| Expiry Date | The date at which the user account expires. |
| Days to Expiry | The number of days remaining for the user account to expire. |
| Account Status | The current status of the user account. |
| User Profile | The profile name of the user. |
| Parameter | Description |
|---|---|
| PGA Stats Per Process: Provides a graphical representation of the PGA used by processes. | |
| Oracle Process: | |
| Process ID | Identifier for the Oracle process. |
| PGA Allocated | Amount of PGA memory allocated for the process (in megabytes). |
| PGA Used | Amount of PGA memory consumed by the process (in megabytes). |
| Freeable PGA | Amount of allocated PGA memory that can be freed back to the operating system (in megabytes). |
| Max PGA Used | Maximum amount of PGA memory consumed by the process. |
| Program Name | Name of the program in progress. |
| Parameter | Description |
|---|---|
| Schedule Jobs Details: | |
| Job Name | Name of the job. |
| Current State | The current state of the job. |
| Last Run Status | Status of the job that was running during the last run. |
| Last Run Date | The date on which the job started running during the last run. |
| Last Run Duration | Amount of time the job took to complete during the last run (in seconds). |
| Next Run Date | The date on which the job is scheduled to run. |
| Run Count | Number of times the job has run. |
| Failure Count | Number of times the job has failed to run. |
| Retry Count | Number of times the job has retried to run. |
| Elapsed Time | Denotes the time elapsed since the job was started (in seconds). |
| Is Enabled | Denotes whether the job is enabled or not. |
| Parameter | Description |
|---|---|
| CONFIGURATION DETAILS: | |
| Autonomous Database Name | Name of the autonomous database. |
| Compartment Name | Name of the compartment. |
| Region | Region where the autonomous database instance is running. |
| Compartment OCID | Oracle Cloud ID for the compartment. |
| CPU Core Count | The number of CPU cores to be made available for the autonomous database. |
| Auto Scaling Enabled | Indicates if auto scaling is enabled for the Autonomous Database. |
| Created Time | The date and time on which the database was created. |
| Dedicated Deployment | Indicates if the database uses the dedicated deployment option. |
| License Model | The license model that applies to the Oracle Autonomous Database. |
| DATABASE INFORMATION: | |
| Database Name | Name of the Oracle database. |
| Database Version | Version of the valid Oracle Database for Autonomous Database. |
| Data Storage Size | The amount of storage available in the database (in terrabytes). |
| Used Storage Size | The amount of storage that has been used (in terabytes). |
| Workload Type | The workload type of the autonomous database. Possible values are:
|
| Always Free Resource | Indicates if this the resource is 'Always Free'. The default value is false. |
| Preview Version | Indicates if the Autonomous Database is a preview version or not. |
| Life Cycle State | The current life cycle state of the autonomous database. |
| Life Cycle Details | Information about the current life cycle state of the autonomous database. |
| White listed IPs | The client IP access control list (ACL) for the database. (Available for server less deployments only) |
| CONNECTION INFORMATION: | |
| Oracle Application Express (APEX) URL | URL of the Oracle Application Express (APEX). |
| Oracle SQL Developer Web URL | URL of the Oracle SQL Developer. |
| Service Console URL | The URL of the Service Console for the Autonomous Database. |
| TPurgent | Denotes the database service tpurgent used for autonomous transaction processing operations. |
| TP | Denotes the database service tp used for autonomous transaction processing operations. |
| High | Denotes the database service high used for autonomous transaction processing operations. |
| Medium | Denotes the database service medium used for autonomous transaction processing operations. |
| Low | Denotes the database service low used for autonomous transaction processing operations. |
