SELECT OBJECT_NAME, MACHINE, S.SID, S.SERIAL#, L.ORACLE_USERNAME, L.OS_USER_NAME, S.SQL_EXEC_START
FROM GV$LOCKED_OBJECT L, DBA_OBJECTS O, GV$SESSION S
WHERE L.OBJECT_ID = O.OBJECT_ID
AND L.SESSION_ID = S.SID
ORDER BY OBJECT_NAME, MACHINE;
SELECT * FROM GV$SESSION WHERE SID = 2848;
SELECT * FROM GV$SQL WHERE SQL_ID = 'bajspnur2apn1';
alter system kill session '237, 11823';