| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Performance
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_at_hotsos.com
> Sent: 11 March 2004 19:47
> To: cary.millsap_at_hotsos.com; oracle-l_at_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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Juan Cachito Reyes
> Pacheco
> Sent: Thursday, March 11, 2004 10:19 AM
> To: oracle-l_at_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" <BAnderson_at_PresiNET.com>
> To: <oracle-l_at_freelists.org>
> Sent: Thursday, March 11, 2004 11:01 AM
> Subject: Re: Oracle Performance
>
>
> > Juan Cachito Reyes Pacheco wrote:
> > <snip>
> > > 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.
> > <snip>
> > 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_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
> > -----------------------------------------------------------------
> >
>
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
>
-- 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 Fri Mar 12 2004 - 04:13:36 CST
 |
 |