Re: CBO irregularity

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@xxxxxxxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: