Hi,
you should try to use a dedicated worker process for connections.
Oracle by defaults spawns (some) worker processes for incoming connection
requests which are shared (i.e. not dedicated to a certain user).
Setting your connection count to a high number will probably result in an
equally high number of worker processes used.
So try to use a dedicated connection:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT
= 1521)))(CONNECT_DATA=(SID=ORCL)(SERVER=DEDICATED))).
You will have to use the jdbc driver supplied by Oracle though to get this
working (you can use a recent version (i.e. >= 10.x.y.z) with Oracle 9i).
For further (and exact) information on this topic ask your local oracle
database administrator.
regards
Dirk
-------- Original-Nachricht --------
> Datum: Wed, 27 Feb 2008 11:56:36 +0530
> Von: "abhishek reddy" <[EMAIL PROTECTED]>
> An: "Tomcat Users List" <users@tomcat.apache.org>
> Betreff: Re: Connection Pooling
> thanks Mr Adam Gordon for the reply,
>
> Can u tell me how to determine why oracle is generating those many
> processes?
> Also tell me where to check the number of oracle processes in use and
> how to reduce it?
>
> > abhishek reddy wrote:
> > > Here are the pool configuration details in context.xml file.........
> > >
> > > <Resource
> > > name="jdbc/pool"
> > > auth="Container"
> > > type="javax.sql.DataSource"
> > > username="scott"
> > > password="tiger"
> > > driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
> > > url="jdbc:odbc:pool"
> > > maxWait="60000"
> > > removeAbandoned="true"
> > > maxActive="130"
> > > maxIdle="50"
> > > removeAbandonedTimeout="300"
> > > logAbandoned="true"
> > > />
> > >
> > > software:
> > > database : oracle 9i
> > > server: tomcat 5.5
> > >
> > > iam getting the following error:
> > >
> > > java.sql.SQLException: [Oracle][ODBC][Ora]ORA-00020: maximum number
> > > of processes (150) exceeded.
> > >
> > > I have set the maxActive to 130 then how will the number of
> processes
> > > exceeds 150?
> > >
> > > tell me when will the maximum number of processes (150) exceeded in
> > > the oracle and how do i solve the problem?
> > >
> > > I have checked the application 5 to 10 times and there is no
> > > connection leakage problem.
> > >
> > > the application is under going performance testing.....with around
> > > 200 users at a time, for the first time it worked perfeclty, next
> time
> > > the
> > > above mentioned error is comming..
> > >
> > > i need your help in solving this problem..
> > >
> > >
> > >
> >
> > ---------------------------------------------------------------------
> > To start a new topic, e-mail: users@tomcat.apache.org
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
>
> --
> Abhishek
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
--
Psssst! Schon vom neuen GMX MultiMessenger gehört?
Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
