Note: Available for Oracle 10g and later.
The Segments page displays information on database segments associated with specified waiting events.
The Segments page contains a single table, Segments related to the event, which shows segment details for the specified event. You can use these details to spot performance problems associated with individual segments, and so identify hot tables or indexes.
To open the Segments page
Click Cluster | Overhead Page | Segments.
Note: Click Activity | Waiting Events Page to show wait events in other categories.
Grid: Segments related to the event
Column | Description |
---|---|
Segment Name |
The segment related to the event. |
Waits |
The total number of waits associated with the segment. |
Waits Percentage |
The percentage of time spent waiting that was associated with the segment. |
© ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center