SAP Note 626172 - Performance problems with Outer Join queries in Oracle 9.2

Composant : Oracle -

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

Mots Clés :
prerequisites additional internal optimizer settings, symptom considerable performance problems, business information warehouse, unfavorable access plan, setting _push_join_predicate = true, hash_join_enabled=falseis set, terms outer join, outer join queries, current oracle release, _push_join_predicate = falsethe problem

Notes associées :

712624High CPU consumption by Oracle
706132Composite SAP Note: Problems with Oracle 9i
621349
619188FAQ: Oracle wait events
124361Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x)