Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Spotlight on Oracle 11.0 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Troubleshooting: Connection Problems

Segments Page

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

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. Click Activity | Waiting Events Page | Segments.

Grid: Segments related to the event

This table contains data only when a wait category (and, optionally, a wait event) is selected in the drop-down list at the top of the page.

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.

 

Related Topics

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation