Re: JDBC thin driver and sql_trace

Actually, I'm having the same problem if you ever figured it out. Essentially, I used to be able to this on Oracle 8, but now that we've switched to 9i, no dice. Very annoying. Thanks to anyone who might have some ideas.

greg

Thomas Kellerer <spam_eater_at_gmx.net> wrote in message news:<bpu0t3$cec$1_at_svr7.m-online.net>...
> Hello all,
>
> I'm trying to get sql_trace enabled from a Java based front end, which
> connects through the JDBC thin driver to a 8.1.7 database.
>
> When I fire up SQL*Plus and issue ALTER SESSION SET sql_trace = true; I get
> my trace files written to disk.
>
> When I do the same through JDBC (same user, same server, same instance) the
> trace files are not written. I tried it also with a small test program but
> still no trace file were generated.
>
> Am I missing something? Do I need to pass additional parameters when
> connecting in order to get sql_trace enabled?
>
> I tried this with the 8.1.7 driver (classes12.zip) and the new 9.2 driver
> (ojdbc14.jar) - no difference. JDK was 1.4.2
>
> Any help is greatly appreciated.
>
> Thanks in advance
> Thomas
Received on Fri Dec 12 2003 - 01:10:46 CST