/* + SYS_DL_CURSOR */This hint
Run the/* + SYS_DL_CURSOR */hint.
Today in a db SQL statement, encountered this/* + SYS_DL_CURSOR */hint, after baidu, In the post of Huang Wei http://www.hellodba.com/reader.php? ID = 201
It is described as follows:
Syntax: SYS_DL_CURSOR
Description: This prompt is added to the related INSERT statement when running SQL * Loader to load data directly (Direct = TRUE. Direct Load cursor is used to insert data in batches.
Example (after running SQL * Loader to directly load data, you can see the following statement in the shared cache ):
HELLODBA. COM> select SQL _text, module from v $ SQL where SQL _text like 'insert/* + SYS_DL_CURSOR */% '; SQL _TEXT MODULE Certificate ------------------------------------------------------------------------------------------------------ INSERT/* +SYS_DL_CURSOR*/INTO "DEMO". "T_TABLES_LD" ("OWNER", "TABLE_NAME") VALUES (NULL, NULL)SQL Loader Direct Path Load |
Record it first. In 11g, there is a view that can query the hint: v $ SQL _hint.