| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Bea WebLogic and Oracle shared server
Helmut
Yes, Weblogic does connection pooling. It will only open the number of connections in its configuration. My feeling is that to configure shared server on the Oracle side would be redundant. Essentially your Weblogic administrator is opening the floodgates and you are clamping on the brakes. I think you and your Weblogic administrator need to have a chat and come to a common understanding of the appropriate number of Oracle connections in the Weblogic configuration. To do otherwise makes me think of an automobile driven by two people, one of whom has their foot on the accelerator and the other with their foot on the brake. My instinct says that with two entities (Weblogic and Oracle Shared Server) each performing connection pooling, the result may be less than optimum.
Doubling the number of end users does not require the number of Oracle connections to be doubled. Can't the number of existing connections handle the load? Either a compromise needs to be achieved or the capacity of the Oracle database needs to be increased.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Daiminger, Helmut
Sent: Monday, June 07, 2004 5:55 AM
To: 'oracle-l_at_freelists.org'
Subject: Bea WebLogic and Oracle shared server
Hi!
We are a 3rd party insurance application here. The clients are accesing the java application on the app-server (BEA WebLogic 8.1). BEA opens a fixed number of connections (Thin JDBC) to our Oracle database. Right now, Oracle is running in dedicated server mode. But since the number of users is going to double, the number of BEA connections is going to double as well (from 250 to over 500). This would lead to an increase in shard server processes to over 500 as well.
Now we are thinking about putting the database in shared server mode.
Does anybody have any experience with this? Will shared server mode work with thin JDBC connections to the database? Can BEA WebLogic handle shared servers on the Oracle side?
This is 9.2 on HP-UX 11i and WebLogic 8.1 on HP-UX 11i.
Thanks,
Helmut
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |