Hi List,
I'm going to change my job and I'll have to inherite one DB which doesn't seem to be
very good
designated. I haven't known much about the application yet and I can't post many
details to you but
I would appreciate your general advices.
Despite of the optimizer_mode set to RULE at instance level, they use many new features
(partitioning, bitmap indexes, function-based indexes, etc). It seems the system is
overloaded with
indexes and optimizer hints. They collect statistics regularly. Molotov's cocktail! So
I expect some
hybrid behaviour of the optimizer. The sql statements don't seem to be especially
optimized for RBO
and give real trouble for system (my first feeling).
Before we could start any sql tuning we have to decide which road to choose. My current
understanding is that we need to fix existing execution plans with 'Plan Stability'
option and set
optimizer_mode = all_rows. Then ask the developers to use CBO in new development and
gradually test
and rewrite existing code. What would be your advice? Any experience?
Also I would like to know if anybody use the 'plan stability' feature. Is it stable
itself ? :) The
system is 8.1.7.0.1 on Red Hat
Thanks,
Ed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shevtsov, Eduard
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).