Q
Problem solve Get help with specific problems with your technologies, process and projects.

Recursive SQL error when using Web app

I encountered an error when using a Web application.
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 8.1.7.4 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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close