Re: datapump export incredibly slow
From: rjamya <rjamya_at_gmail.com>
Date: Sun, 16 Feb 2014 20:35:49 -0500
Message-ID: <CAGurbTMvLe6rGVktv4dKh7R2DReGWhGXdM7UdgcRQ2G50_7_+Q_at_mail.gmail.com>
And remember, if you are exporting CLOBs, then you are out of luck :) Sometimes you will get better performance with ACCESS_METHOD=external_table but that you have to try out. Also if flashback_time is not critical for you, I'd take it out.
Date: Sun, 16 Feb 2014 20:35:49 -0500
Message-ID: <CAGurbTMvLe6rGVktv4dKh7R2DReGWhGXdM7UdgcRQ2G50_7_+Q_at_mail.gmail.com>
And remember, if you are exporting CLOBs, then you are out of luck :) Sometimes you will get better performance with ACCESS_METHOD=external_table but that you have to try out. Also if flashback_time is not critical for you, I'd take it out.
Raj
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 17 2014 - 02:35:49 CET