ANALYZE HANGING SESSIONS USING HANGANALYZE 3 utility/tool in ORACLE
sqlplus / as sysdba
select a.sid, a.serial#, b.spid ospid, to_char(logon_time,’dd-Mon-rr hh24:mi’) Logintime
from v$session a, v$process b
where a.inst_id = b.inst_id and a.paddr = b.addr and status = ‘ACTIVE’;
SQL> oradebug setospid [spid]
SQL> oradebug unlimit;
SQL> oradebug hanganalyze 3
This will generate a trace file which will contain the detail why the oracle database session is hanging. Even though the trace file will contain loads of information still it is quite easy to find out the real culprit.
sqlplus / as sysdba
select a.sid, a.serial#, b.spid ospid, to_char(logon_time,’dd-Mon-rr hh24:mi’) Logintime
from v$session a, v$process b
where a.inst_id = b.inst_id and a.paddr = b.addr and status = ‘ACTIVE’;
SQL> oradebug setospid [spid]
SQL> oradebug unlimit;
SQL> oradebug hanganalyze 3
This will generate a trace file which will contain the detail why the oracle database session is hanging. Even though the trace file will contain loads of information still it is quite easy to find out the real culprit.
No comments:
Post a Comment