High "gc" cluster wait with Warning: log write elapsed time
(Doc ID 2219204.1)
Last updated on DECEMBER 28, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Cloud Schema 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
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
For a short period of time, "gc" related waits show up in top in awr report:
Top 10 Foreground Events by Total Wait Time
Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time Wait Class
gc buffer busy acquire 82,801 83.9K 1014 58.3 Cluster
gc cr block busy 5,376 31.2K 5799 21.7 Cluster
gc current block busy 4,020 13K 3225 9.0 Cluster
gc buffer busy release 61,783 8488.4 137 5.9 Cluster
enq: TX - index contention 13,960 4982.9 357 3.5 Concurrency
buffer busy waits 19,316 658 34 .5 Concurrency
enq: TX - row lock contention 62 626.8 10109 .4 Application
lgwr trace shows a small write took long time:
ash also confirms all gc related waits started while the lgwr log writing was going on.
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 |
| Cause |
| Solution |