RE: ora-4031 & large_pool
- From: Stephen.Lee@xxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 18 May 2004 15:13:10 -0500
> -----Original Message-----
> 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")
I forget which versions were affected, but there are versions prior to
9.2.0.4 that mismanaged the shared pool so that it gradually became more and
more fragmented until, finally, nothing else could load into it. An
additional symptom was that all attempts to flush the shared pool failed.
Patching to 9.2.0.4 (or later, I suppose) fixes it.
----------------------------------------------------------------
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:
