Re: High Memory Usage
- From: Stalin <stalinsk@xxxxxxxxx>
- To: "D'Hooge Freek" <Freek.DHooge@xxxxxxxxx>
- Date: Fri, 26 Aug 2011 09:01:07 -0700
Thanks. Checking v$pgastat, maximum pga allocated has been around 3.5G,
still that doesn't add up to 29G.
Any other ideas?
On Fri, Aug 26, 2011 at 1:14 AM, D'Hooge Freek <Freek.DHooge@xxxxxxxxx>wrote:
> Hi,
>
> Yes, pga_aggregate_target is kind of a soft limit.
> For certain memory requests it will have no other option to give memory to
> the process requesting it.
>
> You can see the current allocation and how many times oracle had to exceed
> the pga_aggregate_target limit in v$pgastat.
>
>
> Regards,
>
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> email: freek.dhooge@xxxxxxxxx
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
> ---
>
Other related posts:
