在Oracle9i OCP教材上有这么一段话:
INITRANS, which defaults to 1 for a data segment and 2 for an index segment, guarantees a minimum level of concurrency.
这段话是错误的,对于table,initrans默认是2,最小值也是2,某些情况下,默认值和最小值都是3。
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
1.普通的table的initrans默认值为2
SQL> create table t1(id int,name varchar2(20));
Table created.
SQL> insert into t1 values(1,'a');
1 row created.
SQL> commit;
Commit complete.
SQL> select file_id,block_id from dba_extents