Should I use V$CACHE or V$BH to determine the contents of the buffer cache?
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