Skip to Content
0
Former Member
Mar 13, 2009 at 02:19 PM

CC/RAR 5.2 Full Batch Risk Analysis User Analysis

22 Views

Subject: ECD Database Contention (Waits)

In looking at the database these two SQL statements are causing a large amount of contention (waits and slow performance) u2013 sessions waiting on the update. This is typically an application issue, that you have one session updating a record that other sessions are waiting to also update the same record. Between these 2 SQL statements looks like this accounts for about 75% of the database time waiting.

SELECT "LOCKVALUE" FROM "VIRSA_CC_LOCKTABLE" WHERE "LOCKKEY" = '1001' FOR UPDATE;

SELECT "LOCKVALUE" FROM "VIRSA_CC_LOCKTABLE" WHERE "LOCKKEY" = '1002' FOR UPDATE;

Can anyone offer an idea as to why, when we run a Full Batch Risk Analysis User Analysis, this is slowing our performance and causing the job to run extremely long?