2 Replies Latest reply: May 16, 2012 4:59 PM by jgarry RSS

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

    rahulras
      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.