December 2002
Intermediate to advanced
928 pages
85h 29m
English
TEMPORARY_TABLE_LOCKS
Value: 0-operating system dependent
Default: SESSIONS
Specifies the number of temporary tables that can be created in the temporary segment space. A temporary table lock is needed any time a sort occurs that is too large to hold in memory. This may occur as the result of a SELECT on a large table with ORDER BY or as the result of sorting a large index. Obsolete with Oracle8i.