> 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 ?
Generally, you shouldn't bother as newer versions of the CBO supposed to
do better job (and usually they do), so changes in plans may be for gain.
But if they are not, you can hint queries that performed better with different
plans to those plans, or, if you can't change the SQL, create stored outlines
with needed plans and force them on these misbehaving queries. Having
all statistics collected and keeping them current are also very helpful to CBO.
Applying latest patchset usually doesn't hurt either.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Tue Jul 23 2002 - 14:21:28 CDT
