This discussion is archived
1 Reply Latest reply: Oct 7, 2011 4:09 PM by jonhwell RSS

Problems in my update

jonhwell Newbie
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points