实时性要求很高吗?
1分钟也太快了一点
给你几个监控脚本:
-- 列出物化视图属性
SET LINESIZE 200
COLUMN MVIEW_NAME HEADING 'Materialized|View Name' FORMAT A15
COLUMN OWNER HEADING 'Owner' FORMAT A10
COLUMN REFRESH_METHOD HEADING 'Refresh|Method' FORMAT A10
COLUMN UPDATABLE HEADING 'Updatable?' FORMAT A10
COLUMN LAST_REFRESH_DATE HEADING 'Last|Refresh|Date' FORMAT A20
COLUMN LAST_REFRESH_TYPE HEADING 'Last|Refresh|Type' FORMAT A15
SELECT MVIEW_NAME,
OWNER,
REFRESH_METHOD,
UPDATABLE,
to_char(LAST_REFRESH_DATE, 'yyyymmdd hh24:mi:ss') LAST_REFRESH_DATE,
LAST_REFRESH_TYPE
FROM DBA_MVIEWS
ORDER BY LAST_REFRESH_DATE
/
-- 1.4.5Listing Information About the Refresh Groups at a Materialized View Site
-- 列出物化视图站点上刷新组的信息
COLUMN RNAME HEADING 'Refresh|Group|Name' FORMAT A10
COLUMN ROWNER HEADING 'Refresh|Group|Owner' FORMAT A10
COLUMN BROKEN HEADING 'Broken?' FORMAT A7
COLUMN next_refresh HEADING 'Next Refresh'
COLUMN INTERVAL HEADING 'Interval' FORMAT A20
SELECT RNAME,
ROWNER,
BROKEN,
TO_CHAR(NEXT_DATE, 'DD-MON-YYYY HH:MI:SS AM') next_refresh,
INTERVAL
FROM DBA_REFRESH
ORDER BY 1
/
-- 列出当前正在刷新的物化视图
COLUMN SID HEADING 'Session|Identifier' FORMAT 9999
COLUMN SERIAL# HEADING 'Serial|Number' FORMAT 999999
COLUMN CURRMVOWNER HEADING 'Owner' FORMAT A15
COLUMN CURRMVNAME HEADING 'Materialized|View' FORMAT A25
SELECT * FROM V$MVREFRESH
/
btw:用oem来对job进行可视化监控是个不错的选择.
|