From oracle-l-bounce@freelists.org Fri Mar 12 04:13:36 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2CADaW04087 for ; Fri, 12 Mar 2004 04:13:36 -0600 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 i2CADao04082 for ; Fri, 12 Mar 2004 04:13:36 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D06B739493A; Fri, 12 Mar 2004 05:12:58 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 12 Mar 2004 05:11:50 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from bristol24.audit-commission.gov.uk (mailhost.audit-commission.gov.uk [193.128.236.210]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0179D394D61 for ; Fri, 12 Mar 2004 05:11:47 -0500 (EST) Received: from bristol21.bristol.ac (unverified) by bristol24.audit-commission.gov.uk (Content Technologies SMTPRS 4.3.6) with SMTP id for ; Fri, 12 Mar 2004 10:17:00 +0000 Received: from AC-Message_Server by bristol21.bristol.ac with Novell_GroupWise; Fri, 12 Mar 2004 10:15:43 +0000 Message-Id: X-Mailer: Novell GroupWise Internet Agent 5.5.5.1 Date: Fri, 12 Mar 2004 10:15:01 +0000 From: "Niall Litchfield" To: Subject: RE: Oracle Performance Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline X-archive-position: 615 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: n-litchfield@audit-commission.gov.uk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l I interpreted the rule the same way. However I still don't believe it to be true. It probably is true that if Oracle *or* the competing database is *much* slower as it was here there is something a smart person can do to make the slow system faster (unless one or other database is using a feature that the other does not have an equivalent for). However I am entirely convinced that there will be occasions where MSSQL is faster than Oracle on the same os/hardware. In such situations though I wouldn't expect the difference to be significant. Niall Litchfield Oracle DBA Audit Commission +44 117 975 7805 > -----Original Message----- > From: cary.millsap@hotsos.com > Sent: 11 March 2004 19:47 > To: cary.millsap@hotsos.com; oracle-l@freelists.org > Subject: RE: Oracle Performance > > > Sorry if I'm off-base, but is this a language > misunderstanding problem? > > I think that "the rule is under the same conditions, Oracle is always > faster, so..." means: "If an Oracle-based application is > slower than the > same application on a competing database, then there's probably > something that a smart person can do to make the Oracle one > perform much > faster." > > I don't think it intended was a statement about whether RULE or CHOOSE > is better. > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > * Nullius in verba * > > Upcoming events: > - Performance Diagnosis 101: 3/23 Park City, 4/6 Seattle > - Visit www.hotsos.com for schedule details... > > > -----Original Message----- > From: oracle-l-bounce@freelists.org > [mailto:oracle-l-bounce@freelists.org] On Behalf Of Juan Cachito Reyes > Pacheco > Sent: Thursday, March 11, 2004 10:19 AM > To: oracle-l@freelists.org > Subject: Re: Oracle Performance > > Why you changed what I said. > I said > > Honestly I don't agree with this, I don't think there is any > need to use > rule, in Oracle 9i, CBO works > perfectly with this kind of situation, the problem must be find and > fixed. > > ----- Original Message ----- > From: "Bricklen Anderson" > To: > Sent: Thursday, March 11, 2004 11:01 AM > Subject: Re: Oracle Performance > > > > Juan Cachito Reyes Pacheco wrote: > > > > > The rule is under same conditions Oracle is always faster, so I > think > you > > > are doing > > > something wrong, if you want to get some help you will > have to post > more > > > information. > > > > Really? That's an interesting rule. Any metrics to support that > > statement, or does that kinda fall into the same category > as the other > > 'myths'? > > > > > > Regards, > > > > Bricklen > > > > -- > > Bricklen Anderson, Database Administrator > > PresiNET Systems > > http://www.PresiNET.com > > Online Demo: https://www.presinet.com/secure/login > > ---------------------------------------------------------------- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > ---------------------------------------------------------------- > > To unsubscribe send email to: oracle-l-request@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 > > ----------------------------------------------------------------- > > > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@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 > ----------------------------------------------------------------- > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@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 > ----------------------------------------------------------------- > > ********************************************************************** This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or professional privilege. Any dissemination, distribution, copyright or use of this communication without prior permission of the sender is strictly prohibited. ********************************************************************** ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------