Why sessions with no program or user?

From: Dino Hsu <dino1.nospam_at_ms1.hinet.net>
Date: Sat, 10 May 2003 13:34:21 +0800
Message-ID: <b9i33f$eua$1@news.is.net.tw>

Dear all,

In addition to the six background sessions, there are some sessions (10 in the example below) with no program or user names, what are they?

select s.program sprg, s.module, p.program pprg, s.status, count(*) from v$session s, v$process p where s.paddr = p.addr group by s.program, s.module, p.program, s.status

SPRG MODULE PPRG STATUS COUNT(*) --------------- --------------- --------------- -------- ----------

ORACLE.EXE                      ORACLE.EXE      ACTIVE            6
SQLPLUSW.EXE    SQL*Plus        ORACLE.EXE      ACTIVE            1
TOAD.exe        T.O.A.D.        ORACLE.EXE      INACTIVE          1
jrew.exe                        ORACLE.EXE      INACTIVE          1
                                ORACLE.EXE      ACTIVE           10

Version: Oracle 8.1.7 on Windows NT.

Regards,
Dino Received on Sat May 10 2003 - 00:34:21 CDT