Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Slow Export

Re: Slow Export

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Tue, 31 Jan 2006 23:06:44 +0100
Message-ID: <c2213f680601311406o71f75cbbn@mail.gmail.com>


Mark, I think if he runs export remotely from another client node - it might not have those settings in sqlnet.ora and that's why it runs fast.
Traces cannot be generated on a node different from one where dump file is produced as both dump file and sql net trace file are written on the client. Right?

Alex

2006/1/31, Bobak, Mark <Mark.Bobak_at_il.proquest.com>:
> It's possible that the combination of the SQL*Net trace writes and the exp writes are killing your I/O. When the export runs remotely, the SQL*Net trace writes still happen, but the export writes are on another host.....

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 31 2006 - 16:06:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US