My Oracle Support Banner

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 AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.