Re: understanding rollback segments

From: Phil Cook <pcook_at_iamerica.net>
Date: 1997/04/23
Message-ID: <01bc4ffb$b896afc0$93f9adcd@cookp.mo.chaparralsteel.com>#1/1

Dave,

The inserts into foo may be causing the rollback segment to run out of extents, look at v$rollstat and v$rollname for extents, wraps, and extends. Look at dba_rollback_segs for the max extents.

This query may help to see what rollback segment you are using and it's stats.....

select t.start_time, u.usename,r.name,s.wraps,s.extends,s.extents from v$transaction t, v$rollstat s, v$rollname r, v$session u where r.usn = s.usn and s.usn = t.xidusn and t.status = 'ACTIVE' and u.taddr = t.addr

Phil Cook

Dave Wotton <Dave.Wotton_at_it.camcnty.gov.uk> wrote in article <5jkuhe$o9g_at_dns.camcnty.gov.uk>...
>
> hi all,
>
> I thought I understood how rollback segments worked, but now I'm not
> sure. Can someone explain what is happening here...
>
Received on Wed Apr 23 1997 - 00:00:00 CDT