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

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

164

积分

0

好友

16

主题
1#
发表于 2014-8-18 12:13:54 | 查看: 3368| 回复: 5
    请教下各位大神11gr2 rac顶级活动 实时15秒刷新 为什么不会自动刷新,感觉15s会闪一下但时间轴不会动,而进入各个实例的顶级活动的实时15秒刷新才会刷新.
    进入各个实例的顶级活动能正常15s实时刷新,但总的集群顶级活动实时15s反而不会自动刷新.
    换了几台电脑和浏览器都一样.oel5.5+ora11.2.0.2.0二节点rac
2#
发表于 2014-8-18 12:21:20
本帖最后由 lxhbww 于 2014-8-18 14:56 编辑

如图,实时15s刷新,当前时间都为12:16了,监控还停留在12:01重进入时的状态.都放在那边15分钟了.
在几台电脑上用浏览器打开登录都一样。

无标题.png (171.6 KB, 下载次数: 434)

无标题.png

回复 只看该作者 道具 举报

3#
发表于 2014-8-18 23:02:13
ODM FINDING:

Hdr: 10105497 11.2.0.1.0 DB_PERF 11.2.0.1.0 PRODID-1366 PORTID-226 9025758
Abstract: TOP ACTIVITY PAGE FOR RAC DATABASE IS NOT AUTOMATICALLY REFRESHING

*** 09/11/10 06:22 am ***
*** 09/11/10 06:22 am ***
TAR
---

Problem Description
-------------------
11.2.0.1 DB Console. The top activity page is not automatically refreshing
and the graph is not automatically moving forward ("Real time: 15 seconds
refresh" is selected)

Environment Information
-----------------------

Test Case Step-by-Step Instructions
-----------------------------------

Test Case Location
------------------

Diagnostic Analysis
-------------------
The is nothing in emoms.trc logged when the refresh is occuring.

回复 只看该作者 道具 举报

4#
发表于 2014-8-18 23:02:54
ODM FINDING:

Hdr: 12794222 11.1.0.7.0 DB_PERF 11.1.0.7.0 PERF PRODID-1366 PORTID-233 10307099
Abstract: TOP ACTIVITY DOES NOT REFRESH

*** 07/25/11 01:49 am ***
----
3-4099192750

PROBLEM:
--------
The problem is that OEM Top activity screen for an instance of a cluster
database sometimes stop updating. Now this is only on the instance level. At
the cluster level it still updates.

DIAGNOSTIC ANALYSIS:
--------------------
Data is available after the refresh interval is changed to other than "Real
Time 15 seconds".

The page does not refresh after the interval is set to 15 seconds.

WORKAROUND:
-----------
None

RELATED BUGS:
-------------

REPRODUCIBILITY:
----------------
No

TEST CASE:
----------
no

STACK TRACE:
------------

SUPPORTING INFORMATION:
-----------------------
We use OEM extensively to monitor our database because we have a real time
database and application that needs immediate action if something goes wrong.
So if OEM falls behind, we do not get a clear picture of the performance
issues that our clients might experience.

24 HOUR CONTACT INFORMATION FOR P1 BUGS:
----------------------------------------

DIAL-IN INFORMATION:
--------------------

IMPACT DATE:
------------
21-Jul-2011

*** 07/25/11 01:55 am ***
*** 07/25/11 01:55 am ***
*** 07/25/11 01:55 am ***
*** 07/25/11 01:56 am ***
*** 07/25/11 01:56 am ***
*** 07/25/11 01:57 am *** (CHG: Sta->16)
*** 08/22/11 06:35 pm ***
*** 09/01/11 10:14 pm ***
*** 09/12/11 06:51 am ***
*** 10/17/11 09:37 am *** (CHG: Sta->10)
*** 10/17/11 09:37 am ***
*** 11/01/11 10:16 pm ***
Dear BDE,
Below are the comments from the CT.
1) Is the problem after a reboot of the target DB?
yes
2) Does the 15 minute refresh ever work?
yes we always use it.
3) How about after restarting the agent?
If it is not refreshing, not even restarting the agent helps, only restarting
OEM.
4) Does the problem occur for all target DB's
yes, after reboot of a server.
5) What are the versions of the OMS, Agent, Target DB's that have the problem

agent 11.1.0.7, target DB 11.1.0.7 and 11.2.0.2
6) Have you enabled DEBUG trace for the OMS and Agent?
no
7) how many targets exist on the server displaying the issue?
1 db target
8) do you have lsInventory from OMS, and Agent homes?
9) Does the problem only occur for targets on Windows? how about linux or
other
For  target AIX

回复 只看该作者 道具 举报

5#
发表于 2014-8-18 23:04:12
在11.1.0.7和11.2.0.1 + RAC 上有类似案例,考虑:

换一个节点重新配置dbconsole
or
尝试用 11g grid control来监控
or
放弃使用dbconsole

回复 只看该作者 道具 举报

6#
发表于 2014-8-19 08:14:21
好的,谢谢刘大!

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-12-21 01:53 , Processed in 0.085304 second(s), 23 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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