Direct Load Insert

Direct Load Insert is a faster way of running an INSERT statement. It is particularly useful for inserting large numbers of rows. Direct Load Insert differs from Conventional Insert in that it bypasses the buffer cache. Of course there are side-effects; keep in mind the following:

To use Direct Load Insert, add the APPEND hint to your INSERT statement.

To make sure your SQL is using Direct Load Insert, run it through Explain Plan. You should see a line reading LOAD AS SELECT.