Re: help: How do you set event 10046 in this situation

You can use set_ev from sys.dbms_system all you need is sid and serial# think its exec sys.dbms_system.set_ev(sid, serial#, 10046,12,'') to turn it on and when done exec sys.dbms_system.set_ev(sid,serial#, 10046,0,'') to turn it off.

This is the easiest way I know think there are some other ways also this still works in 9.2.x dunno about 10g but probably. Received on Fri Dec 24 2004 - 07:28:18 CST