Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to Clean up the killed session in Oracle ???

Re: How to Clean up the killed session in Oracle ???

From: DNP <High.Flight_at_btinternet.com>
Date: 2000/05/06
Message-ID: <3914907E.46DF@btinternet.com>#1/1 






Kill the process using OS tools (if your platform allows of course).
v$session will give you the process ID (PID or SPID I think).




If you are runnuing NT, you may sometimes find that the processes never
leave v$session even though they've been marked for killing.



In this case you'll need to restart the Oracle instance.




David P.



Oracle Certified DBA.




Received on Sat May 06 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US