| sizing sort area [message #169369] |
Wed, 26 April 2006 08:33  |
balavignesh
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  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
