Re: Monitoring process usage
- From: Harel Safra <harel.safra@xxxxxxxxx>
- To: janine@xxxxxxxxxx
- Date: Tue, 02 Feb 2010 20:24:23 +0200
select count(*) from v$process;
Or in RAC, to check all the nodes at once:
select inst_id,count(*)
from gv$process
group by inst_id;
You can also use v$resource_limit (or gv$... in RAC) to check what was
the high water mark of processes/session etc.
Harel Safra
On 02/02/2010 19:44, Janine Sisk wrote:
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
