Hello,
get below error
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select /*+ rule */ bucket, e...","KGLH0^762675f5","kglHeapInitialize:temp")
Tue Jun 11 09:26:30 2013
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/xxx/xxx/trace/xxx_cjq0_2245.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","unknown object","KGLH0^db4b04d9","kglHeapInitialize:temp")
and the databse version is 11.2.0.2, no patch.
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
---------------------------------------- ---------- ---------- ---------- ----------- --------------- -------------------------
05-SEP-10 06.22.14.370943 AM APPLY SERVER 11.2.0.2 0 PSU Patchset 11.2.0.2.0
01-JUN-12 07.13.14.681950 AM APPLY SERVER 11.2.0.2 0 PSU Patchset 11.2.0.2.0
I checked shared pool, it has some free space right now.
Pool Name Allocated Free % Free
------------ -------------------------- ---------------- ------------ ----------
shared pool free memory 788,529,152 449,212,832 56.97
large pool free memory 16,777,216 8,192,000 48.83
java pool free memory 50,331,648 26,216,256 52.09
streams pool free memory 16,777,216 16,777,216 100
Any suggestions?
Thank you very much!!!