Re: How can I find size of my DB?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 17 Aug 2002 08:58:27 -0700
Message-ID: <92eeeff0.0208170758.6d653add_at_posting.google.com>


ashrivastava_at_auriga-insys.com (Anand) wrote in message news:<396cc940.0208160602.52f1e69d_at_posting.google.com>...
> Hi,
> I need a method to find out the exact size of my database! One way to
> do this that I can predict is to take the size of each table and then
> sum it up, but there must be a cleaner approach!
>
> Thanks and Regards,
> Anand

select round(sum(a.bytes)/1048576, 0) "Total Allocated Size (MB)",

       round(sum(b.bytes)/1048576, 0) "Total Used Size (MB)" from sys.dba_data_files a, sys.sm$ts_used b where a.tablespace_name = b.tablespace_name(+);

//Rauf Sarwar Received on Sat Aug 17 2002 - 17:58:27 CEST

Original text of this message