Oracle bad magic 1,kewastUnPackStats(): bad magic 1 (0x7f92ce11cbab, 0)

平台：Linux-x86_64 +oracle 11.2.0.1

1,在检查中发现alert日志中报以下错误：

Wed Sep 25 13:00:08 2012

kewastUnPackStats(): bad magic 1 (0x7f92ce11cbab, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11cbab, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ca72, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ca72, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccbb, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ca6a, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ca6a, 0)

kewastUnPackStats(): bad magic 1 (0x7f92ce11ccc3, 0)

2，问题分析：

这是oracle的已知bug,Bug:8967729/ un-published bug 8730312

该报错可能出现在oracle9.2.0.8-11.2.0.1任何平台上数据库的alert日志中

该Bug触发的原因是，Active Session History中的可变部分(the moduile, action program, etc. information)未被正确存储，导致

访问V$ACTIVE_SESSION_HISTORY 视图失败。

3，解决方案：

1，升级数据库，在12C和 11.2.0.2以后的版本中已修改该Bug.

2, 打Patch:8730312修改该Bug(用这种方法修复时，需要在测试系统测试后再实施)

参考：MOS文章(Doc ID 1227524.1)