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

Other related posts: