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