FTS from x$bh

Libal/List,

you can also BITAND the flag in x$bh with 524288 to know if the block was read in FTS

-----cut----------cut---------cut--------------
SELECT o.object_name,o.object_type,o.owner FROM dba_objects o,x$bh x
WHERE x.obj=o.data_object_id
AND o.object_type='TABLE'
AND standard.bitand(x.flag,524288)>0
AND o.owner<>'SYS';
-----cut----------cut---------cut--------------

HTH Received on Thu Aug 03 2000 - 00:17:19 CDT