Re: High Memory Usage

From: K R <kp0773_at_gmail.com>
Date: Mon, 29 Aug 2011 19:23:43 -0700
Message-ID: <CABPz0xg2LNEy-kWUZM1gWyhwH59qCMaCoFhrCWWX4GHuPTQrOA_at_mail.gmail.com>

any chance filecache/pagecache taken by os

On Fri, Aug 26, 2011 at 9:01 AM, Stalin <stalinsk_at_gmail.com> wrote:

> 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 Mon Aug 29 2011 - 21:23:43 CDT