设置isolation level隔离级别

SQL> alter session set isolation_level= serializable; Session altered. SQL> delete from t1 where rownum = 1; 1 row deleted. SQL> select flag from v$transaction; FLAG ---------- 268439043 SQL> commit; Commit complete. SQL> alter session set isolation_level = READ COMMITTED; Session altered. SQL> delete from t1 where rownum = 1; 1 row deleted. SQL> select flag from v$transaction; FLAG ---------- 3587