# 我當(dāng)前自動(dòng)提交設(shè)置為OFF，即默認(rèn)不自動(dòng)提交
SYS@helowin>show autocommit;
autocommit OFF

# 可通過(guò)set命令，選擇是否開(kāi)啟自動(dòng)提交事務(wù)
SYS@helowin>set auto
SP2-0281: autocommit missing set option
Usage: SET AUTO[COMMIT] { OFF | ON | IMM[EDIATE] | n }

SYS@helowin>select * from zxy.study;

        ID NAME                 TESTTIME
---------- -------------------- --------------------------------------------------
         1 a                    2022-09-26

# 在終端一模擬插入一條數(shù)據(jù)，不commit
SYS@helowin>insert into zxy.study values(2,'b','2022-09-26');

1 row created.
# 發(fā)現(xiàn)在當(dāng)前終端中可以查到數(shù)據(jù)
# 在事務(wù)提交之前，只有操作數(shù)據(jù)庫(kù)的這個(gè)人才能看到所做的事，別人只能等待提交后才可以
SYS@helowin>select * from zxy.study;

        ID NAME                 TESTTIME
---------- -------------------- --------------------------------------------------
         2 b                    2022-09-26
         1 a                    2022-09-26

# 在終端二中不能查到數(shù)據(jù)
SYS@helowin>select * from zxy.study;

        ID NAME                 TESTTIME
---------- -------------------- --------------------------------------------------
         1 a                    2022-09-26

SYS@helowin>commit;

Commit complete.

SYS@helowin>select * from zxy.study;

        ID NAME                 TESTTIME
---------- -------------------- --------------------------------------------------
         2 b                    2022-09-26
         1 a                    2022-09-26

SYS@helowin>select * from zxy.study;

        ID NAME                 TESTTIME
---------- -------------------- --------------------------------------------------
         2 b                    2022-09-26
         1 a                    2022-09-26

SYS@helowin>insert into zxy.study values(3,'c','2022-09-26');

1 row created.

SYS@helowin>select * from zxy.study;

        ID NAME                 TESTTIME
---------- -------------------- --------------------------------------------------
         2 b                    2022-09-26
         3 c                    2022-09-26
         1 a                    2022-09-26

select sess.sid,
sess.serial#,
lo.oracle_username,
lo.os_user_name,
ao.object_name,
lo.locked_mode
from v$locked_object lo, dba_objects ao, v$session sess
where ao.object_id = lo.object_id
and lo.session_id = sess.sid;

alter system kill session 'sid,serial#';