Hello Arvind,
This is sort of an open ended question. In general this parameter
controls how much memory is allocated on a per session basis for in
memory sorts. Sorts that require more memory than this will sort on the
disk with a performance penalty. If you have the memory you should stay
well north of 90% of your sorts in memory by bumping this parameter
appropriately. The hitch comes when you consider the fact that an
increase in this parameter uses the incremental amount that you
increased sort area size and mulitplies it by the number of connected
sessions. You can allocate enough memory this way to force your box to
page if you are close to the line anyway. So you have a trade off.
More memory to sort area size can reduce disk sorts and so speed up your
process. UNIX will be happy right up to the point where you have to
page or swap things to disk and at that point your system will crawl.
Allan
-----Original Message-----
Sent: Monday, March 31, 2003 4:04 AM
To: Multiple recipients of list ORACLE-L
hello all,
how does increasing the value of SORT_AREA_SIZE affect the unix
system perfomance.
Thanks
Arvind
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arvind Kumar
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from). You may also send the HELP
command for other information (like subscribing).
______________________________________________________________________________
This email is intended solely for the person or entity to which it is addressed and
may contain confidential and/or privileged information. Copying, forwarding or
distributing this message by persons or entities other than the addressee is
prohibited. If you have received this email in error, please contact the sender
immediately and delete the material from any computer. This email may have been
monitored for policy compliance. [021216]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nelson, Allan
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
