RE: Oracle Performance
- From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Mar 2004 10:15:01 +0000
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@xxxxxxxxxx
> Sent: 11 March 2004 19:47
> To: cary.millsap@xxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Juan Cachito Reyes
> Pacheco
> Sent: Thursday, March 11, 2004 10:19 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
