select a.sid,a.serial#,a.status,a.last_call_et,b.type,d.OWNER,d.OBJECT_NAME,d.OBJECT_TYPE
from dba_objects d,v$session a,v$lock b,v$locked_object c
where a.sid=b.sid
and b.sid=c.session_id
and c.object_id=d.object_id
and b.type='TX'
and a.status='INACTIVE'
and a.last_call_et>600
union all
select a.sid,a.serial#,a.status,a.last_call_et,b.type,d.OWNER,d.OBJECT_NAME,d.OBJECT_TYPE
from dba_objects@dblink d,v$session@dblink a,v$lock@dblink b,v$locked_object@dblink c
where a.sid=b.sid
and b.sid=c.session_id
and c.object_id=d.object_id
and b.type='TX'
and a.status='INACTIVE'
and a.last_call_et>600
from dba_objects d,v$session a,v$lock b,v$locked_object c
where a.sid=b.sid
and b.sid=c.session_id
and c.object_id=d.object_id
and b.type='TX'
and a.status='INACTIVE'
and a.last_call_et>600
union all
select a.sid,a.serial#,a.status,a.last_call_et,b.type,d.OWNER,d.OBJECT_NAME,d.OBJECT_TYPE
from dba_objects@dblink d,v$session@dblink a,v$lock@dblink b,v$locked_object@dblink c
where a.sid=b.sid
and b.sid=c.session_id
and c.object_id=d.object_id
and b.type='TX'
and a.status='INACTIVE'
and a.last_call_et>600