BLOCKING SESSION QUERIES


1. Kill a blocking session if the sid was known already

e.g:
To find a serial# :
select sid,serial#,status,sql_address,action,module from v$session where sid=147;

To kill a session :
ALTER SYSTEM KILL SESSION 'SID,SERIAL#';

2. Kill a blocking session if the spid was known already

e.g:
To find a serial# :
select sid,serial#,status,action,event from v$session where paddr=(select addr from v$process where spid=26722);

To kill a session :
ALTER SYSTEM KILL SESSION 'SID,SERIAL#';