Oracle Database Discussions

I've searched Oracle's documentation and wanted to confirm my understanding on a few SPM questions:

Does enabling SPM (setting OPTIMIZER_USE_SQL_PLAN_BASELINES to TRUE) for a database and having previously captured SQL plans, effectively lock all the plans for subsequent executions of the captured SQL statements?


Must automatic plan capture be running all of the time in order to know whether the optimizer is coming up with new plans for your SQL baselines? If it was OFF it seems that any new plans for statements in your baseline would always be ignored and you'd be ignorant of new plans.

Thank you,

Richard