下面是个测试方法
The interested transaction list is an array that keeps track of (some of) the most recent transactions on a block. The size of this array is specified by the initrans parameter when an object is created. If more entries are needed in the ITL and if there is enough space in the block, the array can grow up to maxtrans.
The interested transaction list is an array that keeps track of (some of) the most recent transactions on a block. The size of this array is specified by the initrans parameter when an object is created. If more entries are needed in the ITL and if there is enough space in the block, the array can grow up to maxtrans.
This can be demonstrated with 3 sessions:
First session;
Second session:
Third session:
This third session hangs until one of the other session commits or rolls back.
oracle默认initrans就是2,maxtrans是255;initrans可以单独设,maxtrans是要和initrans参数是要同时用的,否则设不成功
10g的maxtrans默认就是255。
select table_name,ini_trans,max_trans from user_tables where table_name ='TNAME'
可看到设置情况
oracle默认initrans就是2,maxtrans是255;initrans可以单独设,maxtrans是要和initrans参数是要同时用的,否则设不成功
10g的maxtrans默认就是255。
select table_name,ini_trans,max_trans from user_tables where table_name ='TNAME'
可看到设置情况
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-84961/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-84961/