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