A critical application is experiencing timeouts due to blocking in the database. How do you identify the blocking chain, determine the root cause, and resolve it without disrupting other users?

Sample answer preview

Blocking occurs when one session holds a lock that another session needs, causing the waiting session to be blocked until the lock is released. Unlike deadlocks, blocking does not resolve automatically and can cascade into long chains affecting many sessions.