IF: Undo Related Wait Event - Latch: undo global data
(Doc ID 1951702.1)
Last updated on JANUARY 07, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Oracle 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.
***Checked for relevance on 21-Jul-2017***
AWR report shows event latch: undo global data as the top wait event
Event Waits Time(s) Avg wait (ms) % DB time Wait Class
latch: undo global data 72,119,056 865,904 12 47.88 Other <<<
DB CPU 753,239 41.65
db file sequential read 57,249,544 118,554 2 6.55 User I/O
wait list latch free 1,767,054 17,961 10 0.99 Other
SQL*Net message from dblink 1,916,501 14,427 8 0.80 Network
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