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