isolation_level

来源：互联网发布：网络游戏编程编辑：程序博客网时间：2024/06/05 20:12

今天在一qq群里学到查isolation_level状态的语句

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as test@192.168.1.118:1521/orclSQL> SQL> alter session set isolation_level=read committed;Session alteredSQL> update dept set  loc='SHANGHAI' where deptno=30;1 row updatedSQL> select sid,  2         serial#,  3         flag,  4         CASE  5           WHEN BITAND(t.flag, POWER(2, 28)) = 0 THEN  6            'READ COMMITTED'  7           ELSE  8            'SERIALIZABLE'  9         END AS ISOLATIONLEVEL 10    from V$transaction t, v$session s 11   where t.addr = s.taddr 12     AND audsid = USERENV('SESSIONID');       SID    SERIAL#       FLAG ISOLATIONLEVEL---------- ---------- ---------- --------------       149         50       7683 READ COMMITTED

SQL> alter session set isolation_level=serializable;Session alteredSQL> update dept set loc='CHENGDU' where deptno=30;1 row updatedSQL> select sid,  2         serial#,  3         flag,  4         CASE  5           WHEN BITAND(t.flag, POWER(2, 28)) = 0 THEN  6            'READ COMMITTED'  7           ELSE  8            'SERIALIZABLE'  9         END AS ISOLATIONLEVEL 10    from V$transaction t, v$session s 11   where t.addr = s.taddr 12     AND audsid = USERENV('SESSIONID');       SID    SERIAL#       FLAG ISOLATIONLEVEL---------- ---------- ---------- --------------        20         66  268443139 SERIALIZABLE