Re: Slow Export

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Tue, 31 Jan 2006 14:26:07 -0600
Message-ID: <099d01c626a4$937ccec0$c6bc21c8@porgand>

MessageAnd when you should see from v$session_event and v$session_wait that database itself is not the bottleneck, you could run truss -c on the exp process for a while and see the breakdown whether any system calls (like write()) take lots of time.

Are you exporting lots of small objects or few large objects?

Tanel.

Original Message ----- From: Bobak, Mark To: rlsmith_at_kmg.com ; oracle-l_at_freelists.org ; oracle-db-l_at_Groups.ITtoolbox.com ; oracle-rdbms_at_yahoogroups.com Sent: Tuesday, January 31, 2006 2:07 PM Subject: RE: Slow Export

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."

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 31 2006 - 14:26:07 CST