David
Are you using RULE alone on your current system? Probably some of your
queries will run faster and some will run slower if you switch to CBO. Guess
which ones your users will complain about? My suggestion to avoid a riot at
your cubicle is to try to identify the queries that will need tuning to work
under CBO before you "bet the farm" on it. Do you have a test system?
Compute statistics on that system and ask your users/developers to run their
critical queries on this system and report to you the ones that have poor
performance so you can sort out what you need to do.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Wednesday, March 19, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
Hi everyone
I was trying to migrate one of our applications to 9.2 and put in cost at
the same time
I came across Gather_system_stats and was wondering if anyone had used it?
Did it improve the executions plan choice at all?
Thanks
David Hill
DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
