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