Oracle Database

--
--  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
/