Source of expensive SQL

Hello  

Solaris 8

Oracle 9.2.0.4  

The following piece of SQL is popping up in STATSPACK reports as expensive. It runs about once an hour. I can see that it is executed as the SYS user, but I don't know what is causing it to run.

Any ideas what the source of this is?  

select i.obj#, i.flags, u.name, o.name

from sys.obj$ o, sys.user$ u, sys.ind$ i

where (bitand(i.flags, 256) = 256 or bitand(i.flags, 512) = 512)

and (not((i.type# = 9) and bitand(i.flags,8) = 8))

and o.obj#=i.obj#

and o.owner# = u.user#

Ray   Received on Thu Jan 05 2006 - 23:52:29 CST