SDL Tridion Sites 9.1: Temporary table T_ITEM_LIST introduced with hotfix CM_188.8.131.5235 is not cleaned up
000013635|9/25/2020 9:07 PM
SDL Tridion Sites 9.1, Oracle
SDL Tridion Sites 9.1 had a hotfix for publication loading and translation job loading performance, CM_184.108.40.20635. This is for Oracle databases. It introduces a new temporary table called T_ITEM_LIST. But over time this table is seen to not be cleaned up as it should be. This can lead to a lag in performance navigating the Content Manager and when publishing.
A subsequent hotfix is available to fix the cleanup of the T_ITEM_LIST table - CM_220.127.116.1116. Hotfixes CM_18.104.22.16835 and CM_22.214.171.12495 are prerequisites for this hotfix. The hotfixes are available via FTP as per: