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_at_gmail.com> wrote:
>
> 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/

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

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