Wednesday, February 6, 2019

Find all database schemas size

SELECT OWNER,
  SUM(bytes)/1024/1024/1000 "SIZE_IN_GB"
FROM dba_segments
GROUP BY owner
ORDER BY owner;
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)