dd_initial_extents.sql

select
s.segment_name,
s.bytes / 1024 || 'K' suggest1,
ceil(s.bytes / (10 * p.value)) * (p.value / 1024) || 'K' suggest2
from
sys.dba_segments s,
sys.v_$parameter p
where
s.tablespace_name = 'SYSTEM' and
s.extents > 1 and
s.segment_name != 'SYSTEM' and
p.name = 'db_block_size'
/
Script: dd_initial_extents.sql
-- Purpose: to get initial extent sizes for dd segments when rebuilding