How to enable trace for session level in oracle Database
Find SID for session
SELECT
sys_context('USERENV', 'SID') FROM DUAL;
EX:sid:
4179
select
sid,serial#,username,program,status,event from v$session where sid='4179';
Enable Trace for session level
begin
dbms_monitor.session_trace_enable(session_id=>4179,serial_num=>59963,binds=>true,waits=>true);
end;
SQL>
select spid from v$process where addr=(select paddr from v$session where
sid=9219);
SPID
------------------------
12124222
There
was file system issue during which alerts got triggered
Disable trace
begin
dbms_monitor.session_trace_disable(session_id=>4179,serial_num=>59963,binds=>true,waits=>true);
end;
Comments
Post a Comment