Re: Help needed-- free space in tables

From: Bass Chorng <bass_at_octel.com>
Date: 18 May 1999 20:11:09 GMT
Message-ID: <7hshgt$mt5$1@news.eng.octel.com>

tedchyn_at_yahoo.com wrote:

: vick, you are able to find out from dba_free_spce.  Ted
: In article <7hpde0$jed$1_at_nnrp1.deja.com>,
:   newbie DBA <vramming_at_my-dejanews.com> wrote:

: > I need to find out how much free space in left in some tables or if I
: > should increase the values of MAX_EXTENTS and PCTINCREASE.
: > Help greatly appreciated!
: > Thanks
: > Vick
: >

dba_free_space only helps to find out free space in a tablespace, not in a table. The original question was 'in a table' - although maybe Vick did not mean it, but to answer this question precisely, you need to run dbms_space.unused_space procedure.

This tells you how many blocks are unused within the segment.

Regards,

-Bass Chorng Received on Tue May 18 1999 - 15:11:09 CDT