Database Autonomy Service (DAS) provides the real-time monitoring feature to monitor database instances. You can use this feature to check the performance of your database instance in real time 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 tab, you can select one of the following views:
- Chart: 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 execution times, usage of InnoDB cache, hit ratio of 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.
- Table: On the Real-time Tables tab, you can view the performance metrics that are collected at specific points in time. Note You can click Metric Description in the upper-left corner to view the description of each metric.