RE: Oracle Performance
- From: "Rich Gesler" <rgesler@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Mar 2004 09:22:51 -0500
Re: Oracle PerformanceHas anybody asked if these tables are indexed yet?
Rich
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Tim Gorman
Sent: Thursday, March 11, 2004 9:00 AM
To: oracle-l@xxxxxxxxxxxxx
Cc: VChoque
Subject: Re: Oracle Performance
Please run ANALYZE TABLE <table-name> ESTIMATE STATISTICS SAMPLE 10
PERCENT on both tables? Then try again?
on 3/11/04 6:35 AM, Huascar Espinoza at hespinoza@xxxxxxxxxxxxxxx wrote:
To realize the test, we have the basic following structure (similar on
Oracle 9i and SQL Server 7.0):
· Table ?SC_FACTURACION? have the following indexes:
a.. COD_IMPORTACION
b.. NRO_FACTURACION
c.. COD_FACTURA_ESTIMADA
d.. COD_FACTURA_REFACTURADA
e.. COD_MOTIVO_ESTIMACION
f.. COD_NIVEL_CALIDAD.
· Table ?GE_HISTORICO_IMPORTACION? has 30 registers.
· Table ?SC_FACTURACION? has 1,885,618 registers.
On ?SC_FACTURACION? we execute the following SQL sentences:
1.. SELECT COUNT(NRO_FACTURACION) FROM SC_FACTURACION WHERE
COD_IMPORTACION = '14' AND COD_NIVEL_CALIDAD = '1'
2.. SELECT MAX(NRO_FACTURACION) FROM SC_FACTURACION WHERE
COD_IMPORTACION = '14' AND COD_NIVEL_CALIDAD = '1'
3.. SELECT MIN(NRO_FACTURACION) FROM SC_FACTURACION WHERE
COD_IMPORTACION = '14' AND COD_NIVEL_CALIDAD = '1'
The results are:
Sentence Performance ORACLE 9i Performance MS SQL Server 7.0
1 2 minutes 20 secs.
2 2 minutes 1 sec.
3 50 secs. 1 secs.
The servers are the followins features:
ORACLE 9i Server
Processor Intel Pentium IV - 2.4 GHz
RAM Memory 512 MB
S SQL Server 7.0 Server
Processor Intel Celeron 2.4 GHz
RAM Memory 380 MB
Please let me know, why the performance of Oracle is so low.
Thank you!
Huáscar Espinoza
-----Mensaje original-----
De: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
En nombre de DENNIS WILLIAMS
Enviado el: Jueves 11 de Marzo de 2004 9:16
Para: 'oracle-l@xxxxxxxxxxxxx'
Asunto: 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@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Huascar Espinoza
Sent: Thursday, March 11, 2004 7:04 AM
To: oracle-l@xxxxxxxxxxxxx
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@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:
