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;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
No comments:
Post a Comment