Re: Altering Freelist Groups in 10gR2 when moving to RAC from NON-RAC?

Anand,

You are not joking right?

-Gopal

On 9/27/06, Anand Rao <panandrao_at_gmail.com> wrote:
>
> FREELIST is not applicable for INSERT statements.
>
> regards
> anand
>
> On 27/09/06, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com > wrote:
> >
> > Jonathan, Folks
> >
> >
> >
> > A small change to include indexes too in the below Qs:-
> >
> >
> >
> > Qs Does conversion of freelist groups to 4 needs to be done ONLY for
> > Tables & Indexes which undergo INSERTs & NOT for Tables / Indexes which
> > undergo UPDATEs, SELECTs, DELETEs?
> >
> >
> >
> > NOTE Our Database Size is Huge i.e. 3 TB.
> >
> >
> >
> > Qs Any Other parameter that should also be changed when moving a NON-RAC
> > Database to RAC?
> >
> >
> >
> > Thanks indeed for responding
> >
> >
> >
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> > On Behalf Of Jonathan Lewis
> > Sent: Wednesday, September 27, 2006 3:17 PM
> > To: oracle-l_at_freelists.org
> > Subject: Re: Altering Freelist Groups in 10gR2 ?
> >
> >
> >
> >
> >
> > The only option is to do the CTAS, as the freelist group
> >
> > blocks are located immediately after the segment header
> >
> > block in the first extent.
> >
> >
> >
> > The only other option to consider is 'alter table move' to
> >
> > move the table into a tablespace defined to use ASSM
> >
> > and forget about freelist groups - but I'm not very keen
> >
> > on ASSM for high-performance, high-concurrency systems
> >
> > myself.
> >
> >
> >
> > Regards
> >
> >
> >
> > Jonathan Lewis
> >
> >
> >
> > ----- Original Message -----
> >
> > From: "VIVEK_SHARMA" <VIVEK_SHARMA_at_infosys.com>
> >
> > To: <oracle-l_at_freelists.org>
> >
> > Sent: Wednesday, September 27, 2006 10:42 AM
> >
> > Subject: Altering Freelist Groups in 10gR2 ?
> >
> >
> >
> > Folks
> >
> >
> >
> > When converting a NON-RAC Database to RAC in 10.2, the freelist groups
> >
> > need to be altered to 4(= to the Number of RAC Nodes)
> >
> >
> >
> > How is the freelist groups to be altered?
> >
> >
> >
> > Seek to avoid usage of the CTAS command i.e. "Create Table <Duplicate
> >
> > Tbl Name with freelist groups 4> As Select * from Original Table" since
> >
> > this is very tedious
> >
> >
> >
> > Is there any performance issue/Others with using the alter approach
> >
> > versus the CTAS approach?
> >
> >
> >
> > Thanks indeed
> > **************** CAUTION - Disclaimer *****************
> > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> > solely for the use of the addressee(s). If you are not the intended
> > recipient, please notify the sender by e-mail and delete the original
> > message. Further, you are not to copy, disclose, or distribute this e-mail
> > or its contents to any other person and any such actions are unlawful. This
> > e-mail may contain viruses. Infosys has taken every reasonable precaution to
> > minimize this risk, but is not liable for any damage you may sustain as a
> > result of any virus in this e-mail. You should carry out your own virus
> > checks before opening the e-mail or attachment. Infosys reserves the right
> > to monitor and review the content of all messages sent to or from this
> > e-mail address. Messages sent to or from this e-mail address may be stored
> > on the Infosys e-mail system.
> > ***INFOSYS******** End of Disclaimer ********INFOSYS***
> >
>
>
>
> --
> All I need to make a comedy is a park, a policeman and a pretty girl -
> Charlie Chaplin

-- 
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Coming Soon... Oracle RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/

--
http://www.freelists.org/webpage/oracle-l