Home » RDBMS Server » Performance Tuning » sizing sort area
sizing sort area [message #169369] Wed, 26 April 2006 08:33 Go to next message
Messages: 180
Registered: March 2005
Senior Member
Hi experts,

We have a 9i database under Linux.

we need to size sort area.

How to size the sort area..?
is there any hard and fast rule for sizing the same..?
How to find the user session's sort requirments..?

from where the memory is allocated to PGA and how much is allocated in both dedicated and shared server..?

whether PGA is having impact on sort area..?

Plz clear..!!
Re: sizing sort area [message #169437 is a reply to message #169369] Wed, 26 April 2006 17:08 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member

If you are on oracle 9i then why you want to configure sort_Area_size. I will go for workarea_size_policy, set this parameter to auto and allocate a sufficient amount of memory according to your infrastructure to pga_aggregate_target and let oracle handle all this hassle for you. In short set the following init parameters and relax:

pga_aggregate_target = 500m (change it according to your env)
workarea_size_policy = auto

After setting these parameters you dont need to set ant sort_* and work_* parameters.

Best of Luck
Daljit Singh

Previous Topic: dbms_job package
Next Topic: SQL Tuning
Goto Forum:

Current Time: Wed May 29 20:16:41 CDT 2024