Re: Database Sizing

Eileen Ong wrote:
>
> Hi Allan,
>
> Thanks, but won't this also give the size of the unused space too? I only
> want to find out the size of all the database objects alone and do not want
> to include the unused space.
>
> Cheers
> Eileen
>
> --
>
> "godmann" <allanwtham_at_yahoo.com> wrote in message
> news:95cd51c.0111210108.32de3438_at_posting.google.com...
> > Hi there,
> >
> > try select sum(bytes) from dba_segments where tablespace_name='xyz'.
> > If you have a lot of tablespaces, do a script for it.
> >
> > Allan W. Tham
> > DBA
As Howard put, dba_segments, dba_data_files and dba_free_space will get you close. If you need to go to higher accurary, you could possibly glean some information from the dbms_space package.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."