Before that, everything was fine.
From: oracle-l-bounce_at_freelists.org On Behalf Of Tanel Põder
Sent: Tuesday, January 31, 2006 2:26 PM
Subject: Re: Slow Export
And 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?
----- 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."