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-----
From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Table Scans
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';
