RE: Export taking to long

Ron,
Consistent=y will make it run slow. Is 'consistent=y' a requirement? If your version of the database allows multiple dump files, you may want to consider that option (if disk space is available). Compressing dump file on the fly will add to the slowness.

• Kirti

-----Original Message-----
Sent: Tuesday, April 09, 2002 9:28 AM
To: Multiple recipients of list ORACLE-L

I have an export of a 16G database that is consistently taking 6 hours to export.
It doesn't matter what time of the day or night the script is executed. There is
very little activity on the server. Any ideas?

#!/bin/ksh

export ORACLE_SID=adprod
export ORACLE_HOME=`grep $ORACLE_SID /etc/oratab | cut -d : -f2` PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:. export USERPASS=system/sysada2
#
# Create a new pipe each time
#

if [ -p exp_pipe_$ORACLE_SID ]

        then rm exp_pipe_$ORACLE_SID
fi
mknod exp_pipe_$ORACLE_SID p

OUTFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.dmp.Z" LOGFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.log"
#
# Begin compress job and export to pipe with userid and password hidden
#

compress < /oracle_dba/expimp/adprod/exp_pipe_adprod > $OUTFILE & exp $USERPASS full=y compress=n consistent=y recordlength=65535 direct=y file=/oracle_dba/expimp/adprod/exp_pipe_adprod log= $LOGFILE Ron Smith
DBA
Kerr-McGee Corp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  INET: rlsmith_at_kmg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).