doc

    Name:   rollstat.sql

    Author: Mark Gurry


The following script lists the number of waits for each rollback segment
as well as the number of gets and active transactions using the rollback
segment.

#


select usn "Rollback Table", Gets, Waits , xacts "Active Transactions" 
 from v$rollstat;