Linguistic Sorting on Application Side caused query to ignore SQL Profiles/SQL Baselines and was not using desired index.
(Doc ID 2570477.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterInformation in this document applies to any platform.
Symptoms
- On 12.1.0.1 version, SQL_IDs are not picking the desired explain plan after applying the profile
Changes
Linuguistic Sorting by the use of NLS_COMP = LINGUISTIC at client side, caused the Oracle Index access path to be ignored by specific runs from Application. Query invoked from SQLPLUS was using desired index.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |