Re: Orphaned sessions

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