How to Identify Hot Blocks Within the Database Buffer Cache that may be Associated with 'latch: cache buffers chains' Wait Contention (Doc ID 163424.1)

Last updated on JULY 13, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.6.0 and later
Oracle Database - Personal Edition - Version 8.0.6.0 and later
Oracle Database - Standard Edition - Version 8.0.6.0 and later
Information in this document applies to any platform.

Goal

Identify blocks which cause latch contention on the 'cache buffers chains' latch. 

NOTE: To solve a hot block, the application may need to be reviewed because the contention may be caused by inefficient SQL repeatedly accessing the same buffers unnecessarily.
For more details see:

<Document 1342917.1> Troubleshooting 'latch: cache buffers chains' Wait Contention


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms