Tag Archives: mutex

The case of a stuck query (mutexes in 10g)

10 Apr

In my earlier post, I mentioned an interesting case which among other symptoms, featured high CPU usage. In this post I would like to tell more about that case.

I was investigating poor performance on a 10.2.0.5 Oracle database, and I was asked to look at it after yet another outage (the database wasn’t accepting any connections for over two hours). The AWR report showed massive mutex and latch contention:

Continue reading

Follow

Get every new post delivered to your Inbox.

Join 250 other followers