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: Orphaned sessions

Re: Orphaned sessions

From: MarkP28665 <markp28665_at_aol.com>
Date: 1997/09/03
Message-ID: <19970903141800.KAA18030@ladder02.news.aol.com>#1/1

Thread is about run-away or leftover oracle processes. Instead of using Unix kill command to terminate the user process and take the risk that the oracle support/background process will be left try killing the processes using the 'alter system kill session (sid,serial#);' command. This usually works, but I have seen sessions marked for kill hang around on occassion. After giving Oracle a few minutes to backout updates using the original background process I use the Unix kill command on the leftover Oracle process and let pmon do the work.

Good luck.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Wed Sep 03 1997 - 00:00:00 CDT

Original text of this message

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