Article - CS109678
Poorly performing WfBlock SQL identified by the Oracle diagnostics report in Windchill PDMLink
Modified: 01-Mar-2018
Applies To
- Windchill PDMLink 10.1 to 11.1
Description
Poorly performing WfBlock SQL identified by the Oracle diagnostics report:
SELECT 'wt.workflow.engine.WfBlock',A0.adSQEN,A0.administrativeLockIsNull,A0.typeadministrativeLock,A0.alertTime,A0.blob$context,A0.changeStateTime,A0.classnamekeycontainerReferen,A0.idA3containerReference,A0.context,A0.dSQEN,TO_CHAR(A0.deadline,'dd mm yyyyhh24:mi:ss'),A0.deadlineDuration,A0.description,A0.classnamekeydomainRef,A0.idA3domainRef,TO_CHAR(A0.endTime,'dd mm yyyyhh24:mi:ss'),A0.eventConfiguration,A0.eventSet,A0.inheritedDomain,A0.wtkey,A0.name,A0.pdSQEN,A0.priority,A0.classnamekeyA6,A0.idA3A6,A0.securityLabels,TO_CHAR(A0.startTime,'dd mm yyyyhh24:mi:ss'),A0.state,A0.suspendTime,A0.templateIsNull,A0.classnamekeyA5,A0.idA3A5,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'),TO_CHAR(A0.timeToStart,'dd mm yyyy hh24:mi:ss')
FROM WfBlock A0
WHERE ((A0.idA3A6 = :1 ))
AND (A0.markForDeleteA2 = 0)
This is a printer-friendly version of Article 109678 and may be out of date. For the latest version click CS109678