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;