RE: ora-4031 & large

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Tue, 18 May 2004 19:14:18 -0700 (PDT)
Message-ID: <20040519021418.16516.qmail@web60705.mail.yahoo.com>

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

Received on Tue May 18 2004 - 21:44:59 CDT

RE: ora-4031 & large_pool