Session Trace Enabled by Default? Can it be disabled?

[JamesSmyth]

Many-year user of PL/SQL Developer. Love it.

However, we think that it is enabling session tracing at the server. We have this off by default on the database, and the PL/SQL Developer appears to be the only client that is generating trace (UDUMP .trc files).

Is this something we can disable? Brief searches of the web and your site don't show anything.

Just to be clear, the documentation (and the UI, via lack of check-mark indicator) seems to imply that sessions are normally not set to enable SQL Trace. But that doesn't appear to be the case (again, database-wide only for PL/SQL Developer client session)

PL/SQL Developer
Version 7.1.5.1396
01.42643 - 5 user license
Windows Vista 6.0 Build 6001 (Service Pack 1)

Physical memory : 2,097,152 kB (978,708 available)
Paging file : 4,194,304 kB (3,821,228 available)
Virtual memory : 2,097,024 kB (1,829,216 available)

Using
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0

Thanks,

James

 

[JamesSmyth]

Just to be clear, the documentation (and the UI, via lack of check-mark indicator) seems to imply that sessions are normally not set to enable SQL Trace. But that doesn't appear to be the case (again, database-wide only for PL/SQL Developer client session)

 

[Marco Kalter]

Normally PL/SQL Developer will not enable tracing. To see what PL/SQL Developer is executing, you can modify the PL/SQL Developer shortcut and add the DebugSQL parameter. For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and review the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Documents and Settings\\Application Data). Feel free to contact me with your findings, and/or send me the debug.txt file.

 

[JamesSmyth]

I can see from the debugging now that the "alter session set sql_trace = true/false" is happening when I select/deselect the Session->SQL Trace option, but it doesn't seem to have any effect on the user dump/trace file.

 

[Marco Kalter]

What is your conclusion?