ITPub博客

首页 > 应用开发 > IT综合 > Transactions and Data Concurrency (333)

Transactions and Data Concurrency (333)

原创 IT综合 作者:tsinglee 时间:2007-12-09 10:24:50 0 删除 编辑

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默认采用的锁机制能尽可能地减小对数据访问的限制,在保证数据一致性的同时实现高度
的数据并发性

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-990393/,如需转载,请注明出处,否则将追究法律责任。

下一篇: Modes of Locking (334)
请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892816