Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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