MSSQL与Oracle数据库事务隔离级别与锁机制对比(2)
七，附 查看锁 ORACLE： select object_name,session_id,os_user_name,oracle_username,process,locked_mode,statusfrom v$locked_object l, all_objects awhere l.object_id=a.object_id; MS_SQL： EXEC SP
七，附
查看锁
ORACLE：
select object_name,session_id,os_user_name,oracle_username,process,locked_mode,status from v$locked_object l, all_objects a where l.object_id=a.object_id;
MS_SQL：
EXEC SP_LOCK
精彩图集
精彩文章