Unable to disable tracing - XE

From: BD <robert.drea_at_gmail.com>
Date: Tue, 9 Feb 2010 17:01:22 -0800 (PST)
Message-ID: <b662c5cb-a6b7-42d2-b734-f998ef5a2a42_at_p6g2000vbl.googlegroups.com>



.. 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
Received on Tue Feb 09 2010 - 19:01:22 CST

Original text of this message