Re: high cpu on query

  • From: Joe Armstrong-Champ <joseph.armstrong-champ@xxxxxxxxx>
  • To: Alex Gorbachev <ag@xxxxxxxxxxxx>
  • Date: Mon, 02 Jul 2007 09:21:08 -0400

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.

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


Other related posts: