Re: Table Scans

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 Alexander.Feinstein_at_mitchell1.com 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: mgogala_at_adelphia.net

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