/* + SYS_DL_CURSOR */This hint, sys_dl_cursorhint

/* + SYS_DL_CURSOR */This hint, sys_dl_cursorhint

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.