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

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_at_gmail.co                                             
             m>                                                         To 
             Sent by:                  chzhu_at_ebay.com                      
             oracle-l-bounce_at_f                                          cc 
             reelists.org              sinardyxing_at_bkgcomsvc.com,          
                                       oracle-l_at_freelists.org              
                                                                   Subject 
             10/02/2004 12:34          Re: Increase FREEIST w/o drop       
             PM                        objects--sorry for the previous     
                                       garbage code                        
                                                                           
             Please respond to                                             
             zhuchao_at_gmail.com                                             
                                                                           
                                                                           
                                                                           

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

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 ======

--

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