--

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

/