Solution : https://service.sap.com/sap/support/notes/869006 (SAP Service marketplace login required)
Key words :
library cache pin latch free library cache load lock row cache lock reason, oracle logs memory-intensive sql statements, library cache object loaded, excessively high blocking factor depending, increased shared pool load, library cache, relevant sap source code, temporary hang situations due, object-specific dependent objects, shared cursor cache
Related Notes :
| 1478228 | Oracle ORA-4031 WHEN GATHER STATS IN PARALLEL |
| 1472386 | ORA-04031 out of memory error in BW systems |
| 1070102 | High memory allocation by 'obj stat memo' |
| 1031682 | ORA-04031 due to shared pool component "mvobj part des" |
| 997889 | Error ORA-04031 due to "_fix_control" |
| 881083 | Blocking factors on Oracle-based systems |
| 767414 | FAQ: Oracle latches |
| 690241 | The Shared SQL Area in the Shared Pool and large SQL Stmnts |
| 651060 | FAQ: Oracle Parallel Execution |
| 619188 | FAQ: Oracle wait events |
| 618868 | FAQ: Oracle performance |
| 514758 | ORA-4031 and database hang after upgrade to 8.1.7.3 |
| 176754 | Problems with CBO and RBO |
| 122718 | CBO: Tables with special treatment |
| 106047 | DB21: Customizing the DBSTATC |
| 48230 | Parameters for the SELECT ... FOR ALL ENTRIES statement |