Home » RDBMS Server » Server Administration » seting *_area_size parameter (oracle 10.2.0.3)
seting *_area_size parameter [message #528786] Thu, 27 October 2011 02:37 Go to next message
deepa_balu
Messages: 73
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 Go to previous message
Michel Cadot
Messages: 60058
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: rowid type and varchar2 type issue
Next Topic: patch versioning documentation
Goto Forum:
  


Current Time: Thu Dec 25 18:14:29 CST 2014

Total time taken to generate the page: 0.10582 seconds