1. Find out thread id that needed to be kill from OS level select vs.sid, vs.username, vs.osuser, vs.process fg_pid, vp.spid bg_pid from v$session vs, v$process vp where vs.paddr = vp.addr;
select vs.sid,vs.username,vs.osuser, vs.process,vp.spid from v$session vs, v$process vp where vs.paddr = vp.addr and vs.username='NAZMUL' and vs.osuser='ENAZMUL';
Output:
2. Kill the session from OS level Unix: Run in UNIX as
the oracle/root user Example from the
above output:
Windows: orakill ORACLE_SID spid ORACLE_SID is the unique database name. Example from the
above output:
Here cor is the unique database name. |