Oracle中被锁的表以及解锁

select * from t_gl_voucher;

update t_dar_deparmonrptstart rpt set rpt.ffivouchered = 0;

---查看被锁的表

SELECT

a.sid, b.owner, object_name, object_type

FROM v$lock a, all_objects b

WHERE TYPE = 'TM'

and a.id1 = b.object_id;

--删除被锁的表

SELECT sid,serial# FROM v$session WHERE sid = &sid;

--alter system kill session 'sid,serial#';

alter system kill session '104,23136';

sqlServer：锁表时会锁住整个表

oracle：对行进行锁定。