Different execution plans of query on different RAC nodes
We have one big partitoned table which is being created evey month new with 31 days partitions. This table's size become more than 800 GB at the end of month. Every day, we are analyzing the daily partitions after loading whole day data in that particular day's partition. we are analying the partition with option "no_invalidate=false" of DBMS_STATS package. Due to this, query, takes proper plan on the node on which we analyzes the partition while on other nodes, it des not pickup the correct plan. is there any option by which we can invalidate the execution plan across