Does anyone have any idea of how many
people are using cpu_costing ? Could we
take a quick poll ? My impression is that
the number is still pretty low.

In answer to your question: So far I haven't found
any good reasons to not use it - but as it says in
the article, it's almost as scary as switching from
RBO to CBO.

One particular oddity I came across a couple
of weeks ago is that if you are messing about
with multiple block sizes, you may find that the
switch to cpu_costing makes the optimizer to
do more tablescans (or index fast full scans)
on objects in tablespaces with larger block sizes.

Bear in mind that when you migrate to 10g,
you WILL be using cpu_costing unless you
fiddle with a couple of hidden parameters to
disable it.

Please see the official ORACLE-L FAQ: http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
Please see the official ORACLE-L FAQ: http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--