Re: oracle processes - dead??

Nanda,

Those look like sqlnet connection and maybe inactive sessions left over from previous sessions. I have a few on my system as well

The following query (as system) should show all user bases sessions, and state if they are active or inactive:

select sid, status, username, osuser, terminal, machine, program from v$session
where username is not null
order by sid
/

Give that a shot and see what it reports

Nandakumar wrote:

> 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:48:24 CST