| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Performance
I am surprised that nobody mentioned Histograms? Which leads to the question
- Does SquealServer do histograms?
John Kanagaraj
>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mike Killough
>Sent: Thursday, March 11, 2004 6:29 AM
>To: oracle-l_at_freelists.org
>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_at_superele.gov.bo>
>>Reply-To: oracle-l_at_freelists.org
>>To: <oracle-l_at_freelists.org>
>>CC: "VChoque" <VChoque_at_superele.gov.bo>
>>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_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
>>-----------------------------------------------------------------
>
>_________________________________________________________________
>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_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
>-----------------------------------------------------------------
>
-- 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 - 13:56:58 CST
 |
 |