Thanks, Terry. That reminded me to review Wolfgang Breitling's "What is New in the oracle 9i CBO". I'm setting one-by-one the parameters that changed defaults between 8i and 9.2 at the session level. I haven't hit the correct one yet, but you've given me hope! Barb
On 11/4/05, Terry Sutton <terrysutton@(protected)> wrote: > > Barbara, > I can't tell you the specific action to take to fix the process, but it's > root cause is probably because of the different default values in 9i vs. 8i > for many underscore parameters related to the optimizer. These particularly > affect subqueries. Take a look in Metalink for terms like "unnest". > --Terry > > I'm testing an upgrade of a database from version 8.1.7.4 <http://8.1.7.4>to version > 9.2.0.4 <http://9.2.0.4> > Test db LEGS Oracle version 9.2.0.4 <http://9.2.0.4> just created > Prod db ARMS Oracle version 8.1.7.4 <http://8.1.7.4> > Prod db AMPROD Oracle version 9.2.0.4 <http://9.2.0.4> > >
Thanks, Terry.<br> That reminded me to review Wolfgang Breitling's "What is New in the oracle 9i CBO".<br> I'm setting one-by-one the parameters that changed defaults between 8i and 9.2 at the session level.<br> I haven't hit the correct one yet, but you've given me hope!<br> Barb<br> <br><br><div><span class="gmail_quote">On 11/4/05, <b class="gmail_sendername" >Terry Sutton</b> <<a href="mailto:terrysutton@(protected)">terrysutton@(protected)< /a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><font face="Arial" size="2">Barbara,</font></div> <div><font face="Arial" size="2"></font> </div> <div><font face="Arial" size="2">I can't tell you the specific action to take to fix the process, but it's root cause is probably because of the different default values in 9i vs. 8i for many underscore parameters related to the optimizer. These particularly affect subqueries. Take a look in Metalink for terms like "unnest".</font></div><span class="sg"> <div><font face="Arial" size="2"></font> </div> <div><font face="Arial" size="2">--Terry</font></div></span><div><span class="e " id="q_1075ca9d3f2240f2_2"> <blockquote style="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;"> <div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">I'm testing an upgrade of a database from version <a href="http://8.1.7.4" target="_blank" onclick="return top.js .OpenExtLink(window,event,this)">8.1.7.4</a> to version <a href="http://9.2.0.4" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"> 9.2.0.4</a><br> Test db LEGS Oracle version <a href="http://9.2.0.4" target=" _blank" onclick="return top.js.OpenExtLink(window,event,this)">9.2.0.4</a> just created <br> Prod db ARMS Oracle version <a href="http://8 .1.7.4" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">8 .1.7.4</a><br> Prod db AMPROD Oracle version <a href="http://9.2.0.4" target=" _blank" onclick="return top.js.OpenExtLink(window,event,this)">9.2.0.4</a><br> <br></div></blockquote></span></div></blockquote></div><br>
