Why is SQL*Loader direct path so fast?

Submitted by: Administrator
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.
Submitted by: Administrator

Read Online Oracle DBA Job Interview Questions And Answers