Oracle error, can not figure out

[Ratzie]

I keep getting this oracle error that I can not figure out, I was hoping you can share some light into what it means...
unknown object??
sga heap??
state objects??


SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Aug 31 07:24:21 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
pool","unknown object","sga heap","state objects")

[Cheryl Griffin]

http://www.orafaq.com/msgboard/server/messages/25374.htm
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=349228

[Jean-Luc Oudart · Accepted solution]

Hi,

This error is due to the shared pool being too small and/or fragmented.

cf. attachment

Regards,
Jean-Luc

[Jean-Luc Oudart]

Hi Again,

you can check the space available in your shared pool with this SQL script.

cf. attachment

Regards,
Jean-Luc

[Jean-Luc Oudart]

Also,

it seems you're not on the latest of oracle8i.
You should patch your oracle install and databases.
8.1.7.4

Regards,
Jean-Luc

[Indira Aramandla]

Hi,

If your Oracle RDBMS release is 8.1.7.0 and you are experiencing the error ORA-604 that precedes the ORA-4031 the error was encountered during the execution of recursive SQL.

This appears to be due to bug 1397603 which effects 8.1.7.0 and 8.1.7.1 releases.
It is fixed in later releases.

There is a workaround for this.
Use the workaround as an interim solution which is setting _db_handles_cached = 0 in the init.ora file. Shutdown and restart the database in order for the parameter change to take effect. Remember to unset this parameter after applying the patchset release.


Indira A

[Yogeeraj_1]

hi,

i also recommend the installation of the latest patches to 8.1.7.4.

This contain fixes to many more bugs.

regards
Yogeeraj