SELECT substr(A.SESSION_ID,1,5) SID, substr(C.SERIAL#,1,5) SERIAL#, substr(B.OBJECT_NAME,1,25) OBJ_NAME, C.STATUS, C.USERNAME, c.action, C.USER#, A.LOCKED_MODE ,c.* FROM DBA_OBJECTS B, V$SESSION C, V$LOCKED_OBJECT A WHERE A.OBJECT_ID = B.OBJECT_ID AND B.OBJECT_NAME like '%AP%' AND c.client_info like '%142%%' --OU_ID:就是指所在企业的OU的ID AND C.SID = A.SESSION_ID; alter system kill session 'sid,serial#';