Name
TEMPORARY_TABLE_LOCKS
Synopsis
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.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.