Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Trace SQL based on PID

Trace SQL based on PID

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Fri, 13 Jan 2006 11:06:54 +0000
Message-ID: <1137150431.96309.0@doris.uk.clara.net>


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 Received on Fri Jan 13 2006 - 05:06:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US