首页 > 代码库 > 【BUG】Kewastunpackstats(): Bad Magic 1 (0x。。。。, 0)

【BUG】Kewastunpackstats(): Bad Magic 1 (0x。。。。, 0)

 

Kewastunpackstats(): Bad Magic 1 (0x1108f7b87, 0) In Alert Logfile After Upgrading to 11.2.0.1

Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.8 and later [Release: 9.2 and later ]
Information in this document applies to any platform.
Kewastunpackstats(): Bad Magic 1 (0x1108f7b87, 0)in Alert Logfile After Upgrading to 11.2.0.1
 
Symptoms
The following message is reportedin the instance alertfile:
 
kewastUnPackStats(): bad magic 1 (0x1108f7b87, 0)
 
Cause
The cause of this problem has been identifiedin Bug:8967729 which has been closed
as duplicate of unpublished bug 8730312.It is caused by the variable part of
the Active Session History rows (the moduile, action program, etc. information)
not being stored properly, causing anyread-back of this data through views like
(G)V$ACTIVE_SESSION_HISTORY to fail.
 
Solution
The issue has been fixedin the upcoming Oracle12c release and the 11.2.0.2 and higher patchsets.
The solution is toinstall the 11.2.0.3 patchset
(whichis the current patchset at timeof publishing this Note (MAR-2012).
 
Apply Patch:8730312for any other environments.
As one-off patches are not subjected to the same rigorous level of testing asdone
for Oracle Server patch sets, you are encouraged to installand test this patch
in a test environment prior to full production implementation.