Calculation on Calendar Preventive Maintenance (Doc ID 2731471.1)

Last updated on MARCH 12, 2025

Applies to:

Goal

On : 2.2.0.6.0
We noticed that whenever Batch W1-MNTTR (Maintenance Trigger Periodic Monitor Process) is running, it is locking up the CI_SEQ table. When it does that, no one can create any transactions which uses CI_SEQ table to get the next sequence number. For now, we had to kill the Threadpool to stop this Batch and release the lock on the Sequence table.

WAM v2.2.0.6.0.096 000
Framework v4.4.0.2.0 007 000
 

Solution

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