Recursive SQL error when using Web app |
 |
EXPERT RESPONSE FROM: Brian Peasland
|
|
|
| > |
QUESTION POSED ON: 07 June 2004
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.
|
|
|
|
|
|
|
|
Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
|
|
|
|
|
|
|
|
|
|
|
|
