active_tx.sql
Download Script
REM Name: active_tx.sql
REM Purpose: Tells us what user processes are using a particular r/s
REM History: 21 June 1995 rhardcas Created
col saddr for 99999999
col sid for 9999
col serial# for 9999999
col username for a10
col command for 9999999
col status for a10
col osuser for a10
col process for 9999999
set pages 100
select s.saddr,s.sid,s.serial#,s.username,s.command,s.status,s.osuser,s.process
from v$session s, v$transaction t
where t.xidusn=&rs_number
and t.addr=s.taddr;
