What Is Database Deadlock ? How Can We Avoid Them?

1.	What Is Database Deadlock ? How Can We Avoid Them?
Answer» When multiple external resources are trying to access the DB locks and runs into cyclic WAIT, it may makes the DB unresponsive. Deadlock can be AVOIDED using VARIETY of measures, Few listed below: Can make a queue wherein we can verify and order the request to DB. LESS USE of cursors as they lock the tables for long time. Keeping the transaction smaller. When multiple external resources are trying to access the DB locks and runs into cyclic wait, it may makes the DB unresponsive. Deadlock can be avoided using variety of measures, Few listed below:

Answer»

When multiple external resources are trying to access the DB locks and runs into cyclic WAIT, it may makes the DB unresponsive.

Deadlock can be AVOIDED using VARIETY of measures, Few listed below:

When multiple external resources are trying to access the DB locks and runs into cyclic wait, it may makes the DB unresponsive.

Deadlock can be avoided using variety of measures, Few listed below:

Discussion