RE: ora-4031 & large

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 19 May 2004 08:39:22 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00699@EXCHMN3>

Rachel

Thanks for your reply. I checked with our WebLogic administrator and he said that when he creates a connection pool there is a checkbox option for XA, which he hasn't chosen at this point.

For the paranoid among us, have you found a way in Oracle to verify whether XA is being used?

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 Rachel Carmichael Sent: Tuesday, May 18, 2004 9:14 PM
To: oracle-l_at_freelists.org
Subject: RE: ora-4031 & large_pool

we run weblogic as well, so I'd bet you are running XA...

check into large pool. We found it by accident, the symptom was that none of the XA connections could actually connect to the db. So we rolled back the init.ora changes, even though the other DBA kept insisting there was no way his changes could have been the problem. Changes gone (one of which was changing the large pool size) and connections miraculously were made. He insisted it was just "the order in which things were shut down and restarted"

Oh yeah, one of his changes was to increase the db_cache_size "because the BCHR was at 70%"

Yes I screamed over that one. And I keep screaming. And he keeps ignoring me.

I wonder sometimes if the reason they don't listen to me is because "I'm a girl"

DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> Rachel - Any connection pooling? (ears perked up) We use Weblogic
> connection
> pooling. Would XA be true there?
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>

Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price. http://promo.yahoo.com/sbc/

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 Wed May 19 2004 - 08:44:30 CDT