Oracle 9i (pga_aggregate_target) paremeter

[skdas]

If we set

workarea_size_policy = AUTO
and pga_aggregate_target = 500M

Is it required to set sort_area_size..?

or sort_are_size should be 0

[agasimani]

No, you dont have to worry about *_area_size parameters once you set workarea_size_policy = AUTO and and pga_aggregate_target = somevalue.

[julian]

Originally posted by skdas
If we set

workarea_size_policy = AUTO
and pga_aggregate_target = 500M

Is it required to set sort_area_size..?

or sort_are_size should be 0

No, it not required. Oracle will automatically set it (to 64K).

[adewri]

Originally posted by julian
No, it not required. Oracle will automatically set it (to 64K).

No its totally ignored if WORKAREA_SIZE_POLICY is auto.