Re: wield session and process number???
Date: Fri, 21 Aug 2009 10:31:16 -0700 (PDT)
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.
From: dba1 mcc <mccdba1_at_yahoo.com>
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?
http://www.freelists.org/webpage/oracle-l Received on Fri Aug 21 2009 - 12:31:16 CDT