Re: pga_aggregate_target

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.

--
http://www.freelists.org/webpage/oracle-l