Re: orphan oracle processes please help...

engsys_at_merlion.singnet.com.sg wrote in message <6e83kd$ujf$1_at_columbine.singnet.com.sg>... <snipped>
>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 ??

Activate DCD (dead connection detection) in the listener - I think it is a timeout parameter that you set in the
$ORACLE_HOME/network/admin/listener.ora. The listener will then kill these dead/lost client connections.

regards,
Billy Received on Thu Mar 12 1998 - 00:00:00 CST