Re: Why oracle process exceeds the max number ????
From: Alex Ivascu <alex_at_ivascu.comNoSpam>
Date: Tue, 05 Nov 2002 04:33:25 GMT
Message-ID: <pSHx9.38264$bG.36328_at_rwcrnsc53>
Date: Tue, 05 Nov 2002 04:33:25 GMT
Message-ID: <pSHx9.38264$bG.36328_at_rwcrnsc53>
He can keep increasing this parameter; but, if he doesn't fix his leak..... it's worthless.
-- Alex Ivascu "SEJ" <sejprv_at_adsl.tele.dk> wrote in message news:3dc6bf2d$0$232$edfadb0f_at_dread11.news.tele.dk...Received on Tue Nov 05 2002 - 05:33:25 CET
> Hi
>
> the parameter in initxxx.ora needs a correction processes=xxx
> If you select from v$parameter you can se the max value.
>
> regards Svend
> "YYgo" <goinghome2008_at_hotmail.com> wrote in message
> news:7e949f76.0211040647.2e24bc59_at_posting.google.com...
> > I'm using WebLogic 6.1 and Oracle 8.1.7.0.0 , and my web application
> > always reach the following error:
> >
> > java.sql.SQLException: ORA-00020: maximum number of processes (150)
exceeded
> >
> >
> > Are there anybody know how to correct this error ???
> >
> > I'm searching the internet for almost ten days .
> >
> > But i got no answer.
> >
> >
> > HELP ME !!!!!!!!!!!!!!!!!
> > HELP ME !!!!!!!!!!!!!!!!!
> >
> >
> > Someone say: JDBC connection does't return back to the connection pool ,
> >
> > Is there a way to know what code does not close the connection.
> >
> > And
> >
> > What is the relation of process and session in oracle ??
> >
> >
> > Thanks first ...
> >
> > [And sorry for my bad english]
>
>