Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> mismatch between v$process and v$session

mismatch between v$process and v$session

From: Giovanni Cuccu <giovanni.cuccu_at_gmail.com>
Date: Thu, 28 Jul 2005 17:04:59 +0200
Message-ID: <23e0d1170507280804394cbdcf@mail.gmail.com>


Hi all,

    I have a strange problem (at least for me). Oracle 8.1.7.4 on Hp Tru64
I have a lot of rows in v$process without the corresponding one in the v$session.
the number of rows in v$process grows until it reachs the operating system maximum number of processes and it stop becaus of the os limit (actually 512). the active sessions number is stable around 200 while the number of processes is always near to the limit (512). I did a ps -fu oracle and I noticed that there are a lot of processes with description LOCAL=NO
I think they are user processes originating from end-user connections, but I don't know why they are there with no oracle sessions. Any ideas?
Thanks in advance,

    Giovanni
P.S. I did not check it but I'm quite sure that MTS is not enabled.

-- 
--------------------------------------------------------------------
Another free oracle resource profiler
http://sourceforge.net/projects/oraresprof/
New version 0.8 with many bug fixes
and warnings on file truncated, timed_statistics=false, incorrect
tracing deactivation and more
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 28 2005 - 10:07:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US