Oracle_scripte/Tanel/tracesid.sql
2014-09-17 13:23:48 +02:00

15 lines
227 B
SQL

declare
l_sid number;
l_serial number;
begin
select sid, serial#
into l_sid, l_serial
from v$session
where sid = &1;
sys.dbms_monitor.session_trace_enable(l_sid,l_serial,true,true);
end;
/