Article - CS108165
Poorly performing ScheduleHistory SQL identified by the Oracle diagnostics report in Windchill
Modified: 13-Jan-2025
Applies To
- Windchill PDMLink 10.1
Description
- Poorly performing ScheduleHistory SQL identified by the Oracle diagnostics report
- API's StandardSchedulingService.previousExecutingScheduleStatus() and wt.scheduler.ScheduleItem.getLatestSchedHistory() are slow
- The SQL and Stack Trace
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.previousExecutingScheduleStatus(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)
This is a printer-friendly version of Article 108165 and may be out of date. For the latest version click CS108165