Friday, January 18, 2008

calculate exp dump size for oracle db

Thanks to Jared-

select sum(bytes)/(1024*1024*1024) bytes
from dba_segments
where segment_type not in (
'CACHE',
'ROLLBACK',
'TYPE2',
'UNDO',
'INDEX'
)

10% variation

No comments: