Solution : https://service.sap.com/sap/support/notes/135048 (SAP Service marketplace login required)
Key words :
symptom long response times occur, delete parameter dbs/ora/use_hints, oracle shared cursor caches, dbs/ora/use_hints = upto->1000, dbs/ora/use_hints =, special parameter setting, sort merge join, full table scan, lowest resource consumption, solution sap offers
Related Notes :
| 772497 | FAQ: Oracle Hints |
| 766349 | FAQ: Oracle SQL optimization |
| 618868 | FAQ: Oracle performance |
| 385139 | Performance Select M_VMVAA |
| 215917 | Easy change from Rule to Cost-Based Optimizer |
| 191565 | F4 help slow during street call |
| 176754 | Problems with CBO and RBO |
| 170282 | use_hints profile parameter under NT |
| 164238 | Performance matchcode search ac.to p. order number |
| 127715 | CBO: Optimum parameters for performance |