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
Printable View
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, you dont have to worry about *_area_size parameters once you set workarea_size_policy = AUTO and and pga_aggregate_target = somevalue.
No, it not required. Oracle will automatically set it (to 64K).Quote:
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 its totally ignored if WORKAREA_SIZE_POLICY is auto.Quote:
Originally posted by julian
No, it not required. Oracle will automatically set it (to 64K).