Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: In praise of auto space management

Re: In praise of auto space management

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Fri, 12 Jul 2002 20:32:06 +1000
Message-ID: <3d2eb1be$0$14695$afc38c87@news.optusnet.com.au>


In article <1026389310.15520.0.nnrp-12.9e984b29_at_news.demon.co.uk>, you said (and I quote):

> You've crossed wires on the FREELIST/INITRANS I think.
> initrans became modifiable in 8.0, I'm pretty sure that
> freelist wasn't until somewhere in 8.1

Yup, just confirmed it with the old doco and an old 8.0.6 install.

>
> The reason why it could waste space to have large
> numbers of free lists is that each free list could
> request 5 blocks of free space when the master
> free list was empty - so worst case is that the
> last (5 x freelists x freelist groups) blocks in the
> table could contain virtually no data.

Ah, OK! I've only got a small number of freelists with reasonably large tables, don't think it will ever be a problem for me. Well, it hasn't so far... ;-)

-- 
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam
Received on Fri Jul 12 2002 - 05:32:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US