Tracing in Multi-Threaded Server

Hello all,

we use multi-threaded server, Net8, Oracle 8.1.5 on Sun Solaris 2.6

We can easily switch on and off tracing by sys.dbms_system.set_sql_trace_in_session of an already running session. As you all may know tracing is fun with shared servers as your traced statements are spread across the trace files which are related to the server processes, not the sessions.

However, switching tracing off does not release the file (detected by /etc/fuser). It only stops writing to that trace files.

Removing the trace files after switching off the tracing (or terminating the traced sessions) is possible in Unix, but if you start another trace session the deleted trace files will not be recreated (as the shared servers think they are still there - for their process they in fact are).

But the problem is that starting a new trace session does not write a new header. Without it tkprof will not recognise commands in the trace file.

Any help appreciated. How do you handle this situation without restarting the instance?

Martin Received on Tue Dec 28 1999 - 17:53:56 CST