Friday , December 6 2024

Lock Control In Database

In today’s article, we will discuss checking for LOCKs in the database, which is one of the checks we perform when there is a problem in the database.

1. First, we check if there are any UNCOMMITTED transactions.

2. We identify which table the LOCK caused by this operation is on and how long it has been there. Additionally, the type of LOCK is displayed as shown below.

3. Finally, we can obtain more detailed data with the following queries.

For example, information such as who caused the LOCK, who was LOCKed, is the session currently ACTIVE or INACTIVE? can be obtained.

4. A similar query to the one above.

Loading

About Onur ARDAHANLI

Leave a Reply

Your email address will not be published. Required fields are marked *