oracle 9i shutdown 遇到ora-600 [504]

oracle version 9.2.0.8

platform aix5.3

shutdown时发生ora-600 504 ...  shared pool 错误

bug 5888835

当cpu_count>32时发生，当时客户cpu_count=72,所以触发bug

 

解决方案，升级到10.2.0.5，或者设置_kgl_latch_count <= 31

 

查看现有_kgl_latch_count语句

SQL> select a.ksppinm aa, b.ksppstvl bb
from x$ksppi a, x$ksppsv b
where a.indx=b.indx
and a.ksppinm like '%latch%count%';