Re: Trace SQL based on PID

From: Anurag Varma <avoracle_at_gmail.com>
Date: 13 Jan 2006 06:53:52 -0800
Message-ID: <1137164032.718929.74680@g14g2000cwa.googlegroups.com>

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

http://www.petefinnigan.com/ramblings/how_to_set_trace.htm

search for oradebug

Anurag Received on Fri Jan 13 2006 - 08:53:52 CST

This message: [ Message body ]
Next message: yong321_at_yahoo.com: "Re: "ODBC Bind Timestamp as Date" where has it gone ?"
Previous message: stephen O'D: "Re: Trace SQL based on PID"
In reply to: Tom: "Trace SQL based on PID"
Next in thread: Mladen Gogala: "Re: Trace SQL based on PID"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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