oracle查詢鎖表:oracle查詢是否鎖表[朗讀]

--查看被鎖的表selectb.owner,b.object_name,a.session_id,a.locked_modefromv$locked_objecta,dba_objectsbwhereb.object_id=a.object_id;--查看那個用戶那個進程照成死鎖selectb.username,b.sid,b.serial#,logon_timefromv$locked_objecta,v$sessionbwherea.session_id=b.sidorderbyb.logon_time;