SELECT class, count(*)
FROM   v$waitstat
WHERE  class in ('system undo header', 'system undo block',
                 'undo header',        'undo block')
