Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to trace sql coming through JDBC
The Oracle JDBC is a level 4(?) driver. Does it really pass SQL into the DB or does it go through sort of 'native' way?
just an idea
O. Glueck
gzwzhang_at_my-deja.com wrote:
>
> It's easy to trace the SQl statement coming through Perl-DBI, DBD,
> however 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 statement 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.
Received on Fri Sep 08 2000 - 18:34:00 CDT