« 数据字典表之:DBA_TABLES | Blog首页 | Oracle Wait Events:Data file init write »
数据字典表之:DBA_HIGH_WATER_MARK_STATISTICS
作者:eygle | 【转载请注出处】|【云和恩墨 领先的zData数据库一体机 | zCloud PaaS云管平台 | SQM SQL审核平台 | ZDBM 数据库备份一体机】
链接:https://www.eygle.com/archives/2008/04/dba_high_water_mark_statistics.html
DBA_HIGH_WATER_MARK_STATISTICS是在Oracle10g中引入的。链接:https://www.eygle.com/archives/2008/04/dba_high_water_mark_statistics.html
其中记录了数据库相关的一些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;
历史上的今天...
>> 2016-04-09文章:
>> 2013-04-09文章:
>> 2012-04-09文章:
>> 2009-04-09文章:
>> 2006-04-09文章:
By eygle on 2008-04-09 23:47 | Comments (0) | FAQ | 1921 |