CURSOR_SPACE_FOR_TIME

CURSOR_SPACE_FOR_TIME lets you use more space for cursors to save time.

Property	Description
Parameter type	Boolean
Default value	false
Modifiable	No
Modifiable in a PDB	No
Range of values	true | false
Basic	No

Note: The CURSOR_SPACE_FOR_TIME parameter is deprecated. It is retained for backward compatibility only.

This parameter affects both the shared SQL area and the client’s private SQL area.

Most users will not need to set this parameter because of the significantly enhanced concurrency modifications introduced in Oracle Database 10g Release 2 ( 10.2.0.2) and later.

Values

• true

  Shared SQL areas are kept pinned in the shared pool. As a result, shared SQL areas are not aged out of the pool as long as an open cursor references them. Because each active cursor’s SQL area is present in memory, execution is faster. However, the shared SQL areas never leave memory while they are in use. Therefore, you should set this parameter to true only when the shared pool is large enough to hold all open cursors simultaneously.

  In addition, a setting of true retains the private SQL area allocated for each cursor between executions instead of discarding it after cursor execution, saving cursor allocation and initialization time.

• false

  Shared SQL areas can be deallocated from the library cache to make room for new SQL statements.

Note: If this parameter is set to true, then the SERIAL_REUSE parameter is disabled.

See Also: “SERIAL_REUSE”