Originally posted by mike73
If you want to get rid of this session right away, go to OS and issue the ORAKILL for NT or KILL -9 for Unix to get rid of them, but you need to know the OS number of this session
Run

Code:
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 
/
If you get something like:

SID USERNAME OSUSER FG_PID BG_PID
---- --------------- ---------- --------- ---------
10 JULIAN JULIAN 1965:6969 1234

run in unix as the oracle user

kill -9 1234