5 Replies Latest reply: Jun 17, 2009 8:06 AM by goiyala RSS

    dbms_monitor.Client_id_trace_enable is not working

    goiyala
      Hi

      I was about to trace a session which comes thru Bea weblogic whenever any query runinng client_identifier will be set to 'MAIN1'.
      i have enabled trace using
      EXECUTE DBMS_MONITOR.CLIENT_ID_TRACE_ENABLE('MAIN1',TRUE,TRUE);

      after i have done some operations, but trace file not generated.

      i have tried alter system set events '10046 trace name context forever, level 12';

      But trace was not created because connection pool sessions are already running.

      Pls help