How to stop the logminer process in the snapshot standby database?
(Doc ID 2797894.1)
Last updated on JANUARY 11, 2022
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
When a physical standby is converted to snapshot standby database, it is reporting an active session with wait event "LogMiner preparer: memory". This is causing a slowness of the snapshot standby while testing.
The AWR report shows event "LogMiner preparer: memory" in the top events.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document