Memory Based Snapshot Taking Long Time to Complete Due to ROW LOCK CONTENTION From SQL ID 7uf908a2u7jx6 (Doc ID 3036861.1)

Last updated on JULY 23, 2024

Applies to:

Symptoms

When attempting to run a plan, the Memory-based Snapshot is taking longer than expected to complete with a large amount of time taking place running the following SQL ID:

SQL ID:  7uf908a2u7jx6
update mrp_plans set curr_assignment_set_id=:b0 where (organization_id=:b1 and compile_designator=:b2)

The statement is executing multiple times per plan run and taking close to 2,000 seconds per execution.

This is a very straight forward SQL and the expectation is that it should run very quickly.

The issue can be reproduced at will with the following steps:
1. Responsibility: Material Planning
2. Navigation: Material Planning > Launch
3. Enter the necessary parameters to run the plan

Cause

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