DBA_HIST_PGASTAT

DBA_HIST_PGASTAT displays historical PGA memory usage statistics as well as statistics about the automatic PGA memory manager when it is enabled. This view contains snapshots of V$PGASTAT.

Column Datatype NULL Description
SNAP_ID NUMBER NOT NULL Unique snapshot ID
DBID NUMBER NOT NULL Database ID for the snapshot
INSTANCE_NUMBER NUMBER NOT NULL Unique snapshot ID
NAME VARCHAR2(64) NOT NULL Name of the statistic:

  • aggregate PGA target parameter

  • aggregate PGA auto target

  • global memory bound

  • total PGA allocated

  • total PGA used

  • total PGA used for auto workareas

  • total PGA used for manual workareas

  • over allocation count

  • bytes processed

  • extra bytes read/written

  • cache hit percentage

See Also: V$PGASTAT for descriptions of the statistics
VALUE NUMBER   Statistic value