Re: Execution plan changing
From: Paul Drake <bdbafh_at_gmail.com>
Date: Fri, 14 Sep 2012 10:21:23 -0400
Message-ID: <CAPptggVbpG8JaHK52fE2JiWC4i69OBtWjfXEwambgD1rQcK5kQ_at_mail.gmail.com>
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.
Date: Fri, 14 Sep 2012 10:21:23 -0400
Message-ID: <CAPptggVbpG8JaHK52fE2JiWC4i69OBtWjfXEwambgD1rQcK5kQ_at_mail.gmail.com>
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_at_uchicago.edu>wrote:
> _optimizer_use_feedback=TRUE****
>
> ** **
>
> *From:* Paul Drake [mailto:bdbafh_at_gmail.com]
> *Sent:* Friday, September 14, 2012 8:46 AM
> *To:* Michael Schmitt
> *Cc:* Christopher.Taylor2_at_parallon.net; oracle-l_at_freelists.org
>
> *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 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 14 2012 - 09:21:23 CDT