Re: Increase FREEIST w/o drop objects--sorry for the previous garbage code

hi,

    To increase the freelists on an object, you must be 8.1.6+. and to modify the freelist groups (at least 9i), you need to recreate the object.

    Some old rules get changed while oracle continue to change. By the way, one of our senior dba said, the freelists needs to be prime " Freelists needs to be a prime number. If you cannot use 23, use 17", I don't know why. Anyone have experience?  

Regards   

--

Regards
Zhu Chao
www.cnoug.org
--

http://www.freelists.org/webpage/oracle-l Received on Sat Oct 02 2004 - 04:30:17 CDT