Re: wield session and process number???

SQL> select count(sid) from v$session;

COUNT(SID)

        33

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

COUNT(USERNAME)

             17

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

COUNT(PROCESS)

            33

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

COUNT(USERNAME)

             99

• On Fri, 8/21/09, Joey D'Antoni <jdanton1_at_yahoo.com> wrote:

> From: Joey D'Antoni <jdanton1_at_yahoo.com>
> Subject: Re: wield session and process number???
> To: mccdba1_at_yahoo.com
> Cc: oracle-l_at_freelists.org
> Date: Friday, August 21, 2009, 1:31 PM
> 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