(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 - 02:36:26 CDT
