Question on SORT% variables
From: NetComrade <netcomradeNOSPAM_at_earthlink.net>
Date: Tue, 22 Jun 1999 07:15:25 GMT
Message-ID: <376f3792.53568407_at_news.earthlink.net>
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
Date: Tue, 22 Jun 1999 07:15:25 GMT
Message-ID: <376f3792.53568407_at_news.earthlink.net>
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 - 09:15:25 CEST