Database Administration (MOSC)

MOSC Banner

Should I use V$CACHE or V$BH to determine the contents of the buffer cache?

edited Mar 29, 2017 12:16PM in Database Administration (MOSC) 5 commentsAnswered

I've been searching trying to find a script that would tell me the tables and indexes in the default  buffer cache.  The main script I found uses the V$BH view.  However, when I use those scripts, I don't see any blocks from a particularly active table being queried.  If I use the V$CACHE view, I can see millions of blocks.  Upon doing some research, I found that the V$BH view shows "pings" to the buffer cache, not really the buffer cache contents.  It seems the V$CACHE view (shows SGA contents) would be the more accurate way to view the contents

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center