Oracle Cloud Autonomous AI Database

Oracle Cloud Autonomous AI Database - Overview

An Autonomous AI Database is a fully managed, pre-configured cloud database environment that uses AI and machine learning to perform tasks without any human intervention. It makes use of AI to automate 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 to perform routine functions such as backing up, patching, upgrading and tuning the database with ease.

Monitored Parameters

Prerequisites for monitoring Oracle Cloud Autonomous AI DB metrics:Click here

Go to the Monitors Category View by clicking the Monitors tab. Click on the Autonomous AI Database instance available under Oracle Cloud in the Cloud Apps section. Displayed is the Oracle Cloud Autonomous AI Database bulk configuration view distributed into three tabs:

Availability tab gives the availability history for the past 24 hours or 30 days.
Performance tab gives the health status and events for the past 24 hours or 30 days.
List view enables you to perform bulk admin configurations.

On clicking a monitor from the list, you will be taken to the Oracle Cloud Autonomous AI Database dashboard. It has 6 tabs:

Overview

Parameter	Description
UTILIZATION
CPU Utilization	Amount of CPU utilized by the Autonomous AI Database (in %).
Storage Utilization	Amount of storage capacity utilized by the Autonomous AI Database (in %).
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 AI 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.
STATEMENTS
Queued Statements	The number of queued SQL statements aggregated across all consumer groups.
Running Statements	The number of running SQL statements aggregated across all consumer groups.
FAILED LOGONS & CONNECTIONS THROUGHPUT:
Failed Connections	The number of failed database connections occurred.
Failed Logons	The number of failed logons occurred.
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.

Tablespace

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 %).
Free Bytes (%)	The remaining amount of storage that is free in the tablespace (in %).
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. Possible values: 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 sec).
Write Time	Time taken for a single write to the tablespace (in sec).
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 ms).
Average Write Time	The average time taken for write operations to occur (in ms).
Objects Approaching MAX Extents
Segment Name	Name of the segment approaching maximum extents.
Tablespace Name	Name of the tablespace.
Owner	Owner name of the table space.
Segment Type	The type of segment approaching maximum extents.
Extents	Number of extents allocated to the segment.
Next Extents	Size of the next extent (in GB).
Max Extents	Maximum allowed extents that can be filled in a segment.

Session

Parameter	Description
Session Details
Session ID	Session Identifier for the connected session.
Status	Current status of the session. Possible values: 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 sec).
CPU Time	Amount of time the CPU was in use by the session (in sec).
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 %).
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. Possible values: 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 (in ms). 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 sec).
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.

Process

Parameter	Description
Oracle Processes Using MAX PGA: 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 MB).
PGA Used	Amount of PGA memory consumed by the process (in MB).
Freeable PGA	Amount of allocated PGA memory that can be freed back to the operating system (in MB).
Max PGA Used	Maximum amount of PGA memory consumed by the process (in MB).
Program Name	Name of the program in progress.

Scheduled Jobs

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 sec).
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 sec).
Is Enabled	Denotes whether the job is enabled or not.

Configuration

Parameter	Description
CONFIGURATION DETAILS
Autonomous AI DB Name	Name of the autonomous AI database.
Compartment Name	Name of the compartment.
Region	Region where the autonomous AI 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 AI Database.
Auto Scaling Enabled	Indicates if auto scaling is enabled for the Autonomous AI 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 Cloud Autonomous AI Database.
DATABASE INFORMATION:
Database Name	Name of the Oracle database.
Database Version	Version of the valid Oracle DB for Autonomous AI Database.
Data Storage Size	The amount of storage available in the database (in TB).
Workload Type	The workload type of the Autonomous AI Database. Possible values are: OLTP - Autonomous Transaction Processing DW - Autonomous Data Warehouse
Always Free Resource	Indicates if this the resource is 'Always Free'. The default value is false.
Preview Version	Indicates if the Autonomous AI Database is a preview version or not.
Life Cycle State	The current life cycle state of the Autonomous AI Database.
Life Cycle Details	Information about the current life cycle state of the Autonomous AI 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 AI 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.

Oracle Cloud Autonomous AI Database