Many queries are blocked behind a long-running transaction. What should be determined before terminating its session?

Published
  1. Delete every blocked table immediately
  2. The blocking chain, transaction purpose, business impact, and rollback consequences
  3. Only the query text's length
  4. Whether its session id is the highest number

Comments — 0