Oracle DBA Question:

Why is SQL*Loader direct path so fast?

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 PDF Read All 50 Oracle DBA Questions

Previous Question	Next 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?