v$process entries not in v$session

From: Ted Chyn <tedchyn_at_yahoo.com>
Date: 19 Oct 2001 13:17:10 -0700
Message-ID: <44a19320.0110191217.2d7ac3b8@posting.google.com>

all, what are these processes existing in v$process but not in v$session(see below)

 1 select * from v$process x where not exists (select 1 from v$session y   2* where x.addr = y.paddr)
SQL> / ADDR PID SPID USERNAME SERIAL# TERMINAL -------- ---------- --------- --------------- ---------- ----------

PROGRAM                                          B LATCHWAI LATCHSPI
------------------------------------------------ - -------- --------
B05E6338          1                                    0

PSEUDO

B0631F38        405 1204      oracle                  72 UNKNOWN

oracle_at_dlfwsp41 (TNS V1-V3)

thanx ted chyn Received on Fri Oct 19 2001 - 15:17:10 CDT