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

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

How to run Gather Schema Statistics in R12.2

How to clear weblogic stuck threads in R12.2