Post date: 04-Jun-2010 07:13:01
TASKS for Reorganization using EXP/IMP
================================
1. Prepare Following Scripts for
(A) Building Tables
(B) Building Indexes
(C) Building Constraints
2. Export the tables with following parameters to gain performance
(A) Use direct=y
(B) Do not export Indexes
Before Starting Import do following actions on DB
(A) Run the Table build scripts to build all the structures of tables
(B) Increase the sort_area_size using deferred clause.
(C) Incerease the db_file_multiblock_read_count (128 is the maximum value)
3 Import with following strategy/parameters
(A) Keep Database in Noarchivelog mode.
(B) Use Ignore=y
(C) Use commit=y
(D) Use buffer=10485760
(E) Use STATISTICS=NONE
(F) Use Bigger Sort area size before starting the import
After the import do the following actions on DB
(A) Run Index build scripts with nologging cluase and run them with parallel option
(B) Put the indexes to logging mode or nologging mode acording to their previous state whether they were logging or nologging.
(C) Change back the sort_area_size and db_file_multiblock_read_count to original values using deferred clause.
(D) Take statistics of Database.