How to kill session:
1. identify which session to kill using following query:
SQL> select
s.sid,
s.serial#,
spid,
trim(s.machine) machine,
trim(s.module) module,
status
from
v$session s,
v$process p
where
paddr=addr
and module is not null
order by 1,2
SID SERIAL# SPID MACHINE MODULE STATUS
---------- ---------- -------------------- -------------------- ------------------------------------------------ --------------------
1 5 2311 server1.soumya.com sqlplus@server1.soumya.com (TNS V1-V3) ACTIVE
29 1 2323 server1.soumya.com STREAMS ACTIVE
35 14 2457 server1.soumya.com sqlplus@server1.soumya.com (TNS V1-V3) INACTIVE
37 16 2450 server1.soumya.com KTSJ ACTIVE
40 2 2359 server1.soumya.com STREAMS ACTIVE
44 27 2448 server1.soumya.com KTSJ ACTIVE
47 2 2361 server1.soumya.com STREAMS ACTIVE
2. Killing a session
SQL> ALTER SYSTEM KILL SESSION '35,14' immediate;
System altered.
No comments:
Post a Comment