Re: PCTUSED & PCTFREE Q's

Peter Moore (pt_at_chaff.demon.co.uk) wrote:

: What this means is each block will be on the FREELIST until it has only 15% 
: remaining free.  Then it is taken off the freelist.  So, now rows in that 
: block may be updated or deleted.  If the freespace in the block increases to 
: more than 60% then the block is replaced on the freelist.

Yes, but what if you shutdown the DB. Will blocks that are taken from the freelist, apper on the freelist when the DB is started again. Or in other word, are the freelist beeing saved when you do a shutdown ??

-- 
    .       !/                                           #######################


    %&     [>    ..               li      ..             #                     #


   #_at_\\  /+}   g8''9c   #\.=-.  .ro£=-  o6''8m   %\.--.  # Morten              #
   _at_o `?' J=  s2   @e   RP'´    "T2T"  m3   %e   H!''#|  # Kristiansen         #