Latch contention

Library cache latch contention is typically caused by NOT using bind variables. It is due to excessive parsing of statements.

Cache buffers chain latches contention is typically caused by concurrent access to a very “hot” block and the most common type of such a hot block is an index root or branch block (since any index based query must access the root block).

Redo copy/redo allocation latches contention are rarely encountered today. They protect the redolog buffer

A useful and very complete article/scripts on latch contention by Tanel Poder (Oracle 9i to 12c):

The scripts:

Vincent Fenoll Oracle Database Administrator in Montreal

Laisser un commentaire

Votre adresse e-mail ne sera pas publiée. Les champs obligatoires sont indiqués avec *

Ce site utilise Akismet pour réduire les indésirables. En savoir plus sur comment les données de vos commentaires sont utilisées.