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

I AM ON TURBO SPEED !!!

Jee...what was i thinking. i meant write that about the other 2 DML
statements and ended up "inserting" an INSERT statement...

Christian,Gopal, Vivek and everyone...

that was not meant to be there. Looong Holidays starting tomorrow.....in a
hurry to click all the buttons :)

apologies.

FREELISTs are meant for INSERT statements.

*must stop drugs*

*stop listening to Dreamtheater*

*can't do it*

anand

On 28/09/06, K Gopalakrishnan <kaygopal@xxxxxxxxx> wrote: 

Anand,

You are not joking right?

-Gopal


On 9/27/06, Anand Rao <panandrao@xxxxxxxxx> wrote:
>
> FREELIST is not applicable for INSERT statements.
>
> regards
> anand
>
> On 27/09/06, VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx > 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> > On Behalf Of Jonathan Lewis
> > Sent: Wednesday, September 27, 2006 3:17 PM
> > To: oracle-l@xxxxxxxxxxxxx
> > 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@xxxxxxxxxxx>
> >
> > To: <oracle-l@xxxxxxxxxxxxx>
> >
> > 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/





--
All I need to make a comedy is a park, a policeman and a pretty girl -
Charlie Chaplin

Other related posts: