Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PMON is not removing killed/inactive processes .. is there a way to kick it into action?
Hi,
I believe that you keep in the mind (inactive processes) processes that left in the server memory after client abnormally disconnected from server, for example via shutdown by power supply switch.
So check operating system feature - keepalive timeout.
Vladimir
In article <380455da.6383498_at_news.dial.pipex.com>,
bob_at_silent.com ([SLH]Silentbob) wrote:
> The number of processes on one of my servers keeps increasing daily
> until it hits the limit (200) and then ofcourse I get the no available
> processes error and have to reboot it :-( I believe PMON _should_ be
> removing the large number of inactive processes regularily, but it's
> not. I have also killed a few about a day ago to see if it would
> remove them and unlock some of the tables that they were tying up, but
> it hasn't. There are no errors in the ALRT.log and PMON starts
> normaly every time the DB is brought up. There are not usually more
> than 15-20 active processes at any one time.. but the number of
> inactive ones grows by about 10 a day :-(
>
> Does anyone have any suggestions?
>
> 7.3.3 BTW.
>
> [SLH]Silentbob
> --
> 'Think of them as little horses'
> Visit Bob's ECTS News Website:
> www.go.to/bobsnews
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Oct 14 1999 - 02:02:08 CDT