Re: wield session and process number???

From: Joey D'Antoni <jdanton1_at_yahoo.com>
Date: Fri, 21 Aug 2009 10:31:16 -0700 (PDT)
Message-ID: <661580.77478.qm_at_web59003.mail.re1.yahoo.com>

Oracle owns all of the processes that are v$process. However in v$session, the username for system processes is null. If you just do a select count(sid) from v$session; your numbers should match up.

Joe D'Antoni
Synthes USA

---

From: dba1 mcc <mccdba1_at_yahoo.com>
To: oracle-l_at_freelists.org
Sent: Friday, August 21, 2009 1:26:04 PM Subject: wield session and process number???

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       

--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 21 2009 - 12:31:16 CDT