Dynamic performance views offer deep insights into the performance and health of Autonomous Databases, enabling database administrators to perform detailed analyses and optimizations. ACD_ performance views allow you to monitor databases at the Autonomous Container Database level. You can leverage real-time and historical data for effective database monitoring and management provided that you have the privileges to access these views.

Dynamic performance views are continuously updated system views maintained by the database server. They provide real-time data primarily related to database performance, making them invaluable for database monitoring and tuning.

Using dynamic performance views, you can:

• Monitor real-time database activities through various wait events and classes.
• Analyze historical performance data to identify trends or issues.
• Assess database resource utilization against limits.
• Summarize performance metrics to gauge overall database health.

In Autonomous Database instances, besides accessing standard PDB level Oracle Database dynamic performance views, you can also access views at the Autonomous Container Database level which are prefixed with ACD_, followed by either V$ for single-instance databases or GV$ for Real Application Clusters (RAC), indicating global views that aggregate data across all instances.

The following table lists the Autonomous Container Database level dynamic performance views available in Autonomous Database on Dedicated Exadata Infrastructure:

For a complete list and detailed information about each dynamic performance view, refer to the Oracle documentation on About Dynamic Performance Views.

To help you get started, see the example queries to extract metrics from these views:

SELECT METRIC_NAME, VALUE, METRIC_UNIT
FROM ACD_V$SYSMETRIC
WHERE METRIC_NAME IN ('Database CPU Time Ratio', 'Database Wait Time Ratio');

SELECT RESOURCE_NAME, CURRENT_UTILIZATION, MAX_UTILIZATION, LIMIT_VALUE
FROM ACD_V$RESOURCE_LIMIT
WHERE RESOURCE_NAME IN ('processes', 'sessions', 'enqueue_locks');

SELECT e.NAME AS EVENT_NAME, m.NUM_SESS_WAITING, m.TIME_WAITED
FROM ACD_V$EVENTMETRIC m JOIN V$EVENT_NAME e ON m.EVENT_ID = e.EVENT_ID
WHERE e.NAME IN ('db file sequential read', 'db file scattered read', 'log file sync');

SELECT METRIC_NAME, METRIC_VALUE, METRIC_TYPE
FROM ACD_V$CELL_GLOBAL
WHERE METRIC_NAME IN (
        'Cumulative User CPU ticks',
        'Cumulative System CPU ticks',
        'Network bytes received',
        'Network bytes transmitted',
        'Total Reads',
        'Total Writes',
        'Ticks spent reading',
        'Ticks spent writing');

SELECT REASON_NAME, METRIC_NAME, METRIC_VALUE, METRIC_TYPE
FROM ACD_V$CELL_IOREASON
WHERE CELL_NAME = 'YourCellName';