ALERT日志出现:
kewastUnPackStats(): bad magic 1 (0x7f3521c489a0, 0) kewastUnPackStats(): bad magic 1 (0x7f3521c489a0, 0) kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0) kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0) kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0) kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0) kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0) kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0) kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0) kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0) kewastUnPackStats(): bad magic 1 (0x7f3521c48ad0, 0) kewastUnPackStats(): bad magic 1 (0x7f3521c48ad0, 0) kewastUnPackStats(): bad magic 1 (0x7f3521c48ad0, 0) kewastUnPackStats(): bad magic 1 (0x7f3521c48ad0, 0)
SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for Linux: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production SQL> show parameter comp NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cell_offload_compaction string ADAPTIVE compatible string 11.2.0.0.0 nls_comp string BINARY plsql_v2_compatibility boolean FALSE
文档提示,这是由于ASH信息读取出错导致的:
It is caused by the variable part of the Active Session History rows (the moduile, 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.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30182853/viewspace-1482637/ ,如需转载,请注明出处,否则将追究法律责任。