ORA-02042: too many distributed transactions

[dashangg]

怎么会报这个错啊，我只是对一个小表进行一个查询啊！！





数据变慢会不会由于这个原因造成的啊！！！1

[wwl007]

修改
init.ora文件
增加
distributed_transactions = 500的数量

[snowy_howe]

查看init.ora中的DISTRIBUTED_TRANSACTIONS参数。

[LGQDUCKY]

ORA-02042 too many distributed transactions

原因: The distributed transaction table is full because too many distributed transactions are active.

方法: Increase the DISTRIBUTED_TRANSACTIONS parameter in the initialization parameter file, shut down and restart Oracle, or run fewer transactions. If it is certain there are not too many concurrent distributed transactions, this may be an internal error. In this case, contact customer support. Shutting down and restarting the instance could be a work-around.

[woodpan]

ORA-02042 too many distributed transactions
Cause: The distributed transaction table is full because too many distributed transactions are active.

Action: Increase the DISTRIBUTED_TRANSACTIONS parameter in the initialization parameter file, shut down and restart Oracle, or run fewer transactions. If it is certain there are not too many concurrent distributed transactions, this may be an internal error. In this case, contact Oracle Customer Support. Shutting down and restarting the instance could be a workaround

[pegtop]

事务参数太小，修改init.ora的参数，调大一点就可以了！