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