Re: Database Sizing
From: Eileen Ong <eileen_ong_at_abacus.com.sg>
Date: Wed, 21 Nov 2001 17:28:49 +0800
Message-ID: <9tfs0o$q8j$1_at_newton.pacific.net.sg>
Date: Wed, 21 Nov 2001 17:28:49 +0800
Message-ID: <9tfs0o$q8j$1_at_newton.pacific.net.sg>
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
Received on Wed Nov 21 2001 - 10:28:49 CET