Re: CBO irregularity
- From: chris@xxxxxxxxxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 8 Jun 2004 16:35:02 +0100
Jonathan,
Thanks for providing the exact version when the change occured.
Cheers,
Chris
Quoting Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>:
>
>
> :
> : PS Even doing this I've had 1 or 2 cases where the execution plan
> generated by
> : the stored proc was different from what happened in live. Couldn't fully
> : explain it must have been an optimizer funny. BTW it wasn't the
> "optimizer_goal
> : = choose always used by PL/SQL" "feature" that we had to endure up until,
> 9i I
> : believe.
> :
>
> The change appeared in 8.1.6 with the default for a hidden parameter:
>
> _optimizer_mode_force = true in 8.1.6
> _optimizer_mode_force = false in 8.1.5
>
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-------------------------------------------------
Everyone should have http://www.freedom2surf.net/
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
