Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Increase FREEIST w/o drop objects--sorry for the previous garbage code

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

From: zhu chao <zhuchao_at_gmail.com>
Date: Sat, 2 Oct 2004 17:45:23 +0800
Message-ID: <962cf44b0410020245cf53d75@mail.gmail.com>


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_at_alfransi.com.sa <sjhussain_at_alfransi.com.sa> 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_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
>

-- 
Regards
Zhu Chao
www.cnoug.org
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Oct 02 2004 - 04:40:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US