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?