Examine the Number of Extents in a Table

The amount of time it takes to retrieve data blocks is proportionate to the number of extents in the table. Ideally, a table should have one to three extents. Run this script from sqlplus to get those segments (tables or indexes) that have a surplus of extents. Here

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: