Re: High Memory Usage

From: Stalin <stalinsk_at_gmail.com>
Date: Tue, 30 Aug 2011 12:40:37 -0700
Message-ID: <CA+FfP7iEfvf-nn=_WitS5QA92qUKfZrwGpWaH3--NA2RsgJ60g_at_mail.gmail.com>

We are using UFS, however the FS where the datafiles are housed, are mounted with forcedirectIO and in DB we have filesystemio_options set to setall.

On Tue, Aug 30, 2011 at 12:26 PM, LS Cheng <exriscer_at_gmail.com> wrote:

> what sort of filesystem are you using?
>
> thanks
>
> --
> LSC
>
>
> On Fri, Aug 26, 2011 at 10:02 AM, Stalin <stalinsk_at_gmail.com> wrote:
>
>> All,
>>
>> I'm trying to figure out high memory usage on one of the DB servers we
>> have and wondering if pga_aggregate_target could ever exceed from what's
>> allocated.
>>
>> We have sga_target set to 16G and pga_a_t set to 2G, however from
>> statspack, i see pga usage to be close to 3G. Is that normal. I have posted
>> relevant sections from statspack for reference. Though i see only 59% of
>> total memory being used, vmstat reports 29G being used. Any idea what could
>> be causing it. This node is a dedicated DB server and only one DB runs on
>> it.
>>
>> Memory Statistics Begin End
>> ~~~~~~~~~~~~~~~~~ ------------ ------------
>> Host Mem (MB): 32,640.0 32,640.0
>> SGA use (MB): 16,315.7 16,315.7
>> PGA use (MB): 2,854.4 2,981.5
>> % Host Mem used for SGA+PGA: 58.7 59.1
>> -------------------------------------------------------------
>> Instance Activity Stats
>> workarea memory allocated 0 6,043
>>
>> Statistic Total per Second per
>> Trans
>> --------------------------------- ------------------ --------------
>> ------------
>> workarea executions - onepass 0 0.0
>> 0.0
>> workarea executions - optimal 7,635 2.1
>> 0.0
>>
>> --
>> Thanks,
>>
>> Stalin
>>
>> 11gR2, Solaris 10
>>
>
>

-- 
Thanks,

Stalin

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

Received on Tue Aug 30 2011 - 14:40:37 CDT