| SGA Parameters [message #159626] |
Mon, 20 February 2006 11:38  |
toshidas2000
Messages: 120
Registered: November 2005
|
Senior Member |
|
|
If I have to tune SGA Parameters, What are the parameters I need to look into it?? What are the recommended value??
Thanks
|
|
|
|
| Re: SGA Parameters [message #159643 is a reply to message #159626] |
Mon, 20 February 2006 14:23  |
mlin125
Messages: 1
Registered: February 2006
Location: Los Angeles
|
Junior Member |
|
|
I read Oracle 9i performance tunning book, it has 4 key parameters:
1. PGA_AGGREGATE_TARGET
2. SHARED_POOL_SIZE
3. DB_CACHE_SIZE
4. SGA_MAX_SIZE
You may want to refer to that book for the recommended values.
|
|
|
|
|
|
| Re: SGA Parameters [message #159680 is a reply to message #159643] |
Mon, 20 February 2006 22:44 |
milind_sri
Messages: 70
Registered: February 2005
Location: Pune
|
Member |
|
|
And also set WORK_AREA_SIZE_POLICY =auto
Regards
Milind.
EDIT: The correct parmater is WORKAREA_SIZE_POLICY and not WORK_AREA_SIZE_POLICY!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
