The Activity Summary page provides an overview of the activity on the database you are diagnosing.
To open the Summary page
Click Activity | Summary.
Charts on the Summary page
Notes:
Note: Applicable to Oracle 12c. From the Container field select to filter the data in these charts for:
Chart | Description | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
IO Demand |
Shows all user IO demand over time. User I/O is broken down into the following categories:
For more details on logical I/O, view the I/O drilldown | Summary Page. | ||||||||||||||
Average Active Sessions |
Shows the DB time for all sessions over time. DB time is broken down into the following categories:
See also Average Active Sessions on the Spotlight on Oracle home page | Service Panel. | ||||||||||||||
Event Waits |
Shows the amount of time (in milliseconds) that sessions have spent waiting on various events per second. Event wait categories from V$SYSTEM_EVENT are aggregated into categories so that they can be graphed. To see a further breakdown of Disk I/O see Activity | Waits Page | Event Waits. For more information on wait events, see Deal With Wait Events. | ||||||||||||||
Top Waits |
Shows the wait events (from the Activity | Waits Page) that have shown the highest rate of wait time over the past hour. For more information on wait events, see Deal With Wait Events. | ||||||||||||||
Throughput - requests |
The rate of I/O requests according to file type. As the number of requests approaches the limit of the I/O system being used for the database, latency will start to degrade. Latency is the average time (in milliseconds) taken to process a physical I/O request. Values that are consistently high over the displayed period are those most likely to contribute to performance bottlenecks. This chart replicates the I/O drilldown | Summary Page | File Type | Throughput - requests chart. | ||||||||||||||
Latency |
The average time delay experienced while the database performs I/O activities. To maximize response time to end users, the latency should remain low – in general a latency below 10ms will give users good response time. As the latency increases, the response time may degrade. This time will vary from database to database – for example in a large batch job – the latency might not be as important as the throughput, but when there is a lot of users on the system, a low latency is important to ensure response time. This chart replicates the I/O drilldown | Summary Page | File Type | Latency chart. |
© ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center