A deadlock can occur when two or more users are waiting for data locked by each
other. Deadlocks prevent some transactions from continuing to work. Figure 13–3 is a
hypothetical illustration of two transactions in a deadlock.
In Figure 13–3, no problem exists at time point A, as each transaction has a row lock on
the row it attempts to update. Each transaction proceeds without being terminated.
However, each tries next to update the row currently held by the other transaction.
Therefore, a deadlock results at time point B, because neither transaction can obtain
the resource it needs to proceed or terminate. It is a deadlock because no matter how
long each transaction waits, the conflicting locks are held.
死锁
1. 当两个用户互相等待对方释放锁定的资源时就会发生死锁 , 死锁将阻止事务继续执行
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-990925/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002852
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
