Segments which are nearing the upper limit of maximum extents.
The rest of the information in this section is only valid for this metric when it appears in either the Enterprise Manager Grid Control or the Enterprise Manager Database Control (if applicable).
The following table shows how often the metric's value is collected.
Target Version |
Collection Frequency |
All Versions |
Every 24 Hours |
The first 10 segments names which are approaching their MaxExtent in the tablespace.
If possible, increase the value of the segment’s MAXEXTENTS storage parameter.
Otherwise, rebuild the segment with a larger extent size ensuring the extents within a segment are the same size by specifying STORAGE parameters where NEXT=INITIAL and PCTINCREASE = 0.
For segments that are linearly scanned, choose an extent size that is a multiple of the number of blocks read during each multiblock read. This will ensure that the Oracle multiblock read capability is used efficiently.
Related Topics
About Alerts
About the Metric Detail Page
Editing Thresholds
Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.