Buffer Deadlock Wait Event In 12.1.0.2 After New Bundle Patch 12102170718ProactiveBP
(Doc ID 2350323.1)
Last updated on MARCH 03, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |