Re: How find DB size

Depends on what size you want. If you want the size of all of the datafiles:

select sum(bytes)/1024/1024 from dba_data_files;

If you want the amount of space allocated to all of the segments within a database:

select sum(bytes)/1024/1024 from dba_segments;

If you want the amount of space actually consumed by data:

hire me to consult . . .

JekPorkins wrote:

>How I do sql regarding to find database size in megabites? New to Oracle databse.
>
>Thanks,
>
>Ganji
>
Received on Fri Apr 26 2002 - 20:28:13 CDT