Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?

The set of metrics including IOPS (Input/Output Operations Per Second), and Apply and Transport Lag are unique to Autonomous Database on Dedicated Infrastructure. These metrics provide deeper insight into the performance of the underlying dedicated hardware and specific features like Autonomous Data Guard. Apply and Transport Lag are crucial for monitoring the disaster recovery configuration (standby database), a feature managed within the dedicated deployment model. These granular performance and feature-specific metrics are not exposed in the shared (serverless) infrastructure model.

A. Transaction Count, Running Statements, Sessions: These are standard database activity metrics available for both Autonomous Database on Shared and Dedicated Infrastructure to monitor general workload.
B. CPU Utilization, Storage Utilization: These are fundamental resource consumption metrics provided by the Oracle Cloud Infrastructure Monitoring service for both Shared and Dedicated deployment models.
D. Query Latency, User Calls, Execute Count: These are common SQL performance and execution metrics that are available for both Shared and Dedicated Autonomous Database deployments.

1. Oracle Cloud Infrastructure Documentation - Metrics for Autonomous Database on Dedicated Exadata Infrastructure: This official document lists the available metrics for the dedicated service. It explicitly includes autonomousDataGuardApplyLag

autonomousDataGuardTransportLag

readIops

and writeIops.

Reference: Oracle Cloud Infrastructure Documentation

"Database Service"

"Metrics for Autonomous Database on Dedicated Exadata Infrastructure"

Section: "Available Metrics: ociautonomousdatabase".

2. Oracle Cloud Infrastructure Documentation - Metrics for Autonomous Database on Shared Exadata Infrastructure: This document lists the metrics for the shared (serverless) service. It notably omits the Data Guard lag and IOPS metrics

while including metrics from options A

B

and D such as CpuUtilization

StorageUtilization

TransactionCount

RunningStatements

SessionCount

and UserCalls.

Reference: Oracle Cloud Infrastructure Documentation

"Database Service"

"Metrics for Autonomous Database on Shared Exadata Infrastructure"

Section: "Available Metrics: ociautonomousdatabase".