Re: Which RBS have active transactions?

Terrian, Tom wrote: Does anyone know of a way to determine which RBS extents have active transactions? Specifically: select a.segment_name, a.bytes, a.extents, c.xacts from dba_segments a, dba_rollback_segs b, v$rollstat c where a.segment_type = 'ROLLBACK'

RE: Which RBS have active transactions?

Thanks, I was able to write a script that gets me most of what I want: select a.segment_name, b.start_uext ACTIVE EXENT NUMBER, b.used_ublk USED RBS BLOCKS from dba_rollback_segs a, v$transaction b where a.segment_id = b.xidusn order by