Tuesday, October 7, 2014

Find Blocking Session details

Find Blocking Session details

 
 
How to find Oracle Database Blocking Session Details
In first step, find SID from v$session.
SQL> select process,sid, blocking_session from v$session where blocking_session is not null;
 PROCESS SID BLOCKING_SESSION
 ———— ———- —————-
 1234 365 366
 1234 366 365
In second step find the serial number for the Blocking Session to kill using SID
 SQL> select SERIAL# from v$session where SID=365;
 SERIAL#
 ———-
 130
In third step, kill the blocking session using SID and serial number
SQL> alter system kill session ’365,130′;
 System altered.

No comments:

Post a Comment