The PL/SQL data loading procedures use the following HINTS for performance. They are
/*+ APPEND NOLOGGING PARALLEL */
Append: - When “Append” hint is used in a PL/SQL INSERT statement, Oracle will perform a DIRECT Load of data and hence will be fast. It's known as direct path insert
NoLogging : - When "NoLogging" hint is provided, Oracle will not perform any logging operations for this statement
Parallel: - Oracle will make use of Parallel Loading when “Parallel” hint is used in SQL Statement.