Re: orphan oracle processes please help...

engsys_at_merlion.singnet.com.sg () wrote:

]The problem is when the user using the application developed in forms 4.5
]switches off his pc or kills the application on the PC, the oracle process
]on the AIX machine still exists and starts taking up a lot of CPU time.
]I guess it is the pmon's job to kill such processes. Is there any way to
]identify such sessions which do not have a client so that i can kill them ?
]or is there any way to tell the pmon to take care of such processes ??

I really hope someone posts a better solution, but I use lsof (Solaris 2.4 on Sun Sparc) to find the process numbers associated with the client machine name -this is a PC number in our case, so it's fairly easy to identify. Then I use the date/time of the process to identify which is the runaway process and kill it from unix. This happens to us far too often, esp when Win95 clients crash.

-- 
 ,-,_|\   George Dau,                                             __
/    * \  Unix (Solaris, DEC Unix, Linux), Oracle, Internet.     (OO)
\_,--\_/  Home: gedau_at_pobox.com      Work: gedau_at_isa.mim.com.au ( \/ )
      v   WWW:  http://pobox.com/~gedau                          W--W