Re: Orphaned sessions

I've seen a similar problem when user processes are killed. As well as the user process there is also an associated Oracle process. Although the user process has been killed the associated Oracle process is still running and as far as Oracle is concerned is still valid. This will be the process that you can see via your query. The output below shows this, process 16495 is the user process but note the 16512 process. Killing 17495 will leave 16512 running. This example is against a 7.1 database but the idea is still true for 7.3.

  r31055 16538 16516  9 09:31:44 ttyv8    0:00 ps -ef
  r31055 16495 16494  0 09:31:08 ttyv6    0:00 -ksh
  r31055 16511 16495  0 09:31:19 ttyv6    0:00 sqlplus /
  r31055 16512 16511  0 09:31:19 ?        0:00 oracletmis P:4096,6,9,
  r31055 16516 16514  0 09:31:26 ttyv8    0:00 -ksh
  r31055 16539 16516  0 09:31:44 ttyv8    0:00 grep r31055     
               

Hope this helps,

Cheers,

Allan Received on Mon Sep 08 1997 - 00:00:00 CDT