Aaaaaargh! Thanks! Flag 19 is "sequential only access" and bitand with 2**19 will get only the buffers belonging to objects accessed using full table scan. Thanks! On 2002.10.09 23:08 [EMAIL PROTECTED] wrote: > Mladen, > > Look up definition of x$bh.flag. > For example, http://www.jlcomp.demon.co.uk/buf_flag.html > > Correction to the query, join should be x.obj=o.data_object_id > And as a note, one needs to take care about clustered tables. > > Alex. > > > -----Original Message----- > Sent: Wednesday, October 09, 2002 1:19 PM > To: Multiple recipients of list ORACLE-L > > > That is correct, but I do think that everybody wants to know > how did you get that number (512k) and where can we find more info > about that. > > > set serverout on size 1000000 > > set verify off > > col object_name form a30 > > SELECT distinct(o.object_name),o.object_type,o.owner > > FROM dba_objects o,x$bh x > > WHERE x.obj=o.object_id > > AND o.object_type='TABLE' > > AND standard.bitand(x.flag,524288)>0 > > AND o.owner<>'SYS'; >
-- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).