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
