Posts

Showing posts with the label SQL Lock Transaction Direct Insert

How to tell if "direct-load insert" was used with the APPEND hint

Both the serial and parallel version of:    INSERT /*+ APPEND */           INTO ...     SELECT ...         FROM ... uses the same quick interface as Direct Load under some conditions. Conditions are listed in Concepts Guide. How can one to tell if direct insert feature is used or not?