SAP Note 767414 - FAQ: Oracle latches

Composant : Oracle - Backoffice Service Delivery

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

Mots Clés :
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

Notes associées :

1611285FRP sequence 1: Performance improvement for DIF access
1020225High number of 'cache buffer chains' in Oracle 10.2.0.2
964344FAQ: Oracle mutexes
913247Performance problems due to open changes
869006Composite SAP note: ORA-04031
789011FAQ: Oracle memory areas
766349FAQ: Oracle SQL optimization
745639FAQ: Oracle enqueues
712624High CPU consumption by Oracle
651060FAQ: Oracle Parallel Execution
619188FAQ: Oracle wait events
618868FAQ: Oracle performance
596420System standstill during deadlock (ORA-60)
488583Database hangs: Waits for cache buffer chain latch
449136"cache buffers chains" latch contention on 8.1
400698ORA-4031 Memory leak on Oracle 8.1.7
20071Permanent lock after connection termination
391Archiver stuck