The ASG_SYSTEM_DIRTY_QUEUE Table Contains A High Number Of Counter Records For CSF_M_COUNTER_VALUES
Last updated on MARCH 08, 2017
Applies to:Oracle Mobile Field Service - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
On : 12.1.3
There is a large volume of data in the table ASG_SYSTEM_DIRTY_QUEUE for each user.
The table has thousands of records in CSF_M_COUNTER_VALUES
The profile option "CSM:Maximum Readings per Counter" is set to 3, but a large number of records is added
every time the JTM master program is run.
The issue can be reproduced at will with the following steps:
1. High volume of counter data in the table ASG_SYSTEM_DIRTY_QUEUE
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms