我在plsql中运行一个包，其中有一段程序是对A表中的所有数据按条更新数据，并更新一条提交一条。
A表中约有十万条记录，而所要更新的A表中的数据要通过其它多个表关联得到。每次这个程序运行到一个小时的时候就会出现这个错误，而当我把数据量减少时程序可以正常运行。请问是不是数据库或plsql 的设置有问题，怎样才能解决这个问题？
我用的是客户端。有劳各位高人了，麻烦了。
谢谢！
A表中约有十万条记录，而所要更新的A表中的数据要通过其它多个表关联得到。每次这个程序运行到一个小时的时候就会出现这个错误，而当我把数据量减少时程序可以正常运行。请问是不是数据库或plsql 的设置有问题，怎样才能解决这个问题？
我用的是客户端。有劳各位高人了，麻烦了。
谢谢！
ORA-03113 end-of-file on communication channel
Cause: An unexpected end-of-file was processed on the communication
channel. The problem could not be handled by the Net8 two-task software. This
message could occur if the shadow two-task process associated with a Net8
connect has terminated abnormally, or if there is a physical failure of the
interprocess communication vehicle, that is, the network or server machine
went down.
In addition, this message could occur when any of the following
statements/commands have been issued:
n ALTER SYSTEM KILL SESSION ... IMMEDIATE
n ALTER SYSTEM DISCONNECT SESSION ... IMMEDIATE
n SHUTDOWN ABORT/IMMEDIATE/TRANSACTIONAL
Action: If this message occurs during a connection attempt, check the setup
files for the appropriate Net8 driver and confirm Net8 software is correctly
installed on the server. If the message occurs after a connection is well
established, and the error is not due to a physical failure, check if a trace file
was generated on the server at failure time. Existence of a trace file may suggest
an Oracle internal error that requires the assistance of Oracle Support Services.