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@xxxxxxxxx] Sent: Tuesday, January 31, 2006 5:07 PM To: Bobak, Mark Cc: Smith, Ron; M Rafiq; tanel.poder.003@xxxxxxx; oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxxxx>: > 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.....
BEGIN:VCARD VERSION:2.1 N:Bobak;Mark FN:Bobak, Mark ORG:ProQuest Information and Learning;Database Group TITLE:Software Architect, Sr-TPD TEL;WORK;VOICE:734.975.6086 ADR;WORK:;ECC4-N01E04;1400 Eisenhower Parkway LABEL;WORK;ENCODING=QUOTED-PRINTABLE:ECC4-N01E04=0D=0A1400 Eisenhower Parkway EMAIL;PREF;INTERNET:Mark.Bobak@xxxxxxxxxxxxxxx REV:20051213T223654Z END:VCARD