> -----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_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:10:29 CDT
