V$CACHE

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


© Copyright SS64.com 1999-2013
Some rights reserved