Solution : https://service.sap.com/sap/support/notes/138639 (SAP Service marketplace login required)
Key words :
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
Related Notes :
| 962859 | Inserts are much slower in 10.2.0.2 with unique index |
| 838725 | Oracle dictionary statistics and system statistics |
| 712624 | High CPU consumption by Oracle |
| 618868 | FAQ: Oracle performance |
| 558746 | Better Oracle Data Dictionary BW Performance |
| 68896 | R3trans: Performance problems and cluster |