Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Getting multiple explain plans for 1 sql statement

Getting multiple explain plans for 1 sql statement

From: <ryan_gaffuri_at_comcast.net>
Date: Fri, 29 Sep 2006 17:38:11 +0000
Message-Id: <092920061738.5075.451D5A03000701D7000013D32200734364079D9A00000E09A1020E979D@comcast.net> 





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? 

--
http://www.freelists.org/webpage/oracle-l


Received on Fri Sep 29 2006 - 12:38:11 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US