Re: High Memory Usage

From: Stalin <stalinsk_at_gmail.com>
Date: Fri, 26 Aug 2011 09:01:07 -0700
Message-ID: <CA+FfP7g7aWo+LvmirjASfpCJ7ex_RNgUEPTW3DmYs+qQcmjzrA_at_mail.gmail.com>

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_at_uptime.be>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_at_uptime.be
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
> ---
>

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

Received on Fri Aug 26 2011 - 11:01:07 CDT