Re: Diff between recycle pool and nocache keywords

On Sat, 10 May 2003 08:13:59 +1000, Howard J. Rogers wrote:

> If you want a view to check things with, then v$bh will allow you to see
> what is in the buffer cache. In 9i, you can run /rdbms/admin/catclust.sql to
> create a v$cache which does the same sort of job, but better. (It's a RAC
> view, really, but works in a single instance).

What makes you think that v$cache is so much better then v$bh? BTW, v$bh is also a RAC (actually, OPS) view which used to be a part of $ORACLE_HOME/rdbms/admin/catparr.sql (father of the catclust.sql). The only information which v$bh doesn't readily provide is type of the segment to which the cached block belongs, but, on the other hand, v$cache doesn't provide OBJECT_ID, which I think is an extremely important column. I must confess that I prefer v$bh and I don't see why would v$cache be better.

-- 
Mladen Gogala
Software is like sex, it is better when it is free.
Linus Torvalds