Re: Source of expensive SQL

From: jame tong <jametong_at_gmail.com>
Date: 2006-01-13 10:48:49
Message-id: 264ff9340601130148y7101c650n5b5968c5c2ac9e2f@mail.gmail.com

Why not check which process run this script. then tune this sql , may be there was a parameter or storage parameter to control this.

On 1/9/06, Tim Hopkins wrote:

> Tim
>
> > Not sure if it helps, but wouldn't "bitand(i.flags, 256)" and
> > "bitand(i.flags, 512)" be the same as 0x100 and 0x200 below
> > (from sql.bsq):
> >
> > From the same source:
> >
> > /* cooperative index method : 9 */
> >
> > PS. Anyone know what a "cooperative index method" is?
> >
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
Received on Fri Jan 13 2006 - 10:48:49 CST