Re: High Memory Usage

From: LS Cheng <exriscer_at_gmail.com>
Date: Tue, 30 Aug 2011 21:26:14 +0200
Message-ID: <CAJ2-Qb-zOQYWxg4+su0n9j8xzGaXofFaT9506=btiuo+hbfgHg_at_mail.gmail.com>

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

>


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

Received on Tue Aug 30 2011 - 14:26:14 CDT