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?