以下脚本可以用于收集 11gR2中 RAC DRM 动态资源管理 特性的诊断信息:
REM for 11.2 only
REM written by Maclean.Liu
set linesize 140 pagesize 1400
select DRMS, AVG_DRM_TIME, QUIESCE_T,FRZ_T,CLEANUP_T,REPLAY_T,FIXWRITE_T,SYNC_T from X$KJDRMAFNSTATS
/
select * from GV$DYNAMIC_REMASTER_STATS
/
select object, node, sopens, xopens, xfers
from x$object_policy_statistics
-- where object=&object_id
/
select data_object_id, current_master, previous_master, remaster_cnt from gv$gcspfmaster_info
/
select * from gv$policy_history
-- where object=&object_id
order by EVENT_DATE
/
select name, value
from v$sysstat
where name in ('gc local grants',
'gc remote grants')
/
