| harsh area size and sort area size [message #521401] |
Mon, 29 August 2011 10:54  |
matthew00
Messages: 7
Registered: October 2005
|
Junior Member |
|
|
after running ADDM, I found out the application had a lot of queries having multiple join and sort in its query.
The current harsh area is 131072 and sort area size is 65536. I am thinking to increase sort area to 102400000 and harsh area to 204800000.
any negative impact for increasing this value? The purpose of increasing the RAM so it can allocate RAM for harsh join in memory rather than disk....
is it the right argument?
|
|
|
|
|
|
|
|
| Re: harsh area size and sort area size [message #521408 is a reply to message #521401] |
Mon, 29 August 2011 11:38  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
If you have access to ADDM, you must be using release 10.1 or higher, in which case setting these parameters is usually wrong and/or irrelevant. You need to post exactly what release you are using, and your reasoning behand wanting to change them.
John.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
