Tuesday 12 March 2013

Query to find the SCHEMA Size in oracle database

Here the query,
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