To enable and disable event 10046 tracing for the current session,
SQL> Alter session set events ‘10046 TRACE NAME CONTEXT FOREVER, LEVEL 12’;
SQL> Alter session set events ‘10046 TRACE NAME CONTEXT OFF’;
To enable and disable event 10046 tracing for the entire instance
SQL> Alter system set events ‘10046 TRACE NAME CONTEXT FOREVER, LEVEL 12’;
SQL> Alter system set events ‘10046 TRACE NAME CONTEXT OFF’;
Thanks
Wednesday, July 29, 2009
Subscribe to:
Post Comments (Atom)
1 comment:
Interesting to know how to enable and disable event 10046 tracing for the current session. Thanks for sharing the information. Keep the good work going.
sap pp h
Post a Comment