DBA_HIST_PROCESS_MEM_SUMMARY

DBA_HIST_PROCESS_MEM_SUMMARY displays historical information about dynamic PGA memory usage by named component categories for each process.

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`	Instance number for the snapshot
`CATEGORY`	`VARCHAR2(15)`	`NOT NULL`	Category name. Categories include "SQL", "PL/SQL", "OLAP" and "JAVA". Special categories are "Freeable" and "Other". Freeable memory has been allocated to the process by the operating system, but has not been allocated to a category. "Other" memory has been allocated to a category, but not to one of the named categories
`NUM_PROCESSES`	`NUMBER`		Number of processes
`NON_ZERO_ALLOCS`	`NUMBER`		Number of processes with nonzero allocations
`USED_TOTAL`	`NUMBER`		Bytes of PGA memory used by the process for the category
`ALLOCATED_TOTAL`	`NUMBER`		Total number of bytes of PGA memory allocated by the process for the category.
`ALLOCATED_AVG`	`NUMBER`		Average number of bytes of PGA memory allocated by the process for the category
`ALLOCATED_STDDEV`	`NUMBER`		Standard deviation of the number of bytes of PGA memory allocated by the process for the category
`ALLOCATED_MAX`	`NUMBER`		Maximum bytes of PGA memory ever allocated by the process for the category
`MAX_ALLOCATED_MAX`	`NUMBER`		Maximum bytes of PGA memory that can be allocated by the process for the category
`CON_DBID`	`NUMBER`		The database ID of the PDB for the sampled session
`CON_ID`	`NUMBER`		The ID of the container that `CON_DBID` identifies. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data