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;
Labels: , , , , ,

1 comment:

  1. Santosh Tiwary1 January 2015 at 12:01

    Very helpful for finding the SCHEMA Size in Oracle database. Thanks for sharing.

    ReplyDelete

Subscribe to: Post Comments (Atom)