Re: Increase FREEIST w/o drop objects--sorry for the previous garbage code
- From: zhu chao <zhuchao@xxxxxxxxx>
- To: sjhussain@xxxxxxxxxxxxxxx
- Date: Sat, 2 Oct 2004 17:45:23 +0800
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
> --
> //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
>
--
Regards
Zhu Chao
www.cnoug.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
