oracle atomic operation logs

2009532140

vage 发表于 2014-6-18 11:58
什么资料啊。发过来看看

下面的资料中，有个：
the mutex state diagram

图中，有几个步骤：GET DECR
GET_LONG_EXCL 不太明白，不过GET_LONG_EXCL猜测是长时间占用mutex 不知道对不对

Yong Huang

GET_DECR seems to be the function or macro for the mutex state to go from S1 (S for shared mode) to E0 (E for examine mode), and GET_LONG_EXCL to go from NONE to LONG_X. I'm guessing that long exclusive is the mode held by a session busy for quite a while on the CPU while holding in exclusive mode.

The diagram shows all mutex *transition* operations and their function names. Some operations that are not transitions are not shown. For example, if you check oracle binary (strings $ORACLE_HOME/bin/oracle), you'll see these functions:

GET_SHRD
SHRD_EXAM
REL_SHRD
GET_EXCL
REL_EXCL
GET_INCR
INCR_EXAM
GET_DECR
DECR_EXAM
EXCL_SHRD
GET_EXAM
GET_LONG_EXCL
REL_LONG_EXCL

So for instance, INCR_EXAM is not listed as a transition operation.

2009532140

Yong Huang 发表于 2014-6-20 03:14
GET_DECR seems to be the function or macro for the mutex state to go from S1 (S for shared mode) to  ...

谢谢版主。
不知道你从哪得到的资料，我找了挺长时间没搜到

Yong Huang

It's the same document by Andrey Nikolaev. I posted the URL in msg #2 and you posted it in #8.