Buffer Deadlock Wait Event In 12.1.0.2 After New Bundle Patch 12102170718ProactiveBP

(Doc ID 2350323.1)

Last updated on JULY 03, 2018

Applies to:

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

Symptoms

In Oracle Database 12.1.0.2 after new bundle patch 12102170718ProactiveBP was applied, high wait event "buffer deadlock" is immediately observed (top wait event in AWR)
whereby the Avg(ms) value is high too (up to 100 ms):

Top 10 Foreground Events by Total Wait Time
Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time Wait Class
-----------------------------------------------------------------------------------------------------------------

DB CPU 21.2K 90.2
buffer deadlock 11,719 908.4 77.51 3.9 Other

Changes

Applied 12102170718ProactiveBP.

Cause

	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