Anônimo.
Anônimo
Ol?, possuo uma solu??o de integra??o que gera triggers num banco Oracle 9.01. Quando as mesmas est?o criadas, o desempenho da aplica??o cai drasticamente. O que pode ser??? Existe alguma paremetriza??o poss?vel???
Abaixo segue a estrutura t?pica das triggers:
CREATE OR REPLACE TRIGGER DBOPROMUL.PSNI_T_ARQ_306
BEFORE INSERT ON DBOPROMUL.T_ARQ
FOR EACH ROW
DECLARE vSEQUENCE NUMBER(10);
vCONTADOR NUMBER(4);
BEGIN
IF ( USER NOT LIKE ‘REPL’) THEN
SELECT PSN_CMENVI.NEXTVAL INTO vSEQUENCE FROM DUAL;
vCONTADOR := 0;
INSERT INTO CMENVI ( dCDA, iSEQ, iNCO, sTBA, sCLA, sDEL, sICE, CT_VARCHAR2) VALUES (SYSDATE, vSEQUENCE,4,’DBOPROMUL.T_ARQ’,’CD_TIPO’,’N’,’S’,:NEW.”CD_TIPO”);
INSERT INTO CMENVI ( dCDA, iSEQ, iNCO, sTBA, sCLA, sDEL, sICE, CT_VARCHAR2) VALUES (SYSDATE, vSEQUENCE,4,’DBOPROMUL.T_ARQ’,’DS_TP_ARQ’,’N’,”,:NEW.”DS_TP_ARQ”);
INSERT INTO CMENVI ( dCDA, iSEQ, iNCO, sTBA, sCLA, sDEL, sICE, CT_VARCHAR2) VALUES (SYSDATE, vSEQUENCE,4,’DBOPROMUL.T_ARQ’,’ID_IN_OUT’,’N’,”,:NEW.”ID_IN_OUT”);
INSERT INTO CMENVI ( dCDA, iSEQ, iNCO, sTBA, sCLA, sDEL, sICE, CT_NUMBER) VALUES (SYSDATE, vSEQUENCE,4,’DBOPROMUL.T_ARQ’,’ID_TP_PROC’,’N’,”,:NEW.”ID_TP_PROC”);
END IF;
END;
Anônimo
Na tabela em que vc est? inserindo (CMENVI), existem triggers e ?ndices? Em caso positivo, isto pode estar honerando a inser??o na DBOPROMUL.T_ARQ.
[quote=”poppius”:31bkdwun]Ol?, possuo uma solu??o de integra??o que gera triggers num banco Oracle 9.01. Quando as mesmas est?o criadas, o desempenho da aplica??o cai drasticamente. O que pode ser??? Existe alguma paremetriza??o poss?vel???
Abaixo segue a estrutura t?pica das triggers:
CREATE OR REPLACE TRIGGER DBOPROMUL.PSNI_T_ARQ_306
BEFORE INSERT ON DBOPROMUL.T_ARQ
FOR EACH ROW
DECLARE vSEQUENCE NUMBER(10);
vCONTADOR NUMBER(4);
BEGIN
IF ( USER NOT LIKE ‘REPL’) THEN
SELECT PSN_CMENVI.NEXTVAL INTO vSEQUENCE FROM DUAL;
vCONTADOR := 0;
INSERT INTO CMENVI ( dCDA, iSEQ, iNCO, sTBA, sCLA, sDEL, sICE, CT_VARCHAR2) VALUES (SYSDATE, vSEQUENCE,4,’DBOPROMUL.T_ARQ’,’CD_TIPO’,’N’,’S’,:NEW.”CD_TIPO”);
INSERT INTO CMENVI ( dCDA, iSEQ, iNCO, sTBA, sCLA, sDEL, sICE, CT_VARCHAR2) VALUES (SYSDATE, vSEQUENCE,4,’DBOPROMUL.T_ARQ’,’DS_TP_ARQ’,’N’,”,:NEW.”DS_TP_ARQ”);
INSERT INTO CMENVI ( dCDA, iSEQ, iNCO, sTBA, sCLA, sDEL, sICE, CT_VARCHAR2) VALUES (SYSDATE, vSEQUENCE,4,’DBOPROMUL.T_ARQ’,’ID_IN_OUT’,’N’,”,:NEW.”ID_IN_OUT”);
INSERT INTO CMENVI ( dCDA, iSEQ, iNCO, sTBA, sCLA, sDEL, sICE, CT_NUMBER) VALUES (SYSDATE, vSEQUENCE,4,’DBOPROMUL.T_ARQ’,’ID_TP_PROC’,’N’,”,:NEW.”ID_TP_PROC”);
END IF;
END;[/quote]