doc

    Name:   rolbwait.sql

    Author: Mark Gurry


The following script lists the number of waits for the rollback segment
header (undo header) and the rollback segment blocks.

#


SELECT CLASS, COUNT 
  FROM V$WAITSTAT
 WHERE CLASS IN  ('undo header', 'undo block');