ITPub博客

首页 > 数字化转型 > ERP > Set the Isolation Level (318)

Set the Isolation Level (318)

原创 ERP 作者:tsinglee 时间:2007-12-06 12:13:00 0 删除 编辑

Application designers, application developers, and database administrators can
choose appropriate isolation levels for different transactions, depending on the
application and workload. You can set the isolation level of a transaction by using one
of these statements at the beginning of a transaction:
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SET TRANSACTION READ ONLY;
To save the networking and processing cost of beginning each transaction with a SET
TRANSACTION statement, you can use the ALTER SESSION statement to set the
transaction isolation level for all subsequent transactions:
ALTER SESSION SET ISOLATION_LEVEL SERIALIZABLE;
ALTER SESSION SET ISOLATION_LEVEL READ COMMITTED;

设置隔离级别
1. 设定事务的隔离级别 : set transactions isolation level ...
2. 使用 ALTER SESSION 语句设置一个会话所有内事务的默认隔离级别 ,
来减少网络和处理的开销

[@more@]

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

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892897