1 Reply Latest reply: Oct 7, 2011 6:09 PM by jonhwell RSS

    Problems in my update

    jonhwell
      Migrated to 10.1.0.4 and 10.2.0.1 before using a Windows 2003 32bit and now use a Windows 2003 64 bit, I use Oracle with Visual Basic 6, with the shift to a more powerful server I went from a Xeon with a core for a core I7 whole system was faster, however, has a set of searches, which are too slow to run I'll put a sample ...

      SELECT ROWNUM, SUP_ITEMORDEMCOMPRA.NRSEQOC,
      VW_EMPRESA.NOESTABELECIMENTO, QTDCOMPRADA, TO_CHAR(DTEMISOC,'DD/MM/YYYY'),
      DECODE(TO_CHAR(DTENCOMENDA,'DD/MM/YYYY'),'01/01/1800',' ',TO_CHAR(DTENCOMENDA,'DD/MM/YYYY')),
      DECODE(TO_CHAR(DTPREVRECEB,'DD/MM/YYYY'),'01/01/1800',' ',TO_CHAR(DTPREVRECEB,'DD/MM/YYYY')),
      NOPESSOAFORNEC, NOSTATUS
      FROM VW_FORNECEDOR, VW_EMPRESA, SUP_STATUS, SUP_ORDEMCOMPRA, SUP_ITEMORDEMCOMPRA
      WHERE SUP_ITEMORDEMCOMPRA.CDMATERIAL = 100
      AND ( (TRUNC(DTPREVRECEB) >= TRUNC(SYSDATE) AND SUP_ITEMORDEMCOMPRA.CDSTATUS = FNC_PARAMETRO('SUP','CDSTATUS_ATENDIDO',0) ) OR
      (TRUNC(DTPREVRECEB) = '01/01/1800' AND SUP_ITEMORDEMCOMPRA.CDSTATUS IN (FNC_PARAMETRO('SUP','CDSTATUSCOMOC',0),FNC_PARAMETRO('SUP','CDSTATUS_ENCOMENDA',0),FNC_PARAMETRO('SUP','CDSTATUS_PARCIAL',0),FNC_PARAMETRO('SUP','CDSTATUS_TRANSITO',0))))
      AND SUP_ITEMORDEMCOMPRA.NRPED = 0
      AND SUP_ORDEMCOMPRA.NRSEQOC = SUP_ITEMORDEMCOMPRA.NRSEQOC
      AND SUP_ORDEMCOMPRA.DTCANCOC = '01/01/1800'
      AND SUP_STATUS.CDSTATUS(+) = SUP_ITEMORDEMCOMPRA.CDSTATUS
      AND VW_EMPRESA.CDPESSOAEMP = SUP_ORDEMCOMPRA.CDPESSOAEMP
      AND VW_FORNECEDOR.CDPESSOAFORNEC = SUP_ORDEMCOMPRA.CDPESSOAFORNEC
      ORDER BY VW_EMPRESA.NOESTABELECIMENTO, SUP_ITEMORDEMCOMPRA.NRSEQOC

      Before it did not happen, someone have any idea what can be?