Getting multiple explain plans for 1 sql statement

  • From: ryan_gaffuri@xxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 29 Sep 2006 17:38:11 +0000

10G Release 2:

We are seeing two different explain plans(two rows) in the v$sql_plan for a 
given hash_value

How does Oracle decide which plan to use? Or is one of them just historical 
data? If so how do you tell which plan is active? 

Other related posts: