Re: Execution plan changing

  • From: Paul Drake <bdbafh@xxxxxxxxx>
  • To: Michael Schmitt <mschmitt@xxxxxxxxxxxx>
  • Date: Fri, 14 Sep 2012 10:21:23 -0400

results in "_execution_plan_deterministic"=FALSE
This feature was introduced in 11g.
Perhaps it is worth using in 11.2.0.3.
IMHO, It was not worth using in 11.2.0.2.


On Fri, Sep 14, 2012 at 9:54 AM, Michael Schmitt <mschmitt@xxxxxxxxxxxx>wrote:

>  _optimizer_use_feedback=TRUE****
>
> ** **
>
> *From:* Paul Drake [mailto:bdbafh@xxxxxxxxx]
> *Sent:* Friday, September 14, 2012 8:46 AM
> *To:* Michael Schmitt
> *Cc:* Christopher.Taylor2@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
>
> *Subject:* Re: Execution plan changing****
>
>  ** **
>
> SQL> show parameter "_optimizer_use_feedback".
>
> ****
>



-- 
http://www.completestreets.org/faq.html
http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf


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


Other related posts: