DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: sort_area_retained_size and pga_aggregate_target

  1. #1
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257

    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

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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
  •  


Click Here to Expand Forum to Full Width