ORA-08007:
Further changes to this block by this transaction not allowed
Cause:
Max locks have been reached for this transaction in this block
Action:
Commit changes
导致原因:是因为 oracle 数据块持有的事务数到达上限。
解决办法:
1.缩短事务时间,增加提交事务的频度。
2.给对应的表增加索引,让更新操作执行时间更短。(我在项目中采用的办法)
Further changes to this block by this transaction not allowed
Cause:
Max locks have been reached for this transaction in this block
Action:
Commit changes
导致原因:是因为 oracle 数据块持有的事务数到达上限。
解决办法:
1.缩短事务时间,增加提交事务的频度。
2.给对应的表增加索引,让更新操作执行时间更短。(我在项目中采用的办法)