Re: wield session and process number???

From: Joey D'Antoni <>
Date: Fri, 21 Aug 2009 10:31:16 -0700 (PDT)
Message-ID: <>

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 <>
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;



SQL>select count(username) from v$session



I check on LINUX system use :

%ps -ef | grep DB01 | wc -l

anyone know why only 16 session and have 99 processes?       


-- Received on Fri Aug 21 2009 - 12:31:16 CDT

Original text of this message