设置事务

iteye_7135

于 2010-07-25 12:16:06 发布

阅读量138

点赞数

CC 4.0 BY-SA版权

分类专栏： db

本文链接：https://blog.youkuaiyun.com/iteye_7135/article/details/81896069

db 专栏收录该内容

16 篇文章

订阅专栏




set transaction isolation level read committed;
set transaction isolation level serializable;
rollback;
set transaction isolation level serializable;
rollback;
set transaction read only;
rollback;
begin
  set transaction read only;
  rollback;
end;
/
--exec dbms_transaction.read_only;
alter session set isolation_level=serializable;
rollback;
alter session set isolation_level=read committed;
begin
  execute immediate 'alter session set isolation_level=serializable';
end;
/
rollback;

ALTER SESSION SET isolation_level 与 SET TRANSACTION ISOLATION LEVEL 区别
1: set transaction readonly只能设置SERIALIZABLE | READ COMMITTED
    而ALTER SESSION SET isolation_level 可以设置任何事务

2:SET TRANSACTION ISOLATION LEVEL 设置的事务在rollback 或commit 后，就恢复到默认read COMMIT
而ALTER SESSION SET是在会话级别 有效

设置事务只能在事务语句的第一句