RE: Slow Export

  • From: "Smith, Ron" <rlsmith@xxxxxxx>
  • To: <tanel.poder.003@xxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 31 Jan 2006 14:36:13 -0600

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.

        -----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?

                ----- 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." 


Other related posts: