Copy plan program is failing and the plan partitions turns to unusable state
Hi All,
Copy plan program is failing with 'No free partitions available'. We had 1 free plan partitions available in msc_plan_partitions (free_flag =1), but still the copy plan program errors out occationally in our production instance and also the plan partition moves to 'UNUSABLE' state. Please note that we will have only 1 free partition while performing copy plan.
Please let me know the reason the partition moving to unusable state and can we have 1-5 plan partitions available all the time.. If yes, will it impact the performance and 24x7 switch plan ATP as ATP plan will occupy one partition.. Appreciate your help..