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.

References:

pga_aggregate_target
From: The Human Fly

Re: pga_aggregate_target
From: Sami Seerangan

Re: pga_aggregate_target
From: zhu chao

Other related posts:

Browse oracle-l