Re: cannot remove trace mode

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 17 Jul 2003 00:03:38 GMT
Message-ID: <uJlRa.49$4y6.11@news02.roc.ny>

"zeb" <thierry.constant1.nospam_at_free.fr> wrote in message news:3f15aa9b$0$12330$626a54ce_at_news.free.fr...
> Hi,
>
> I put a database into trace mode with:
> >ALTER SYSTEM SET EVENTS '10046 TRACE NAME CONTEXT FOREVER, LEVEL 8';
>
> I want to stop the trace mode, I did:
> >ALTER SYSTEM SET EVENTS '10046 TRACE NAME CONTEXT OFF';
> but the database stay in trace mode
> even after a reboot ( no sql_trace in init )
>
> Any helps ???
>
> Thanks in advance
>
> Oracle 8.1.7 .4
> HP-UX 11.0
>
>

So what is the output of the following procedure (from metalink):

set serveroutput on
declare

   event_level number;
begin

   for i in 10000..10999
   loop

      sys.dbms_system.read_ev(i,event_level);
      if (event_level > 0) then
         dbms_output.put_line('Event '||to_char(i)||' set at level '||
                              to_char(event_level));
      end if;

   end loop;
end;
/

... and yes .. contact oracle support. This should not be happening.

Anurag Received on Wed Jul 16 2003 - 19:03:38 CDT