查看oracle被锁对象

一个字不用改,直接执行就可以得到被锁的对象

SELECT A.OWNER,                 
A.xzdm,                    
B.XIDUSN,                         
B.XIDSLOT,                        
B.XIDSQN,                         
B.SESSION_ID,                     
B.ORACLE_USERNAME,                
B.OS_USER_NAME,                   
B.PROCESS,                        
B.LOCKED_MODE,                    
C.MACHINE,                        
C.STATUS,                         
C.SERVER,                         
C.SID,                            
C.SERIAL#,                        
C.PROGRAM                         
FROM ALL_OBJECTS A,               
V$LOCKED_OBJECT B,                
SYS.GV_$SESSION C                 
WHERE ( A.OBJECT_ID = B.OBJECT_ID )
AND (B.PROCESS = C.PROCESS )      
ORDER BY 1,2;