Check Locked Objects

SELECT *  FROM v$locked_object A,all_objects B WHERE a.OBJECT_ID = b.object_id

SELECT * FROM v$session WHERE SID = 'XXX'
ALTER SYSTEM KILL SESSION 'SIS,SERIAL#'
SELECT
b.action,
c.object_name,
c.object_type,
b.SID,
b.serial#,
c.owner,
c.object_name,
c.object_type,
b.SID,
b.serial#,
b.status,
b.osuser,
b.machine
FROM
v$locked_object a ,
v$session b,
dba_objects c
WHERE
b.SID = a.session_id
AND
a.object_id = c.object_id
and object_name like '%XX%';

SELECT
b.action,
--c.object_name,
--c.object_type,
b.SID,
b.serial#,
--c.owner,
--c.object_name,
--c.object_type,
b.SID,
b.serial#,
b.status,
b.osuser,
b.machine
FROM
--v$locked_object a ,
v$session b
where action like 'FRM%'
--dba_objects c
--WHERE
--b.SID = a.session_id
AND
a.object_id = c.object_id