Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle threads increasing, even after closing sessions

Re: oracle threads increasing, even after closing sessions

From: Jimmy <jimmy.cooleman_at_gmail.com>
Date: Thu, 14 Jun 2007 08:33:13 -0000
Message-ID: <1181809993.937836.68900@d30g2000prg.googlegroups.com>


On 14 jun, 09:48, Jimmy <jimmy.coole..._at_gmail.com> wrote:
> On 13 jun, 21:09, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
>
>
>
>
> > On Jun 13, 1:50 pm, Jimmy <jimmy.coole..._at_gmail.com> wrote:
>
> > > Dear,
> > > We have a problem with 2 Oracle Server 10.2.0.0 on Windows 2003
> > > Server.
> > > The number of threads in the oracle.exe process keeps increasing, even
> > > after the user session is finished.
> > > We currently have +- 35 session open, and already 136 threads !
> > > We already changed the PROCESSES ini parameter to 300, because we
> > > received ORA-00020 error.
> > > It seems that the threads are not properly cleaned up, after the
> > > session is finished.
> > > Is PMON not supposed to clean this up ?
>
> > > Any ideas ?
>
> > Hmmm, 10.2.0.0 .... I thought 10.2.0.2 was the base release...
>
> > You have checked metalink for this issue, I presume. And you do
> > realise that 10gR2 is certified for Windows 2003 server ONLY at the
> > 10.2.0.2 and 10.2.0.3 patch levels.
>
> > It appears you need to patch your installation.
>
> > David Fitzjarrell
>
> Dear,
> sorry litle mistake, the oracle version we're using is 10.2.0.3 .- Tekst uit oorspronkelijk bericht niet weergeven -
>
> - Tekst uit oorspronkelijk bericht weergeven -

After reboot of the server, still the same problem :-( It runs fine for a couple of hours, but after that, threads are increasing,
session seem to disappear properly, but the thread remains . Received on Thu Jun 14 2007 - 03:33:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US