What Is a Deadlock
What Is a Deadlock?
✍: fyicenter.com
Deadlock is a unique situation in a multi user system that causes two or more users to wait indefinitely for a locked resource. First user needs a resource locked by the second user and the second user needs a resource locked by the first user. To avoid dead locks, avoid using exclusive table lock and if using, use it in the same sequence and use Commit frequently to release locks.
2007-04-15, 5923👍, 0💬
Related Topics:
What Is Consistency
What Is Consistency? Consistency : Assures users that the data they are changing or viewing is not changed until the are through with it. 2007-04-15, 5475👍, 0💬
What Is Rollback
What Is Rollback? Rollback causes work in the current transaction to be undone. 2007-04-15, 5358👍, 0💬
What Is a Savepoint
What Is a Savepoint? Savepoint is a point within a particular transaction to which you may rollback without rolling back the entire transaction. 2007-04-15, 5233👍, 0💬