Monitor Autonomous 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.

See Also:

Parent topic: Monitor Oracle APEX Performance

View Metrics for an Autonomous Database Instance

View metrics for an Autonomous 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 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 (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 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 Database Serverless.
  7. Optionally, to view all the Autonomous 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:

Parent topic: Monitor Autonomous Database

View Autonomous Database Metrics in a Compartment

View Autonomous 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 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 (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 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

Parent topic: Monitor Autonomous Database

View Autonomous Database Logs and Audit Trails

View Autonomous 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 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 (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 Database details page, scroll down to Metrics and click View audit and logs.
  6. Under Logging,
    • Click Logs to view log information.
    • Click Audit to view audit information.

See Also:

Parent topic: Monitor Autonomous Database