RE: Source of expensive SQL
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <ray@xxxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 5 Jan 2006 17:56:35 -0500
Just a guess.....do you have index monitoring turned on...?
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
"There are 10 types of people in the world: Those who understand
binary, and those who don't."
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ray Feighery
Sent: Thursday, January 05, 2006 5:52 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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
BEGIN:VCARD
VERSION:2.1
N:Bobak;Mark
FN:Bobak, Mark
ORG:ProQuest Information and Learning;Database Group
TITLE:Software Architect, Sr-TPD
TEL;WORK;VOICE:734.975.6086
ADR;WORK:;ECC4-N01E04;1400 Eisenhower Parkway
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:ECC4-N01E04=0D=0A1400 Eisenhower Parkway
EMAIL;PREF;INTERNET:Mark.Bobak@xxxxxxxxxxxxxxx
REV:20051213T223654Z
END:VCARD
Other related posts:
