December 2002
Intermediate to advanced
928 pages
85h 29m
English
CURSOR_SPACE_FOR_TIME
Value: TRUE | FALSE
Default: FALSE
Controls the use of memory used to store cursors. If this parameter is set to TRUE, the database uses more space for cursors to save time. Because the shared SQL areas never leave memory while they are in use, however, this parameter should be set to TRUE only when the shared pool is large enough to hold all open cursors simultaneously. Setting this parameter to TRUE also retains the private SQL area allocated for each cursor between executes instead of discarding it after cursor execution, which saves cursor allocation and initialization time.