Re: Trace SQL based on PID

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Fri, 13 Jan 2006 15:23:02 GMT
Message-Id: <pan.2006.01.13.15.23.02.672004@sbcglobal.net>

On Fri, 13 Jan 2006 11:06:54 +0000, Tom wrote:

> 9.2.0.4
> Linux EL3
>
> I have some long running sql (i presume) and one of the cpu's is nearly
> 100% so knowing the pid of the process that is eating this CPU is it
> possible to trace the sql that is being run?
>
> thanks

Yes. Attach the process in oradebug and trace it. There are short instructions how to use oradebug on my website. May Larry be with you.

-- 
http://www.mgogala.com

Received on Fri Jan 13 2006 - 09:23:02 CST