Re: Oracle Performance

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Thu, 11 Mar 2004 09:24:01 -0400
Message-ID: <00c201c4076c$233d7870$2501a8c0@dazasoftware.com>

You are asking, my old car worked 10 miles with 1 lt and my new car, only 9. Is very difficult to know that, you have to study several years to find an answer .

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.
I have a paper which can introduce to performance, I'll fix some bugs in some weeks.
http://www.geocities.com/juancarlosreyesp/101basictunningonOracle9i.pdf

Original Message ----- From: "DENNIS WILLIAMS" <DWILLIAMS_at_LIFETOUCH.COM> To: <oracle-l_at_freelists.org> Sent: Thursday, March 11, 2004 9:16 AM Subject: RE: Oracle Performance

Huascar

Normal? No. In order to help diagnose your situation, please post more details. Like your query, the sizes of your tables, etc. Have you analyzed the tables in Oracle?

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Huascar Espinoza
Sent: Thursday, March 11, 2004 7:04 AM
To: oracle-l_at_freelists.org
Subject: Oracle Performance

¿Is it normal that a SQL sentence: MAX or MIN, execute over 1.5 minutes on Oracle 9i, and in 1 sec. on SQL Server 7.0 (2 millions of registers), using equals data structures and servers? ¿Why occur this situation?

Thank you,

Huascar Espinoza

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

Received on Thu Mar 11 2004 - 07:24:53 CST