Source of expensive SQL
- From: "Ray Feighery" <ray@xxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 6 Jan 2006 09:52:29 +1100
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
Other related posts:
