The value (30) of MAXTRANS parameter ignored

最新推荐文章于 2021-04-07 10:38:53 发布

转载最新推荐文章于 2021-04-07 10:38:53 发布 · 159 阅读

本文探讨了在使用Oracle Data Pump进行数据库导出时遇到的关于MAXTRANS参数被忽略的问题。该问题源于创建备份主表时使用的语句中含有已废弃的MAXTRANS参数，导致告警日志中出现提示信息。文章详细解释了这一现象的原因，并指出这是一个已知的bug，不会对数据库运行造成实际影响。

Oracle 10.2.0.4 , Linux AS 4.5 64bit

Fri Nov 20 20:20:25 2009
Thread 1 advanced to log sequence 4775 (LGWR switch)
Current log# 11 seq# 4775 mem# 0: /u01/product/oradata/mxdell/redo11a.log
Current log# 11 seq# 4775 mem# 1: /data1/mxdell/redo11b.log
Fri Nov 20 20:21:31 2009
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=537, OS id=15342
to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_SCHEMA_01', 'SYSTEM', 'KUPC$C_1_20091120202131', 'KUPC$S_1_20091120202131', 0);
kupprdp: worker process DW01 started with worker id=1, pid=551, OS id=15344
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_01', 'SYSTEM');
Fri Nov 20 20:23:16 2009
Thread 1 advanced to log sequence 4776 (LGWR switch)
Current log# 12 seq# 4776 mem# 0: /u01/product/oradata/mxdell/redo12a.log
Current log# 12 seq# 4776 mem# 1: /data1/mxdell/redo12b.log
Fri Nov 20 20:26:19 2009
Thread 1 advanced to log sequence 4777 (LGWR switch)

诊断过程：

这个时间段正在使用expdp进行数据库导出，当然从错误描述也可以看出和导出操作有关，不过当时导出是成功，没有报任何错误。在metalink查询，发现这是Version: 10.1.0.2 to 11.1.0.7 (任何平台) 的一个bug，Bug号为：6347775

这是由于在创建备份主表时使用了如下语句：
CREATE TABLE () INITRANS 10 MAXTRANS 30

而Maxtrans参数在10gR1时已经废弃，所以在告警日志中就提示：
The value (30) of MAXTRANS parameter ignored. ，此bug没有什么影响，所以可以忽略。

-----------------------------------------------------

DataPump Export/Import Generate Messages "The Value (30) Of Maxtrans Parameter Ignored" in Alert Log [ID 455021.1]

--------------------------------------------------------------------------------

修改时间 12-AUG-2009 类型 PROBLEM 状态 PUBLISHED

In this Document
Symptoms
Cause
Solution
References

--------------------------------------------------------------------------------

Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7
This problem can occur on any platform.

Symptoms
You started DataPump export (or import) and the following messages are logged in alert.log:

The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=40, OS id=28000
to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_FULL_01', 'BKUPUSER',
'KUPC$C_1_20070810163730', 'KUPC$S_1_20070810163730', 0);
kupprdp: worker process DW01 started with worker id=1, pid=43, OS id=28002
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_01', 'BKUPUSER');

There are no invalid objects in data dictionary.
Cause
The message:

The value (30) of MAXTRANS parameter ignored.

comes from master table creation statement.

Expdp (or impdp) creates the master table with a statement like:

CREATE TABLE () INITRANS 10 MAXTRANS 30
Since 10gR1 the parameter MAXTRANS is obsoleted and the informational message is put into alert.log.

This can be reproduced with a simple test performed in SQL*Plus:

SQL> create table test001 (col001 number) initrans 10 maxtrans 25;
Then verify alert.log and you will see:

The value (25) of MAXTRANS parameter ignored.
Solution
Ignore these informational messages. This problem is handled in bug 6347775 base bug 4892288 (not published externally, fixed in version 11.2).

References
BUG:6347775 - MESSAGES "THE VALUE (30) OF MAXTRANS PARAMETER IGNORED" IN ALERT LOG

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

转载于:http://blog.itpub.net/35489/viewspace-620270/