SELECT P.SPID,A.SERIAL#,C.OBJECT_NAME,B.SESSION_ID,B.ORACLE_USERNAME,B.OS_USER_NAME
FROM V$PROCESS P,V$SESSION A,V$LOCKED_OBJECT B,ALL_OBJECTS C
WHERE P.ADDR = A.PADDR AND A.PROCESS = B.PROCESS AND C.OBJECT_ID = B.OBJECT_ID;
FROM V$PROCESS P,V$SESSION A,V$LOCKED_OBJECT B,ALL_OBJECTS C
WHERE P.ADDR = A.PADDR AND A.PROCESS = B.PROCESS AND C.OBJECT_ID = B.OBJECT_ID;