关于ORA－04031 kglseshtTable与kgllc
今天我们负责监视的一套在VMWare上配置的Oracle 11.2.0.3 RAC环境中，发生大量的ORA－04031错误。Sat Apr 19 16:05:28 2014
Errors in file /opt/oracle/diag/rdbms/abrcps/abrcps01/trace/abrcps01_ora_12729.trc (incident=229190):
ORA-04031: unable to allocate 12312 bytes of shared memory ("shared pool","unknown object","kglseshtTable","kgllc")
Sat Apr 19 17:58:37 2014
Errors in file /opt/oracle/diag/rdbms/abrcps/abrcps01/trace/abrcps01_ora_21304.trc (incident=229254):
ORA-04031: unable to allocate 12312 bytes of shared memory ("shared pool","unknown object","kglseshtTable","kgllc")
临时解决方案是，将共享池清空，保证环境可以正常使用。
是什么原因，暂时没有找到。请刘大帮着看看。谢谢
Memory Utilization of Subpool 1
================================
Allocation Name Size
___________________________ ____________
"free memory " 1024916456
"miscellaneous " 392
Memory Utilization of Subpool 2
================================
Allocation Name Size
___________________________ ____________
"free memory " 1510147504
2个subpool free memory较多
要分配的大小为 12312字节， 怀疑shared pool不健康 碎片较多
该问题属于常见问题， 适用于ORA-4031 常用脚本 ORA-4031错误原理及诊断脚本汇总
http://www.oracledatabase12g.com/archives/ora-4031-common-analysisdiagnostic-scripts.html 谢谢，刘大。主要是我们监视组，对DB内部机能了解不多。
再次谢谢您。
页:
[1]