Re: High Memory Usage

hi

since its solaris you could try run prstat -a, this will show you the memory
consumed by each OS user

thanks


On Tue, Aug 30, 2011 at 9:40 PM, Stalin <stalinsk@xxxxxxxxx> wrote:

> 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@xxxxxxxxx> wrote:
>
>> what sort of filesystem are you using?
>>
>> thanks
>>
>> --
>> LSC
>>
>>
>> On Fri, Aug 26, 2011 at 10:02 AM, Stalin <stalinsk@xxxxxxxxx> 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
>

Other related posts: