Article - CS269878
Integrity 11.1 Hotfix HF-S160000001-010 Performance degradation of all IM SQL statements which use old Oracle USE_NL statement hint on Oracle 12c
Modified: 07-Sep-2017
Applies To
- PTC RV&S (formerly Integrity Lifecycle Manager) 11.1
- Oracle 12c
Description
- Integrity Server performance degrades for all SQL statements which use old Oracle USE_NL statement hint on Oracle 12c
- USE_NL hints on Oracle 12c significantly degrades Integrity performance; skipStatementNestedLoops query hint is not enough
- Significant performance degradation occurs when Integrity is run on Oracle 12c due to the use of old USE_NL SQL statement hints
- Integrity uses query hints that are for older releases of Oracle but impact performance on Oracle 12c
This is a printer-friendly version of Article 269878 and may be out of date. For the latest version click CS269878