InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
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. 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. |
|