RE: CBO irregularity

From: Vergara, Michael (TEM) <mvergara_at_guidant.com>
Date: Mon, 7 Jun 2004 12:40:47 -0700
Message-ID: <791D0E1ECDECD04D89205F33806FC38701E91EF8@temmse06.tem.guidant.com>

Rick:

You might try transporting the Production statistics back to the development environments. See Oracle note 117203.1 on MetalLink.

Cheers,
Mike

-----Original Message-----

From: Rick Stephenson [mailto:RStephenson_at_Ovid.com] Sent: Monday, June 07, 2004 12:36 PM
To: oracle-l_at_freelists.org
Subject: CBO irregularity

The CBO has been nothing short of a pain in the butt to me. Going from Development to QA to a live environment achieves unexpected results. It seems that you never know what you are going to get when it comes to an execution plan. The developers run Oracle on their Windows box and the execution path is one way, but when it gets moved to a QA environment it chooses another way. At least with the RULE base optimizer you know what you are going to get.

Sometimes I think I am the only one with this problem. How do you work this? Do you always use hints, do you use stored outlines....?

Thanks,

Rick Stephenson

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


-----------------------------------------------------------------

Received on Mon Jun 07 2004 - 14:38:11 CDT