Re: tables in buffer cache

I don't know if this is the same info that you seek, This is as close as I come to know "What's in the Buffer Cache right now" research, it is from ORACLE SERVER 7.3: Performance Tuning volume 1 Student Guide

Sometimes you may find it useful to know which blocks are currently being cached.
You can use the script "catparr.sql" to generate the V$CACHE view, which gives you this information.

• Is really intended for use with Oracle Parallel Server (OPS).
• Creates a number of other views which are only useful for OPS.
• Maps extents in the database files to database objects
• Needs to be re-run after new objects have been created.

The V$CACHE View

Column        		Description
FILE#			Datafile number
BLOCK#			Block number
STATUS			FREE	Not currently in use
STATUS			XCUR	Exclusive Current
STATUS			SCUR	Shared current (OPS only)
STATUS			CR	Consistent read
STATUS			READ	Being read from disk
STATUS			MREC	In media recovery mode
STATUS			IREC	In instance recovery mode
XNC			For OPS only
NAME			Object name
KIND			Type of Object
OWNER#			Owner number
LOCK_ELEMENT_ADDRESS	For OPS only

Pavel wrote:
>
> Is there any view allowing to see what is being loaded into buffer
> cache?
> Thanks,
>
> Paul
  Received on Tue Aug 26 1997 - 00:00:00 CDT