wield session and process number???

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Fri, 21 Aug 2009 10:26:04 -0700 (PDT)
Message-ID: <200671.73008.qm_at_web65707.mail.ac4.yahoo.com>

we have ORACLE database 10GR2 on LINUX server. I found one thing very wield:

SQL> select count(username) from v$process;

COUNT(USERNAME)

---

             99

SQL>select count(username) from v$session

COUNT(USERNAME)

---

             16

I check on LINUX system use :

%ps -ef | grep DB01 | wc -l
99

anyone know why only 16 session and have 99 processes?       

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 21 2009 - 12:26:04 CDT