在10G中，MAXTRANS 参数已经被抛弃

在10G中，MAXTRANS 参数已经被抛弃

Kevin Zou

2011-9-20

在做《TX ENQUEUE阻塞的理解》时，发现在10G中无法模拟出来ITL满的CASE，

查看了ORACLE 文档如下：

MAXTRANS Parameter

In earlier releases, the MAXTRANS parameter determined the maximum number of concurrent update transactions allowed for each data block in the segment. This parameter has been deprecated. Oracle now automatically allows up to 255 concurrent update transactions for any data block, depending on the available space in the block.

Existing objects for which a value of MAXTRANS has already been set retain that setting. However, if you attempt to change the value for MAXTRANS, Oracle ignores the new specification and substitutes the value 255 without returning an error.

-THE END-

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/40239/viewspace-707936/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/40239/viewspace-707936/