High US - contention enqueue / rowcache lock while trying to online a NEW undo segment
(Doc ID 1577753.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 to 18.104.22.168 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 06-Aug-2016***
High US - contention enqueue , latch: row cache objects and rowcache locks may be seen while trying to online a new undo segment.
When transaction concurrency increases sharply (e.g. following a connection storm or high DML activity), Automatic UNDO Management (AUM) may need to bring online existing undo segments, or create additional undo segments.
The process of creating additional undo segments or onlining existing undo segments appears to be slower in 22.214.171.124 than in 10.2.0.3 .
The Test Case Done for the Bug Investigation creates 1782 undo segments in first run on freshly created db and onlines 1782 undo segments in second run .
The Following are the Test Case results , which shows slight increase in the Database Time , slight increase in US enqueue while onlining ,
and Huge increase in latch: row cache objects wait time in both scenarios (creating or onlining undo segments)
|Wait Event time create undo segments||10.2.0.3||126.96.36.199|
|US - contention||4636||2587|
|row cache objects latch||96||3434|
|row cache lock wait time||569||169|
|latch free wait time||58||118|
|Wait Event time onlining undo segments||10.2.0.3||188.8.131.52|
|US - contention||1141||1532|
|row cache objects latch||98||226|
|row cache lock||667||313|
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!