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
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