Direct Path and Conventional Path

What is the difference between direct path and conventional path?

Questions by ramojiapps

Showing Answers 1 - 3 of 3 Answers

arifmahmud

  • Apr 20th, 2009
 

When you use SQL loader by default it use conventional path to load data. This method competes equally with all other oracle processes for buffer resources. This can slow the load.



A direct path load eliminates much of the Oracle database overhead by formatting Oracle data blocks and writing the data blocks directly to the database files. If load speed is most important to you, you should use direct path load because it is faster

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions