ORA-00604: error occurred at recursive SQL Level
1. ORA-04031: unable to allocate 4200 bytes of shared memory "RBKS_BK_INFO", "sga_heap", "library cache"). What do these two errors mean? How can I solve them? Are they in the application or the database?
The first error is telling you that a SQL statement that Oracle issued on your behalf has faild. The ORA-4031 is telling you why it failed. The ORA-4031 error means that you do not have enough free space available to you. You can increase your SHARED_POOL_SIZE, bounce the database, and try again. If you are running Oracle8i, then there was bug that would produce ORA-4031 errors. This bug was fixed in the 220.127.116.11 patchset. If you are not at that level, you may have to apply the patchset.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.