Re: Who's sorting ?

From: Vitaliy Mogilevskiy <vit100gain_at_earthlink.net>
Date: Tue, 16 Feb 1999 17:12:25 -0800
Message-ID: <36CA1779.9EFC9ECD@earthlink.net>

Or you can RUN this script:

rem -----------------------------------------------------------------------

rem Filename: acttrx.sql
rem Purpose: Shows active (in progress) transactions

rem Date:       12-Apr-1998
rem Author:     Frank Naude (frank_at_onwe.co.za)
rem -----------------------------------------------------------------------

col name format a8
col username format a8
col osuser format a8
col start_time format a17
col status format a12
tti 'Active transactions'

select username, terminal, osuser,

       t.start_time, r.name, t.used_ublk "ROLLB BLKS",
       decode(t.space, 'YES', 'SPACE TX',
          decode(t.recursive, 'YES', 'RECURSIVE TX',
             decode(t.noundo, 'YES', 'NO UNDO TX', t.status)
       )) status

from sys.v_$transaction t, sys.v_$rollname r, sys.v_$session s where t.xidusn = r.usn
  and t.ses_addr = s.saddr
/

Vitaliy Mogilevskiy Received on Tue Feb 16 1999 - 19:12:25 CST