Very briefly...

select sum(bytes)/1048576 MB from dba_data_files;

Then add to it sum of sizes of all redo log and control files.

Regards,

- Kirti Deshpande
Verizon Information Services
http://www.superpages.com

> -----Original Message-----
> From: Paresh Gawade [SMTP:[Email Address Removed] Sent: Saturday, June 30, 2001 1:06 AM
> To: LazyDBA.com Discussion
> Subject: Size of database
>
> Dear Gurus,
>
> Can anybody tell me how to calculate the size of the database.
> Pls tell me in brief.
>
> Paresh
>
>
Oracle LazyDBA home page