kewastUnPackStats():bad magic in Alert Logfile After Upgrading to 11.2.0.1

刘泽宇

现象：
The following message is reported in the instance alert file: (The hexadecimal string "0x1108f7b87" may be variable)

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

原因：
The cause of this problem has been identified in Bug:8967729 which has been closed as duplicate of un-published bug 8730312.
It is caused by the variable part of the Active Session History rows (the module, action program, etc. information) not being stored properly, causing any read-back of this data through views like (G)V$ACTIVE_SESSION_HISTORY to fail.

处理方法：
The issue has been fixed in the upcoming Oracle12c release and the 11.2.0.2 or higher patchsets.

For any environments where this is not available, apply Patch:8730312

As one-off patches are not subjected to the same rigorous level of testing as done for Oracle Server patch sets, you are encouraged to install and test this patch in a test environment prior to full production implementation.