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. 

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: