Re: Make export / Import run faster ?

Hi Vivek,
Hi Vivek,
We have used the single task executables during some bench marking operations on Sequent on versions 7.3.4 and 8.0.5 and they do offer a good improvement in terms of performance. But it is not supported by oracle and hence its use is limited to test systems and benchmarks and is not very popular with productions systems. It also introduces chances of corruption when the database is being accessed during the export using these executables.

Hope this helps.
Regards,

Madhavan
http://www.dpapps.com

> CASE - What can be done to make export/import run faster?
> > The IMP/EXP programs run in two task mode to protect the SGA from
> > potential corruption by user programs. If you relink these programs in
> > single task mode you can gain much improvement in speed (up to 30%).
> > Although Oracle won't support this they supposedly use this method
> > themselves.
> > Although running in single-task is faster, it requires more memory
> > since the Oracle 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/
> > Now use expst and impst instead of imp or exp.

-- 
Madhavan Amruthur
DecisionPoint Applications

-- 
http://www.fastmail.fm - A no graphics, no pop-ups email service
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Madhavan Amruthur
  INET: mad5698_at_fastmail.fm

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: ListGuru_at_fatcity.com (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).