RE: Table Scans

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';

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Alexander.Feinstein_at_mitchell1.com

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: 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).