In order to enable event 10046 for a particular session, how do I enable it for that session?
Well - This question was posted in a bit of hurry. Found the solution myself.
execute sys.DBMS_SYSTEM.SET_EV(18, 52392, 10046, 12, '')
After 12, its two single quotes. Took me a few attempts to get that one right.
18 and 52392 are the SID's and serial # , 12 is level.