SAP Note 138639 - Poor DML performance with Oracle DDIC statistics

Composant : Oracle -

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

Mots Clés :
shared cursor cache displays, current operationv$sysstat shows, db file scattered read, current oracle data dictionary statistics, long-running dml statements, recursive sql level 1ora-01013, delete statements perform poorlyeven, critical recursive sql statement, oracle data dictionary statistics, recursive sql statements

Notes associées :

962859Inserts are much slower in 10.2.0.2 with unique index
838725Oracle dictionary statistics and system statistics
712624High CPU consumption by Oracle
618868FAQ: Oracle performance
558746Better Oracle Data Dictionary BW Performance
68896R3trans: Performance problems and cluster