Re: Monitoring process usage
- From: John D Parker <orclwzrd@xxxxxxxxx>
- To: janine@xxxxxxxxxx, oracle-l L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 2 Feb 2010 10:47:17 -0800 (PST)
With web apps that have a connection pool, I've discovered that you don't want
that pool to have very large limits. My experience is that max connections
needs to be very close if not the same as min connections. This prevents
behavior where connections, ie processes, increase very rapidly. The example is
I have X connections and they are slow so 5 more are added making things slower
so 5 more are added which make things slower so... well you see how that goes.
Anyway, that's my experience. hope it helps!
John
________________________________
From: Janine Sisk <janine@xxxxxxxxxx>
To: oracle-l L <oracle-l@xxxxxxxxxxxxx>
Sent: Tue, February 2, 2010 11:44:17 AM
Subject: Monitoring process usage
This is a real DBA 101 question... I have a 9.2 installation that has been
running without issue for years, and suddenly it has started running out of
processes every few months. The first couple of times I misdiagnosed the
problem, thinking it meant UNIX processes. This time I dug deeper and realized
it was actually hitting the PROCESSES limit within Oracle.
I have doubled the value of the PROCESSES initialization parameter, from 250 to
500. If the problem is due solely to the website getting busier over time,
which it has been, then that should fix it. But I want to keep an eye on
things to see if there is something running amok (this client does a lot of his
own programming, and he's not a trained programmer, so it's entirely possible
that he has created a monster).
So, my question - I have been searching the Google, looking for a script I can
run periodically to check on how many processes are in use and whether we are
close to the limit, but I can't find one. I'm sure I could write one with a
bit of research, but it seems silly to reinvent the wheel if I don't have to.
Does anyone have a script or link they could share?
thanks,
janine
--
//www.freelists.org/webpage/oracle-l
Other related posts:
