DBA_HIST_RESOURCE_LIMIT

DBA_HIST_RESOURCE_LIMIT displays historical information about global resource use for some of the system resource. This view contains snapshots of V$RESOURCE_LIMIT.

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
`RESOURCE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the resource
`CURRENT_UTILIZATION`	`NUMBER`		Number of (resources, locks, or processes) currently being used
`MAX_UTILIZATION`	`NUMBER`		Maximum consumption of the resource since the last instance start up
`INITIAL_ALLOCATION`	`VARCHAR2(10)`		Initial allocation. This will be equal to the value specified for the resource in the initialization parameter file (`UNLIMITED` for infinite allocation).
`LIMIT_VALUE`	`VARCHAR2(10)`		Unlimited for resources and locks. This can be greater than the initial allocation value (`UNLIMITED` for infinite limit).