Re: Monitoring process usage
- From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- To: janine@xxxxxxxxxx
- Date: Tue, 2 Feb 2010 12:05:11 -0600
V$resource_limit is your friend here..
-Gopal
On Tue, Feb 2, 2010 at 11:44 AM, Janine Sisk <janine@xxxxxxxxxx> 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:
