col owner FOR a20
col segment_name FOR a40
SELECT S.owner “Owner”,
Nvl(S.segment_name, ‘TABLE TOTAL SIZE’) “Segment_name”,
Round(SUM(S.bytes) / 1024 / 1024 / 1024, 1) “Segment_size_GB”
FROM dba_segments S
WHERE S.segment_name IN ( ‘&TABLE_NAME’ )
AND S.owner IN ( ‘&SCHEMA_NAME’ )
OR S.segment_name IN ((SELECT L.segment_name
FROM dba_lobs L
WHERE L.table_name = ‘&TABLE_NAME’
AND L.owner IN ( ‘&SCHEMA_NAME’ )))
GROUP BY S.owner,rollup( S.segment_name )
ORDER BY 1,2,3;d
Recent Posts
