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

These are SQL*NET connections from client machines.
Users who connect in through SQL*NET have their processes(the ones you are seeing) spawned in background (therefore Parent PID =1) so that the spawning process (the Oracle Listener) can be shutdown without kicking all the users out of the database.

If you're in doubt as to whether a process IS valid or not, look at V$SESSION , "process" column. On UNIX platforms this gives you the (unix) PID's of processes attached to the database. If it's not in that list, then it's probably defunct. Unfortunatly, none of this is straightforward on NT.

Will

Eric Shepherd wrote:

Check the PID of the parent process (the 3rd column in the ps -ef response).
Generally, any oracle process that has a parent process of '1' is an orphan
that can be killed.

Seigmund Akinwande Johnson wrote:

> 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

-- 


ISS UNIX support 
The University Of Leeds.
0113 233 5670