查看oracle的事务级别

SYS@moe65 SQL>delete from scott.emp;14 rows deleted.SYS@moe65 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 COMMITTEDSYS@moe65 SQL>rollback;Rollback complete.SYS@moe65 SQL>exit