Advertisement
GLASHATAY_007

database

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