How does one relink Oracle Utilities as single-task binaries?

Submitted by admin on Sat, 2004-08-07 08:18
Body: 

Note: Single-task linking of tools are not available in Oracle 9i and above releases.

By default Oracle utilities (like imp and exp), run in two task mode to protect the SGA from potential corruption by user programs. These utilities can be relinked in single task mode to improve performance (up to 30%). Although Oracle won't support this, they supposedly use it
themselves.

Besides the speed-gain, the single-task utilities require more memory to run as the executable's text is no longer shared between the front-end and background processes. Thus, if you need to transfer large amounts of data between databases, relink the executale for greater efficiency.

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/

You can now use the *st utilities instead of the original utilities. For example, use expst and impst instead of imp and exp.

»