How calculate new extent sizes?

-- tabextprop.sql

select dbsname,

tabname,

count(*) num_of_extents,

sum (pe_size ) current_pages_used,

round (sum (pe_size )

* 2 { Your systems page size in KB }

* 1.2 { Add 20% Growth factor })

Proposed_ext_size, { First Extent Size in KB }

round (sum (pe_size )

* 2 { Your systems page size in KB }

* .2 { Estimated 20% Yearly Growth })

Proposed_next_size { Next Extent Size in KB }

from systabnames, sysptnext

where partnum = pe_partnum

group by 1, 2

order by 3 desc, 4 desc;

Previous slide

Next slide

Back to first slide

View graphic version