DBA_HIST_MEM_DYNAMIC_COMP

DBA_HIST_MEM_DYNAMIC_COMP displays historical memory component sizes. This view contains snapshots of V$MEMORY_DYNAMIC_COMPONENTS.

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
`COMPONENT`	`VARCHAR2(64)`	`NOT NULL`	Component name
`CURRENT_SIZE`	`NUMBER`		Current size of the component
`MIN_SIZE`	`NUMBER`		Minimum size of the component since instance startup
`MAX_SIZE`	`NUMBER`		Maximum size of the component since instance startup
`USER_SPECIFIED_SIZE`	`NUMBER`		Value of the user parameter for the component
`OPER_COUNT`	`NUMBER`		Number of operations since instance startup
`LAST_OPER_TYPE`	`VARCHAR2(13)`		Last completed operation for the component: `STATIC` `INITIALIZING` `DISABLED` `GROW` `SHRINK` `SHRINK_CANCEL`
`LAST_OPER_MODE`	`VARCHAR2(9)`		Mode of the last completed operation: `MANUAL` `DEFERRED` `IMMEDIATE`
`LAST_OPER_TIME`	`DATE`		Start time of the last completed operation
`GRANULE_SIZE`	`NUMBER`		Granularity of the `GROW` or `SHRINK` operation
`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