2 Replies Latest reply on May 16, 2012 9:59 PM by jgarry

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

      Hi All,

      I am on Oracle v (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.