报警文件中大量：LOGMINER: Summary For Session# = nnn in 11g

郑全

目前无法禁止该消息的输出


参见

Doc ID 1632209.1

In this Document
Goal
Solution
References
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Goal
Clarify the messages from the alert.log 'LOGMINER: summary for session#'

Solution
These kind of messages were introduced in 10.2.0.5 where they appear as described in
Note 1485217.1 - Alert.log Messages 'LOGMINER: krvxpsr summary

In 10.2.0.5 the message was 'LOGMINER: krvxpsr summary for session'.
In 11g the 'krvxpsr ' was suppressed from the message, but the message itself is defined in the code in function krvxpsr, so it is in fact the same.

...
LOGMINER: summary for session# = 2147483905
LOGMINER: StartScn: 55288667444 (0x000c.df761d34)
LOGMINER: EndScn: 55288667645 (0x000c.df761dfd)
LOGMINER: HighConsumedScn: 0
LOGMINER: session_flag 0x0
LOGMINER: Begin mining logfile for session -2147483391 thread 1 sequence 357, /.../redo01.log
LOGMINER: skipped redo. Thread 1, RBA 0x000165.00000003.0288, nCV 10
LOGMINER: op 4.1 (Index)
LOGMINER: summary for session# = 2147484161
LOGMINER: StartScn: 55288667444 (0x000c.df761d34)
LOGMINER: EndScn: 55288667648 (0x000c.df761e00)
...

The messages cannot be disabled.

An Enhancement Request has been filed as unpublished
Bug 18110092 - SUPPRESS LOGMINER: SUMMARY FOR SESSION MESSAGES FROM ALERT.LOG
regarding introducing the possibility to suppress these messages in a future release, as they can generate large amount of unwanted information in the alert log after activating supplemental logging for the database, for example for CDC (Change Data Capture) usage.

References

NOTE:1485217.1 - Alert.log Messages 'LOGMINER: krvxpsr summary'