Re: need help

From: michael ringbo <mri_at_dde.dk>
Date: Mon, 25 May 1998 15:15:43 +0200
Message-ID: <35696EFF.1FF00EEB@dde.dk>

Hi,

Try some summarization on the Data Dictionary views DBA_FREE_SPACE and DBA SEGMENTS. A sum in DBA_FREE_SPACE, grouped by tablespace_name, gives you the free space in both bytes and blocks. A sum in DBA_SEGMENTS gives you the total used space.

Please note that the allocation of new space for some table or index is done in the way of extents, which is failing, if your free space i s made up of too many small places.

Hope this brief explanation could help you getting further.

Regards,

Michael Ringbo, DDE A/S

frank cannata wrote:

> please someone help me, I am a new junior oracla dba and have asked
> to create a script to analyze our database. by each segment I need to
> figure out the free space , the used space and the total space allocated
> in bytes.
>
> Please help me someone.......
>
> fcannata_at_cmp.com
Received on Mon May 25 1998 - 08:15:43 CDT