Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

0

好友

14

主题
1#
发表于 2013-1-28 09:07:52 | 查看: 4244| 回复: 2
OEM : 12.1.0.2
Target: 10.2.0.4 rac

最近刚添加rac 数据库为监控对象,设置邮件提醒,老是收到如下警告:

EM Event: Critical:test_dingcan_INST1 - Metrics "Global Cache Average Current Get Time" is at 2.125
EM Event: Critical:bfsty_crs_bfsty1 - Metrics "Global Cache Average CR Get Time" is at 1.256

查阅文档:
http://docs.oracle.com/cd/E24628_01/em.121/e25160/oracle_database.htm#autoId140

没有完全匹配的解释,现有2个问题:

1.这2个参数值应该怎么理解?是否是说明2节点之间通信有问题?

2.现在这个告警的值是否在正常范围之内?几乎所有添加的rac数据库都会收到这个警告?如果是正常范围,我应该把metric调整到多少适合?
2#
发表于 2013-1-28 10:02:25
补一个邮件提醒全部内容:

Categories=Performance
Message=Metrics "Global Cache Average CR Get Time" is at 13.421
Severity=Critical
Event reported time=Jan 28, 2013 7:47:27 AM CST
Operating System=Linux
Platform=x86_64
Associated Incident Id=1166
Associated Incident Status=New
Associated Incident Owner=
Associated Incident Acknowledged By Owner=No
Associated Incident Priority=None
Associated Incident Escalation Level=0
Event Type=Metric Alert
Event name=rac_global_cache:cr_request_cs
Metric Group=Global Cache Statistics
Metric=Global Cache Average CR Block Request Time (centi-seconds)
Metric value=13.4210526315789
Key Value=SYSTEM
Rule Name=DEFAULT_RULESET_FOR_ALL_TARGETS,METRIC_ALERT_INCIDENT_CREATION
Rule Owner=
Update Details:
Metrics "Global Cache Average CR Get Time" is at 13.421
Incident created by rule (Name = Incident management Ruleset for all targets, Incident creation Rule for metric alerts.; Owner = ).

回复 只看该作者 道具 举报

3#
发表于 2013-1-28 14:26:11
只是2个 Global Cache 的metric度量, 这个问题本身就在哪里, 只不过EM告诉你这一点。

如果觉得DB有性能问题那么值得去看一下AWR和其他performance trend。

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 06:49 , Processed in 0.044679 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569