Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Fixed table
Across most recent versions of Oracle,
you can use dbms_space. This has
procedure which return
Be warned that the only way to discover the (temporarily) exact number of blocks on the free lists is to walk every free list one block at a time - so the procedure for counting free blocks may be very hard on I/O in some special cases.
-- Jonathan Lewis http://www.jlcomp.demon.co.uk Now running 3-day intensive seminars http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases Michele Brugo wrote in message ...Received on Tue Mar 05 2002 - 02:37:24 CST
>On Mon, 04 Mar 2002 19:42:34 GMT, damorgan
><dan.morgan_at_ci.seattle.wa.us> wrote:
>
>>Free blocks are free ... they are not in extents.
>>
>>Daniel Morgan
>>
>>
>>
>>Michele Brugo wrote:
>>
>>> Hi,
>>> is there a view, fixed table that describe which free blocks are in a
>>> generic extent ?
>>>
>>> TIA
>>>
>>> Mike
>
>i mean the blocks that are in extent but are marked free, ready for an
>insert.
>
>mike
>