Article - CS93254
Default Oracle Index Caching value of 100 is too high for Integrity Lifecycle Manager
Modified: 10-Mar-2022
Applies To
- PTC RV&S (formerly Integrity Lifecycle Manager) 2009 to 13.0
Description
- 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 printer-friendly version of Article 93254 and may be out of date. For the latest version click CS93254