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

  • From: "Anand Rao" <panandrao@xxxxxxxxx>
  • To: VIVEK_SHARMA@xxxxxxxxxxx
  • Date: Thu, 28 Sep 2006 10:28:10 +0530

FREELIST is not applicable for INSERT statements.


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

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



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 ?


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

Other related posts: