world apps dba
Saturday, 22 February 2014
Query to find the SCHEMA Size in oracle database
Query to find the SCHEMA Size in oracle database
SELECT s.owner,SUM (s.BYTES) / (1024 * 1024 * 1024) SIZE_IN_GB
FROM dba_segments s
GROUP BY s.owner;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment