If your performance problem occurs in a multi-user environment or if the query runs slowly or hangs intermittently, you may have a concurrency problem.

Concurrency problems occur when several users access the same tables and at least one is a writer. If your query needs to access objects that are locked, the session waits indefinitely for locks to be released unless the lockmode timeout is set or a deadlock occurs.