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: [EMAIL PROTECTED]
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
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: [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).
