1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110
|
TKPROF: Release 9.2.0.8.0 - Production on Me Jul 28 15:32:54 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Trace file: kgtprod_ora_2016.trc
Sort options: execnt fchcnt
********************************************************************************
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
********************************************************************************
SELECT STOCK.STK_EXTERNALID, STOCK.STK_DOSSIER_STE, STOCK.STK_DOSSIER_NUM, STOCK.STK_DOSSIER_TYPE, STOCK.STK_DOSSIER_LIGNE, STOCK.STK_VTEP_DISPO, F563301.PLLITM, F563301.PLITM, F563301.PLFY, F563301.PLPN, F563301.PL$SRES, F563301.PLUORG, F563301.PLKIT, F563301.PL$VTEP, F563301.PLUPMJ, F563301.PL$NB1, F563301.PL$NB2, F563301.PL$NB3, F563301.PL$NB4, F563301.PL$NB5, F563301.PL$NB6, F563301.PL$NB7, F563301.PL$NB8, F563301.PL$NB9, F563301.PL$NB10, F564406.RDFY, F564406.RDPN, F564406.RDKIT, F564406.RDUPMJ, DATE_REFERENCE.DATE_APPLICATION, STOCK.STK_DATE
FROM
yield.STOCK, KOGITO_SAS.F563301, KOGITO_SAS.F564406, yield.DATE_REFERENCE
WHERE
F564406.RDDOC(+)=0
AND
F563301.PLITM=STOCK.STK_ID_RESEAU
and
F563301.PLFY=STOCK.STK_ANNEE
and
F563301.PLPN=STOCK.STK_SEMAINE
and
F563301.PLITM=F564406.RDKIT(+)
and
F563301.PLFY=F564406.RDFY(+)
and
F563301.PLPN=F564406.RDPN(+)
and
STOCK.STK_DATE_GENE=DATE_REFERENCE.DATE_APPLICATION
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 2873 1.06 3.38 2419 123098 0 43081
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2875 1.06 3.38 2419 123098 0 43081
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 2873 0.00 0.00
db file scattered read 415 0.03 0.43
db file sequential read 1106 0.11 2.01
SQL*Net more data to client 1 0.00 0.00
SQL*Net message from client 2872 0.61 891.31
********************************************************************************
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
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 2873 1.06 3.38 2419 123098 0 43081
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2875 1.06 3.38 2419 123098 0 43081
Misses in library cache during parse: 1
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 2874 0.00 0.00
SQL*Net message from client 2873 6.20 897.52
db file scattered read 415 0.03 0.43
db file sequential read 1106 0.11 2.01
SQL*Net more data to client 1 0.00 0.00
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 0 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 0 0.00 0.00 0 0 0 0
Misses in library cache during parse: 0
1 user SQL statements in session.
0 internal SQL statements in session.
1 SQL statements in session.
0 statements EXPLAINed in this session.
********************************************************************************
Trace file: kgtprod_ora_2016.trc
Trace file compatibility: 9.02.00
Sort options: execnt fchcnt
1 session in tracefile.
1 user SQL statements in trace file.
0 internal SQL statements in trace file.
1 SQL statements in trace file.
1 unique SQL statements in trace file.
10187 lines in trace file. |
Partager