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 FEBRUARY 13, 2020

Applies to:

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

Goal

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

Solution

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
Goal
Solution
References


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