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..."
Received on Wed Nov 21 2001 - 05:17:28 CST
