Oracle provides data concurrency and integrity between transactions using its locking
mechanisms. Because the locking mechanisms of Oracle are tied closely to transaction
control, application designers need only define transactions properly, and Oracle
automatically manages locking.
Keep in mind that Oracle locking is fully automatic and requires no user action.
Implicit locking occurs for all SQL statements so that database users never need to lock
any resource explicitly. Oracle’s default locking mechanisms lock data at the lowest
level of restrictiveness to guarantee data integrity while allowing the highest degree of
data concurrency.
事务与数据并发访问中的锁
1. Oracle默认采用的锁机制能尽可能地减小对数据访问的限制，在保证数据一致性的同时实现高度
的数据并发性
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-990393/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002860
最新文章
- 人力&人手&人才&人物
- 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
- 目睹奥运火炬传递
