Re: Optimizer Instability on 10.2.0.2

i've heard of system still running under Oracle 7 and i've seen many running
under Oracle 8i. Those vesions are not supported, but are running from years
and support does not need a lot.
Also us are still using 9iR2 on some installations, we are migrating on 10g and
we have got problems with CBO. However, on 10g also not supported RBO still exists,
you can use it, but it gives you no performance.

By
Cristian
http://cristiancudizio.wordpress.com
http://oracledb.wordpress.com

Jack ha scritto:

> Hi!
>
> We are still using 9iR2 and found any reasons to switch to CBO.
> Our databases are relative small, even MySQL could handle those.
>
> But time is ticking...
> 9iR2 Jul-2010 Extended Support Ends
> Oracle Forms 6iExtended Support (ES): 31-JAN-2008
>
> Forms are run in Citrix, and that is giving a bit more time. in a way.
>
> I am sure there are plenty of systems in similar situation (or in even worse
> ;).
>
> Jack
> "Mark D Powell" <Mark.Powell_at_eds.com> wrote in message
> news:1177089894.142394.301420_at_o5g2000hsb.googlegroups.com...
> > On Apr 20, 8:02 am, "Jack" <n..._at_INVALIDmail.com> wrote:
> >> RBO is rock stable, and needs zero admin :)
> >> -> RBO is still better than CBO
> >> (If no need for some new features)
> >>
> >> want RBO back.
> >
> > Back on version 7.0 we had a vendor application written per the vendor
> > to run rules based. The customer and developers said the performance
> > was horrible and wanted to know what DBA could do about it. We said
> > all we could do was generate statistics and run cost based but that
> > some SQL could go to lunch if we did this.
> >
> > The customer said try it. We did and performance was significantly
> > better under cost than under rule so life under the RBO wasn't that
> > great. The requirement to tune was still a basic DBA fact of life.
> >
> > HTH -- Mark D Powell --
> >
Received on Mon Apr 23 2007 - 03:00:58 CDT