Name
SORT_DIRECT_WRITES
Synopsis
Value: AUTO | TRUE | FALSE
Default: AUTO
Dynamic: ALTER SYSTEM, ALTER SESSION
Controls whether sort data will bypass the buffer cache to write intermediate sort results to disk. If AUTO, and the value of the sort area size is greater than 10 times the block size, memory is allocated from the sort area to do this. If TRUE, additional buffers are allocated from memory during each sort, and additional temporary segment space can be required. If FALSE, the sorts that write to disk write through the buffer cache. 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.