Re: ps -lef returns this Oracle process oracleWG73 (LOCAL=NO)

From: Ted McCabe <theom_at_gte.net>
Date: Sun, 12 Sep 1999 07:36:26 GMT
Message-ID: <_JIC3.6230$ZR2.52008_at_dfiatx1-snr1.gtei.net>

(LOCAL=NO) generally indicates inbound connections via the listener. Checking what processes are in the instance can help: SELECT

 "V_$SESSION".SID,
 "V_$PROCESS".SPID,
 "V_$SESSION".USERNAME,
 "V_$PROCESS".USERNAME,
 "V_$SESSION".PROGRAM,
 "V_$SESSION".OSUSER,
 "V_$PROCESS".PROGRAM,
 "V_$SESSION".TERMINAL

FROM
 SYS."V_$PROCESS" "V_$PROCESS",
 SYS."V_$SESSION" "V_$SESSION"
WHERE
 "V_$SESSION".PADDR = "V_$PROCESS".ADDR
AND
 (("V_$PROCESS".BACKGROUND Is Null)
AND
 ("V_$PROCESS".SPID<>'UPPER(''&1'')')
AND
 ("V_$SESSION"."USER#">0))
ORDER BY "V_$SESSION".SID;
/
HTH
tED

Seigmund Akinwande Johnson wrote in message ...
>All,
>I am running oracle 7.3 on Solaris 7 and I get a list of process listed as
>oracleWG73 (LOCAL=NO) about 8 does anyone know what they are doing ?,
>my SID is WG73
>Can I get rid of them ? are they orphan connections ?
>
>--
>Developer Preserve Project
>BSDIS
>773-834-2652
>
>
Received on Sun Sep 12 1999 - 09:36:26 CEST