Hi!
Just wondering anyone has notice this.
19.15.0.0.0 version, RDBMS
SYS_AUTO_SPM_EVOLVE_TASK run during maintenance window timed out as > time limit of 1 hour.
ORA-13639: The current operation was interrupted because it timed out.
Reports indicated:
Number of plans processed : 6
Number of findings : 5
Number of recommendations : 0
Number of errors : 1
The one with error (timed out) = SQL_PLAN_xxxx
Although this particular plan evolve has timed out halfway, the last verified date of this plan name is being still updated and no longer null.
Isn't this an issue? Because if the last verified is updated (though evolve did not complete), than automatic evolve will only consider and verify the plan again if at least 30 days has passed since it was last verified.
thanks