Single-task imports

greenspun.com : LUSENET : DBAzine : One Thread

Has anyone had any success implementing the below steps to create a new import function as a single-task? I'm getting ELF CLASS and file not found errors and am running 64-bit 8.1.7.4...any suggestions are greatly appreciated!!!

The import and export programs (imp/exp) run in two task mode to protect the SGA from potential corruption by user programs. By relinking these two programs in single task mode you can gain much improvement in speed. In many cases up to 30%. Oracle themselves use this method although it is NOT supported by Oracle. Running in single-task is much faster but it requires more memory since the Oracle executable's text is no longer shared between the front-end and background processes. If you need to transfer large amounts of data between databases, relink the executale for greater efficiency. To relink the RDBMS kernel and create the two new imp/exp programs, use the following: % cd $ORACLE_HOME/rdbms/lib % make -f ins_rdbms.mk singletask % make -f ins_rdbms.mk expst % make -f ins_rdbms.mk impst % make -f ins_rdbms.mk sqlldrst % mv expst $ORACLE_HOME/bin/ % mv impst $ORACLE_HOME/bin/ % mv sqlldrst $ORACLE_HOME/bin/

Now use expst and impst instead of imp or exp

-- Brad Hanes (brad_hanes@sra.com), April 22, 2003


Moderation questions? read the FAQ