To turn on trace for a specific event. exec dbms_system.set_ev(<SID>, <serial#>, <event>, 8, ''); Example: Enable trace at level 8… READ MORE