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?