Database - RAC/Scalability (MOSC)

MOSC Banner

Different execution plans of query on different RAC nodes

edited Jun 12, 2012 2:30AM in Database - RAC/Scalability (MOSC) 4 comments
Hi

    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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center