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.
"We are all apprentices in a craft where no one ever becomes a master."
Latest posts by Nagulu Polagani (see all)
- Oracle E-Business Suite 12.2.7 Released - September 9, 2017
- PKI-02010: Invalid MAC for Wallet. Wallet verification failed - August 24, 2017
- ORA-1691: unable to extend lobsegment - August 7, 2017