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 compile forms in R12.2