This discussion is archived
2 Replies Latest reply: May 16, 2012 2:59 PM by jgarry RSS

Which objects are in buffer cache? How much space is each taking up?

rahulras Explorer
Currently Being Moderated
Hi All,

I am on Oracle v 11.2.0.2 (64 bit) RedHat.

I want to find out which objects have presence in buffer cache? and how much space each object is taking up in buffer cache?

I googled around and found few queries based on view x$bh. But when tried to run those on my database, I cannot find x$bh (the user has SELECT_CATALOG_ROLE privilege). Is there any other view holding same information as x$bh?

Thanks in advance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points