技術文章 - CS93254
Default Oracle Index Caching value of 100 is too high for Integrity Lifecycle Manager
修改時間: 10-Mar-2022
套用到
- PTC RV&S (formerly Integrity Lifecycle Manager) 2009 to 13.0
描述
- Slow Query execution on Oracle
- Despite having a good execution plan, queries against an Oracle database are running slowly
- The optimizer_index_caching parameter passed to Oracle is too high for the size of the database
- How to change the optimizer_index_caching
- Queries against the IIMAP table (relationship queries or aggregate computations) are performing slowly
- Historical Queries (queries involving IssueDeltaAtoms) are performing slowly
- What value should mksis.oracle.optimizer_index_caching property be set to
- Opening a document takes very long time
This is a PDF version of Article 93254 and may be out of date. For the latest version CS93254