RE: Execution plan changing

From: Michael Schmitt <mschmitt_at_uchicago.edu>
Date: Fri, 14 Sep 2012 14:30:49 +0000
Message-ID: <1184E7EFAB1D1C47A5038D06F64BE92602022F6B_at_XM-MBX-02-PROD.ad.uchicago.edu>

Hi Paul,
Sorry, both of these parameters are a bit over my head. I will need to look into them. We are running on 11.2.0.1

Thanks,
Mike

From: Paul Drake [mailto:bdbafh_at_gmail.com] Sent: Friday, September 14, 2012 9:21 AM To: Michael Schmitt
Cc: oracle-l_at_freelists.org
Subject: Re: Execution plan changing

results in "_execution_plan_deterministic"úLSE

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<mailto:mschmitt_at_uchicago.edu>> wrote: _optimizer_use_feedback=TRUE

From: Paul Drake [mailto:bdbafh_at_gmail.com<mailto:bdbafh_at_gmail.com>] Sent: Friday, September 14, 2012 8:46 AM To: Michael Schmitt
Cc: Christopher.Taylor2_at_parallon.net<mailto:Christopher.Taylor2_at_parallon.net>; oracle-l_at_freelists.org<mailto: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-l Received on Fri Sep 14 2012 - 09:30:49 CDT