| seting *_area_size parameter [message #528786] |
Thu, 27 October 2011 02:37  |
deepa_balu
Messages: 74
Registered: March 2005
|
Member |
|
|
Hi,
I have set pga_aggregate_target parameter value and workarea_size_policy to Auto.
In this case setting sort_area_size and hash_area_size are considered obsolete right?
in My system
hash_area_size is set to 131072
Does this setting has no effect in automatic pga memory management?
|
|
|
|
| Re: seting *_area_size parameter [message #528787 is a reply to message #528786] |
Thu, 27 October 2011 02:40  |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:In this case setting sort_area_size and hash_area_size are considered obsolete right?
In most cases, yes but you can set it in session (with policy to manual) to overwrite the usage of automatic memory for a specific task that requires more memory than the common one.
Quote:Does this setting has no effect in automatic pga memory management?
Yes, unless you modify the policy at session level.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
