Re: wield session and process number???
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: Joey D'Antoni <jdanton1@xxxxxxxxx>
- Date: Fri, 21 Aug 2009 10:34:52 -0700 (PDT)
Sorry. It still NOT match.
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@xxxxxxxxx> wrote:
> From: Joey D'Antoni <jdanton1@xxxxxxxxx>
> Subject: Re: wield session and process number???
> To: mccdba1@xxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxx>
> To:
> oracle-l@xxxxxxxxxxxxx
> 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?
>
>
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
