Solution : https://service.sap.com/sap/support/notes/767414 (SAP Service marketplace login required)
Key words :
buffer pool < 1124073472 byte -> 1024 latches buffer pool >= 1124073472 byte -> 2048 latches buffer pool >= 2231369728 byte -> 4096 latches buffer pool >= 4445962240 byte -> 8192 latches buffer pool >= 8875147264 byte -> 16384 latches buffer pool >= 17733517312 byte -> 32768 latches buffer pool >= 35500000000 byte -> 65536 latches, reference22 instance tuning-> wait events-> latch freeoracle 9i reference-> dynamic performance views->, performance views-> wait events statisticsoracle 10g reference-> 4 dynamic performance views->, cache buffer handles wait event >= 10g, library cache / library cache pin wait event > = 10g, cache buffers lru chain wait event >= 10g, oracle buffer pool size, $latchoracle 10g performance tuning guide, shared pool wait event >= 10g, enqueue hash chains wait event >= 10g
Related Notes :
| 1611285 | FRP sequence 1: Performance improvement for DIF access |
| 1020225 | High number of 'cache buffer chains' in Oracle 10.2.0.2 |
| 964344 | FAQ: Oracle mutexes |
| 913247 | Performance problems due to open changes |
| 869006 | Composite SAP note: ORA-04031 |
| 789011 | FAQ: Oracle memory areas |
| 766349 | FAQ: Oracle SQL optimization |
| 745639 | FAQ: Oracle enqueues |
| 712624 | High CPU consumption by Oracle |
| 651060 | FAQ: Oracle Parallel Execution |
| 619188 | FAQ: Oracle wait events |
| 618868 | FAQ: Oracle performance |
| 596420 | System standstill during deadlock (ORA-60) |
| 488583 | Database hangs: Waits for cache buffer chain latch |
| 449136 | "cache buffers chains" latch contention on 8.1 |
| 400698 | ORA-4031 Memory leak on Oracle 8.1.7 |
| 20071 | Permanent lock after connection termination |
| 391 | Archiver stuck |