Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT LOWER(owner) || '.' || LOWER(segment_name) AS "table_name",
- LTRIM(TO_CHAR(ROUND(SUM(bytes) / 1024 / 1024, 2), '999G999G999G990D00', 'nls_numeric_characters=''. ''')) || ' MB' AS "table_size"
- FROM dba_segments
- WHERE LOWER(segment_type)='table' AND
- LOWER(owner)='cuba' AND
- LOWER(segment_name) LIKE '%'
- GROUP BY owner, segment_name
- ORDER BY SUM(bytes) DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement