-
sort_area_retained_size and pga_aggregate_target
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
-
In this scenario, the sort_area_retained_size still effects the performance?
NO.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|