From oracle-l-bounce@freelists.org Fri Apr 22 13:51:25 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3MIpPcv019168 for ; Fri, 22 Apr 2005 13:51:25 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3MIpO4Z019163 for ; Fri, 22 Apr 2005 13:51:25 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1AF571864DB; Fri, 22 Apr 2005 12:48:45 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11523-02; Fri, 22 Apr 2005 12:48:45 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8F95918639E; Fri, 22 Apr 2005 12:48:44 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: rm RULE based optimizer != GOOD IDEA Date: Fri, 22 Apr 2005 12:46:10 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: rm RULE based optimizer != GOOD IDEA Thread-Index: AcVHYb98rI3GG2s2Q8aNzvVRaosAEAAACI9A From: "Post, Ethan" To: "Robyn" Cc: X-OriginalArrivalTime: 22 Apr 2005 17:46:50.0149 (UTC) FILETIME=[43025D50:01C54763] X-archive-position: 18854 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Ethan.Post@ps.net Precedence: normal Reply-To: Ethan.Post@ps.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.63 I currently manage database source control for at least 50+ developers who are checking source in for 3 concurrent versions of a software application. The only way to maintain control of the situation is training and a ton of automated validation and reporting. So you would set up monitoring which would alert you to a situation in which a developer checked in anything with RULE string in it. When you get that they get an email asking for supporting evidence that this actually is the solution. A get emails for every code change that contains a link to review the diff as well as daily emails before each build which shows me all changes checked in with the last 24 hours. After a almost 2 years of this you would not believe the things I catch developers doing almost weekly and end up adding yet more logic to trap the error in the future. -----Original Message----- From: Robyn [mailto:robyn.sands@gmail.com]=20 Sent: Friday, April 22, 2005 12:36 PM To: Post, Ethan Cc: oracle-l@freelists.org Subject: Re: rm RULE based optimizer !=3D GOOD IDEA I agree that the valid reason for RBO to go is to remove the need for code maintenance, but it has become a crutch in some of our systems and because of that, I personally won't miss it. Never meant to imply that lazy developers justifies Oracle getting rid of it. As for the baseline, I'd prefer to see traces on the original code and use it as baseline to compare changes throughout a tuning process. Of course I can do this on the queries I know about, but I'm not the only one moving stuff to production. In your case, you mentioned gathering the type of info I like to see BEFORE adding the rule hint, and I'd throw a party if one of developers did that. Robyn -- http://www.freelists.org/webpage/oracle-l