18 lines
406 B
SQL
18 lines
406 B
SQL
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
|
|
|
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;
|
|
/
|