Turn on and off tracing in another session
Turn on:
exec sys.dbms_system.set_ev(34, 20716, 10046, 12, '');
Turn off:
exec sys.dbms_system.set_ev(34, 20716, 10046, 0, '');
dbms_system.set_ev
PROCEDURE SET_EV
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SI BINARY_INTEGER IN
SE BINARY_INTEGER IN
EV BINARY_INTEGER IN
LE BINARY_INTEGER IN
NM VARCHAR2 IN
si = sid
se = serial#
ev = event = 10046
le = level = 12
nm = name = ''
Everything Changes
1 week ago
No comments:
Post a Comment