RE: Which tables are in buffer cache.?

Bunyamin,  

You can check how many blocks are in the buffer cache for segments through the x$bh and v$bh views.  

Try this query,  

select "count",b.object_name from
(select count(*) "count",objd from v$bh

group by objd) a, user_objects b
where a.objd=b.data_object_id
/  

Regards
Suhen        

 Hi all gurus,     

    I want to learn the way to ook at

Which tables are in buffer cache./Analyzed?

Is there a system view showing these tables??  

Thanks to All.  

Bunyamin K.Karadeniz

    Database Group / Information Systems Department     HAVELSAN Ankara /TURKEY
    Tel : +903122873565 / 1681
    Mobile Tel : +90 535 3357729    

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suhen Pather
  INET: Suhen.Pather_at_strandbags.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).