查询锁等待的时间，被锁对象，SID等信息语句(参考OEM);

来源：互联网发布：淘宝店铺添加背景音乐编辑：程序博客网时间：2024/05/04 20:43

select a.sid,a.serial#,a.status,a.last_call_et,b.type,d.OWNER,d.OBJECT_NAME,d.OBJECT_TYPE
from v$session a,v$lock b,v$locked_object c,dba_objects d
where a.sid=b.sid

and b.sid=c.session_id

and c.object_id=d.object_id

-----------------------------------------

结果:

SIDSERIAL#STATUSLAST_CALL_ETTYPEOWNEROBJECT_NAMEOBJECT_TYPE20209353938INACTIVE112832TMINFORES_TESTT_WORK_SHEETTABLE21209353938INACTIVE112832TMINFORES_TESTT_WORK_SHEETTABLE18324936025ACTIVE112832TXINFORES_TESTT_WORK_SHEETTABLE19324936025ACTIVE112832TMINFORES_TESTT_WORK_SHEETTABLE2209353938INACTIVE112832TMINFORES_TESTSYS_RES_OPERLOGTABLE1209353938INACTIVE112832TMINFORES_TESTSYS_RES_OPERLOGTABLE22209353938INACTIVE112832TXINFORES_TESTT_WORK_SHEETTABLE3209353938INACTIVE112832TXINFORES_TESTSYS_RES_OPERLOGTABLE14206757185ACTIVE112821TXINFORES_TESTT_WORK_SHEETTABLE15206757185ACTIVE112821TMINFORES_TESTT_WORK_SHEETTABLE13242848472ACTIVE112761TMINFORES_TESTT_WORK_SHEETTABLE16187817803ACTIVE112761TXINFORES_TESTT_WORK_SHEETTABLE17187817803ACTIVE112761TMINFORES_TESTT_WORK_SHEETTABLE12242848472ACTIVE112761TXINFORES_TESTT_WORK_SHEETTABLE11206813259ACTIVE112461TMINFORES_TESTT_WORK_SHEETTABLE10206813259ACTIVE112461TXINFORES_TESTT_WORK_SHEETTABLE824458181ACTIVE110657TXINFORES_TESTT_WORK_SHEETTABLE924458181ACTIVE110657TMINFORES_TESTT_WORK_SHEETTABLE5283230092ACTIVE79577TMINFORES_TESTT_WORK_SHEETTABLE4283230092ACTIVE79577TXINFORES_TESTT_WORK_SHEETTABLE7231564594ACTIVE67456TMINFORES_TESTT_WORK_SHEETTABLE6231564594ACTIVE67456TXINFORES_TESTT_WORK_SHEETTABLE25266129720INACTIVE45TXMETADATACMS_FRONTIER5TABLE24266129720INACTIVE45TMMETADATACMS_FRONTIER5TABLE23266129720INACTIVE45TOMETADATACMS_FRONTIER5TABLE28228439937ACTIVE38TXRMGZ_KFINTF_GG_SYNCLOGTABLE27228439937ACTIVE38TMRMGZ_KFINTF_GG_SYNCLOGTABLE26228439937ACTIVE38JQRMGZ_KFINTF_GG_SYNCLOGTABLE