Re: v$rollstat

From: srivenu <srivenu_at_hotmail.com>
Date: 1 Jun 2004 22:34:19 -0700
Message-ID: <1a68177.0406012134.69d68196@posting.google.com>

sorry,
i gave the first SQL wrong.

col sid head "Sid" form 9999 trunc
col username head "Username" form a8 trunc col osuser head "OS User" form a7 trunc
col start_time head "Start Time" form a20 col name head "Undo|Segment" form a10
col used_ublk head "Undo|Blocks|Used" form 999999999 col used_urec head "Undo|Records" form 999999999

select s.sid,s.username,s.osuser,t.start_time,

r.name,t.xidusn,t.used_ublk,t.used_urec from v$session s,v$transaction t,v$rollname r where s.taddr=t.addr
and t.xidusn=r.usn
order by 1
/

regards
Srivenu Received on Wed Jun 02 2004 - 00:34:19 CDT