CBC Latch Contention – My Experience

Recently, i got an opportunity to look into CBC latch contention on 9.2.0.8 database version at one of the client's site.As the number of users connecting to the database increased its performance degraded with poor application performance. The first thing was to check the statspack report.Lets see what the "Top 5 Wait Events" had to …

Advertisement