start/stop trace between removing trace files
562238Feb 20 2007 — edited Feb 20 2007Hi,
I have the following problem.
I put some Oracle session on trace (I use sys.dbms_support.start_trace_in_session). Then I make some test. I close the trace (I use sys.dbms_support.stop_trace_in_session). I analyze the trace files (tkprof) and I make some tuning.
Then I'd like to remove the trace files (*.trc) and start the trace again for checking if the tuning was efficient.
It seems not possible. Event if I start the trace again I can't see and trc files.
In order to solve the problem I must to bounce the application I want to trace (so that the Oracle sessions start again).
Any hint?
Thanks, Max