摘要： 1.查询死锁的进程(下面2条语句均可用)语句1：select sess.sid, sess.serial#, lo.oracle_username, lo.os_user_name, ao.object_name, lo.locked_mode from v$locked_object lo, dba_objects ao, v$session sesswhere ... 阅读全文

摘要： select name from v$db_object_cache where locks > 0 and pins > 0 and type='PROCEDURE'; 阅读全文