-- Get the executing SQL query that has locked the DB objects 

SELECT   -- s.*,
     s.osuser
    ,TO_CHAR(s.logon_time,'mm/dd/yyyy hh24:mi:ss') logon_time,  
    ,ao.object_name
    ,s.sid
    ,p.psid
    ,s.serial#
    ,s.status ,s.machine ,s.port ,s.program
    ,q.sql_fulltext
FROM  all_objects ao
     ,gv$locked_object lo
     ,gv$session s
     ,gv$process p
     ,gv$sql q
WHERE  lo.object_id = ao.object_id
AND    lo.session_id = s.sid
AND    s.paddr = p.addr
AND    s.sql_address = q.address
;