注册登录
提 问
English中文版
系统集成Oracle 11g

oracle 11 g VKTM detected a time drift？

Tue Dec 26 00:02:25 2017Archived Log entry 22015 added for thread 1 sequence 13472 ID 0xffffffffffe006b9 dest 1:Tue Dec 26 01:00:00 2017Closing scheduler windowClosing Resource Manager plan via scheduler windowClearing Resource Manager plan via param...显示全部

Tue Dec 26 00:02:25 2017
Archived Log entry 22015 added for thread 1 sequence 13472 ID 0xffffffffffe006b9 dest 1:
Tue Dec 26 01:00:00 2017
Closing scheduler window
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
Tue Dec 26 01:56:23 2017
Thread 1 advanced to log sequence 13474 (LGWR switch)
Current log# 1 seq# 13474 mem# 0: +DATA/erpdb/onlinelog/group_1.261.848792895
Tue Dec 26 01:56:24 2017
Archived Log entry 22019 added for thread 1 sequence 13473 ID 0xffffffffffe006b9 dest 1:
Tue Dec 26 03:11:29 2017
Warning: VKTM detected a time drift.
Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details.
Tue Dec 26 03:50:54 2017
Thread 1 advanced to log sequence 13475 (LGWR switch)
Current log# 2 seq# 13475 mem# 0: +DATA/erpdb/onlinelog/group_2.262.848792895
Tue Dec 26 03:50:55 2017
Archived Log entry 22023 added for thread 1 sequence 13474 ID 0xffffffffffe006b9 dest 1:
Tue Dec 26 05:30:23 2017
Warning: VKTM detected a time drift.
Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details.
Tue Dec 26 06:02:08 2017
Thread 1 advanced to log sequence 13476 (LGWR switch)
Current log# 5 seq# 13476 mem# 0: +DATA/erpdb/onlinelog/group_5.263.848792895
Tue Dec 26 06:02:09 2017
Archived Log entry 22024 added for thread 1 sequence 13475 ID 0xffffffffffe006b9 dest 1:
Tue Dec 26 06:35:29 2017
Warning: VKTM detected a time drift.
Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details.
Tue Dec 26 07:29:09 2017
Thread 1 advanced to log sequence 13477 (LGWR switch)
Current log# 1 seq# 13477 mem# 0: +DATA/erpdb/onlinelog/group_1.261.848792895
Tue Dec 26 07:29:09 2017
Archived Log entry 22025 added for thread 1 sequence 13476 ID 0xffffffffffe006b9 dest 1:^Croot@erpdb1:/u01/oracle/app/oracle/diag/rdbms/erpdb/erpdb1/trace#

收起
关注3
评论
参与11

查看其它 1 个回答renou2012的回答

renou2012renou2012数据库管理员KE

该问题和mos上的
Time Drift Detected. Please Check VKTM Trace File for More Details (文档 ID 1347586.1)
很相似，建议查看系统的负载情况和系统配置信息，
The time drifts usually occurring less than 1sec and 5 sec for forward and backward respectively are permissible and OK.
If the traces are emitting time drifts of amount beyond these ranges, then it needs to be analyzed.
Most of the times, during high loads, there would be issues with underlying OS due to virtual memory, network time protocol improper configuration etc.

In general VKTM process need to be scheduled in every 10ms, if due to above reasons this is not happening we see the time drifts and to certain level (mentioned above) are permissible.
Eventually, this probably would cause the resource manager to take improper decisions and can lead to a hang in worst case.

金融其它 · 2017-12-26
浏览3810
查看赞同的人
twt社区管理员 邀答
评论

回答者

renou2012
renou2012002
数据库管理员KE
擅长领域： 数据库，关系型数据库，数据库系统改造
关注425
回答225
评论230

renou2012 最近回答过的问题

  • 分布式数据库建立的必要性？
  • 两台主机部署oracle采用何种模式为好？
  • 国产数据库能否替换oracle数据库？
  • Oracle SQL*Net more data to client？
  • oracle rac安装时候选项跳不出来？

    • 回答状态

  • 发布时间：2017-12-26
  • 关注会员：3 人
  • 回答浏览：3810

    • 关于TWT使用指南社区专家合作厂商入驻社区企业招聘投诉建议版权与免责声明联系我们
    © 2024talkwithtrend — talk with trend,talk with technologist京ICP备09031017号-30

    X社区推广