Re: CBO irregularity

From: <chris_at_thedunscombes.f2s.com>
Date: Tue, 8 Jun 2004 16:35:02 +0100
Message-ID: <1086708902.40c5dca643cdf@webmail.freedom2surf.net>

Jonathan,

Thanks for providing the exact version when the change occured.

Cheers,

Chris

Quoting Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>:

>
>
> :
> : 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jun 08 2004 - 10:31:58 CDT