Monitor Autonomous AI Database

Monitor database performance by viewing metrics, logs, and audit trails.

Tip:

You can limit the database instances where you see metrics with dimensions. The available dimensions include: workload type, instance display name, region, and the instance OCID. Use dimensions by selecting values in the Oracle Cloud Infrastructure Console Service Metrics page or by setting dimension values with the API.

• View Metrics for an Autonomous AI Database Instance
  View metrics for an Autonomous AI Database instance.
• View Autonomous AI Database Metrics in a Compartment
  View Autonomous AI Database metrics in a compartment.
• View Autonomous AI Database Logs and Audit Trails
  View Autonomous AI Database logs and audit trails.

See Also:

• View Autonomous AI Database Metrics in a Compartment to view metrics and to select metric dimensions.

• Monitor and Manage Performance in Using Oracle Autonomous AI Database Serverless

• Available Metrics: oci_autonomous_database in Using Oracle Autonomous AI Database Serverless to learn about the available database-centric metrics.

View Metrics for an Autonomous AI Database Instance

View metrics for an Autonomous AI Database instance.

Note:

To view metrics you must have the required access as specified in an Oracle Cloud Infrastructure policy (whether you're using the Console, the REST API, or another tool). See Securing Monitoring in Oracle Cloud Infrastructure Documentation.

To view metrics for an Autonomous AI Database.

1. Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
2. Next to the Oracle Cloud logo, click the Navigation menu () and select Developer Services and then APEX Instances.
3. On the APEX Instances page, find and select your service.
4. Under Instance details, find Database and click the database NAME.
5. On the Autonomous AI Database details page, click the Monitoring tab.
   A chart displays for each metric.
6. For each chart, select the Interval and Statistic, or use the default values.

   Tip:

   To learn about the available database-centric metrics, see Available Metrics: oci_autonomous_database in Using Oracle Autonomous AI Database Serverless.
7. Optionally, to view all the Autonomous AI Database metrics:
   1. Click view all database metrics.
   2. From Metric namespace, select oci_autonomous_database.
   3. To edit Dimensions:
      • Next to Dimensions, click Edit.
      • In the Edit dimensions dialog, for deploymentType select Shared.
      • Click Done.
   4. Control the time interval by configuring Start time, End time, or Quick Selects.
8. To create an alarm on a metric, click Options and select Create an Alarm on this Query.

See Also:

• Overview of Monitoring and Managing Alarms in Oracle Cloud Infrastructure Documentation

• To use the Monitoring API to view metrics, see Monitoring API.

View Autonomous AI Database Metrics in a Compartment

View Autonomous AI Database metrics in a compartment.

Note:

To view metrics you must have the required access as specified in an Oracle Cloud Infrastructure policy (whether you're using the Console, the REST API, or another tool). See Getting Started with Policies.

To view Autonomous AI Database metrics in a compartment:

1. Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
2. Next to the Oracle Cloud logo, click the Navigation menu () and select Developer Services and then APEX Instances.
3. On the APEX Instances page, find and select your service.
4. Under Instance details, find Database and click the database NAME.
5. On the Autonomous AI Database details page, click the Monitoring tab.
6. Click view all database metrics.
7. On the Service Metrics page:
   1. Compartment - Select your compartment.
   2. Metric namespace - Select oci_autonomous_database.
8. If you want to limit the metrics you see, next to Dimensions click Add (or click Edit if you have already added dimensions).
   1. Dimension Name field - Select a dimension.
   2. In the Dimension Value field - Select a value.
   3. Click Done.
9. To create an alarm on a metric, click Options and select Create an Alarm on this Query.

See Also:

Overview of Monitoring and Managing Alarms in Oracle Cloud Infrastructure Documentation

View Autonomous AI Database Logs and Audit Trails

View Autonomous AI Database logs and audit trails.

Note:

To view logs and audit trails you must have the required access as specified in an Oracle Cloud Infrastructure policy (whether you're using the Console, the REST API, or another tool). See Getting Started with Policies for information on policies.

To view audit trails and logs for an Autonomous AI Database instance:

1. Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
2. Next to the Oracle Cloud logo, click the Navigation menu () and select Developer Services and then APEX Instances.
3. On the APEX Instances page, find and select your service.
4. Under Instance details, find Database and click the database NAME.
5. On the Autonomous AI Database details page, select Monitoring and click View audit and logs.
6. Under Logging:
   • Click Logs to view log information.
   • Click Audit to view audit information.

See Also:

• Audit Autonomous AI Database in Using Oracle Autonomous AI Database Serverless
• Audit Logs in Oracle Cloud Infrastructure Documentation