Very High Volume Of Archivelog/Redo Logging Generated In MWM Production Database Due To Large M1_GPS_DATA Table
(Doc ID 2638744.1)
Last updated on FEBRUARY 13, 2020
Applies to:Oracle Utilities Mobile Workforce Management - Version 22.214.171.124.0 and later
Oracle Real-Time Scheduler - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Using MWM 2.3 with database version 188.8.131.52, from last month when the MWM operation went live, we created 8 schedulers in MWM PROD for different regions. After this, observed that the archive log generation in database has jumped up by 50 times which is unexpected behavior and requires an unsustainable amount of storage.
ARCHIVE_LOG_PER_HOUR SIZE IN GB
21-OKT-2019 10:00:00 31.11100864
21-OKT-2019 11:00:00 22.08209705
21-OKT-2019 12:00:00 19.21118259
21-OKT-2019 13:00:00 24.46155739
21-OKT-2019 14:00:00 30.53853273
21-OKT-2019 15:00:00 22.40264177
21-OKT-2019 16:00:00 29.45919132
21-OKT-2019 17:00:00 18.38162327
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