www.eygle.com

« 数据字典表之：DBA_TABLES | Blog首页 | Oracle Wait Events:Data file init write »

数据字典表之：DBA_HIGH_WATER_MARK_STATISTICS

作者：eygle |【转载时请以超链接形式标明文章出处和作者信息及本声明】
链接：http://www.eygle.com/archives/2008/04/dba_high_water_mark_statistics.html

---

DBA_HIGH_WATER_MARK_STATISTICS是在Oracle10g中引入的。
其中记录了数据库相关的一些HWM数据，包括数据库的空间使用，会话数量，表数量等

以下是这个视图的创建过程，数据来自Oracle10g 10.2.0.3

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;

By eygle on 2008-04-09 23:47 | Comments (0) | Posted to Knowledge Base | Edit |

相关文章	随机文章
数据字典视图之：v$dlm_traffic_controller 数据字典视图之：V$LOCK_ELEMENT 结构 数据字典表之：DBA_TABLES 数据字典视图之:V$LATCH_CHILDREN 结构 数据字典视图之:V$LATCH、X$KSLLT、X$KSLLD 结构	Use Nid to Change dbname-NID的用法 新生以及将生 等待以及期待 cursor_space_for_time参数在11.1.0.7中 明日将参加Oracle公司组织的DBA Round Table活动 决心修订《深入浅出Oracle》一书

留言 (0)

发表留言:

Name(*):
Email(*):

You Link: Remember Me? YesNo
验证码(*): (输入验证码后方可评论,谢谢支持)
Comments: