12/17/2014

Oracle select - how to check all tables from schema

Select  how to check all tables from schema with table sizes.

SELECT /*+ PARALLEL(dba_segments,16) */ owner,
        segment_name,
        segment_type,
        tablespace_name,
        round(SUM (bytes) / POWER (2, 20), 1) size_gb
        FROM dba_segments
        WHERE owner IN ('<SCHEMA OWNER NAME>')
GROUP BY owner, segment_name, segment_type, tablespace_name 
        order by segment_name;

No comments:

Post a Comment

Popular Posts