wield session and process number???

  • From: dba1 mcc <mccdba1@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 21 Aug 2009 10:26:04 -0700 (PDT)

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?





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


Other related posts: