Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: In praise of auto space management
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.nospamReceived on Fri Jul 12 2002 - 05:32:06 CDT