RE: ora-4031 & large_pool
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 May 2004 08:39:22 -0500
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@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Rachel Carmichael
Sent: Tuesday, May 18, 2004 9:14 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx> wrote:
> Rachel - Any connection pooling? (ears perked up) We use Weblogic
> connection
> pooling. Would XA be true there?
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams@xxxxxxxxxxxxx
>
__________________________________
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@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:
