Re: High Memory Usage
- From: K R <kp0773@xxxxxxxxx>
- To: stalinsk@xxxxxxxxx
- Date: Mon, 29 Aug 2011 19:23:43 -0700
any chance filecache/pagecache taken by os
On Fri, Aug 26, 2011 at 9:01 AM, Stalin <stalinsk@xxxxxxxxx> 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@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:
