I am using Oracle 11.2.0.3
I ran 'ALTER SESSION SET EVENTS '10046 trace name context off';' from toad. It ran successfully but tkprof showed following error:
The following statement encountered a error during parse:
ALTER SESSION SET EVENTS '10046 trace name context off';
Error encountered: ORA-00911
why did my statement had parsing error?
trace file had following entry
*** 2015-04-17 12:06:18.067
WAIT #47601876107192: nam='SQL*Net message from client' ela= 4302806 driver id=1413697536 #bytes=1 p3=0 obj#=2298524 tim=1429286778067504
CLOSE #47601876107192:c=0,e=10,dep=0,type=0,tim=1429286778067634
=====================
PARSE ERROR #47601876107192:len=57 dep=0 uid=57 oct=42 lid=57 tim=1429286778067818 err=911
ALTER SESSION SET EVENTS '10046 trace name context off';
WAIT #47601876107192: nam='SQL*Net break/reset to client' ela= 4 driver id=1413697536 break?=1 p3=0 obj#=2298524 tim=1429286778067926
2015-04-17 12:06:18.067969 : nsdo:sending NSPTMK packet
2015-04-17 12:06:18.068032 : nsdo:sending NSPTMK packet
2015-04-17 12:06:18.069954 : nserror:nsres: id=0, op=0, ns=12630, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
WAIT #47601876107192: nam='SQL*Net break/reset to client' ela= 2036 driver id=1413697536 break?=0 p3=0 obj#=2298524 tim=1429286778069976
WAIT #47601876107192: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=2298524 tim=1429286778069988
WAIT #47601876107192: nam='SQL*Net message from client' ela= 33703 driver id=1413697536 #bytes=1 p3=0 obj#=2298524 tim=1429286778103710
CLOSE #47601876107192:c=0,e=4,dep=0,type=0,tim=1429286778103766
=====================
PARSING IN CURSOR #47601876107192 len=55 dep=0 uid=57 oct=42 lid=57 tim=1429286778103912 hv=2655499671 ad='0' sqlid='0kjg1c2g4gdcr'
ALTER SESSION SET EVENTS '10046 trace name context off'
END OF STMT
PARSE #47601876107192:c=1000,e=94,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=0,tim=1429286778103911
EXEC #47601876107192:c=0,e=394,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=0,tim=1429286778104349