Re: CBO irregularity

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 8 Jun 2004 09:58:04 +0100
Message-ID: <02d801c44d36$b5e457b0$7102a8c0@Primary>

Note in-line

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated May 1st

• Original Message ----- From: <chris_at_thedunscombes.f2s.com> To: <oracle-l_at_freelists.org> Sent: Tuesday, June 08, 2004 9:39 AM Subject: Re: CBO irregularity

:
: 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
-----------------------------------------------------------------

Received on Tue Jun 08 2004 - 03:54:51 CDT