Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to avoid writing to the alert.log while using logminer?

TridentDec 12 2018 — edited Dec 12 2018

Hi All,

I'm developing an application to use logminer to get the changed data.However, I encountered one high I/O problem. Each time executing the dbms_logmnr.start_logmnr will generate the following messages in the alert.log. So more frequently using the logminer, the I/O gets higher. IS THERE ANY WAY TO STOP LOGMINER SERVER WRITING TO ALERT.LOG? Thanks in advance!

Wed Dec 12 20:03:08 2018

LOGMINER: summary for session# = 2147483905

LOGMINER: StartScn: 2275526 (0x0000.0022b8c6)

LOGMINER: EndScn: 2275782 (0x0000.0022b9c6)

LOGMINER: HighConsumedScn: 0

LOGMINER: session_flag: 0x0

LOGMINER: Read buffers: 8

LOGMINER: Memory LWM: limit 10M, LWM 8M, 80%

LOGMINER: Memory Release Limit: 0M

Wed Dec 12 20:05:22 2018

LOGMINER: Begin mining logfile for session -2147483391 thread 1 sequence 77, /home/oracle/app/oradata/orcl/redo02.log

Added on Dec 12 2018

#performance-availability, #streams

1 comment

2,011 views