RE: ora-4031 & large

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 18 May 2004 19:38:13 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00691@EXCHMN3>

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

-----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 4:17 PM
To: oracle-l_at_freelists.org
Subject: Re: ora-4031 & large_pool

having run into this exact problem not that long ago, increase the size of the large pool.

If you are using connection pooling to access the database, you are using XA. And XA needs a (no pun intended) large large_pool. Ours broke when a DBA not familiar with our application and database made changes to the init.ora and decreased the size of the large pool.

Terry Sutton <terrysutton_at_usa.net> wrote:
> One of our clients is getting the following error occasionally on a
> 9.2.0.3 DB:
> ORA-04031: unable to allocate 8704 bytes of shared memory ("large
> pool","unknown object","hash-join subh","kllcqas:kllsltba")
>
> The large pool is set at 16M, which isn't high, but they shouldn't be
> using the large pool at all. The don't use MTS, they don't use
> parallel query or have parallel_automatic_tuning set to true, and
> they don't use RMAN. AFAIK, those are the only things which use the
> large pool.
>
> Any ideas?
>
> --Terry
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------

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 Tue May 18 2004 - 19:37:44 CDT

RE: ora-4031 & large_pool