Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Slow Export
There are several exports in different databases, exporting various size objects. The thing is, this started about the middle of December.
Before that, everything was fine.
Ron
-----Original Message----- From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tanel Põder Sent: Tuesday, January 31, 2006 2:26 PM To: ORACLE-L 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? Tanel. ----- Original Message ----- From: Bobak, Mark <mailto:Mark.Bobak_at_il.proquest.com> 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-lReceived on Tue Jan 31 2006 - 14:36:13 CST
![]() |
![]() |