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
-----------------------------------------------------------------
Received on Tue May 18 2004 - 16:41:57 CDT