ora-4031 & large_pool
- From: "Terry Sutton" <terrysutton@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 May 2004 12:53:58 -0700
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
-----------------------------------------------------------------
Other related posts:
