From oracle-l-bounce@freelists.org Fri Oct 29 13:18:22 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9TIILY05891 for ; Fri, 29 Oct 2004 13:18:21 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i9TIILI05886 for ; Fri, 29 Oct 2004 13:18:21 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 19D0173044C; Fri, 29 Oct 2004 13:22:02 -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 32651-61; Fri, 29 Oct 2004 13:22:02 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AAF6372E9EB; Fri, 29 Oct 2004 13:19:22 -0500 (EST) Message-ID: <30462D80AA52E74698512ADCC4F7EAA317C1FCE1@exchange.aetvn.com> From: "Gogala, Mladen" To: "'joelgarry@anabolicinc.com'" , oracle-l@freelists.org Subject: RE: Re[2]: That crazy CBO..... Date: Fri, 29 Oct 2004 14:03:23 -0400 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 11696 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mladen.Gogala@aetn.com Precedence: normal Reply-To: Mladen.Gogala@aetn.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org OEM? OEM as in "Oracle [Expletive] Manager"? As far as self-tuning-database marketing phrases, haven't you heard about the "paperless office"? It was IBM's favorite terminology in the 1970's. This was an incredible boost for the paper industry. The advent of printers has been the best thing that has ever happened to the paper industry. Our paperless offices are sinking under the sheer weight of printouts. Having that in mind, as a senior Oracle DBA, I am looking forward to "self tuning database". My job can be renamed to "Director of Information and Office Technology" and with mandatory "e-" in front be abbreviated to "e-DIOT", but I will still be doing the same thing. PS: --- In case that anybody needs a clarification, "e-DIOT" comes from Dilbert. That, of course, was the shiny new title for the PHB. -- Mladen Gogala A & E TV Network Ext. 1216 > -----Original Message----- > From: Joel Garry [mailto:joelgarry@anabolicinc.com] > Sent: Friday, October 29, 2004 1:34 PM > To: oracle-l@freelists.org > Subject: Re[2]: That crazy CBO..... > > > Jonathan Gennick wrote: > > >I'd argue that Oracle should fix it. One shouldn't have to > bother with > >something as cumbersome as 10046 trace just to see an > execution plan. I > >don't even like having to query the plan table (or use > dbms_xplan) from > >SQL*Plus. The front end should do all that crud for me. Just MHO. > > You mean, like OEM? :) > > I smiley, but actually I use it all the time, even though > explain plain sometimes lies like a dog. Yes, Oracle should > fix all those things. Until Oracle fixes _all_ those things, > any self-tuning-database marketspeak is suspect, to say the least. -- http://www.freelists.org/webpage/oracle-l