ITPub博客

首页 > 应用开发 > IT综合 > itl slot不足引发的锁等待

itl slot不足引发的锁等待

原创 IT综合 作者:zhangyg 时间:2006-08-16 13:38:28 0 删除 编辑

测试语句:

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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论
  • 博文量
    2
  • 访问量
    7291