Re: Source of expensive SQL
- From: Jared Still <jkstill@xxxxxxxxx>
- To: ray@xxxxxxxxxxxxxxxxxxxxx
- Date: Fri, 6 Jan 2006 23:13:23 -0800
Just a thought:
Try running the query yourself and see what the results are.
That might give a clue.
Jared
On 1/5/06, Ray Feighery <ray@xxxxxxxxxxxxxxxxxxxxx> wrote:
>
> 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
>
>
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
