RE: mismatch between v$process and v$session
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <giovanni.cuccu@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
- Date: Thu, 28 Jul 2005 11:13:28 -0400
Yes, They are sessions that have died and the external client has
dropped off the face of the earth. Can be caused by a number of
reasons, CTRL-ALT-DELETE being one of them. Have your Unix admin look
at the configuration of the Unix kernel. It would appear that
TCPKEEPALIVE is not set. If possible have him set it to something like
5 minutes.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Giovanni Cuccu
Sent: Thursday, July 28, 2005 11:05 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: mismatch between v$process and v$session
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: