RE: Cloning 21 GB Table - Review Approach please
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 10 Mar 2005 15:36:40 +0530
Will Arhive Redo Log be generated by the INSERT /*+ APPEND */ Command if =
the Target Table has been PRE-Created with NOLOGGING?
Any possibility of giving Hint for NOLOGGING in the INSERT Command ?
-----Original Message-----
From: VIVEK_SHARMA=20
Sent: Thursday, March 10, 2005 3:31 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: Cloning 21 GB Table - Review Approach please
We are to clone a 32Million records table of approx 21GB in the same DB.
=A0
We are considering the following approach:-
MULTIPLE statements INSERT /*+ APPEND */ INTO <Target Table> SELECT ... =
FROM <Source Table> WHERE Suitable Condition ..... to be executed.
Num of concurrent (parallel) executions to depend on the Machine config =
(Num of CPUs & nature of Storage Box)
/*+ APPEND */ Hint causes a Block wise(NOT row-wise) Load into the =
Target table provided NO indexes exist on it.
(Oracle 9.2 version much faster for such loads than Oracle 8i)
=A0
OPTIMIZATION PREPERATION=20
Suitable partitioning for the target table=20
Partitions to be Located in different Tablespaces
Tablespaces to be LMTs
=A0
Existence of any suitable indexes on Source Table for faster Selection =
of records therefrom.
=A0
Database Init.ora params to be optimized
OS parameters to be optimized=20
=A0
--
//www.freelists.org/webpage/oracle-l
Other related posts:
