Re: pga_aggregate_target

  • From: Sami Seerangan <dba.orcl@xxxxxxxxx>
  • To: zhu chao <zhuchao@xxxxxxxxx>
  • Date: Sat, 17 Dec 2005 10:38:15 -0500


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: