Hi: I saw the following message while searching web for some tips to improve exp speed. Has anyone tried this "un-supported" way and found improved performance? Had any problems? I don't have a machine that I can try this.
Guang --------- Oracle Export/Import Scripts: How to create imp and exp Oracle as single-task binaries Posted by: Administrator If someone is interested in implementing the create a new Oracle import binary as a single-task, see the steps below. 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%. To read the complete article, click on the Read more ... link. Submitted by our member: Chris 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 when doing export & import of data. Let me know if you have any problems, or improve the above procedure somehow. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
