> Home > Scripts > Oracle >

Calculate size to set extent for re-organization

This script should be run from SQL*plus prompt. This can also be placed in a file and ran from the SQL*plus prompt. 

 

SELECT segment_name, 

       segment_type, 

       extents, 

       initial_extent, 

       next_extent,

      ((initial_extent + 

        (next_extent * (extents - 1))

       )/ (1024 * 1000)

      ) Meg_required 

FROM user_segments
WHERE extents > 1
ORDER BY tablespace_name, segment_type

/