Re: Is there a better way I can handle Oracle runaway processes?

From: "Avadhani mys" <avadhanimys@xxxxxxxxx>
To: ora-apps-dba@xxxxxxxxxxxxx
Date: Fri, 21 Dec 2007 18:52:51 +0530

Hi,

You can check ps -ef | grep LOCAL=NO Processes and login to database and for
particular PID if there is no session running you can kill those sessions
from OS level,

Thanks
Achi


On 11/28/07, Nelabhotla Durga Charan <charan.durga@xxxxxxxxx> wrote:
>
> Hello Team,
>
> Please advice :
>
> Is there a better way who I can handle Oracle runaway processes?
>
> For example end users terminates the concurrent request from front end
> oracle applications ( DBA may not notice this ) and the process will be
> active in database  and at Unix OS level.
>
> How to to track these type of runaway process.Thanks for response.
>
>
> --
> Best Regards
> N.Durga Charan
>

Re: Is there a better way I can handle Oracle runaway processes?

Other related posts: