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).