RE: ora-4031 & large

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 18 May 2004 16:21:08 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CFECFCD6@bosmail00.bos.il.pqe>

Are you using Oracle XA by any chance? It also requires a large pool.

-Mark

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Terry Sutton Sent: Tuesday, May 18, 2004 3:54 PM
To: oracle-l_at_freelists.org
Subject: ora-4031 & large_pool

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


-----------------------------------------------------------------

----------------------------------------------------------------

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 - 15:18:19 CDT

RE: ora-4031 & large_pool