1. 主页
  2. 支持
技术文章 - CS108165

Windchill 中的 Oracle 诊断报告发现 ScheduleHistory SQL 性能不佳

已修改: 13-Jan-2025   


注意：本文已使用机器翻译软件翻译，以方便非英语客户阅读。但翻译内容可能包含语法错误或不准确之处。请注意， PTC对本文所含信息的翻译准确性及使用后果不承担任何责任。请在 此处 查看本文的英文原始版本以便参考。有关机器翻译的更多详情，请单击 此处 。
感谢您告诉我们。我们将尽快审阅此译文。

适用于

  • Windchill PDMLink 10.1

说明

  • Oracle 诊断报告发现ScheduleHistory SQL 性能不佳
  • API 的StandardSchedulingService.previousExecutingScheduleStatus()和wt.scheduler.ScheduleItem.getLatestSchedHistory()很慢
  • SQL 和堆栈跟踪
SELECT 'wt.scheduler.ScheduleHistory',TO_CHAR(A0.completionTime,'dd mmyyyy hh24:mi:ss'),TO_CHAR(A0.executionStartTime,'dd mm yyyyhh24:mi:ss'),A0.instanceStatusIsNull,A0.codeA4,A0.messageA4,TO_CHAR(A0.rescheduleTimeA4,'dd mm yyyy hh24:mi:ss'),TO_CHAR(A0.submissionTime,'ddmm yyyy hh24:mi:ss'),TO_CHAR(A0.createStampA2,'dd mm yyyyhh24:mi:ss'),A0.markForDeleteA2,TO_CHAR(A0.modifyStampA2,'dd mm yyyyhh24:mi:ss'),A0.idA2A2,A0.updateCountA2,TO_CHAR(A0.updateStampA2,'dd mmyyyy hh24:mi:ss'),A0.classnamekeyB4,A0.idA3B4
FROM ScheduleHistory A0
  WHERE ((A0.idA3B4 = :1 ))
ORDER BY A0.submissionTime DESC


wt.scheduler.StandardSchedulingService.previousExecutingScheduleStatu s(StandardSchedulingService.java:2228)
wt.scheduler.StandardSchedulingService.executionKernel(StandardSchedulingService.java:1165)
wt.scheduler.StandardSchedulingService.executeScheduledItem(StandardSchedulingService.java:605)
sun.reflect.GeneratedMethodAccessor224.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
wt.queue.ScheduleQueueEntry.execute(ScheduleQueueEntry.java:264)
wt.queue.ScheduleQueue.execEntry(ScheduleQueue.java:336)
wt.queue.ScheduleQueue.execEntries(ScheduleQueue.java:457)
wt.queue.ScheduleQueueThread.processReadyEntries(ScheduleQueueThread.java:280)

 wt.scheduler.ScheduleItem.getLatestSchedHistory (ScheduleItem.java:407)
wt.scheduler.StandardSchedulingService.executionKernel(StandardSchedulingService.java:1259)
wt.scheduler.StandardSchedulingService.executeScheduledItem(StandardSchedulingService.java:603)
jdk.internal.reflect.GeneratedMethodAccessor216.invoke(Unknown Source)
[email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[email protected]/java.lang.reflect.Method.invoke(Method.java:566)
wt.queue.ScheduleQueueEntry.execute(ScheduleQueueEntry.java:303)
wt.queue.ScheduleQueue.execEntry(ScheduleQueue.java:350)
wt.queue.ScheduleQueue.execEntries(ScheduleQueue.java:492)
wt.queue.ScheduleQueueThread.processReadyEntries(ScheduleQueueThread.java:284)

这是文章 108165 的 PDF 版本，可能已过期。最新版本 CS108165