Guest_imported
New member
- Jan 1, 1970
- 0
Hi,
I'm using Oracle and can enable session tracing via -
alter session set sql_trace=true;
in SQL Plus. I then use TKPROF. However I have a 3rd party application with which I need to trace. Since I cannot enter SQl directly into the application I cannot set the sql_trace session variable.
Short of enableing instance wide tracing, is there any way of enabling tracing for this application? The application connects to Oracle via an ODBC DSN. I cannnot use ODBC tracing as this seems to truncate some of the longer SQL.
Please help,
Rocko.
I'm using Oracle and can enable session tracing via -
alter session set sql_trace=true;
in SQL Plus. I then use TKPROF. However I have a 3rd party application with which I need to trace. Since I cannot enter SQl directly into the application I cannot set the sql_trace session variable.
Short of enableing instance wide tracing, is there any way of enabling tracing for this application? The application connects to Oracle via an ODBC DSN. I cannnot use ODBC tracing as this seems to truncate some of the longer SQL.
Please help,
Rocko.