Re: oracle processes - dead??

LOCAL=YES means the clients are on the UNIX box, LOCAL=NO means they are true remotes/clients
If they still do something you should be able to find them in v$process view. One of the columns is the Unix process id.

Hth,

--
Sybrand Bakker, Oracle DBA
Nandakumar <N.Kumar_at_rocketmail.com> wrote in message news:80s1gc$6fk$1_at_nnrp1.deja.com...
> hi
> The process information of few oracle processes on a UNIX plat is given
> here. Some non-daemon processess seem to be hanging out since oct 11.
> Can someone give the use of LOCAL=NO with an oracle process?
> i'm wondering if these processses are still active.
>
> oracle 1998 1 0.0 Oct 11 ?? 0:00.60 oracleDEM
> (LOCAL=NO)
> oracle 2892 1 0.0 Oct 11 ?? 0:00.69 oracleDEM
> (LOCAL=NO)
> oracle 3324 1 0.0 Oct 01 ?? 0:01.18 oracleDEM
> (LOCAL=NO)
> oracle 4781 1 0.0 Oct 11 ?? 0:00.87 oracleDEM
> (LOCAL=NO)
>
> Thanks
> --
> Nanda
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 16 1999 - 13:34:18 CST