Re: high cpu on query

Alex,

Thanks for your critique and suggestions. Someone else suggested using the same events (10046/10053) off list and I am looking into it now. This is the first major performance issue we've had in years so we are rusty in this area.

I appreciate all the other comments, too.

Thanks.
Joe

Alex Gorbachev wrote:
> Dear list,
>
> It was very interesting to track the development of this thread and
> I've been waiting whether someone will come up with a suggestion to
> take a little different investigation approach instead of, well,
> guesswork. It's a little slow due to the weekend and vacation season
> and I'm a bit impatient. :) So my apologies to Joe for hijacking this
> thread.
>

--
http://www.freelists.org/webpage/oracle-l