Doc

Name: ROLL_STAT.sql

Author: Mahnho Han

If the value is > 1%, add more rollback segment

#

select n.name,round(100*s.waits/s.gets) "%Cont"

from v$rollname n,v$rollstat s

where n.usn = s.usn;