RSS Feed

Method R Discussion Group

I am able to turn on the trace, but once it's on, I can't turn it off:

 -- on
 begin
  hotsos.hotsos_ilo_task.set_config(true, true);
 end;

 -- not off
 begin
    hotsos.hotsos_ilo_task.set_config(false, true);
 end;

 -- not off
 begin
    hotsos.hotsos_ilo_task.set_config(false, false);
 end;

Is there any other way besides having the user disconnect?
--=Chuck

Tracing should be turned off when the final HOTSOS_ILO_TASK.END_TASK is reached, or when the HTOSOS_ILO_TASKS.END_ALL_TASKS procedure is called. As the last step in these procedures, HOTSOS_SYSUTIL.TURN_TRACE_OFF is called, which calls either for 10g and later
dbms_monitor.session_trace_disable (NULL, NULL);
or for 9i and previous
dbms_support.stop_trace;