数据字典表之：DBA_HIGH_WATER_MARK_STATISTICS

CREATE OR REPLACE FORCE VIEW SYS.dba_high_water_mark_statistics (dbid,

                                                                NAME,

                                                                VERSION,

                                                                highwater,

                                                                LAST_VALUE,

                                                                description

                                                                )

AS

  SELECT dbid, hwm.NAME, VERSION, highwater, LAST_VALUE, description

    FROM wri$_dbu_high_water_mark hwm, wri$_dbu_hwm_metadata mt

    WHERE hwm.NAME = mt.NAME

      AND hwm.NAME NOT LIKE '_HWM_TEST%'

      AND                                            /* filter out test hwm */

          BITAND (mt.method, 4) != 4            /* filter out disabled hwm */

                                    ;

COMMENT ON TABLE SYS.DBA_HIGH_WATER_MARK_STATISTICS IS 'Database High Water Mark Statistics';



COMMENT ON COLUMN SYS.DBA_HIGH_WATER_MARK_STATISTICS.DBID IS 'database ID';



COMMENT ON COLUMN SYS.DBA_HIGH_WATER_MARK_STATISTICS.NAME IS 'name of high water mark statistics';



COMMENT ON COLUMN SYS.DBA_HIGH_WATER_MARK_STATISTICS.VERSION IS 'the database version the highwater marks are tracked in';



COMMENT ON COLUMN SYS.DBA_HIGH_WATER_MARK_STATISTICS.HIGHWATER IS 'highest value for statistic seen at sampling time';



COMMENT ON COLUMN SYS.DBA_HIGH_WATER_MARK_STATISTICS.LAST_VALUE IS 'value of statistic at last sample time';



COMMENT ON COLUMN SYS.DBA_HIGH_WATER_MARK_STATISTICS.DESCRIPTION IS 'description of high water mark';





DROP PUBLIC SYNONYM DBA_HIGH_WATER_MARK_STATISTICS;



CREATE PUBLIC SYNONYM DBA_HIGH_WATER_MARK_STATISTICS FOR SYS.DBA_HIGH_WATER_MARK_STATISTICS;





GRANT SELECT ON SYS.DBA_HIGH_WATER_MARK_STATISTICS TO SELECT_CATALOG_ROLE;