Re: Why oracle process exceeds the max number ????

From: SEJ <sejprv_at_adsl.tele.dk>
Date: Mon, 4 Nov 2002 19:40:46 +0100
Message-ID: <3dc6bf2d$0$232$edfadb0f_at_dread11.news.tele.dk>


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]
Received on Mon Nov 04 2002 - 19:40:46 CET

Original text of this message