May 22, 2018 archive

RAC Sequence Contention

I recently ran into a case where selecting the next value from a sequence was causing contention issues in Oracle RAC.  See this screen shot from Lighty (click on the image to see a larger picture) The wait events will look the same if viewed in Enterprise Manager’s performance screens, which does require one to …

Continue reading