RE: Slow Export
- From: "Smith, Ron" <rlsmith@xxxxxxx>
- To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>, <tanel.poder.003@xxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 31 Jan 2006 14:43:31 -0600
His question was "Are you exporting lots of small objects or few large
objects?". I was answering the question.
-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxxxxx]
Sent: Tuesday, January 31, 2006 2:39 PM
To: Smith, Ron; tanel.poder.003@xxxxxxx; ORACLE-L
Subject: RE: Slow Export
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.
Other related posts:
