RE: Slow Export
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <rlsmith@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, <oracle-rdbms@xxxxxxxxxxxxxxx>
- Date: Tue, 31 Jan 2006 15:07:50 -0500
What does V$SESSION_WAIT tell you about the session executing the
export?
--
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."
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Smith, Ron
Sent: Tuesday, January 31, 2006 3:02 PM
To: oracle-l@xxxxxxxxxxxxx; oracle-db-l@xxxxxxxxxxxxxxxxxxxx;
oracle-rdbms@xxxxxxxxxxxxxxx
Subject: Slow Export
We are having trouble with slow exports on Oracle 8.1.7 running on a Sun
server.
Exports that used to take 30 minutes are now running 9 hours.
If I do a file system copy, it runs very fast. So I don't think it is
the file system.
Even an export direct=y to a /dev/null file runs forever.
We have looked at everything.
Any ideas?
Thanks!
Ron
Important Notice!
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received
this message by mistake,
then delete the e-mail message.
Thank you.
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
Other related posts:
