ORA-04031 Error

[ChrisQuick]

I am trying to insert a single new record into a table in Oracle. I keep getting the error message:<br>
<br>
ORA-04031: unable to allocate 2192 bytes of shared memory (&quot;shared pool&quot;,&quot;EHAIRPLU&quot;,&quot;KQLS heap&quot;,&quot;KQLS MEM BLOCK&quot<br>
<br>
We have tried increasing the setting for SHARED_POOL_SIZE, and rebooted the server but still get the same error.<br>
<br>
We can insert new records into any other table we want with no apparent problem. It seems to be limited to this table specifically. Does anyone have a suggestion?

 

[carp]

This sounds like Bugs #668719 and #669226. Both of these bugs were fixed in 8.0.4.2. <br>
Recommend you call Oracle Support and request assistance; it's possible you are running into these bugs and need patches.