oralce性能调整
-
编辑 删除
itl slot不足引发的锁等待
测试语句：drop table try_itl;create table try_itl(c1 number)initrans 1maxtrans 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_numfrom try_itl ;delete try_itl where c1 = 1 ;start showalllock ;[@more@]测试结果SQL> start itl_slotTable dropped.Table created.1 row created.1 row created.1 row
