10046 Trace a Session sid and serial #

Step 1

Get sid and serial #

Step 2

Start trace

sqlplus as sysdba
exec sys.dbms_system.set_ev(130, 54378, 10046, 12, '');  # where (sid=130 and serial#=54378)

Step 3

end trace

exec sys.dbms_system.set_ev(130, 54378, 10046, 0, '');

Hope this helps. Regards Rupam