From oracle-l-bounce@freelists.org Thu Mar 11 13:56:58 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2BJuvE00799 for ; Thu, 11 Mar 2004 13:56:57 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2BJuvo00793 for ; Thu, 11 Mar 2004 13:56:57 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1EB7A397DA8; Thu, 11 Mar 2004 13:48:37 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 11 Mar 2004 13:47:31 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from usscmail6.hds.com (usscmail6.hds.com [63.74.235.12]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C2AEB397466 for ; Thu, 11 Mar 2004 11:45:32 -0500 (EST) Received: from mail.hds.com (usscmail8 [10.1.6.229]) by usscmail6.hds.com (8.11.5-p0-rfc19719/8.11.5) with ESMTP id i2BGoVJ27844 for ; Thu, 11 Mar 2004 08:50:31 -0800 (PST) Received: from usscceb02.hds.com (usscclb02.hds.com [10.1.6.227]) by mail.hds.com (8.11.5-p0-rfc19719/8.11.5) with ESMTP id i2BGoGh02423 for ; Thu, 11 Mar 2004 08:50:16 -0800 (PST) Received: by usscceb02.hds.com with Internet Mail Service (5.5.2653.19) id ; Thu, 11 Mar 2004 08:50:32 -0800 Message-ID: <35CFD500D7BDCE43B9030BBA5979DC181D93C5@ussccem13.hds.com> From: John Kanagaraj To: "'oracle-l@freelists.org'" Subject: RE: Oracle Performance Date: Thu, 11 Mar 2004 08:53:05 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-archive-position: 519 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: john.kanagaraj@hds.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l I am surprised that nobody mentioned Histograms? Which leads to the question - Does SquealServer do histograms? John Kanagaraj >-----Original Message----- >From: oracle-l-bounce@freelists.org >[mailto:oracle-l-bounce@freelists.org] On Behalf Of Mike Killough >Sent: Thursday, March 11, 2004 6:29 AM >To: oracle-l@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" >>Reply-To: oracle-l@freelists.org >>To: >>CC: "VChoque" >>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@freelists.org >[mailto:oracle-l-bounce@freelists.org] En >>nombre de DENNIS WILLIAMS >>Enviado el: Jueves 11 de Marzo de 2004 9:16 >>Para: 'oracle-l@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@lifetouch.com >> >>-----Original Message----- >>From: oracle-l-bounce@freelists.org >>[mailto:oracle-l-bounce@freelists.org]On >>Behalf Of Huascar Espinoza >>Sent: Thursday, March 11, 2004 7:04 AM >>To: oracle-l@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@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@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@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 -----------------------------------------------------------------