DBAs,
We have a database dedicated to our DW project. It is 9.2.0.7
We set the workarea policy is auto and the pga_aggregate_target 3g.
I have a question:
In this scenario, the sort_area_retained_size still effects the performance?
Currently we set it to zero.
Thanks,
Lily