RE: Execution plan changing
- From: Michael Schmitt <mschmitt@xxxxxxxxxxxx>
- To: Paul Drake <bdbafh@xxxxxxxxx>
- Date: Fri, 14 Sep 2012 14:30:49 +0000
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@xxxxxxxxx]
Sent: Friday, September 14, 2012 9:21 AM
To: Michael Schmitt
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxx<mailto:mschmitt@xxxxxxxxxxxx>> wrote:
_optimizer_use_feedback=TRUE
From: Paul Drake [mailto:bdbafh@xxxxxxxxx<mailto:bdbafh@xxxxxxxxx>]
Sent: Friday, September 14, 2012 8:46 AM
To: Michael Schmitt
Cc: Christopher.Taylor2@xxxxxxxxxxxx<mailto:Christopher.Taylor2@xxxxxxxxxxxx>;
oracle-l@xxxxxxxxxxxxx<mailto: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:
