DB2/SQL Server Locking and Concurrency VS Oracle
原创maclean_007 ©著作权
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
Oracle VS DB2
Oracle的优越多版本读一致性模型允许读和写完全独立完成而不冲突
IBM DB2要求读锁,读锁会引起死锁,影响并发能力,增大管理难度
Oracle仅对写活动要求锁
“Locks are acquired even if your application merely reads rows, so it is still important to commit read-only units of work. This is because shared locks are acquired by repeatable read, read stability, and cursor stability isolation levels in read-only applications. With repeatable read and read stability, all locks are held until a COMMIT is issued, preventing other processes from updating the locked data, unless you close your cursor using the WITH RELEASE clause. In addition, catalog locks are acquired even in uncommitted read applications using dynamic SQL or XQuery statements.”
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin.perf.doc/doc/c0005276.html
IBM DB2 does not have rollback segments and thus requires read locks to provide read consistency
下一篇:危险的Alter User权限
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
DB2日常运维命令linux sql Database db2
-
SQL Server 账号管理1
SQL Server 账号管理主要包含登录名、用户、架构、角色等管理。通过对账号的管理可以有效的提高数据库系统的安全性,规范运维及使用。注意:登录名是实例下的安全对象,用户、架构及角色是数据库下的安全对象
登录名 用户名 数据库级的主体 SQL Server 级的主体 安全对象 -
ORACLE VS DB2
1、创建PROCEDURE的参数的区别 1)参数类型和参数名称的位置不同 db2: CREATE PROCEDURE PRO1 (IN
ORACLE 职场 db2 Oracle 休闲 -
DB2 HADR VS ORACLE RAC
DB2 HADR VS ORACLE RAC DB2 HADR compare to ORACLE RAC 一、 故障恢复切换机制的比较 1.
DB2 Oracle 配置管理 Linux 数据结构 -
Oracle MYSQL DB2 sql分页
Oracle MYSQL DB2 sql分页Oracle, MYSQL, DB2, sql, rtI
db2 oracle sql mysql sql server