select c.sid, c.serial#, f.spid as osprocess, c.username, a.object_id, b.object_name, c.program, c.status, d.name, c.osuser,
e.sql_text, DBMS_ROWID.ROWID_CREATE(1, c.ROW_WAIT_OBJ#, c.ROW_WAIT_FILE#, c.ROW_WAIT_BLOCK#, c.ROW_WAIT_ROW# ) locked_rowid
from v$Locked_object a, All_objects b, v$session c, audit_actions d, v$sqlarea e, v$process f
where a.object_id=b.data_object_id
and a.session_id =c.sid(+)
and c.command=d.action
and c.row_wait_obj# != -1
and c.sql_id=e.sql_id
and c.paddr = f.addr;