Presented at INFOCUS Envision 2021
Session Id: 102650
Do you have problems with blocking on your database? If you are trying to solve that problem by killing sessions directly on the database, you could be making the problem worse. You are focusing in the wrong area if you ever want to solve the blocking issue, because blocking is caused by the application – not the database.
Blocking is how the database maintains the integrity of your data in the face of bad application code, conflicting updates, errant users, and much more. If you try to circumvent that protection by killing sessions, you could cause long downtimes and data integrity issues. Blocking is symptom of a problem, not the cause of a problem.
Objectives
Find out how this critical function of your database protects you
How to discover the true cause of blocking so you can solve it once and for all
Bill Rehm, GSI