Re: oracle threads increasing, even after closing sessions

fitzjarrell_at_cox.net ha scritto:

> 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

We have similar problem on development database, 10.2.0.2 on window 2003, it seems that under some
circustances Oracle is unable to cleanup sessions not cleanly closed. i've searched metalink, but
i've not found something usefull. I've tried with window utility process explorer to kill some threads and it works, but obviously is not the solution, at least it may permit to not restart Oracle.

Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com Received on Wed Jun 13 2007 - 15:20:05 CDT