Re: Unable to disable tracing - XE

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Tue, 9 Feb 2010 17:20:52 -0800 (PST)
Message-ID: <d3861a79-8ca3-4d94-9cd3-e8120dbc6567_at_g27g2000yqh.googlegroups.com>

On Feb 9, 8:01 pm, BD <robert.d..._at_gmail.com> wrote:

snip

> ... or at least I would be if I had any.
>
> I am running a copy of 10G XE on a WinXP box.
>
> In a troubleshooting session some time ago, I turned on some
> additional tracing - and quite simply have been unable to turn it off.
>
> Below is an extract from one of my .trc files in my bdump directory.
> It's the alter session statements in this trace that I want to disable
> - they're resulting in way more trace files than I need now.
>
> I've tried ALTER SYSTEM statements, ALTER SESSION statements, to try
> to disable these statements, but they keep getting asserted again on
> instance restart.
>
> I'm sure I'll just smack myself in the head once I work this out, but
> can someone point me to where I can disable these statements?
>
> Given that it's XE, it'd probably be just as time-effective to
> reinstall as to dial this in... but still.
>
> Thanks kindly!!
>
> *** SERVICE NAME:(SYS$USERS) 2010-02-02 09:46:36.593
> *** SESSION ID:(31.46) 2010-02-02 09:46:36.593
> =====================
> PARSING IN CURSOR #6 len=69 dep=2 uid=0 oct=42 lid=0 tim=80934443123
> hv=3164292706 ad='6688fd70'
> alter session set events '10046 trace name context forever, level 12'
> END OF STMT
> EXEC #6:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=80934443118
> =====================
> PARSING IN CURSOR #6 len=71 dep=2 uid=0 oct=42 lid=0 tim=80934681241
> hv=681663222 ad='6b8cb08c'
> alter session set events '21700 trace name errorstack forever, level
> 3'
> END OF STMT
> PARSE #6:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=80934681236
> BINDS #6:
> EXEC #6:c=0,e=8426,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=80934748960
> =====================
> PARSING IN CURSOR #6 len=34 dep=2 uid=0 oct=42 lid=0 tim=80934753347
> hv=1152259314 ad='66a0f058'
> alter session set sql_trace = TRUE
> END OF STMT
> PARSE #6:c=0,e=59,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=80934753343
> BINDS #6:
> EXEC #6:c=0,e=29497,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=80934836162
> =====================
> PARSING IN CURSOR #7 len=435 dep=1 uid=0 oct=47 lid=0 tim=80934862347
> hv=545826169 ad='6b897000'
> begin
>       execute immediate 'alter session set max_dump_file_size =
> unlimited';
>       execute immediate 'alter session set tracefile_identifier =
> ''10046via_app''';
>       execute immediate 'alter session set events ''10046 trace name
> context forever, level 12''';
>       execute immediate 'alter session set events ''21700 trace name
> errorstack forever, level 3''';
>       execute immediate 'alter session set sql_trace = TRUE';
>   end;
> END OF STMT
Do you have an after login database level trigger that is doing these execute immediates? Received on Tue Feb 09 2010 - 19:20:52 CST