Friday, 30 March 2012

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;

Posted by at

1 comment:

  1. Oracle DBA19 April 2012 at 21:47

    nice blog......find more here

    http://chandu208.blogspot.com/2011/09/scripts.html

    ReplyDelete

Subscribe to: Post Comments (Atom)