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@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 - 03:28:49 CST