SERIAL _REUSE

SERIAL_REUSE specifies which types of cursors make use of the serial-reusable memory feature. This feature allocates private cursor memory in the SGA so that it can be reused (serially, not concurrently) by sessions executing the same cursor.

Values:

• DISABLE

  Disables the option for all SQL statement types. This value overrides any other values included in the list.

• SELECT

  Enables the option for SELECT statements.

• DML

  Enables the option for DML statements.

• PLSQL

  Currently has no effect (although PLSQL packages do support the serial-reuse memory option using PLSQL pragmas).

• ALL

  Enables the option for both DML and SELECT statements. Equivalent to setting SELECT, DML, and PLSQL.

  
  

  Note: If CURSOR_SPACE_FOR_TIME is set to TRUE, then the value of SERIAL_REUSE is ignored and treated as if it were set to DISABLE.

  
  
  
  

  See Also: "CURSOR_SPACE_FOR_TIME"