ora-4031 & large_pool

From: Terry Sutton <terrysutton_at_usa.net>
Date: Tue, 18 May 2004 12:53:58 -0700
Message-ID: <004601c43d11$e51c6c00$57761a0a@TerrySutton>

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

---

Received on Tue May 18 2004 - 14:51:34 CDT