RE: Slow Export

You're right, Alex. I don't know what I was thinking....;-)

--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

"There are 10 types of people in the world:  Those who understand
binary, and those who don't."

-----Original Message-----
From: Alex Gorbachev [mailto:gorbyx_at_gmail.com] 
Sent: Tuesday, January 31, 2006 5:07 PM
To: Bobak, Mark
Cc: Smith, Ron; M Rafiq; tanel.poder.003_at_mail.ee; oracle-l_at_freelists.org
Subject: Re: Slow Export

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