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.

Other related posts: