CanonD的博客

原创 解决plsql记录被另外一个用户锁定问题

1、查看数据库锁,诊断锁的来源及类型：select object_id,session_id,locked_mode from v$locked_object;或者用以下命令： select b.owner,b.object_name,l.session_id,l.locked_mode from v$locked_object l, dba_objects b where b.object_id...