oracle 回滚字段过小_详解Oracle参数fast_start_parallel_rollback--并行回滚

概述

最近因为PLSQL崩溃导致几千万的数据产生了回滚，大概有300多万块需要回滚，那么怎么去调整Oracle回滚的速度呢？

---

fast_start_parallel_rollback

回滚的速度快慢通过参数fast_start_parallel_rollback来实现，此参数可以动态调整

关于fast_start_parallel_rollback参数，此参数决定了回滚启动的并行次数，在繁忙的系统或者IO性能较差的系统，如果出现大量回滚操作，会显著影响系统系统，可以通过调整此参数来降低影响。官方文档的定义如下：

FAST_START_PARALLEL_ROLLBACK specifies the degree of parallelism used when recovering terminated transactions. Terminated transactions are transactions that are active before a system failure. If a system fails when there are uncommitted parallel DML or DDL transactions, then you can speed up transaction recovery during startup by using this parameter.

Values:

FALSE

Parallel rollback is disabled

LOW

Limits the maximum degree of parallelism to 2 * CPU_COUNT

HIGH

Limits the maximum d