Database Autonomy Service (DAS) provides the real-time monitoring feature to monitor database instances in real time. You can use this feature to check the performance of your database instances during stress testing or peak hours.
Procedure
- Log on to the DAS console.
- In the left-side navigation pane, click Instance Monitoring.
- Find the database instance that you want to manage and click the instance ID. The instance details page appears.
- In the left-side navigation pane, click Real-time Monitoring.
- On the Real-time Monitoring page, you can select one of the following view modes:
- On the Real-time Charts tab, you can view the monitoring data that is collected at specific points in time, such as the number of slow queries, queries per second (QPS), transactions per second (TPS), the number of connections, DML executions, usage of the InnoDB cache, hit ratio of the InnoDB cache, the number of InnoDB rows that are read, inserted, updated, or deleted, the number of logical reads, and the number of physical reads.
- On the Real-time Tables tab, you can view the performance metrics of the instance at specific points in time. Note You can click Metric Description in the upper-left corner to view the description of each metric.