Skip to Main Content

Oracle Database Discussions

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!

Logminer Entries in Alert log - How to Stop them

Alan R WilsonSep 12 2016 — edited Sep 16 2016

I'm getting loads of entries on the alert log to do with logminer (see below). No one seems to know anything about turning logminer "on", how to I stop them and see the status of logminer?

Mon Sep 12 10:24:48 2016

LOGMINER: summary for session# = 2147744257

LOGMINER: StartScn: 147149163 (0x0000.08c5516b)

LOGMINER: EndScn: 0 (0x0000.00000000)

LOGMINER: HighConsumedScn: 0

LOGMINER: session_flag: 0x0

LOGMINER: Read buffers: 16

LOGMINER: Memory LWM limit: 10M, 80%

LOGMINER: Memory Release Limit: 15000

Mon Sep 12 10:25:03 2016

LOGMINER: summary for session# = 2147744513

LOGMINER: StartScn: 147149163 (0x0000.08c5516b)

LOGMINER: EndScn: 0 (0x0000.00000000)

LOGMINER: HighConsumedScn: 0

LOGMINER: session_flag: 0x0

LOGMINER: Read buffers: 16

LOGMINER: Memory LWM limit: 10M, 80%

LOGMINER: Memory Release Limit: 15000

Mon Sep 12 10:25:19 2016

LOGMINER: summary for session# = 2147744769

LOGMINER: StartScn: 147149163 (0x0000.08c5516b)

LOGMINER: EndScn: 0 (0x0000.00000000)

LOGMINER: HighConsumedScn: 0

LOGMINER: session_flag: 0x0

LOGMINER: Read buffers: 16

LOGMINER: Memory LWM limit: 10M, 80%

LOGMINER: Memory Release Limit: 15000

Mon Sep 12 10:25:35 2016

LOGMINER: summary for session# = 2147745025

LOGMINER: StartScn: 147149163 (0x0000.08c5516b)

LOGMINER: EndScn: 0 (0x0000.00000000)

LOGMINER: HighConsumedScn: 0

LOGMINER: session_flag: 0x0

LOGMINER: Read buffers: 16

LOGMINER: Memory LWM limit: 10M, 80%

LOGMINER: Memory Release Limit: 15000

Mon Sep 12 10:25:51 2016

LOGMINER: summary for session# = 2147745281

LOGMINER: StartScn: 147149163 (0x0000.08c5516b)

LOGMINER: EndScn: 0 (0x0000.00000000)

LOGMINER: HighConsumedScn: 0

LOGMINER: session_flag: 0x0

LOGMINER: Read buffers: 16

LOGMINER: Memory LWM limit: 10M, 80%

LOGMINER: Memory Release Limit: 15000

Mon Sep 12 10:26:07 2016

This post has been answered by John Thorton on Sep 12 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 14 2016
Added on Sep 12 2016
18 comments
4,780 views