Several sessions wait on locks while CPU use stays modest. What is the best initial response?

Published
  1. Increase CPU and assume locks will disappear
  2. Investigate blocking sessions and transaction behavior
  3. Disable authentication for blocked users
  4. Rebuild every table without identifying the blocker

Comments — 0