RE: Oracle Performance
- From: John Kanagaraj <john.kanagaraj@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Mar 2004 08:53:05 -0800
I am surprised that nobody mentioned Histograms? Which leads to the question
- Does SquealServer do histograms?
John Kanagaraj
>-----Original Message-----
>From: oracle-l-bounce@xxxxxxxxxxxxx
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mike Killough
>Sent: Thursday, March 11, 2004 6:29 AM
>To: oracle-l@xxxxxxxxxxxxx
>Subject: RE: Oracle Performance
>
>
>I would have to assume that one of these indexes is on COD_IMPORTACION
>COD_NIVEL_CALIDAD. Please provide the explain plans. I assume
>that you have
>also analyzed the SC_FACTURACION table.
>
>
>>From: "Huascar Espinoza" <hespinoza@xxxxxxxxxxxxxxx>
>>Reply-To: oracle-l@xxxxxxxxxxxxx
>>To: <oracle-l@xxxxxxxxxxxxx>
>>CC: "VChoque" <VChoque@xxxxxxxxxxxxxxx>
>>Subject: RE: Oracle Performance
>>Date: Thu, 11 Mar 2004 09:35:18 -0400
>>
>>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 //www.freelists.org/archives/oracle-l/
>>FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
>>-----------------------------------------------------------------
>
>_________________________________________________________________
>One-click access to Hotmail from any Web page - download MSN
>Toolbar now!
>http://clk.atdmt.com/AVE/go/onm00200413ave/direct/01/
>
>----------------------------------------------------------------
>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
-----------------------------------------------------------------
Other related posts:
