RE: ora-4031 & large_pool

  • From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 18 May 2004 19:38:13 -0500

Rachel - Any connection pooling? (ears perked up) We use Weblogic connection
pooling. Would XA be true there?

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 4:17 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxx> 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@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
> -----------------------------------------------------------------



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