Single-task importsgreenspun.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 220.127.116.11...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 (email@example.com), April 22, 2003