关于ORACLE锁的问题

hooman

最初由 eygle 发布
[B]
[/B]

Thanks, 我理解茬了, 刚刚才查到这个SQL的用法.

先以为这句话是在加锁的SESSION 里用,  原来是在查询的SESSION 里用....

eygle

最初由 Puber 发布
[B]才注意到eygle的头衔也是新手上路.


其实sql reference还是很值得研究的,但又有几个人会这么干呢. [/B]

越来越发现自己知道的东西其实很少很少

d.c.b.a

我也是看过AQ的Document后，trace了一把知道的。

wyq21973

的确是一个好东西，以后可能会用得上的。
8.1.7.0.0 下试了，不支持。

Yong Huang

最初由 Puber 发布
[B]
其实sql reference还是很值得研究的,但又有几个人会这么干呢. [/B]

Even if you read SQL Reference to death, you won't find this feature. I just checked 10g SQL Reference. SKIP LOCKED is still not in SELECT reference. The old old function REVERSE (as in SELECT REVERSE('ABC') FROM DUAL) is not documented either.

Regarding SKIP LOCKED, Steve Adams offers this alternative (http://www.ixora.com.au/newsletter/2000_06.htm):

The alternative to using this statement would be to SELECT candidate rows individually in a loop using the NOWAIT variant of the statement.

Another alternative is at http://www.ixora.com.au/q+a/0010/17094208.htm But I didn't read it carefully to see if it's using the same method.

Yong Huang

zjusxzj

学海无涯