Do wee still need to worry about the freelist setting when using 9i rel.2 feature called Automatic Segment Management? - - - Best Regards, Syed Jaffar Hussain OCP 8i DBA zhu chao <zhuchao@xxxxxxxx m> To Sent by: chzhu@xxxxxxxx oracle-l-bounce@f cc reelists.org sinardyxing@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx Subject 10/02/2004 12:34 Re: Increase FREEIST w/o drop PM objects--sorry for the previous garbage code Please respond to zhuchao@xxxxxxxxx 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 -- //www.freelists.org/webpage/oracle-l Visit us on www.alfransi.com.sa ====== Banque Saudi Fransi - Privacy Notice ====== This message is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any use of this information by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and delete the material from your computer. Any opinions and other information contained in this message that do not relate to the official business of Banque Saudi Fransi shall be understood as neither given or endorsed by it. Although precautions have been taken to ensure no viruses are present in this email, BSF cannot accept responsibility for any loss or damage arising from the use of this email or attachments. ====== Banque Saudi Fransi - Privacy Notice ====== -- //www.freelists.org/webpage/oracle-l