Sort_Area_Size for OLTP

[hbks]

HI

Could anyone suggest how much sort area size I can maintain :-

1.Lot of Joins
2. 100 concurrent users
3. 60 G database

Pls advice me

 

[SantaMufasa]

hbks,

Here is what Oracle says about setting SORT_AREA_SIZE in their documentation:

Set the SORT_AREA_SIZE parameter with care. SORT_AREA_SIZE is the space used in Program Global Area (PGA) for each sort executed by each Oracle process. If the value is too high, the PGA will use excessive memory when sorting. The default value (512 K) is usually sufficient.

Let us know if their suggestions seem to work for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Dagon]

The manual also states:

Note:
Oracle does not recommend using the SORT_AREA_SIZE parameter unless the instance is configured with the shared server option. Oracle recommends that you enable automatic sizing of SQL working areas by setting PGA_AGGREGATE_TARGET instead. SORT_AREA_SIZE is retained for backward compatibility.

 

[hbks]

Thanks a lot for the Feedback