模拟dc_sequences上的row cache lock

db：10.2.0.3

sqlplus / as sysdba

session 1:
create sequence qqq nocache;

select * from seq$ where obj#=(select object_id from dba_objects where object_name='QQQ')
fro update;

session 2:
select qqq.nextval from dual;

hang住了

session 3:
select qqq.nextval from dual;

hang住了

session 4:
select event from v$session;

row cache lock                     session 3
enq: TX - row lock contention      session 2  

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/37279/viewspace-716296/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/37279/viewspace-716296/