My Oracle Support Banner

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 JANUARY 08, 2024

Applies to:

Oracle Utilities Mobile Workforce Management - Version and later
Oracle Real-Time Scheduler - Version and later
Information in this document applies to any platform.


Using MWM 2.3 with database version, 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.

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.