Re: Strange Memory Information on AWR
From: Yong Huang <yong321_at_yahoo.com>
Date: Wed, 23 Oct 2013 07:25:29 -0700 (PDT)
Message-ID: <1382538329.3818.YahooMailNeo_at_web184801.mail.gq1.yahoo.com>
Andrew,
You can also check DBA_HIST_PGASTAT for snapshots of v$pgastat for that time period. But that's still system wide information. I always like session specific info. So check pga_allocated in v$active_session_history for the period if the records are still in there (and if you have the license, and are on 11gR2 or up). For session PGA, there's no dba_hist_* view that I know of. I collect my own Oracle session and OS process specific info, keeping their correlation in mind (see http://yong321.freeshell.org/computer/Perfmon.html).
Date: Wed, 23 Oct 2013 07:25:29 -0700 (PDT)
Message-ID: <1382538329.3818.YahooMailNeo_at_web184801.mail.gq1.yahoo.com>
Andrew,
You can also check DBA_HIST_PGASTAT for snapshots of v$pgastat for that time period. But that's still system wide information. I always like session specific info. So check pga_allocated in v$active_session_history for the period if the records are still in there (and if you have the license, and are on 11gR2 or up). For session PGA, there's no dba_hist_* view that I know of. I collect my own Oracle session and OS process specific info, keeping their correlation in mind (see http://yong321.freeshell.org/computer/Perfmon.html).
Yong Huang
> Looking at the AWR report, I see PGA memory usage that makes no
> sense to me. PGA_AGGREGATE_TARGET is set to 6g, but the Memory Statistics
> show a PGA usage of 19G at end, but there is no pga overallocation indicated.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 23 2013 - 16:25:29 CEST