RE: Bea WebLogic and Oracle shared server
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 7 Jun 2004 08:12:24 -0500
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@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Daiminger, Helmut
Sent: Monday, June 07, 2004 5:55 AM
To: 'oracle-l@xxxxxxxxxxxxx'
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
