V$CACHE is an optional view (OPS/RAC) The view can be created (even in standard edition Oracle) by running the script $ORACLE_HOME/rdbms/admin/catparr.sql
Run this
under
the SYS account.
(In Oracle v9 this actually calls catclust.sql)
Columns ___________________________ FILE# BLOCK# STATUS XNC NAME KIND OWNER# LOCK_ELEMENT_ADDR LOCK_ELEMENT_NAME PARTITION_NAME
Related Views:
V$DB_OBJECT_CACHE V$LIBRARYCACHE V$ROWCACHE V$ROWCACHE_PARENT V$ROWCACHE_SUBORDINATE V$SUBCACHE