I am just throwing these quickly ... how large are your rollback segments? Consistent=y means Oracle has to remember every data block that existed at the time your export began.
I haven't seen recordlength= before, is this the equivalent of the older "buffer=" parameter? Here I often set buffer= to 1000000, we have enough memory on our server to handle it and I don't have to worry too much about record lengths. This is probably silly too --> your server is not paging, I hope. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -----Original Message----- Sent: Tuesday, April 09, 2002 11:28 AM To: Multiple recipients of list ORACLE-L Subject: Export taking to long 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: Boivin, Patrice J 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).