TKPROF: Release 10.2.0.1.0 - Production on Qua Ago 15 22:22:04 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Trace file: cm3b_ora_2884.trc Sort options: default ******************************************************************************** count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call ******************************************************************************** DECLARE BEGIN if ( USER = 'CM2' ) then sys.dbms_monitor.session_trace_enable(); end if; END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SELECT DISTINCT OBJETO.NOMEOBJETO, FORM.NOMEFORM , OPERFUNC.IDOPERFUNC FROM OBJETO, FROBFNOP, FORM, OPERFUNC WHERE ( (FROBFNOP.IDFORM = FORM.IDFORM ) AND (OPERFUNC.IDMODULO = 5) AND (FROBFNOP.IDOPERFUNC = OPERFUNC.IDOPERFUNC) AND (OBJETO.IDOBJETO = FROBFNOP.IDOBJETO) ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.01 0 148 0 126 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.01 0 148 0 126 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 126 HASH UNIQUE (cr=148 pr=0 pw=0 time=11571 us) 126 HASH JOIN (cr=148 pr=0 pw=0 time=7303 us) 126 HASH JOIN (cr=71 pr=0 pw=0 time=5160 us) 126 HASH JOIN (cr=56 pr=0 pw=0 time=1691 us) 126 TABLE ACCESS FULL OPERFUNC (cr=29 pr=0 pw=0 time=465 us) 6045 TABLE ACCESS FULL FROBFNOP (cr=27 pr=0 pw=0 time=12120 us) 1812 TABLE ACCESS FULL FORM (cr=15 pr=0 pw=0 time=3668 us) 4425 TABLE ACCESS FULL OBJETO (cr=77 pr=0 pw=0 time=8902 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 8 0.00 0.00 SQL*Net message from client 8 0.00 0.00 SQL*Net more data to client 6 0.00 0.00 ******************************************************************************** SELECT AUTORIZA.IDOPERFUNC FROM AUTORIZA WHERE (AUTORIZA.IDPESSOA = 3 ) AND ((AUTORIZA.IdEspAcesso = 1) OR (AUTORIZA.IDESPACESSO IN ( SELECT GRUPOACESSO.IDESPACESSO FROM GRUPOACESSO, GRUPOUSU WHERE GRUPOUSU.IDUSUARIO = 2 AND GRUPOACESSO.IDGRUPO = GRUPOUSU.IDGRUPO))) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 183 0.01 0.02 0 539 0 3646 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 185 0.01 0.02 0 539 0 3646 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 3646 FILTER (cr=539 pr=0 pw=0 time=18299 us) 17316 INDEX FAST FULL SCAN XPKAUTORIZA (cr=358 pr=0 pw=0 time=34682 us)(object id 41219) 3 NESTED LOOPS (cr=181 pr=0 pw=0 time=1636 us) 4 TABLE ACCESS FULL GRUPOACESSO (cr=177 pr=0 pw=0 time=1179 us) 3 INDEX UNIQUE SCAN XPKGRUPOUSU (cr=4 pr=0 pw=0 time=61 us)(object id 42792) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 184 0.00 0.00 SQL*Net message from client 184 0.06 0.11 ******************************************************************************** SELECT NOMESEQ FROM FAIXASEQUENCE WHERE NOMESEQ = 'SEQLOGACESSOSIS' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 0 INDEX UNIQUE SCAN XPKFAIXASEQUENCE (cr=1 pr=0 pw=0 time=20 us)(object id 42413) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT SEQUENCE_NAME FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER = 'CM' AND SEQUENCE_NAME = 'SMFSEQLOGACESSOSIS' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 0 FILTER (cr=4 pr=0 pw=0 time=116 us) 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=109 us) 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=100 us) 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=45 us) 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=24 us)(object id 44) 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=2 pr=0 pw=0 time=44 us) 0 INDEX RANGE SCAN I_OBJ2 (cr=2 pr=0 pw=0 time=25 us)(object id 37) 0 INDEX UNIQUE SCAN I_SEQ1 (cr=0 pr=0 pw=0 time=0 us)(object id 102) 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=0 pr=0 pw=0 time=0 us)(object id 103) 0 FIXED TABLE FULL X$KZSRO (cr=0 pr=0 pw=0 time=0 us) 0 FIXED TABLE FULL X$KZSPR (cr=0 pr=0 pw=0 time=0 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT CM.SEQLOGACESSOSIS.NEXTVAL NEXT FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.01 0.00 0 1 3 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 1 3 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 SEQUENCE SEQLOGACESSOSIS (cr=1 pr=0 pw=0 time=737 us) 1 FAST DUAL (cr=0 pr=0 pw=0 time=9 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 log file sync 2 0.00 0.00 ******************************************************************************** update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6, cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 1 2 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 2 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE SEQ$ (cr=1 pr=0 pw=0 time=194 us) 1 INDEX UNIQUE SCAN I_SEQ1 (cr=1 pr=0 pw=0 time=19 us)(object id 102) ******************************************************************************** insert into LOGACESSOSIS (IDUSUARIO,IDMODULO,IDLOGACESSOSIS,FLGOPERACAO) values (2,5,105855,'I') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 1 7 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 7 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 38 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SELECT SMTPPASSWORD, SMTPUSER, SMTPSERVER, SMTPPORT, FLGTIPOENVIOEMAIL FROM PARAMGLOBAL WHERE IDPESSOA = 3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID PARAMGLOBAL (cr=2 pr=0 pw=0 time=45 us) 1 INDEX UNIQUE SCAN XPKPARAMGLOBAL (cr=1 pr=0 pw=0 time=22 us)(object id 44143) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT IDPSQATENDIMENTO FROM PSQATENDIMENTO WHERE FLGEXECAPOSLOGIN = 'S' AND FLGSTATUS = 'A' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS FULL PSQATENDIMENTO (cr=3 pr=0 pw=0 time=46 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** select condition from cdef$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 118 0.00 0.00 0 0 0 0 Execute 118 0.00 0.00 0 0 0 0 Fetch 118 0.00 0.00 0 236 0 118 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 354 0.00 0.00 0 236 0 118 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY USER ROWID CDEF$ (cr=1 pr=0 pw=0 time=28 us) ******************************************************************************** SELECT COUNT(IDMENSAGEM) FROM MENSAGEMCM WHERE (IDDESTINATARIO = 2) AND (LIDA = 0) AND (DATAPROGRAMA <= TO_DATE('15/08/2007 21:59:16', 'dd/mm/yyyy HH24:MI:SS')) AND (TIPODESTINATARIO = 'US') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 4 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 6 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=2 pr=0 pw=0 time=75 us) 0 TABLE ACCESS BY INDEX ROWID MENSAGEMCM (cr=2 pr=0 pw=0 time=53 us) 0 INDEX RANGE SCAN XIE2MENSAGEMCM (cr=2 pr=0 pw=0 time=32 us)(object id 43649) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT IMAGENS.IMAGEM FROM IMAGENS, PESSOA WHERE PESSOA.IDIMAGEM = IMAGENS.IDIMAGEM AND PESSOA.IDPESSOA = 3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 6 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=55 us) 0 TABLE ACCESS BY INDEX ROWID PESSOA (cr=3 pr=0 pw=0 time=47 us) 1 INDEX UNIQUE SCAN IDXPESSOA (cr=2 pr=0 pw=0 time=28 us)(object id 44359) 0 TABLE ACCESS BY INDEX ROWID IMAGENS (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN XPKIMAGENS_DIGITALIZADAS (cr=0 pr=0 pw=0 time=0 us)(object id 43030) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 4 0.00 0.00 SQL*Net message from client 4 0.00 0.00 ******************************************************************************** SELECT COUNT(*) AS QTDE FROM TIPOMOV WHERE ( CODTIPOMOV = 'a' OR CODTIPOMOV = 'b' ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=2 pr=0 pw=0 time=112 us) 0 INLIST ITERATOR (cr=2 pr=0 pw=0 time=87 us) 0 INDEX RANGE SCAN IDXTIPMOV (cr=2 pr=0 pw=0 time=44 us)(object id 45731) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.01 0.01 ******************************************************************************** SELECT UXA.CODALMOXARIFADO, ALM.DESCALMOX, ALM.PRINCIPSECUND, ALM.CODCUSTEIO, ALM.CODCENTROCUSTO, ALM.IDEMPRESA, ALM.CONTABIL FROM ALMOX ALM, USUXALMOX UXA WHERE (UXA.IDUSUARIO = 2) AND (UXA.IDPESSOA = 3) AND (UXA.CODALMOXARIFADO <> 0) AND (UXA.CODALMOXARIFADO = ALM.CODALMOXARIFADO) ORDER BY ALM.DESCALMOX call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 5 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 5 0 4 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 4 SORT ORDER BY (cr=5 pr=0 pw=0 time=275 us) 4 NESTED LOOPS (cr=5 pr=0 pw=0 time=162 us) 11 TABLE ACCESS FULL ALMOX (cr=3 pr=0 pw=0 time=94 us) 4 INDEX UNIQUE SCAN XPKUSUXALMOX (cr=2 pr=0 pw=0 time=97 us)(object id 45987) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT RTRIM( C.CODCENTROCUSTO ) AS CODCENTROCUSTO, C.IDEMPRESA, C.NOME FROM CENTCUST C, USCCUSTO U WHERE ( C.IDEMPRESA = 3 ) AND ( C.ATIVO = 'S' ) AND ( C.STATUSGRUPOCDC = 'A' ) AND ( C.IDEMPRESA = U.IDEMPRESA ) AND ( C.CODCENTROCUSTO = U.CODCENTROCUSTO ) AND ( U.IDUSUARIO = 2 ) ORDER BY C.NOME call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 23 0 15 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 23 0 15 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 15 SORT ORDER BY (cr=23 pr=0 pw=0 time=723 us) 15 NESTED LOOPS (cr=23 pr=0 pw=0 time=660 us) 15 INDEX FAST FULL SCAN IDXUSCCUSTO (cr=6 pr=0 pw=0 time=147 us)(object id 45947) 15 TABLE ACCESS BY INDEX ROWID CENTCUST (cr=17 pr=0 pw=0 time=361 us) 15 INDEX UNIQUE SCAN XPKCENTRO_DE_CUSTO (cr=2 pr=0 pw=0 time=144 us)(object id 41495) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 4.47 4.47 ******************************************************************************** SELECT RECPAG, MASCARADESEMB, MASCARANODOCUM, FLGCOMPLTIPOFAT, INTEGRACONTAB, LANCAFINANC FROM PARAMCAP WHERE IDPESSOA = 3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 2 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS FULL PARAMCAP (cr=3 pr=0 pw=0 time=78 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT EXISTECONTABIL FROM PARALMOX WHERE IDPESSOA = 3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID PARALMOX (cr=2 pr=0 pw=0 time=45 us) 1 INDEX UNIQUE SCAN XPKPARALMOX (cr=1 pr=0 pw=0 time=22 us)(object id 44083) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT P.MASCARA, C.PLANO, C.PACESTORNA, C.PACDOBRADA FROM PLANO P,PARAMCONTAB C WHERE C.IDPESSOA = 3 AND P.PLANO = C.PLANO call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=4 pr=0 pw=0 time=85 us) 1 TABLE ACCESS BY INDEX ROWID PARAMCONTAB (cr=2 pr=0 pw=0 time=44 us) 1 INDEX UNIQUE SCAN XPKPARAMCONTAB (cr=1 pr=0 pw=0 time=21 us)(object id 44109) 1 TABLE ACCESS BY INDEX ROWID PLANO (cr=2 pr=0 pw=0 time=25 us) 1 INDEX UNIQUE SCAN XPKPLANO (cr=1 pr=0 pw=0 time=11 us)(object id 44408) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT TIPCODIGO FROM TIPOPER WHERE TIPCODIGO = '03' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 1 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 INDEX UNIQUE SCAN XPKTIPOPER (cr=1 pr=0 pw=0 time=28 us)(object id 45744) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT P.FLGCRIAAGENCIA, P.MASCARANUMAGENCIA, P.USACRESPON, P.USAABC, P.MASCARACC, P.MASCCENTRORESPON, P.MASCUNIDNEGOC, P.FLGINTEGRAORC, P.UNIDNEGOC, P.IDPLANOPREV, P.IDPATRO, P.FLGOBRIGACC, P.MASCARACLIENTE, P.FLGSUBCONTAFORN, P.FLGSUBCONTACLIE, P.INSCESTADUAL, P.INSCMUNICIPAL, P.MASCARACLIHOTEL, P.FLGSELDOCPESSOA, M.MOECODIGO, M.MOEDESC, M.MOESIGLA, M.NUMDECIMAIS, M.FLGARREDONDA, M.DESCMOESINGULAR, M.DESCMOEPLURAL, M.DESCCENTSINGULAR, M.DESCCENTPLURAL, P.FLGSHOWFORCLIINAT, P.DOCPJURIDICA, P.DOCPFISICA, P.FLGZERADECMOEDA, P.FLGOBRIGENDFORCLI FROM PARAMGLOBAL P, MOEDA M WHERE P.IDPESSOA = 3 AND P.MOEDACORRENTE = M.MOECODIGO(+) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS OUTER (cr=4 pr=0 pw=0 time=97 us) 1 TABLE ACCESS BY INDEX ROWID PARAMGLOBAL (cr=2 pr=0 pw=0 time=50 us) 1 INDEX UNIQUE SCAN XPKPARAMGLOBAL (cr=1 pr=0 pw=0 time=25 us)(object id 44143) 1 TABLE ACCESS BY INDEX ROWID MOEDA (cr=2 pr=0 pw=0 time=27 us) 1 INDEX UNIQUE SCAN XPKMOEDA (cr=1 pr=0 pw=0 time=12 us)(object id 43733) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net more data to client 1 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT FLGINTEGRAVHL FROM PARAMFATHOTEL WHERE IDPESSOA = 3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID PARAMFATHOTEL (cr=2 pr=0 pw=0 time=44 us) 1 INDEX UNIQUE SCAN XPKPARAMFATHOTEL (cr=1 pr=0 pw=0 time=23 us)(object id 44131) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT IDPESSOA,CODALTDEVOLUCAO,CODTIPDOC,MASCGRUPOPROD,EXISTEDV, EXISTECOMPRA,RECEBAUTOMATICO,CODTABPRODUTIL,EXISTECONTASPAGAR, EXISTECONTABIL,FLGINFOVALORUN,FLGCONTABGRUPO,FLGCONTABTRANSF,PERCREQMAT, FLGINTEGRALIVRO, PERCRECEBCOMOC, CODTIPDOCDEVOL,IDPATRO,IDPLANOPREV, FLGUSAGRUPOREQ,FLGREQSEMSALDO,IDPROGRAMA,FLGCONBILIZAREQ,FLGFILTRALMOX, FLGGERACODIGOAUTO,CFOPPADRAO,FLGFILTRAREQCC,CODTIPDOCNFCRED, FLGTIPODEVOL, FLGCONSIDERASEC, FLGTRASCFOPAUTO, FLGVERIFSOLICC, FLGTRASIMPOC, FLGESPELHONOTA, FLGCUSTOTRANSF,FLGENGLOBAPARCEL, FLGUSADEFAULTGLOB,NFOBSPADRAO, FLGVERIFCONSISNF, FLGMARCAINTCAP, COLETORPATHIN,COLETORPATHOUT FROM PARALMOX WHERE (IDPESSOA = 3) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID PARALMOX (cr=2 pr=0 pw=0 time=54 us) 1 INDEX UNIQUE SCAN XPKPARALMOX (cr=1 pr=0 pw=0 time=25 us)(object id 44083) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net more data to client 1 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT MASCARANODOCUM FROM PARAMCAP WHERE (IDPESSOA = 3) AND (RECPAG = 'P') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID PARAMCAP (cr=2 pr=0 pw=0 time=50 us) 1 INDEX UNIQUE SCAN XPKPARAMCAP (cr=1 pr=0 pw=0 time=23 us)(object id 44092) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT TXJUROS,PESOPRECO,PESOPRAZOENT,PESOPRAZOPGTO,PESOAVALIACAO, COMPRARALEMSC,INSTRUCAOOC,ASSINATURA1,ASSINATURA2,ASSINATURA3, IMPOBSAPARTE,IMPLOGO,TRASOBS, FLGORCAMENTO, FLGOBSSCIOC, CODTIPDOC, MODELOIMPOC, FLGVERIFRAD, FLGQUEBRAOCPORCC,FLGSOUMCONTRATO, FLGALTOCCONTRATO, FLGTIPOPRAZOPAG, FLGEXIBIROCVENC FROM PARAMCOMPRAS WHERE (IDPESSOA = 3) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID PARAMCOMPRAS (cr=2 pr=0 pw=0 time=48 us) 1 INDEX UNIQUE SCAN XPKPARAMCOMPRAS (cr=1 pr=0 pw=0 time=23 us)(object id 44105) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT CODCENTRORESPON, UNIDNEGOC FROM PARAMGLOBAL WHERE (IDPESSOA = 3 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID PARAMGLOBAL (cr=2 pr=0 pw=0 time=46 us) 1 INDEX UNIQUE SCAN XPKPARAMGLOBAL (cr=1 pr=0 pw=0 time=23 us)(object id 44143) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 3.32 3.32 ******************************************************************************** SELECT M.DESCMOEPLURAL, M.DESCMOESINGULAR, M.DESCCENTPLURAL, M.DESCCENTSINGULAR FROM MOEDA M WHERE M.MOECODIGO = 0 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID MOEDA (cr=1 pr=0 pw=0 time=31 us) 0 INDEX UNIQUE SCAN XPKMOEDA (cr=1 pr=0 pw=0 time=20 us)(object id 43733) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT USUXRELXEMP.IDREPORTS, USUXRELXEMP.ORIGEMCM FROM USUXRELXEMP, REPORTS WHERE (USUXRELXEMP.IDEMPRESA = 3) AND ((REPORTS.IDMODULO = 5) OR ((REPORTS.IDMODULO = 2) AND (REPORTS.IDDATAVIEW IS NOT NULL))) AND ((USUXRELXEMP.IDESPACESSO = 1) OR (USUXRELXEMP.IDESPACESSO IN (SELECT GRUPOACESSO.IDESPACESSO FROM GRUPOACESSO, GRUPOUSU WHERE GRUPOUSU.IDUSUARIO = 2 AND GRUPOACESSO.IDGRUPO = GRUPOUSU.IDGRUPO))) AND (REPORTS.IDREPORTS = USUXRELXEMP.IDREPORTS) AND (REPORTS.ORIGEMCM = USUXRELXEMP.ORIGEMCM) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 6 0.01 0.01 0 484 0 107 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.01 0.01 0 484 0 107 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 107 CONCATENATION (cr=484 pr=0 pw=0 time=194023 us) 22 FILTER (cr=300 pr=0 pw=0 time=38487 us) 1276 NESTED LOOPS (cr=66 pr=0 pw=0 time=6505 us) 22 TABLE ACCESS BY INDEX ROWID REPORTS (cr=36 pr=0 pw=0 time=540 us) 31 INDEX RANGE SCAN XIE1REPORTS (cr=3 pr=0 pw=0 time=37 us)(object id 45028) 1276 INDEX RANGE SCAN XPKUSUXRELXEMP (cr=30 pr=0 pw=0 time=4026 us)(object id 45998) 1 NESTED LOOPS (cr=245 pr=0 pw=0 time=2115 us) 2 TABLE ACCESS FULL GRUPOACESSO (cr=243 pr=0 pw=0 time=1556 us) 1 INDEX UNIQUE SCAN XPKGRUPOUSU (cr=2 pr=0 pw=0 time=26 us)(object id 42792) 85 FILTER (cr=184 pr=0 pw=0 time=9436 us) 919 HASH JOIN (cr=173 pr=0 pw=0 time=8916 us) 83 TABLE ACCESS BY INDEX ROWID REPORTS (cr=72 pr=0 pw=0 time=1109 us) 83 INDEX RANGE SCAN XIE1REPORTS (cr=2 pr=0 pw=0 time=19 us)(object id 45028) 9769 INDEX FAST FULL SCAN XPKUSUXRELXEMP (cr=101 pr=0 pw=0 time=21904 us)(object id 45998) 1 NESTED LOOPS (cr=245 pr=0 pw=0 time=2115 us) 2 TABLE ACCESS FULL GRUPOACESSO (cr=243 pr=0 pw=0 time=1556 us) 1 INDEX UNIQUE SCAN XPKGRUPOUSU (cr=2 pr=0 pw=0 time=26 us)(object id 42792) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 7 0.00 0.00 SQL*Net message from client 7 0.00 0.00 ******************************************************************************** SELECT R.IDREPORTS, R.ORIGEMCM, M.NOMEMODULO, R.NAME, C.DESCRICAO AS NAMEDESC, G.DESCRICAO, R.FLGEXIBENOPREVIEW, C.IDPESSOA FROM (SELECT IDPESSOA, IDREPORTS, ORIGEMCM, DESCRICAO FROM CONFIGREPORTSCM WHERE IDPESSOA = 3) C, REPORTS R, MODULO M, GRUPORELATORIO G WHERE (C.IDREPORTS(+) = R.IDREPORTS) AND (C.ORIGEMCM(+) = R.ORIGEMCM) AND ((R.IDMODULO = 5) OR ((R.IDMODULO = 2) AND (R.IDDATAVIEW IS NOT NULL))) AND (R.IDMODULO = M.IDMODULO) AND (R.FLGTIPO IS NULL OR R.FLGTIPO = 'R') AND (R.IDGRUPORELATORIO = G.IDGRUPORELATORIO(+)) AND (R.ORIGEMCMGR = G.ORIGEMCMGR(+)) ORDER BY M.NOMEMODULO, G.DESCRICAO, R.NAME call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 6 0.01 0.00 0 254 0 105 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.01 0.00 0 254 0 105 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 105 SORT ORDER BY (cr=254 pr=0 pw=0 time=7865 us) 105 CONCATENATION (cr=254 pr=0 pw=0 time=11236 us) 22 NESTED LOOPS (cr=85 pr=0 pw=0 time=2368 us) 22 NESTED LOOPS OUTER (cr=61 pr=0 pw=0 time=1708 us) 22 NESTED LOOPS OUTER (cr=37 pr=0 pw=0 time=1065 us) 22 TABLE ACCESS BY INDEX ROWID REPORTS (cr=35 pr=0 pw=0 time=545 us) 31 INDEX RANGE SCAN XIE1REPORTS (cr=2 pr=0 pw=0 time=37 us)(object id 45028) 0 TABLE ACCESS BY INDEX ROWID CONFIGREPORTSCM (cr=2 pr=0 pw=0 time=298 us) 0 INDEX UNIQUE SCAN XPKCONFIGREPORTSCM (cr=2 pr=0 pw=0 time=143 us)(object id 41697) 22 TABLE ACCESS BY INDEX ROWID GRUPORELATORIO (cr=24 pr=0 pw=0 time=372 us) 22 INDEX UNIQUE SCAN XPKGRUPORELATORIO (cr=2 pr=0 pw=0 time=179 us)(object id 42770) 22 TABLE ACCESS BY INDEX ROWID MODULO (cr=24 pr=0 pw=0 time=435 us) 22 INDEX UNIQUE SCAN IDXMODULO (cr=2 pr=0 pw=0 time=177 us)(object id 43724) 83 NESTED LOOPS OUTER (cr=169 pr=0 pw=0 time=5274 us) 83 HASH JOIN RIGHT OUTER (cr=84 pr=0 pw=0 time=2780 us) 12 TABLE ACCESS BY INDEX ROWID CONFIGREPORTSCM (cr=7 pr=0 pw=0 time=132 us) 12 INDEX RANGE SCAN XIE1CONFIGREPORTSCM (cr=1 pr=0 pw=0 time=19 us)(object id 41698) 83 HASH JOIN (cr=77 pr=0 pw=0 time=995 us) 83 TABLE ACCESS BY INDEX ROWID REPORTS (cr=72 pr=0 pw=0 time=1379 us) 83 INDEX RANGE SCAN XIE1REPORTS (cr=2 pr=0 pw=0 time=32 us)(object id 45028) 107 TABLE ACCESS FULL MODULO (cr=5 pr=0 pw=0 time=367 us) 83 TABLE ACCESS BY INDEX ROWID GRUPORELATORIO (cr=85 pr=0 pw=0 time=1704 us) 83 INDEX UNIQUE SCAN XPKGRUPORELATORIO (cr=2 pr=0 pw=0 time=708 us)(object id 42770) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 7 0.00 0.00 SQL*Net message from client 7 0.03 0.03 ******************************************************************************** SELECT M.DESCMOEPLURAL, M.DESCMOESINGULAR, M.DESCCENTPLURAL, M.DESCCENTSINGULAR FROM MOEDA M, PARAMGLOBAL P WHERE (P.IDPESSOA = 3) AND (P.MOEDACORRENTE = M.MOECODIGO) AND (UPPER(M.MOEDESC) <> 'REAL') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=84 us) 1 TABLE ACCESS BY INDEX ROWID PARAMGLOBAL (cr=2 pr=0 pw=0 time=43 us) 1 INDEX UNIQUE SCAN XPKPARAMGLOBAL (cr=1 pr=0 pw=0 time=23 us)(object id 44143) 0 TABLE ACCESS BY INDEX ROWID MOEDA (cr=2 pr=0 pw=0 time=28 us) 1 INDEX UNIQUE SCAN XPKMOEDA (cr=1 pr=0 pw=0 time=11 us)(object id 43733) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 3.97 3.97 ******************************************************************************** SELECT R.NAME, R.IDMODULO, R.IDDATAVIEW, R.ORIGEMCMDV, R.DESCRIPTION, R.TEMPLATE AS REPORTTEMPLATE, R.IDGRUPORELATORIO, R.FLGFILTROMANUAL, R.FORMEVENTOS, R.FORMPARAMREL, R.PPREPORT, V.CLASSNAME, V.CLASSDESCRIPTION, V.DESCRIPTION AS DATAVIEWDESCRIPTION, INITCAP(V.NAME) AS DATAVIEWNAME, (TO_CHAR(R.IDREPORTS) || '-' || TO_CHAR(R.ORIGEMCM)) AS CODIGO FROM REPORTS R, DATAVIEW V WHERE (R.IDREPORTS = 4012) AND (R.ORIGEMCM = 1) AND (R.IDDATAVIEW = V.IDDATAVIEW(+)) AND (R.ORIGEMCMDV = V.ORIGEMCMDV(+)) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS OUTER (cr=3 pr=0 pw=0 time=80 us) 1 TABLE ACCESS BY INDEX ROWID REPORTS (cr=3 pr=0 pw=0 time=51 us) 1 INDEX UNIQUE SCAN XPKREPORTS (cr=2 pr=0 pw=0 time=27 us)(object id 45027) 0 TABLE ACCESS BY INDEX ROWID DATAVIEW (cr=0 pr=0 pw=0 time=14 us) 0 INDEX UNIQUE SCAN XPKDATAVIEW (cr=0 pr=0 pw=0 time=7 us)(object id 41968) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.44 0.44 ******************************************************************************** SELECT CODCUSTEIO, DESCCUSTEIO FROM UNCUSTEI WHERE IDPESSOA = 3 ORDER BY 2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.01 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT ORDER BY (cr=3 pr=0 pw=0 time=133 us) 1 TABLE ACCESS FULL UNCUSTEI (cr=3 pr=0 pw=0 time=79 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT CODALMOXARIFADO, DESCALMOX FROM ALMOX WHERE IDPESSOA = 3 ORDER BY 2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 9 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 9 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 9 SORT ORDER BY (cr=3 pr=0 pw=0 time=180 us) 9 TABLE ACCESS FULL ALMOX (cr=3 pr=0 pw=0 time=75 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT CODGRUPOPROD, DESCGRUPOPROD FROM GRUPPROD ORDER BY 2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.00 0 3 0 99 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 3 0 99 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 99 SORT ORDER BY (cr=3 pr=0 pw=0 time=666 us) 99 TABLE ACCESS FULL GRUPPROD (cr=3 pr=0 pw=0 time=251 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6 0.00 0.00 SQL*Net message from client 6 16.63 16.64 ******************************************************************************** SELECT TEMPLATE, DESCRICAO FROM CONFIGREPORTSCM WHERE IDREPORTS = 4012 AND ORIGEMCM = 1 AND IDPESSOA = 3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.01 0.00 0 8 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 8 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID CONFIGREPORTSCM (cr=3 pr=0 pw=0 time=63 us) 1 INDEX UNIQUE SCAN XPKCONFIGREPORTSCM (cr=1 pr=0 pw=0 time=24 us)(object id 41697) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.02 0.02 SQL*Net more data to client 16 0.00 0.00 ******************************************************************************** SELECT CODALMOXARIFADO FROM ALMOX WHERE (CODCUSTEIO = 3) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 9 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 9 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 38 Rows Row Source Operation ------- --------------------------------------------------- 9 TABLE ACCESS FULL ALMOX (cr=3 pr=0 pw=0 time=70 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT SUBSTR(P.CODGRUPOPROD,1,2) AS GRUPOSIN, GS.DESCGRUPOPROD AS DESCGRUPOSIN, G.STATUSGRUPO, G.CODGRUPOPROD, G.DESCGRUPOPROD, (SUM(UN.SALDOANT)+SUM(UN.RECFORN)+SUM(UN.DEVFORN)-SUM(UN.BAITRANS)+ SUM(UN.ENTTRANS)+SUM(UN.BAIACERTO)-SUM(UN.BAIESTRAGO)-SUM(UN.BAIXACC)- SUM(UN.SALDOATU)) AS AJUSTE, SUM( UN.SALDOATU ) + ( SUM( UN.SALDOANT ) - SUM( UN.SALDOATU ) + SUM( UN.RECFORN ) + SUM( UN.DEVFORN ) + SUM( UN.BAITRANS ) + SUM( UN.ENTTRANS ) + SUM( UN.BAIACERTO ) + SUM( UN.BAIESTRAGO ) + SUM( UN.BAIXACC ) ) AS SALDOCOMAJUSTE, SUM(UN.SALDOANT) AS SALDOANT, SUM(UN.SALDOATU) AS SALDOATU, SUM(UN.RECFORN) AS RECFORN, SUM(UN.DEVFORN) AS DEVFORN, SUM(UN.BAITRANS) AS BAITRANS, SUM(UN.ENTTRANS) AS ENTTRANS, SUM(UN.BAIACERTO) AS BAIACERTO, SUM(UN.BAIESTRAGO) AS BAIESTRAGO, SUM(UN.BAIXACC) AS BAIXACC FROM ARTIGO A, PRODUTO P, GRUPPROD G, GRUPPROD GS, ( (SELECT A.CODARTIGO, (Q.SALDOQTDEMOV * C.CUSTOMEDIOMOV ) AS SALDOANT, (0.00) AS SALDOATU, (0.00) AS RECFORN, (0.00) AS DEVFORN, (0.00) AS BAITRANS, (0.00) AS ENTTRANS, (0.00) AS BAIACERTO, (0.00) AS BAIESTRAGO, (0.00) AS BAIXACC FROM ARTIGO A, (SELECT M.CODARTIGO, SUM(M.SALDOQTDEMOV) AS SALDOQTDEMOV FROM MOVIMENT M, (SELECT M.CODARTIGO, M.CODALMOXARIFADO, MAX(IDMOV) AS IDMOV FROM MOVIMENT M, ALMOX A, (SELECT M.CODARTIGO, M.CODALMOXARIFADO, MAX(M.DATAMOV) AS DATAMOV FROM MOVIMENT M, ALMOX A WHERE (M.IDPESSOA = 3 ) AND (M.CODALMOXARIFADO IN ( 9,10,11,12,13,14,15,16,17 ) ) AND (M.CODALMOXARIFADO = A.CODALMOXARIFADO ) AND (A.CODCUSTEIO = 3 ) AND (M.DATAMOV < TO_DATE('01/07/2007','DD/MM/YYYY') ) AND (M.DATAMOV >= (SELECT TO_DATE(NVL(S.ULTIMADATA,P.DATAIMPLANTA),'DD/MM/YYYY') FROM PARALMOX P, (SELECT MAX(ULTIMADATA) AS ULTIMADATA FROM ULTDATAREPRESA WHERE ULTIMADATA < TO_DATE('01/07/2007','DD/MM/YYYY') AND IDPESSOA = 3 ) S WHERE P.IDPESSOA = 3 ) ) GROUP BY M.CODARTIGO, M.CODALMOXARIFADO ) MD WHERE (MD.DATAMOV = M.DATAMOV) AND (MD.CODARTIGO = M.CODARTIGO) AND (MD.CODALMOXARIFADO = M.CODALMOXARIFADO) AND (M.CODALMOXARIFADO = A.CODALMOXARIFADO ) AND (A.CODCUSTEIO = 3 ) AND (M.DATAMOV < TO_DATE('01/07/2007','DD/MM/YYYY') ) AND (M.DATAMOV >= (SELECT TO_DATE(NVL(S.ULTIMADATA,P.DATAIMPLANTA),'DD/MM/YYYY') FROM PARALMOX P, (SELECT MAX(ULTIMADATA) AS ULTIMADATA FROM ULTDATAREPRESA WHERE ULTIMADATA < TO_DATE('01/07/2007','DD/MM/YYYY') AND IDPESSOA = 3 ) S WHERE P.IDPESSOA = 3 ) ) GROUP BY M.CODARTIGO, M.CODALMOXARIFADO) IM WHERE (IM.IDMOV = M.IDMOV) AND (M.CODALMOXARIFADO IN ( 9,10,11,12,13,14,15,16,17 ) ) GROUP BY M.CODARTIGO ) Q, (SELECT M.CODARTIGO, M.CUSTOMEDIOMOV FROM MOVIMENT M, ALMOX A, (SELECT M.CODARTIGO, A.CODCUSTEIO, MAX(IDMOV) AS IDMOV FROM MOVIMENT M, ALMOX A, (SELECT M.CODARTIGO, MAX(M.DATAMOV) AS DATAMOV FROM MOVIMENT M, ALMOX A WHERE (M.IDPESSOA = 3) AND (M.CODALMOXARIFADO = A.CODALMOXARIFADO) AND (A.CODCUSTEIO = 3 ) AND (M.DATAMOV < TO_DATE('01/07/2007','DD/MM/YYYY') ) AND (M.DATAMOV >= (SELECT TO_DATE(NVL(S.ULTIMADATA,P.DATAIMPLANTA),'DD/MM/YYYY') FROM PARALMOX P, (SELECT MAX(ULTIMADATA) AS ULTIMADATA FROM ULTDATAREPRESA WHERE ULTIMADATA <= TO_DATE('01/07/2007','DD/MM/YYYY') AND IDPESSOA = 3 ) S WHERE P.IDPESSOA = 3 ) ) GROUP BY M.CODARTIGO) MD WHERE (MD.DATAMOV = M.DATAMOV) AND (MD.CODARTIGO = M.CODARTIGO) AND (M.CODALMOXARIFADO = A.CODALMOXARIFADO) AND (A.CODCUSTEIO = 3 ) GROUP BY M.CODARTIGO, A.CODCUSTEIO) IM WHERE (IM.IDMOV = M.IDMOV) AND (M.CODALMOXARIFADO = A.CODALMOXARIFADO) ) C WHERE (A.CODARTIGO = C.CODARTIGO) AND (A.CODARTIGO = Q.CODARTIGO) ) UNION ALL (SELECT A.CODARTIGO, (0.00) AS SALDOANT, (Q.SALDOQTDEMOV * C.CUSTOMEDIOMOV ) AS SALDOATU, (0.00) AS RECFORN, (0.00) AS DEVFORN, (0.00) AS BAITRANS, (0.00) AS ENTTRANS, (0.00) AS BAIACERTO, (0.00) AS BAIESTRAGO, (0.00) AS BAIXACC FROM ARTIGO A, (SELECT M.CODARTIGO, SUM(M.SALDOQTDEMOV) AS SALDOQTDEMOV FROM MOVIMENT M, (SELECT M.CODARTIGO, M.CODALMOXARIFADO, MAX(IDMOV) AS IDMOV FROM MOVIMENT M, ALMOX A, (SELECT M.CODARTIGO, M.CODALMOXARIFADO, MAX(M.DATAMOV) AS DATAMOV FROM MOVIMENT M, ALMOX A WHERE (M.IDPESSOA = 3 ) AND (M.CODALMOXARIFADO IN ( 9,10,11,12,13,14,15,16,17 ) ) AND (M.CODALMOXARIFADO = A.CODALMOXARIFADO ) AND (A.CODCUSTEIO = 3 ) AND (M.DATAMOV <= TO_DATE('31/07/2007','DD/MM/YYYY') ) AND (M.DATAMOV >= (SELECT TO_DATE(NVL(S.ULTIMADATA,P.DATAIMPLANTA),'DD/MM/YYYY') FROM PARALMOX P, (SELECT MAX(ULTIMADATA) AS ULTIMADATA FROM ULTDATAREPRESA WHERE ULTIMADATA < TO_DATE('01/07/2007','DD/MM/YYYY') AND IDPESSOA = 3 ) S WHERE P.IDPESSOA = 3 ) ) GROUP BY M.CODARTIGO, M.CODALMOXARIFADO) MD WHERE (MD.DATAMOV = M.DATAMOV) AND (MD.CODARTIGO = M.CODARTIGO) AND (MD.CODALMOXARIFADO = M.CODALMOXARIFADO) AND (M.CODALMOXARIFADO = A.CODALMOXARIFADO ) AND (A.CODCUSTEIO = 3 ) AND (M.DATAMOV <= TO_DATE('31/07/2007','DD/MM/YYYY') ) AND (M.DATAMOV >= (SELECT TO_DATE(NVL(S.ULTIMADATA,P.DATAIMPLANTA),'DD/MM/YYYY') FROM PARALMOX P, (SELECT MAX(ULTIMADATA) AS ULTIMADATA FROM ULTDATAREPRESA WHERE ULTIMADATA < TO_DATE('01/07/2007','DD/MM/YYYY') AND IDPESSOA = 3 ) S WHERE P.IDPESSOA = 3 ) ) GROUP BY M.CODARTIGO, M.CODALMOXARIFADO) IM WHERE (IM.IDMOV = M.IDMOV) AND (M.CODALMOXARIFADO IN ( 9,10,11,12,13,14,15,16,17 ) ) GROUP BY M.CODARTIGO ) Q, (SELECT M.CODARTIGO, M.CUSTOMEDIOMOV FROM MOVIMENT M, ALMOX A, (SELECT M.CODARTIGO, A.CODCUSTEIO, MAX(IDMOV) AS IDMOV FROM MOVIMENT M, ALMOX A, (SELECT M.CODARTIGO, MAX(M.DATAMOV) AS DATAMOV FROM MOVIMENT M, ALMOX A WHERE (M.IDPESSOA = 3 ) AND (M.CODALMOXARIFADO = A.CODALMOXARIFADO) AND (A.CODCUSTEIO = 3 ) AND (M.DATAMOV <= TO_DATE('31/07/2007','DD/MM/YYYY') ) AND (M.DATAMOV >= (SELECT TO_DATE(NVL(S.ULTIMADATA,P.DATAIMPLANTA),'DD/MM/YYYY') FROM PARALMOX P, (SELECT MAX(ULTIMADATA) AS ULTIMADATA FROM ULTDATAREPRESA WHERE ULTIMADATA < TO_DATE('01/07/2007','DD/MM/YYYY') AND IDPESSOA = 3 ) S WHERE P.IDPESSOA = 3 ) ) GROUP BY M.CODARTIGO) MD WHERE (MD.DATAMOV = M.DATAMOV) AND (MD.CODARTIGO = M.CODARTIGO) AND (M.CODALMOXARIFADO = A.CODALMOXARIFADO) AND (A.CODCUSTEIO = 3 ) GROUP BY M.CODARTIGO, A.CODCUSTEIO) IM WHERE (IM.IDMOV = M.IDMOV) AND (M.CODALMOXARIFADO = A.CODALMOXARIFADO) ) C WHERE (A.CODARTIGO = C.CODARTIGO) AND (A.CODARTIGO = Q.CODARTIGO) ) UNION ALL (SELECT M.CODARTIGO, (0.00) AS SALDOANT, (0.00) AS SALDOATU, SUM( DECODE( M.CODTIPOMOV, 'A', M.VALORMOV, 0 ) ) AS RECFORN, SUM( DECODE( M.CODTIPOMOV, 'K', M.VALORMOV, 0 ) ) AS DEVFORN, SUM( DECODE( M.CODTIPOMOV, 'F', M.VALORMOV*-1, 'T', M.VALORMOV*-1, 'G', M.VALORMOV*-1, 'U', M.VALORMOV*-1, 'O', M.VALORMOV*-1, '3', M.VALORMOV*-1, 'R', M.VALORMOV*-1, 0 ) ) AS BAITRANS, SUM( DECODE( M.CODTIPOMOV, 'S', M.VALORMOV, 'C', M.VALORMOV, 'B', M.VALORMOV, 0 ) ) AS ENTTRANS, SUM( DECODE( M.CODTIPOMOV, 'H', M.VALORMOV, '2', M.VALORMOV, '1', M.VALORMOV, 'D', M.VALORMOV, 0 ) ) AS BAIACERTO, SUM( DECODE( M.CODTIPOMOV, 'I', M.VALORMOV*-1, 0 ) ) AS BAIESTRAGO, SUM( DECODE( M.CODTIPOMOV, 'M', M.VALORMOV*-1, 'N', M.VALORMOV*-1, 'L', M.VALORMOV*-1, 'Q', M.VALORMOV*-1, 'J', M.VALORMOV*-1, 'V', M.VALORMOV*-1, 'X', M.VALORMOV*-1, 'W', M.VALORMOV*-1, 'E', M.VALORMOV*-1, 'P', M.VALORMOV*-1, '4', M.VALORMOV*-1, 'Y', M.VALORMOV*-1, 0 ) ) AS BAIXACC FROM MOVIMENT M WHERE (M.IDPESSOA = 3) AND (M.DATAMOV >= TO_DATE('01/07/2007','DD/MM/YYYY') ) AND (M.DATAMOV <= TO_DATE('31/07/2007','DD/MM/YYYY') ) AND (M.CODALMOXARIFADO IN ( 9,10,11,12,13,14,15,16,17 ) ) GROUP BY M.CODARTIGO ) ) UN WHERE (A.CODARTIGO = UN.CODARTIGO) AND (A.CODPRODUTO = P.CODPRODUTO) AND (G.CODGRUPOPROD = P.CODGRUPOPROD) AND (RTRIM(GS.CODGRUPOPROD) = RTRIM(SUBSTR(P.CODGRUPOPROD,1,2)) ) GROUP BY SUBSTR(P.CODGRUPOPROD,1,2), GS.DESCGRUPOPROD, G.STATUSGRUPO, G.CODGRUPOPROD, G.DESCGRUPOPROD HAVING SUM( UN.SALDOANT ) <> 0.00 OR SUM( UN.SALDOATU ) <> 0.00 OR SUM( UN.RECFORN ) <> 0.00 OR SUM( UN.DEVFORN ) <> 0.00 OR SUM( UN.BAITRANS ) <> 0.00 OR SUM( UN.ENTTRANS ) <> 0.00 OR SUM( UN.BAIACERTO ) <> 0.00 OR SUM( UN.BAIESTRAGO ) <> 0.00 OR SUM( UN.BAIXACC ) <> 0.00 ORDER BY GRUPOSIN, G.CODGRUPOPROD call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.25 0.23 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 1194.35 1266.54 5761 43455614 0 33 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 1194.60 1266.77 5761 43455614 0 33 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 38 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 2 0.00 0.00 direct path write temp 772 0.06 0.46 direct path read temp 823 0.20 4.18 ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 35 0.25 0.24 0 4 0 0 Execute 35 0.00 0.00 0 1 7 1 Fetch 237 1194.45 1266.61 5761 43457140 3 4171 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 307 1194.70 1266.85 5761 43457145 10 4172 Misses in library cache during parse: 4 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 276 0.00 0.00 SQL*Net message from client 275 16.63 29.18 SQL*Net more data to client 24 0.00 0.00 log file sync 3 0.00 0.00 SQL*Net more data from client 6 0.00 0.00 direct path write temp 772 0.06 0.46 direct path read temp 823 0.20 4.18 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 119 0.00 0.00 0 0 0 0 Execute 120 0.00 0.00 0 1 2 2 Fetch 118 0.00 0.00 0 236 0 118 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 357 0.00 0.00 0 237 2 120 Misses in library cache during parse: 0 35 user SQL statements in session. 120 internal SQL statements in session. 155 SQL statements in session. ******************************************************************************** Trace file: cm3b_ora_2884.trc Trace file compatibility: 10.01.00 Sort options: default 1 session in tracefile. 35 user SQL statements in trace file. 120 internal SQL statements in trace file. 155 SQL statements in trace file. 37 unique SQL statements in trace file. 4207 lines in trace file. 1296 elapsed seconds in trace file.