原创 查看数据库表的锁情况

查看数据库表的锁情况 select b.object_name ,a.os_user_name ,a.LOCKED_MODE from v$locked_object a ,all_objects b where a.OBJECT_ID = b.object_id; --找到销表object_name 是你操作的表的session_id SELECT  * FROM v$locked