Re: pga_aggregate_target


I don't think so. We don't set  any session level work-area-polilcy(manual)
and ours is not a shared server configuration. However our pga is bigger
than pga_aggregate_target.

>two situations that can lead to bigger pga than that limit:
>1. someuser did alter session manually and that can work-area-polilcy
manual and set some >big/huge sort/hash size.
>2. shared server configurations.

Other related posts: