Re: Strange Memory Information on AWR

From: Yong Huang <>
Date: Wed, 23 Oct 2013 07:25:29 -0700 (PDT)
Message-ID: <>

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

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.

Received on Wed Oct 23 2013 - 16:25:29 CEST

Original text of this message