GV$LOCKED_OBJECT

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';