Resolving Oracle Latch Contention

This paper presents an overview of how the Oracle RDBMS uses latches to protect shared memory, the typical causes of and solutions to latch contention, and summarizes some research conducted at Quest Software that suggests that manipulating the (now) undocumented parameter '_spin_count' can be effective in relieving otherwise intractable latch contention problems.