Re: Does a db upgrade change the SQL parser ?

It doesn't help you this time round, I'm afraid, but now that you are on 8i, you should consider investigating Stored Outlines. These are 'frozen execution plans'... they're pretty much set in stone, and one of their claims to fame is that they ensure execution plans don't change when you upgrade or change O/S or apply patches or re-calculate statistics. So if they're in place by the time you eventually upgrade to 9i, you won't experience the same problems you did this upgrade round.

'Course.... one has also to question the wisdom of setting in stone a sub-optimal execution plan that new optimizer features could improve upon if only it were allowed to.

But horses for courses.

Regards
HJR "Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message news:ahj9cp$tg3jg$1_at_ID-152732.news.dfncis.de...
> Thank You Telemachus,
>
> > go to 9.2 and be current ...
> pity, this is not my decision, it is likely that we will stay on 8.1.7 for
a
> longer time now...
>
> > have you all the 817 patches ?
> We have 8.1.7. R3 now.
>
> > ORA-00980 means there's something missing
> ... but what "something" ? It concerns only one table, and we decided to
> re-create its public synonym in the late evening ...
>
> Back to changes of parsing, is there something that could/should be done
> about it ?
> Can a dba change it with init parameters,
> or is it fixed inside the Oracle Rdbms Software ?
>
>
>
>
Received on Tue Jul 23 2002 - 16:24:01 CDT