Re: Help needed-- free space in tables

It is worth pointing out that the dbms_space pacakge also allows you to determine how many blocks are on the segment free lists - if you are prepared to take the hit of Oracle walking the free list.

Of course even this doesn't tell you how many are empty, only the number that are below the HWM have dropped below PCTUSED at some point and have still not got back to PCTFREE.

However, it is a piece of information that can help you to make a decision about whether or not you need to cater for adding a further extent to a segment.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Jurij Modic wrote in message <37433524.1160338_at_news.siol.net>...
>If we realy want to be precise, we must know that even DBMS_SPACE
>procedures don't show the number of *unused* blocks. The number you
>get from there only shows the number of blocks above the
>highwattermark. The fact is that you may have completely empty table
>(not a single row in it) occupying thousands of db blocks, but the
>DBMS_SPACE.UNUSED_SPACE might show you 0 blocks free!
>
>AFAIK there is no way you could determine precisely the number of
>unused blocks (that is, blocks that don't contain any rows) in a
>table.
Received on Thu May 20 1999 - 02:43:35 CDT