SAP Note 135048 - Long runtimes statements w/ ROWNUM <= condition

Composant : Backoffice Service Delivery - Oracle

Solution : https://service.sap.com/sap/support/notes/135048 (Connexion à SAP Service Marketplace requise)

Mots Clés :
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

Notes associées :

772497FAQ: Oracle Hints
766349FAQ: Oracle SQL optimization
618868FAQ: Oracle performance
385139Performance Select M_VMVAA
215917Easy change from Rule to Cost-Based Optimizer
191565F4 help slow during street call
176754Problems with CBO and RBO
170282use_hints profile parameter under NT
164238Performance matchcode search ac.to p. order number
127715CBO: Optimum parameters for performance