doc

   Name:    shrink.sql

   Author:  Mark Gurry

   This script lists how many times rollback segments have shrunk 
   and expanded. The shrinking occurs when you have set the OPTIMAL
   option when you have first created your rollback segments. 

#

SELECT usn, extends, shrinks, hwmsize, aveshrink
  FROM v$rollstat;
  