Re: Slow Export

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@xxxxxxx ; oracle-l@xxxxxxxxxxxxx ; 
oracle-db-l@xxxxxxxxxxxxxxxxxxxx ; oracle-rdbms@xxxxxxxxxxxxxxx 
  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."

Other related posts: