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

I have joined the views. And it works for the SQl request in Perl-CGi, but it doesn't for Java-Jdbc.
Please tell me more of your environment. Thanks,

In article <8plv55$72f$1_at_nnrp1.deja.com>,   senthil <rsenthilkumar_at_my-deja.com> wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 12 2000 - 17:06:54 CDT