Oracle commit and rollback V$LOCKED_OBJECT查看是否存在未提交的事务
create tabletestlocked(id number,name varchar2(20));
insert intotestlocked values(1,'name1');
select * from V$LOCKED_OBJECT;
commit;
select * fromV$LOCKED_OBJECT;
select * fromtestlocked;
insert intotestlocked values(1,'name1');
select * fromV$LOCKED_OBJECT;
rollback;
select * fromV$LOCKED_OBJECT;
select * fromtestlocked;