acquired in the same mode of immediate or willing to wait correct ?Yes.
The faster I am not sure still why.The code path to get and release them is shorter.
This can be leading to an assumption to a "false contention" sort of thingThe reduced size helps avoiding false contention. In fact, when a latch protects several, independent, structures, false contention might happen. Since mutexes takes less memory, the database engine is able to allocate more of them and, therefore, reduced the likelihood of having false contention.
I am sure besides this , there must be some thing more relevant forTo me it seams that since mutexes can do the same things as latches do by using less memory and in a more performant way, there are already enough good reason for using them!
mutexes also there which I am trying to look.
Yingkuan,Understand. I also failed to find good article to discuss this topic in detail. I assume Oracle thought this too technical to post to general public.
I dont have the official aricle with me to prove that
Oracle is doing mutex implementation. I tried to
search alot for this details but I wasnt able to
find relevant details so I asked, Believe me ( I know
its not good to say, proof is required) but its true