Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database Sizing

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US