oracle 锁表查询

先查看哪些表被锁住了

select b.owner,b.object_name,a.session_id,a.locked_mode
from v$locked_object a,dba_objects b
where b.object_id = a.object_id
and object_name ='HDM_COMPLETED_RATE';


OWNER                          OBJECT_NAME                                 SESSION_ID LOCKED_MODE
------------------------------ --------------------------------------      -------
WSSB                           SBDA_PSHPFTDT                               22           3
WSSB_RTREPOS                   WB_RT_SERVICE_QUEUE_TAB                     24           2
WSSB_RTREPOS                   WB_RT_NOTIFY_QUEUE_TAB                      29           2
WSSB_RTREPOS                   WB_RT_NOTIFY_QUEUE_TAB                      39           2
WSSB                           SBDA_PSDBDT                                 47           3
WSSB_RTREPOS                   WB_RT_AUDIT_DETAIL                          47           3

 

select b.username,b.sid,b.serial#,logon_time 
from v$locked_object a,v$session b
where a.session_id = b.sid and sid in(
select a.SESSION_ID
from v$locked_object a,dba_objects b
where b.object_id = a.object_id
and object_name ='HDM_COMPLETED_RATE') order by b.logon_time

 

USERNAME                              SID    SERIAL# LOGON_TIME