V$BH

Blocks in the database buffer cache.

Columns
   ___________________________
 
   FILE#
   BLOCK#
   CLASS#
   STATUS
   XNC
   FORCED_READS
   FORCED_WRITES
   LOCK_ELEMENT_ADDR
   LOCK_ELEMENT_NAME
   LOCK_ELEMENT_CLASS
   DIRTY
   TEMP
   PING
   STALE
   DIRECT
   NEW
   OBJD
   TS#

Status column values:

free This block is not in use
xcur Block held exclusively by this instance
scur Block held in cache, shared with other instance
cr  Block for consistent read
read Block being read from disk
mrec Block in media recovery mode
irec Block in instance (crash) recovery mode

Related:

V$ACTIVE_INSTANCES 
V$BGPROCESS 
V$COMPATIBILITY 
V$COMPATSEG 
V$COPY_CORRUPTION 
V$DATABASE 
V$DATAFILE 
V$DATAFILE_COPY 
V$DATAFILE_HEADER 
V$DBFILE 
V$DBLINK 
V$DB_PIPES 
V$INSTANCE 
V$LICENSE 
V$OFFLINE_RANGE 
V$OPTION 
V$SGA 
V$SGASTAT 
V$TABLESPACE 
V$VERSION


© Copyright SS64.com 1999-2014
Some rights reserved