RE: Urgent Oracle CPU issue

From: Vlado Barun <vlado_at_cadre5.com>
Date: Thu, 21 Apr 2005 10:48:39 -0400
Message-Id: <200504211448.j3LEmjW02048@cadre5.com>

Mladen Gogala wrote:

...

> Kirti, I am not at all sure that 10046 is the right tool here. The event
> 10046 is geared toward exposing
> waits. The problem with this particular thing seems to be that it is NOT
> waiting at all, it's hogging the CPU.

...

However, 10046 does help in identifying which statements consume the most CPU time, thus helping in finding the source of the problem. Also, in 9i with 10046, cpu time is tracked on the row source level enabling you to find the problem even faster.

Vlado Barun, M.Sc.
Senior Data Architect, Cadre5
www.cadre5.com

Office: 865 690 4442
Mobile: 865 335 7652
e-mail: vlado_at_cadre5.com

AIM: vbarun2

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

Received on Thu Apr 21 2005 - 10:52:58 CDT