RE: Slow Export

Sorry, I see that.  I was responding to the comment that the problem didn't 
exist till mid-December.
 
Have you tried looking at V$SESSION_WAIT?  truss -c?
 
My point remains that you need to identify the bottleneck before you can solve 
the problem.
 
Hope that helps,
 
-Mark
 

-- 
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: Smith, Ron [mailto:rlsmith@xxxxxxx] 
Sent: Tuesday, January 31, 2006 3:44 PM
To: Bobak, Mark; tanel.poder.003@xxxxxxx; ORACLE-L
Subject: RE: Slow Export


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. 


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

Other related posts: