Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Question on SORT% variables
From Burletson's Book:
· The SORT_WRITE_BUFFER_SIZE parameter defines the size of the
in-memory sort area, and the SORT_WRITE_BUFFERS defines the number of
buffer blocks. You must also set the parameter SORT_DIRECT_WRITES=TRUE
to use the disk sort area feature. Setting this parameter will allow
disk sorts in the temporary tablespace to use a direct write buffer
area. Writing sorts to this buffer bypasses the need for the sort to
contend for free blocks in the buffer cache, thereby improving sorting
performace by up to 50 percent. This is done at the expense of
additional memory with the SGA. This movement towards segmenting the
buffer into individual components can dramatically improve response
times in Oracle. The size of SORT_WRITE_BUFFERS X
SORT_WRITE_BUFFER_SIZE should not be more than 1/10th the size
allocated in SORT_AREA_SIZE
Is this for the whole instance, or for each user connected (he mentions SGA, but then I was thinking of SORT_AREA_SIZE, which is acquired from memory per/user) Received on Tue Jun 22 1999 - 02:15:25 CDT