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;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
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment