Show High Water Marks
-- -- List High Water Mark Stats for Database Components. -- SET PAUSE ON SET PAUSE 'Press Return to Continue' SET HEADING ON SET LINESIZE 300 SET PAGESIZE 60 COLUMN name FORMAT A20 COLUMN highwater FORMAT 999,999,999,999 COLUMN last_value FORMAT 999,999,999,999 SELECT hwm1.name, hwm1.highwater, hwm1.last_value FROM dba_high_water_mark_statistics hwm1 WHERE hwm1.version = (SELECT MAX(hwm2.version) FROM dba_high_water_mark_statistics hwm2 WHERE hwm2.name = hwm1.name) ORDER BY hwm1.name /