when the execution plan change for oracle database for single SQL?

How Execution Plans Can Change occur by the below reasons:

1. Schema changes (usually changes in indexes & table ) between the two operations.
2. Different Costs
3. Even if the schema are the same, the optimizer can choose different execution plans when the costs are different. Some factors that affect the costs include the following:

• Data volume and statistics
• Bind variable types and literal values