1.
SELECT t2.username, t2.SID, t2.serial#, t2.logon_time
FROM v$locked_object t1, v$session t2
WHERE t1.session_id = t2.SID
ORDER BY t2.logon_time;
2.
SELECT sql_text
FROM v$session a, v$sqltext_with_newlines b
WHERE DECODE (a.sql_hash_value, 0, prev_hash_value, sql_hash_value) =
b.hash_value
AND a.SID = &sid
ORDER BY piece;
3.ALTER SYSTEM KILL SESSION 'SID, serial#';