“SMON: parallel recovery restart with degree=0 (!=32)”
We were doing imp on a table populating many millions of records. In the middle i have killed and restarted the import. The sequent import went slow, when checked noticed below event in v$session
“wait for stopper event to be increased”
This event is because of parallel rollback of the previous import.
We disabled the behaviour using below command and restart the db.
alter system set fast_start_parallel_rollback = false scope=spfile;
import stated going fast.
convert this post to pdf.