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

There are many site don't use the new features , like ASM. There are a
lot of ASM related bugs in metalink.
So it is still meaningful to tune freelists/groups even in 9i.

Regards.


On Sat, 2 Oct 2004 12:39:25 +0300, sjhussain@xxxxxxxxxxxxxxx
<sjhussain@xxxxxxxxxxxxxxx> wrote:
> 
> 
> 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
> --
> 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
> 



-- 
Regards
Zhu Chao
www.cnoug.org
--
http://www.freelists.org/webpage/oracle-l

Other related posts: