oracle数据库的隔离级别

oracle数据库的默认隔离级别是：read committd

数据库的隔离级别：

SELECT s.sid,
       s.serial#,
       CASE BITAND(t.flag, POWER(2, 28))
         WHEN 0 THEN
          'READ COMMITTED'
         ELSE
          'SERIALIZABLE'
       END AS isolation_level
  FROM v$transaction t
  JOIN v$session s ON t.addr = s.taddr
                  AND s.sid = sys_context('USERENV', 'SID');

修改数据库的隔离级别的方法：

SET TRANSACTION ISOLATION LEVEL [READ UNCOMMITTED|READ COMMITTED|REPEATABLE READ|SERIALIZABLE]