Re: How to capture SQL statements that are currently being executed

From: senthil <rsenthilkumar_at_my-deja.com>
Date: Tue, 12 Sep 2000 19:11:52 GMT
Message-ID: <8plv55$72f$1@nnrp1.deja.com>

but you can join and view v$session, v$process, v$sqlarea to get the exact sql executed by the particulare unix process(nothing but java process). this would help you. i am using the above said procedure to find what all jdbc processes are executing. please correct me if i am wrong.
thanks
-senthil

In article <8plt02$43e$1_at_nnrp1.deja.com>, gzwzhang_at_my-deja.com wrote:
> I found that my old method (using v$sqlarea, v$sqltext) can't grab the
> SQl statement coming from Java--Jdbc. I guess JDBC did
> something to the original SQL statements written by Java/SQl
> programmer. I know that I can turn on the sql_trace, but that will
> cause some extra overhead. I don't want to trace any sql at any time.
> ONly when something happened and the Oracle seems abnormal will I
have
> a look at what's current running.
> Any idea will be highly appreciated.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 12 2000 - 14:11:52 CDT