Database Administrator Guide > Database Administrator Guide > Improving Database and Query Performance
Was this helpful?
Improving Database and Query Performance
Locking and Concurrency Issues
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.
Last modified date: 11/09/2022