Monitoring open transactions is beneficial for the performance of a database. There are many nice SQL queries which show the locked objects but there might be some special situations where these queries do not work. They get blocked by the open transaction of another session. Such a scenario can occur when one of the sessions…
Read More →