Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Bea WebLogic and Oracle shared server

RE: Bea WebLogic and Oracle shared server

From: Michael Fontana <mfontana_at_verio.net>
Date: Mon, 7 Jun 2004 16:01:17 -0500
Message-ID: <00e201c44cd2$93a6ecd0$380b0a0a@corp.verio.net>


We also use BEA connection pooling. One of our developers figured out how to do it after I complained about the number of connections it was generating. Keep in mind also that several versions and interrations of BEA weblogic and (worse yet) it's API will open cursors in java without explicitly closing them. Be prepared to train your development community to be sure all cursors are closed.

It's not immediately apparent this is happening until you have a production issue, of course....

Michael Fontana
Sr. DBA
NTT/Verio

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Carel-Jan Engel Sent: Monday, June 07, 2004 6:17 AM
To: oracle-l_at_freelists.org
Subject: Re: Bea WebLogic and Oracle shared server

> 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.

Helmut,

AFAIK, BEA is doing connection pooling on its own. At the sites I've seen, fixed number of connections is (much) lower than the number of concurrent users. If that's the case in your situation as well, I would suggest not to double the number of BEA connections, and let BEA do the connectionsharing. At least test the performance issues of stacking two multiplexing architectures, BEA connectionpooling on top of MTS. Given 200 users, a test could be 200 BEA connections and 100 shared server processes. Other configurations to test: 100 BEA connections and 100 dedicated processes, and 100 BEA connections with 50 shared processes. So you can find out which one is the most efficient. If you are going to perform such a test, I'm curious about the results. Alas, I don't have access to a proper testenvironment on this topic now.

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon Jun 07 2004 - 15:58:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US