Solution : https://service.sap.com/sap/support/notes/505246 (SAP Service marketplace login required)
Key words :
transaction st04-> detail analysis menu -> sql requests -> sql-statement-template %<tabellenname>%, transaction st04->detail analysis->sql requests, followstransaction st04 -> detail analysis menu -> display, terms ora-3113ora-4031shared_pool_sizedictionary cache reason, return statements displaying memory consumption greater, syslog display ora-31113 error messages, system generates detailed trace files, oracle rule-based optimizer code, 'small' statements produce trace files, display ora-40431 error messages
Related Notes :
| 712624 | High CPU consumption by Oracle |
| 690241 | The Shared SQL Area in the Shared Pool and large SQL Stmnts |
| 557447 | ORA-4031 After upgrade to Oracle 8.1.x.x |
| 556764 | Upgrade hangs in phase ACT_<REL> |
| 520568 | CBO: Long runtimes for large IN lists |
| 515080 | Importing Support Packages hangs. Work process with SEM -17 |
| 514758 | ORA-4031 and database hang after upgrade to 8.1.7.3 |
| 507254 | ORA-4031 and ORA-3113 when processing large IN lists |
| 133351 | Short dumps due to Oracle error ORA 4031 |
| 124361 | Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x) |
| 122718 | CBO: Tables with special treatment |