oracle 특정 테이블 lock 확인

SELECT 
       A.SID,
       A.SERIAL#,
       A.MACHINE,
       B.TYPE,
       C.OWNER,
       C.OBJECT_NAME
 FROM 
       V$SESSION A, V$LOCK B, DBA_OBJECTS C
WHERE
              A.SID = B.SID
       AND B.ID1 = C.OBJECT_ID
       --AND A.USERNAME = '세션유저'
       AND B.TYPE = 'TM'
       AND C.OWNER ='소유자'
       AND C.OBJECT_NAME = '테이블명';