Script: 收集RAC DRM 诊断信息

最新推荐文章于 2023-01-31 23:31:07 发布

weixin_30823833

最新推荐文章于 2023-01-31 23:31:07 发布

阅读量62

点赞数

原文链接：http://www.cnblogs.com/macleanoracle/archive/2013/03/19/2968081.html

版权

以下脚本可以用于收集 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')
/

转载于:https://www.cnblogs.com/macleanoracle/archive/2013/03/19/2968081.html