• Bug 5880921 V$SYSMETRIC_HISTORY 的时间错乱


    V$SYSMETRIC_HISTORY 的时间错乱.

    起初用了下
    select  end_time,
    value
    from    sys.v_$sysmetric_history
    where   metric_name = 'Database CPU Time Ratio'
    order by 1;
    想查看下CPU时间比率,却发现
    END_TIME                  VALUE
    -------------------- ----------
    2011-11-09 23:31:28  92.4533213
    2011-11-09 23:32:28  76.3461827
    这边的时间都是错误的..跑到2011年11月09日去了.
    随即查了下这个v_$sysmetric_history的定义.
    SYS@PPTD(7.15)> select * from v$fixed_view_definition where view_name like '%V$SYSMETRIC_HISTORY%';
    VIEW_NAME
    ------------------------------
    VIEW_DEFINITION
    --------------------------------------------------------------------------------------------------------------------------------------------
    GV$SYSMETRIC_HISTORY
    SELECT inst_id, begtime, endtime, intsize_csec,groupid, metricid, name, value, unit FROM x$kewmdrmv WHERE groupid in (2,3)
    用的是X表,x$kewmdrmv
    这下不知道如何解决是好..
    大伙有碰到类似这样的状况吗?
    难道,Oracle运行了一段时间以后X表的统计值 会有错乱的情况??
    有无方法重置?修复?

    sundog315的答复

    Bug 5880921 - Time inconsistency between V$SYSMETRIC_HISTORY and SYSDATE [ID 5880921.8]   
    --------------------------------------------------------------------------------
      修改时间 03-APR-2009     类型 PATCH     状态 PUBLISHED   
    Bug 5880921  Time inconsistency between V$SYSMETRIC_HISTORY and SYSDATE
    This note gives a brief overview of bug 5880921.
    The content was last updated on: 03-APR-2009
    Click here for details of each of the sections below.
    Affects:
    Product (Component) Oracle Server (Rdbms)
    Range of versions believed to be affected (Not specified)
    Versions confirmed as being affected •10.2.0.3
    •10.2.0.4
    Platforms affected Generic (all / most platforms affected)
    Fixed:
    This issue is fixed in •10.2.0.2 Patch 18 on Windows Platforms
    •10.2.0.3 Patch 10 on Windows Platforms
    •10.2.0.3 Patch 18 on Windows Platforms
    •10.2.0.4 Patch 2 on Windows Platforms
    •10.2.0.5 (Server Patch Set)
    •11.1.0.7 (Server Patch Set)
    Symptoms: Related To:
    •Wrong Results
    •Performance Monitoring
    •V$SYSMETRIC_HISTORY
    Description
    V$SYSMETRIC_HISTORY may show incorrect timestamps
    Note: This bug was previously incorrectly listed as fixed in 10.2.0.4
    Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.
    References
    Bug:5880921 (This link will only work for PUBLISHED bugs)
    Note:245840.1 Information on the sections in this article
    --------------------------------------------------------------------------------

    看来只能通过打补丁解决了,或是restart DB(这个很不现实...)

    作者:Daaprk
    可以转载,但必须以超链接形式标明文章原始出处和作者信息.
  • 相关阅读:
    C++ 复制控制之复制构造函数
    static关键字总结
    C++ 隐式类类型转换
    Unity 移动端触摸屏操作
    【原创】为什么要用规则引擎?
    【原创】你的Redis怎么持久化的
    【原创】JAVA中令人眼花撩乱的数字魔法
    【原创】谈谈redis的热key问题如何解决
    【原创】Mysql中事务ACID实现原理
    【原创】杂谈自增主键用完了怎么办
  • 原文地址:https://www.cnblogs.com/dap570/p/1803957.html
Copyright © 2020-2023  润新知