oracle 设置事务级别,查看oracle的事务级别

[email protected] SQL>delete from scott.emp;

14 rows deleted.

[email protected] SQL>SELECT s.sid, s.serial#,

2     CASE BITAND(t.flag, POWER(2, 28))

3        WHEN 0 THEN ‘READ COMMITTED‘

4        ELSE ‘SERIALIZABLE‘

5     END AS isolation_level

6  FROM v$transaction t

7  JOIN v$session s ON t.addr = s.taddr AND s.sid = sys_context(‘USERENV‘, ‘SID‘);

SID    SERIAL# ISOLATION_LEVE

---------- ---------- --------------

149         61 READ COMMITTED

[email protected] SQL>rollback;

Rollback complete.

[email protected] SQL>exit

原文：http://qhd2004.blog.51cto.com/629417/1543193