SYS.V$CACHE_GROUP_LOAD

SYS.V$CACHE_GROUP_LOAD_STATUS

This view is specific to log-based read-only cache groups. It provides the System Change Number (SCN) on Oracle at which the cache group was last loaded. There is one row per log-based cache group as defined by the CACHE_GROUP_OWNER, CACHE_GROUP_NAME pair in the database.

Columns

Column name	Type	Description
`CACHE_GROUP_OWNER`	`VARCHAR2 (30)INLINE`	Cache group owner.
`CACHE_GROUP_NAME`	`VARCHAR2(30) INLINE`	Name of the cache group.
`MINIMUMLOADSCN`	`VARCHAR2(20) INLINE NOT NULL`	SCN on Oracle at which the cache group was last loaded.