• 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
    可以转载,但必须以超链接形式标明文章原始出处和作者信息.
  • 相关阅读:
    20110228 12:20 .net httpHandler和httpModule
    Microsoft CRM 2011清除缓存
    Sql Server Reporing Service / Windows Azure SQL Reporting应用程序开发
    终于来Cnblogs开博啦!~
    瑞星与360事件依我之看
    xml 基础 学习
    程序员的人生
    C# 发送邮件 .net SendEmail 源码
    Repeater 嵌套 绑定数据,嵌套的Repeater无法绑定的问题
    从maya中 导入物体 到Uniyt3D 规范 整理
  • 原文地址:https://www.cnblogs.com/dap570/p/1803957.html
Copyright © 2020-2023  润新知