itl slot不足引发的锁等待

测试语句：

drop table try_itl;
create table try_itl
(
c1 number
)
initrans 1
maxtrans 2 ;

insert into try_itl values (1) ;
insert into try_itl values (2) ;
insert into try_itl values (3) ;
commit ;

select c1,dbms_rowid.rowid_relative_fno(rowid) as in_file,
dbms_rowid.rowid_block_number(rowid) as in_block,
dbms_rowid.ROWID_ROW_NUMBER(rowid) as row_num
from try_itl ;

delete try_itl where c1 = 1 ;

start showalllock ;

[@more@]

测试结果

SQL> start itl_slot

Table dropped.

Table created.

1 row created.

1 row created.

1 row created.

Commit complete.

C1 IN_FILE IN_BLOCK ROW_NUM
---------- ---------- ---------- ----------
1 9 396413 0
2 9 396413 1
3 9 396413 2

1 row deleted.

SID TY ID1 ID2 LOCK_TYPE REQUEST CTIME BLOCK

---------- -- ---------- ---------- ------------------- ---------- ---------- ----------

35 TX 458797 18253 Exclusive 0 0 0

35 TM 100924 0 Row Exclusive 0 0 0

205 TX 65582 233546 Exclusive 0 17 0

205 TM 39032 0 Row Exclusive 0 17 0

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

转载于:http://blog.itpub.net/44871/viewspace-857451/