Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Direct Path Export vs. Conventional Path Export

Direct Path Export vs. Conventional Path Export

From: Burton Peltier <burttemp1REMOVE_THIS_at_bellsouth.net>
Date: Mon, 1 Sep 2003 23:50:53 -0500
Message-ID: <8jV4b.4779$UF.3526@bignews2.bellsouth.net>


I recently switched our export backups to direct path and was impressed at the performance boost.

I did not set the recordlength (or buffer before with conventional path) and still am seeing a significant boost in performance. The docs mention these settings to boost performance.

In every case, the direct path is at least twice as fast and sometimes 3 times faster than the conventional path.

I assume I am missing something here because this seems too good to be true, so I looked up this in the docs.

I don't see any disadvantage other than you must use the same character set for the client exp session as the database character set, which I always do anyway.

Anyone have experience with this and can comment good or bad on direct path?

-- 
Received on Mon Sep 01 2003 - 23:50:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US