Freelist Groups in 11g documentation

From: Martin Bach <>
Date: Sun, 10 Jan 2010 17:24:19 +0000
Message-ID: <>

Dear list members,

seems like I am beaten by Sunday evening blindness but I can't find anything useful regarding freelist groups in the 11g documentation. I queried and google but all I got back were hits in 9i and OPS documentation.

So it seems users are discouraged from using manual segment space management?

I am asking because I couldn't reply properly (to my own standards) to a developer who wanted to increase ITL entries and freelists on some index segments where he saw lots of buffer busy waits (read by other session) during a parallel alter table move ... updating global indexes. Oh, the developer claimed they were in data blocks, not segment headers (based on an AWR report).

Is there a good source of information available besides said slightly older documentation? Or does anyone know why you'd increase freelists and ITL entries for indexes? From a thread on this list I thought there wasn't much point in doing so...

Any pointers to information appreciated.


PS: Oracle 64bit on RHEL 5.3/3 node cluster (and no interconnect problem :)

Received on Sun Jan 10 2010 - 11:24:19 CST

Original text of this message