Understood Ron. The point that Tanel and I are trying to make is, if the process is slow, there is a bottleneck somewhere. You can use Oracle features and O/S tools to determine where it is. Once you've done that, you're one step closer to solving the problem. Until you understand the behavior, you're nowhere. -- 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:36 PM To: tanel.poder.003@xxxxxxx; ORACLE-L Subject: 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxxxx> 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." 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