Oracle DBA Question:

Download Job Interview Questions and Answers PDF

Why is SQL*Loader direct path so fast?

Oracle DBA Interview Question
Oracle DBA Interview Question

Answer:

SQL*Loader with direct path option can load data ABOVE the high water mark of a table, and DIRECTLY into the datafiles, without going through the SQL engine at all. This avoids all the locking, latching, and so on, and doesn't impact the db (except possibly the I/O subsystem) at all.

Download Oracle DBA Interview Questions And Answers PDF

Previous QuestionNext Question
In PL/SQL, what is bulk binding, and when/how would it help performance?What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?