-
编辑 删除
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
-
编辑 删除
hash分区表怎么增加分区？
hash分区表怎么增加分区？[@more@]hash分区表怎么增加分区，下面是我的建表语句，表中有千万级别的数据，希望不影响数据drop table test;CREATE TABLE test (acc CHAR(19) NOT NULL...............open_inst ..................) INITRANS 30 PARTITION BY HASH (acc)(PARTITION P1 TABLESPACE users,PARTITION P2 TABLESPACE users ) ;CREATE UNIQUE INDEX idxxp_abcdtest ON test(acc ASC) INITRANS 50 LOCAL(PARTITION P1TABLESPACE users,PARTITION P2TABLESPACE users);CREATE INDEX XAK4test ON test(open_inst ASC) INITRANS 50 TA
