Re: High Memory Usage
- From: LS Cheng <exriscer@xxxxxxxxx>
- To: stalinsk@xxxxxxxxx
- Date: Tue, 30 Aug 2011 21:26:14 +0200
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
>
Other related posts:
