Re: v$rollstat

From: srivenu <srivenu_at_hotmail.com>
Date: 1 Jun 2004 22:33:02 -0700
Message-ID: <1a68177.0406012133.4372d6aa@posting.google.com>

You can use this SQL
select segment_name,b.status,xacts,extents,b.rssize/1048576 rssize,aveactive/1048576 aveactive,

hwmsize/1048576 hwmsize,optsize/1048576 optsize,aveshrink/1048576 aveshrink,

gets,waits,extends,shrinks
from dba_rollback_segs a,v$rollstat b
where a.segment_id=b.usn(+)
order by 1
/

To find out dead transactions which are being cleaned out, you can use this SQL

set echo off

col ktuxeusn head "RBS|No" form 999
col ktuxeslt head "RBS|Slot" form 9999999
col ktuxesqn head "RBS|Wrap" form 9999999

select ktuxeusn,ktuxeslt,ktuxesqn,ktuxesiz from x$ktuxe
where ktuxecfl='DEAD'
/

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