Re: pga_aggregate_target
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: zhu chao <zhuchao@xxxxxxxxx>
- Date: Sat, 17 Dec 2005 10:38:15 -0500
Zhu,
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:
