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:
>> * COD_IMPORTACION
>> * NRO_FACTURACION
>> * COD_FACTURA_ESTIMADA
>> * COD_FACTURA_REFACTURADA
>> * COD_MOTIVO_ESTIMACION
>> * 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 http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

JPEG image

Other related posts: