RE: Oracle Performance

From: Rich Gesler <rgesler_at_atriumwindows.com>
Date: Thu, 11 Mar 2004 09:22:51 -0500
Message-ID: <003101c40774$568f01f0$572c0280@AWD001680>

Re: Oracle PerformanceHas anybody asked if these tables are indexed yet?

Rich
  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tim Gorman   Sent: Thursday, March 11, 2004 9:00 AM   To: oracle-l_at_freelists.org
  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_at_superele.gov.bo 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] En nombre de DENNIS WILLIAMS

Enviado el: Jueves 11 de Marzo de 2004 9:16 Para: 'oracle-l_at_freelists.org'
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_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

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
-----------------------------------------------------------------

Received on Thu Mar 11 2004 - 09:09:26 CST