技术文章 - CS120486
在 Windchill 中, CtmdRecomputeMembershipQueue 队列条目执行慢
已修改: 23-Nov-2016
适用于
- Windchill PDMLink 9.1 to 10.0 M040
- Windchill PDMLink 10.1 F000 to M040
说明
- CtmdRecomputeMembershipQueue 条目执行慢
- CtmdRecomputeMembershipQueue 大量消耗内存
- 下面 SQL 执行了大量的次数
SELECT 'wt.org.WTUser',A0.allowLDAPSynchronization,...
FROM WTUser A0
WHERE ((A0.idA2A2 IN (
SELECT /*+ CARDINALITY(wtot 7500) */ *
FROM TABLE(cast(? as XXXX.TABLE_OF_NUMBER)) wtot
WHERE (ROWNUM > 0)
AND (column_value IS NOT NULL))))
AND (A0.markForDeleteA2 = 0)
FROM WTUser A0
WHERE ((A0.idA2A2 IN (
SELECT /*+ CARDINALITY(wtot 7500) */ *
FROM TABLE(cast(? as XXXX.TABLE_OF_NUMBER)) wtot
WHERE (ROWNUM > 0)
AND (column_value IS NOT NULL))))
AND (A0.markForDeleteA2 = 0)
这是文章 120486 的 PDF 版本，可能已过期。最新版本 CS120486