Re: ps -lef returns this Oracle process oracleWG73 (LOCAL=NO)
From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sun, 12 Sep 1999 07:18:14 +0200
Message-ID: <937113552.27585.0.pluto.d4ee154e_at_news.demon.nl>
Date: Sun, 12 Sep 1999 07:18:14 +0200
Message-ID: <937113552.27585.0.pluto.d4ee154e_at_news.demon.nl>
Each instance has (depending on configuration) about 8 processes managing it. I do not exactly remember (working with NT know) whether they show up with LOCAL=NO. The background processes show up in both the v$session and v$process view and their pid is also listed there, so it should be possible to map up your 'orphan' connections to v$session entries. It looks like the answer to your questions is a big NONO.
Hth,
-- Sybrand Bakker, Oracle DBA Seigmund Akinwande Johnson <asjohns_at_midway.uchicago.edu> wrote in message news:FHx4ss.HHy_at_midway.uchicago.edu...Received on Sun Sep 12 1999 - 07:18:14 CEST
> 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
>
>