TKPROF: Release 11.2.0.3.0 - Development on Wed Aug 13 21:43:59 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Trace file: dev_ora_2556168_BHG_RLX.trc
Sort options: fchela
********************************************************************************
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
********************************************************************************
SQL ID: 09ctb08um26rt Plan Hash: 705702674
SELECT RSH.RECEIPT_NUM, V.VENDOR_NAME,
CUX_GL_TRACE_PKG.GET_EMP_NAME(RSH.LAST_UPDATED_BY, RSH.LAST_UPDATE_DATE),
RSH.COMMENTS
FROM
GL_IMPORT_REFERENCES GIR, XLA_AE_LINES XAL, XLA_AE_HEADERS XAH,
XLA.XLA_TRANSACTION_ENTITIES XTE, RCV_TRANSACTIONS RT, RCV_SHIPMENT_HEADERS
RSH, FND_USER FU, PO_VENDORS V WHERE GIR.GL_SL_LINK_ID = XAL.GL_SL_LINK_ID
AND GIR.GL_SL_LINK_TABLE = XAL.GL_SL_LINK_TABLE AND XAH.AE_HEADER_ID =
XAL.AE_HEADER_ID AND XAH.APPLICATION_ID = XAL.APPLICATION_ID AND
XTE.ENTITY_ID = XAH.ENTITY_ID AND XTE.APPLICATION_ID = XAH.APPLICATION_ID
AND XTE.APPLICATION_ID = 707 AND XTE.ENTITY_CODE = 'RCV_ACCOUNTING_EVENTS'
AND XTE.TRANSACTION_NUMBER = RT.TRANSACTION_ID AND RT.SHIPMENT_HEADER_ID =
RSH.SHIPMENT_HEADER_ID AND RSH.CREATED_BY = FU.USER_ID AND
RT.TRANSACTION_ID = :B1 ORDER BY GIR.JE_LINE_NUM
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 20 0.00 0.00 0 0 0 0
Execute 20 0.01 0.02 0 0 0 0
Fetch 20 27.16 44.26 0 91642 0 20
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 60 27.17 44.29 0 91642 0 20
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 44 (recursive depth: 1)
Number of plan statistics captured: 20
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
2 2 2 SORT ORDER BY (cr=138222 pr=0 pw=0 time=5704854 us cost=776 size=2591338 card=13154)
26728 26728 26728 NESTED LOOPS (cr=4582 pr=0 pw=0 time=176263 us cost=207 size=2591338 card=13154)
26728 26728 26728 MERGE JOIN CARTESIAN (cr=915 pr=0 pw=0 time=49756 us cost=205 size=2525568 card=13154)
2 2 2 NESTED LOOPS (cr=224 pr=0 pw=0 time=2773 us)
2 2 2 NESTED LOOPS (cr=223 pr=0 pw=0 time=2762 us cost=21 size=140 card=1)
2 2 2 NESTED LOOPS (cr=217 pr=0 pw=0 time=2730 us cost=18 size=125 card=1)
1 1 1 NESTED LOOPS (cr=214 pr=0 pw=0 time=3855 us cost=16 size=104 card=1)
1 1 1 NESTED LOOPS (cr=66 pr=0 pw=0 time=712 us cost=16 size=90 card=1)
1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=34 us cost=3 size=52 card=1)
1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=28 us cost=3 size=48 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID RCV_TRANSACTIONS (cr=3 pr=0 pw=0 time=15 us cost=2 size=10 card=1)
1 1 1 INDEX UNIQUE SCAN RCV_TRANSACTIONS_U1 (cr=2 pr=0 pw=0 time=10 us cost=1 size=0 card=1)(object id 124697)
1 1 1 TABLE ACCESS BY INDEX ROWID RCV_SHIPMENT_HEADERS (cr=2 pr=0 pw=0 time=9 us cost=1 size=19342 card=509)
1 1 1 INDEX UNIQUE SCAN RCV_SHIPMENT_HEADERS_U1 (cr=1 pr=0 pw=0 time=4 us cost=0 size=0 card=1)(object id 124607)
1 1 1 INDEX UNIQUE SCAN FND_USER_U1 (cr=1 pr=0 pw=0 time=3 us cost=0 size=2164 card=541)(object id 132187)
1 1 1 PARTITION LIST SINGLE PARTITION: KEY KEY (cr=60 pr=0 pw=0 time=676 us cost=13 size=38 card=1)
1 1 1 TABLE ACCESS FULL XLA_TRANSACTION_ENTITIES PARTITION: 9 9 (cr=60 pr=0 pw=0 time=667 us cost=13 size=38 card=1)
1 1 1 PARTITION LIST SINGLE PARTITION: KEY KEY (cr=148 pr=0 pw=0 time=3140 us cost=0 size=14 card=1)
1 1 1 TABLE ACCESS BY LOCAL INDEX ROWID XLA_AE_HEADERS PARTITION: 9 9 (cr=148 pr=0 pw=0 time=3135 us cost=0 size=14 card=1)
2839 2839 2839 INDEX RANGE SCAN XLA_AE_HEADERS_N4 PARTITION: 9 9 (cr=12 pr=0 pw=0 time=1138 us cost=0 size=0 card=77)(object id 341720)
2 2 2 PARTITION LIST SINGLE PARTITION: KEY KEY (cr=3 pr=0 pw=0 time=33 us cost=2 size=42 card=2)
2 2 2 TABLE ACCESS BY LOCAL INDEX ROWID XLA_AE_LINES PARTITION: 9 9 (cr=3 pr=0 pw=0 time=28 us cost=2 size=42 card=2)
2 2 2 INDEX RANGE SCAN XLA_AE_LINES_U1 PARTITION: 9 9 (cr=2 pr=0 pw=0 time=9 us cost=1 size=0 card=1)(object id 296750)
2 2 2 INDEX RANGE SCAN GL_IMPORT_REFERENCES_N4 (cr=6 pr=0 pw=0 time=31 us cost=2 size=0 card=1)(object id 47198)
2 2 2 TABLE ACCESS BY INDEX ROWID GL_IMPORT_REFERENCES (cr=1 pr=0 pw=0 time=7 us cost=3 size=15 card=1)
26728 26728 26728 BUFFER SORT (cr=691 pr=0 pw=0 time=37351 us cost=202 size=671892 card=12921)
13364 13364 13364 TABLE ACCESS FULL AP_SUPPLIERS (cr=691 pr=0 pw=0 time=13765 us cost=184 size=671892 card=12921)
26728 26728 26728 INDEX UNIQUE SCAN HZ_PARTIES_U1 (cr=3667 pr=0 pw=0 time=87316 us cost=0 size=5 card=1)(object id 46227)
********************************************************************************
SQL ID: f580a5k3vh4fa Plan Hash: 2247341928
SELECT FA.ASSET_NUMBER, NULL,
CUX_GL_TRACE_PKG.GET_EMP_NAME(FA.LAST_UPDATED_BY, FA.LAST_UPDATE_DATE),
FA.DESCRIPTION
FROM
GL_IMPORT_REFERENCES GIR, GL_JE_HEADERS GJH, XLA_AE_HEADERS XAH,
XLA.XLA_TRANSACTION_ENTITIES XTE, XLA_AE_LINES XAL, FA_ADDITIONS FA WHERE
GIR.JE_HEADER_ID = GJH.JE_HEADER_ID AND GJH.JE_SOURCE = 'Assets' AND
XTE.APPLICATION_ID = 140 AND GJH.JE_CATEGORY = 'Depreciation' AND
XAL.GL_SL_LINK_TABLE = GIR.GL_SL_LINK_TABLE AND XAL.GL_SL_LINK_ID =
GIR.GL_SL_LINK_ID AND XAH.AE_HEADER_ID = XAL.AE_HEADER_ID AND
XAH.APPLICATION_ID = XAL.APPLICATION_ID AND XTE.ENTITY_ID = XAH.ENTITY_ID
AND XTE.APPLICATION_ID = XAH.APPLICATION_ID AND XTE.ENTITY_CODE =
'DEPRECIATION' AND XAH.BALANCE_TYPE_CODE = 'A' AND XTE.SOURCE_ID_INT_1 =
FA.ASSET_ID AND FA.ASSET_ID = :B1 ORDER BY GIR.JE_LINE_NUM
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1548 0.03 0.05 0 0 0 0
Execute 1548 0.09 0.15 0 0 0 0
Fetch 1548 20.91 33.62 0 1664488 0 1548
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4644 21.05 33.84 0 1664488 0 1548
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 44 (recursive depth: 1)
Number of plan statistics captured: 1548
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
2 2 2 SORT ORDER BY (cr=1095 pr=0 pw=0 time=22402 us cost=109 size=160 card=1)
4 4 4 NESTED LOOPS (cr=1075 pr=0 pw=0 time=10545 us)
4 4 4 NESTED LOOPS (cr=1071 pr=0 pw=0 time=10521 us cost=108 size=160 card=1)
4 4 4 NESTED LOOPS (cr=1065 pr=0 pw=0 time=10488 us cost=107 size=141 card=1)
4 4 4 NESTED LOOPS (cr=1053 pr=0 pw=0 time=10410 us cost=104 size=121 card=1)
2 2 2 NESTED LOOPS (cr=1047 pr=0 pw=0 time=20393 us cost=102 size=100 card=1)
2 2 2 NESTED LOOPS (cr=380 pr=0 pw=0 time=2619 us cost=102 size=84 card=1)
1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=32 us cost=3 size=56 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID FA_ADDITIONS_TL (cr=3 pr=0 pw=0 time=18 us cost=2 size=27 card=1)
1 1 1 INDEX UNIQUE SCAN FA_ADDITIONS_TL_U1 (cr=2 pr=0 pw=0 time=12 us cost=1 size=0 card=1)(object id 78536)
1 1 1 TABLE ACCESS BY INDEX ROWID FA_ADDITIONS_B (cr=3 pr=0 pw=0 time=11 us cost=1 size=29 card=1)
1 1 1 INDEX UNIQUE SCAN FA_ADDITIONS_B_U1 (cr=2 pr=0 pw=0 time=6 us cost=0 size=0 card=1)(object id 78529)
2 2 2 PARTITION LIST SINGLE PARTITION: KEY KEY (cr=374 pr=0 pw=0 time=2588 us cost=99 size=28 card=1)
2 2 2 TABLE ACCESS FULL XLA_TRANSACTION_ENTITIES PARTITION: 6 6 (cr=374 pr=0 pw=0 time=2582 us cost=99 size=28 card=1)
2 2 2 PARTITION LIST SINGLE PARTITION: KEY KEY (cr=667 pr=0 pw=0 time=18264 us cost=0 size=16 card=1)
2 2 2 TABLE ACCESS BY LOCAL INDEX ROWID XLA_AE_HEADERS PARTITION: 6 6 (cr=667 pr=0 pw=0 time=18255 us cost=0 size=16 card=1)
15414 15394 15414 INDEX RANGE SCAN XLA_AE_HEADERS_N4 PARTITION: 6 6 (cr=68 pr=0 pw=0 time=5726 us cost=0 size=0 card=974)(object id 341720)
4 4 4 PARTITION LIST SINGLE PARTITION: KEY KEY (cr=6 pr=0 pw=0 time=75 us cost=2 size=42 card=2)
4 4 4 TABLE ACCESS BY LOCAL INDEX ROWID XLA_AE_LINES PARTITION: 6 6 (cr=6 pr=0 pw=0 time=65 us cost=2 size=42 card=2)
4 4 4 INDEX RANGE SCAN XLA_AE_LINES_U1 PARTITION: 6 6 (cr=4 pr=0 pw=0 time=31 us cost=1 size=0 card=1)(object id 296750)
4 4 4 TABLE ACCESS BY INDEX ROWID GL_IMPORT_REFERENCES (cr=12 pr=0 pw=0 time=79 us cost=3 size=20 card=1)
4 4 4 INDEX RANGE SCAN GL_IMPORT_REFERENCES_N4 (cr=10 pr=0 pw=0 time=52 us cost=2 size=0 card=1)(object id 47198)
4 4 4 INDEX UNIQUE SCAN GL_JE_HEADERS_U1 (cr=6 pr=0 pw=0 time=25 us cost=0 size=0 card=1)(object id 47534)
4 4 4 TABLE ACCESS BY INDEX ROWID GL_JE_HEADERS (cr=4 pr=0 pw=0 time=19 us cost=1 size=19 card=1)
********************************************************************************
SQL ID: gvpdw4rcv45ft Plan Hash: 2185071097
SELECT NVL(RTRIM(PP.FULL_NAME, ','), U.USER_NAME)
FROM
FND_USER U, PER_ALL_PEOPLE_F PP WHERE U.USER_ID = :B2 AND U.EMPLOYEE_ID =
PP.PERSON_ID(+) AND :B1 BETWEEN PP.EFFECTIVE_START_DATE(+) AND
PP.EFFECTIVE_END_DATE(+)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 543240 38.18 61.27 0 0 0 0
Fetch 543240 6.07 9.97 0 2715810 0 543240
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1086480 44.26 71.25 0 2715810 0 543240
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 44 (recursive depth: 2)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
cursor: pin S 20 0.01 0.10
********************************************************************************
SQL ID: 57ky29k8jbntc Plan Hash: 358401753
SELECT DEFAULT_EFFECTIVE_DATE,BATCH_NAME,HEADER_NAME,USER_JE_SOURCE_NAME,
STATUS_DESC,JE_LINE_NUM,CURRENCY_CODE,VOUCHER_NUMBER,USER_JE_CATEGORY_NAME,
LINE_DESC,/*DECODE(L.SUBLEGER_FLAG,1,L.XLAT.CREATED_BY_NAME,
L.CREATED_BY_NAME)*/CREATED_BY_NAME,L.XLAT.XX_NUMBER,L.XLAT.PARTY_NAME,
ENTERED_DR,ENTERED_CR,ACCOUNTED_DR,ACCOUNTED_CR,JE_HEADER_ID,JE_BATCH_ID,
AE_HEADER_ID,CHART_OF_ACCOUNTS_ID,PERIOD_START_DATE,LEDGER_ID,SUBLEGER_FLAG,
PERIOD_NAME,JE_SOURCE,JE_CATEGORY,HEADER_DESC
FROM
CUX_GL_BAL_JE_LINES_V L WHERE l.ledger_id = :1 AND ((nvl(:2, 'N') = 'N' AND
l.code_combination_id = :3) OR (:4 = 'Y' AND EXISTS (SELECT 1 FROM
gl_account_hierarchies ah WHERE ah.template_id = nvl(:5, ah.template_id)
AND ah.summary_code_combination_id = :6 AND l.code_combination_id =
ah.detail_code_combination_id))) AND period_name = :7 AND (:8 = 1 OR
l.status = 'P') AND -1=-1 order by L.PERIOD_START_DATE,L.VOUCHER_NUMBER,
L.JE_BATCH_ID,L.JE_HEADER_ID,L.JE_LINE_NUM
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.88 1.42 0 72 0 0
Fetch 1 1.05 1.70 0 12895 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 1.94 3.13 0 12967 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 44
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 SORT ORDER BY (cr=4496273 pr=0 pw=0 time=151223933 us cost=9294 size=21156425 card=7489)
0 0 0 FILTER (cr=4496273 pr=0 pw=0 time=151223914 us)
2307 2307 2307 VIEW CUX_GL_BAL_JE_LINES_V (cr=4496273 pr=0 pw=0 time=34407078 us cost=4877 size=21156425 card=7489)
2307 2307 2307 UNION-ALL (cr=4496273 pr=0 pw=0 time=34402094 us)
554 554 554 HASH JOIN RIGHT OUTER (cr=2397 pr=0 pw=0 time=78679 us cost=986 size=427096 card=1084)
92 92 92 TABLE ACCESS FULL GL_JE_SOURCES_TL (cr=14 pr=0 pw=0 time=632 us cost=5 size=2852 card=92)
554 554 554 HASH JOIN RIGHT OUTER (cr=2383 pr=0 pw=0 time=77423 us cost=981 size=295119 card=813)
201 201 201 TABLE ACCESS FULL GL_JE_CATEGORIES_TL (cr=14 pr=0 pw=0 time=318 us cost=5 size=6231 card=201)
554 554 554 HASH JOIN ANTI (cr=2369 pr=0 pw=0 time=75925 us cost=975 size=202852 card=611)
750 750 750 NESTED LOOPS (cr=457 pr=0 pw=0 time=8436 us)
750 750 750 NESTED LOOPS (cr=328 pr=0 pw=0 time=3929 us cost=460 size=967512 card=3101)
113 113 113 HASH JOIN (cr=215 pr=0 pw=0 time=8821 us cost=59 size=24860 card=110)
113 113 113 NESTED LOOPS (cr=140 pr=0 pw=0 time=7359 us cost=36 size=19140 card=110)
1 1 1 NESTED LOOPS (cr=4 pr=0 pw=0 time=37 us cost=2 size=44 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID GL_LEDGERS (cr=2 pr=0 pw=0 time=19 us cost=1 size=12 card=1)
1 1 1 INDEX UNIQUE SCAN GL_LEDGERS_U2 (cr=1 pr=0 pw=0 time=11 us cost=0 size=0 card=1)(object id 285094)
1 1 1 TABLE ACCESS BY INDEX ROWID GL_PERIODS (cr=2 pr=0 pw=0 time=15 us cost=1 size=32 card=1)
1 1 1 INDEX UNIQUE SCAN GL_PERIODS_U1 (cr=1 pr=0 pw=0 time=6 us cost=0 size=0 card=1)(object id 48037)
113 113 113 TABLE ACCESS FULL GL_JE_HEADERS (cr=136 pr=0 pw=0 time=7213 us cost=34 size=14300 card=110)
2299 2299 2299 TABLE ACCESS FULL GL_JE_BATCHES (cr=75 pr=0 pw=0 time=3214 us cost=22 size=118456 card=2278)
750 750 750 INDEX RANGE SCAN GL_JE_LINES_U1 (cr=113 pr=0 pw=0 time=1045 us cost=1 size=0 card=56)(object id 47576)
750 750 750 TABLE ACCESS BY INDEX ROWID GL_JE_LINES (cr=129 pr=0 pw=0 time=1358 us cost=4 size=2408 card=28)
134199 134199 134199 TABLE ACCESS FULL GL_IMPORT_REFERENCES (cr=1912 pr=0 pw=0 time=43537 us cost=514 size=1302420 card=65121)
1753 1753 1753 HASH GROUP BY (cr=10498 pr=0 pw=0 time=232017 us cost=3891 size=3554775 card=6405)
1753 1753 1753 HASH JOIN RIGHT OUTER (cr=10498 pr=0 pw=0 time=200255 us cost=3135 size=3554775 card=6405)
92 92 92 TABLE ACCESS FULL GL_JE_SOURCES_TL (cr=14 pr=0 pw=0 time=702 us cost=5 size=3956 card=92)
1753 1753 1753 HASH JOIN RIGHT OUTER (cr=10484 pr=0 pw=0 time=198076 us cost=3129 size=2459648 card=4804)
201 201 201 TABLE ACCESS FULL GL_JE_CATEGORIES_TL (cr=14 pr=0 pw=0 time=218 us cost=5 size=8643 card=201)
1753 1753 1753 HASH JOIN (cr=10470 pr=0 pw=0 time=195814 us cost=3124 size=1692621 card=3609)
1753 1753 1753 HASH JOIN (cr=9570 pr=0 pw=0 time=165077 us cost=2891 size=1606005 card=3609)
2299 2299 2299 TABLE ACCESS FULL GL_JE_BATCHES (cr=75 pr=0 pw=0 time=2832 us cost=22 size=145792 card=2278)
1753 1753 1753 HASH JOIN (cr=9495 pr=0 pw=0 time=161064 us cost=2868 size=1375029 card=3609)
1753 1753 1753 PART JOIN FILTER CREATE :BF0000 (cr=7566 pr=0 pw=0 time=127221 us cost=2360 size=1277586 card=3609)
1753 1753 1753 HASH JOIN (cr=7566 pr=0 pw=0 time=125945 us cost=2360 size=1277586 card=3609)
1753 1753 1753 HASH JOIN (cr=2293 pr=0 pw=0 time=58052 us cost=952 size=1167645 card=3615)
750 750 750 NESTED LOOPS (cr=381 pr=0 pw=0 time=3647 us)
750 750 750 NESTED LOOPS (cr=251 pr=0 pw=0 time=1638 us cost=437 size=939603 card=3101)
113 113 113 NESTED LOOPS (cr=140 pr=0 pw=0 time=7693 us cost=36 size=23870 card=110)
1 1 1 NESTED LOOPS (cr=4 pr=0 pw=0 time=37 us cost=2 size=75 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID GL_LEDGERS (cr=2 pr=0 pw=0 time=21 us cost=1 size=24 card=1)
1 1 1 INDEX UNIQUE SCAN GL_LEDGERS_U2 (cr=1 pr=0 pw=0 time=10 us cost=0 size=0 card=1)(object id 285094)
1 1 1 TABLE ACCESS BY INDEX ROWID GL_PERIODS (cr=2 pr=0 pw=0 time=14 us cost=1 size=51 card=1)
1 1 1 INDEX UNIQUE SCAN GL_PERIODS_U1 (cr=1 pr=0 pw=0 time=5 us cost=0 size=0 card=1)(object id 48037)
113 113 113 TABLE ACCESS FULL GL_JE_HEADERS (cr=136 pr=0 pw=0 time=7546 us cost=34 size=15620 card=110)
750 750 750 INDEX RANGE SCAN GL_JE_LINES_U1 (cr=111 pr=0 pw=0 time=1070 us cost=1 size=0 card=56)(object id 47576)
750 750 750 TABLE ACCESS BY INDEX ROWID GL_JE_LINES (cr=130 pr=0 pw=0 time=1390 us cost=4 size=2408 card=28)
134227 134227 134227 TABLE ACCESS FULL GL_IMPORT_REFERENCES (cr=1912 pr=0 pw=0 time=40986 us cost=514 size=2609880 card=130494)
138295 138295 138295 PARTITION LIST ALL PARTITION: 1 19 (cr=5273 pr=0 pw=0 time=113139 us cost=1406 size=4171422 card=134562)
138295 138295 138295 TABLE ACCESS FULL XLA_AE_LINES PARTITION: 1 19 (cr=5273 pr=0 pw=0 time=67372 us cost=1406 size=4171422 card=134562)
39997 39997 39997 PARTITION LIST JOIN-FILTER PARTITION: :BF0000 :BF0000 (cr=1929 pr=0 pw=0 time=38493 us cost=507 size=1032021 card=38223)
39997 39997 39997 TABLE ACCESS FULL XLA_AE_HEADERS PARTITION: :BF0000 :BF0000 (cr=1929 pr=0 pw=0 time=25292 us cost=507 size=1032021 card=38223)
54255 54255 54255 PARTITION LIST ALL PARTITION: 1 19 (cr=900 pr=0 pw=0 time=29845 us cost=232 size=1261920 card=52580)
54255 54255 54255 TABLE ACCESS FULL XLA_TRANSACTION_ENTITIES PARTITION: 1 19 (cr=900 pr=0 pw=0 time=13712 us cost=232 size=1261920 card=52580)
0 0 0 TABLE ACCESS BY INDEX ROWID GL_ACCOUNT_HIERARCHIES (cr=0 pr=0 pw=0 time=0 us cost=2 size=14 card=1)
0 0 0 INDEX UNIQUE SCAN GL_ACCOUNT_HIERARCHIES_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 44947)
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.01 0.01
********************************************************************************
SQL ID: 70rx0sb2sfdqj Plan Hash: 2536199626
SELECT COUNT(ACCOUNTED_CR),SUM(ACCOUNTED_CR),COUNT(ACCOUNTED_DR),
SUM(ACCOUNTED_DR),COUNT(ENTERED_CR),SUM(ENTERED_CR),COUNT(ENTERED_DR),
SUM(ENTERED_DR)
FROM
CUX_GL_BAL_JE_LINES_V L WHERE l.ledger_id = :1 AND ((nvl(:2, 'N') = 'N' AND
l.code_combination_id = :3) OR (:4 = 'Y' AND EXISTS (SELECT 1 FROM
gl_account_hierarchies ah WHERE ah.template_id = nvl(:5, ah.template_id)
AND ah.summary_code_combination_id = :6 AND l.code_combination_id =
ah.detail_code_combination_id))) AND period_name = :7 AND (:8 = 1 OR
l.status = 'P') AND -1=-1 order by L.PERIOD_START_DATE,L.VOUCHER_NUMBER,
L.JE_BATCH_ID,L.JE_HEADER_ID,L.JE_LINE_NUM
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 0
Fetch 1 0.13 0.20 0 12879 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.13 0.20 0 12879 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 44
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
********************************************************************************
SQL ID: dyrhr13ad2gz3 Plan Hash: 3008433410
SELECT XE.APPLICATION_ID
FROM
XLA.XLA_TRANSACTION_ENTITIES XE WHERE SOURCE_ID_INT_1 = :B2 AND
XE.ENTITY_CODE = :B1 AND SOURCE_APPLICATION_ID = APPLICATION_ID AND ROWNUM =
1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 13 0.00 0.00 0 0 0 0
Fetch 13 0.02 0.04 0 7236 0 13
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 26 0.02 0.04 0 7236 0 13
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 44 (recursive depth: 1)
********************************************************************************
SQL ID: gmfg04zy0kz77 Plan Hash: 2971021889
SELECT DISTINCT FA.ASSET_NUMBER, NULL,
CUX_GL_TRACE_PKG.GET_EMP_NAME(FTH.LAST_UPDATED_BY, FTH.LAST_UPDATE_DATE),
FA.DESCRIPTION
FROM
GL_IMPORT_REFERENCES GIR, GL_JE_HEADERS GJH, XLA_AE_HEADERS XAH,
XLA.XLA_TRANSACTION_ENTITIES XTE, XLA_AE_LINES XAL, FA_TRANSACTION_HEADERS
FTH, FA_ADDITIONS FA WHERE GIR.JE_HEADER_ID = GJH.JE_HEADER_ID AND
GJH.JE_SOURCE = 'Assets' AND XTE.APPLICATION_ID = 140 AND GJH.JE_CATEGORY
IN ('Addition', 'Adjustment', 'Retirement', 'Transfer') AND
XAL.GL_SL_LINK_TABLE = GIR.GL_SL_LINK_TABLE AND XAL.GL_SL_LINK_ID =
GIR.GL_SL_LINK_ID AND XAH.AE_HEADER_ID = XAL.AE_HEADER_ID AND
XAH.APPLICATION_ID = XAL.APPLICATION_ID AND XTE.ENTITY_ID = XAH.ENTITY_ID
AND XTE.APPLICATION_ID = XAH.APPLICATION_ID AND XTE.ENTITY_CODE =
'TRANSACTIONS' AND XAH.BALANCE_TYPE_CODE = 'A' AND XTE.SOURCE_ID_INT_1 =
FTH.TRANSACTION_HEADER_ID AND FTH.ASSET_ID = FA.ASSET_ID AND
FTH.TRANSACTION_HEADER_ID = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 4 0.00 0.00 0 0 0 0
Fetch 4 0.02 0.04 0 2928 0 4
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 8 0.02 0.04 0 2928 0 4
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 44 (recursive depth: 1)
********************************************************************************
SQL ID: cvn54b7yz0s8u Plan Hash: 2991757387
select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece
from
idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 6 0.00 0.00 0 0 0 0
Execute 6 0.00 0.00 0 0 0 0
Fetch 12 0.00 0.03 10 40 0 8
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 24 0.00 0.03 10 40 0 8
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS BY INDEX ROWID IDL_UB1$ (cr=5 pr=2 pw=0 time=8192 us cost=4 size=22 card=1)
1 1 1 INDEX RANGE SCAN I_IDL_UB11 (cr=4 pr=1 pw=0 time=243 us cost=3 size=0 card=1)(object id 120)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
Disk file operations I/O 4 0.00 0.00
db file sequential read 10 0.00 0.03
********************************************************************************
SQL ID: ga9j9xk5cy9s0 Plan Hash: 467424113
select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece
from
idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 6 0.00 0.00 0 0 0 0
Execute 6 0.00 0.00 0 0 0 0
Fetch 16 0.00 0.03 8 48 0 10
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 28 0.00 0.03 8 48 0 10
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
2 2 2 TABLE ACCESS BY INDEX ROWID IDL_SB4$ (cr=7 pr=2 pw=0 time=8517 us cost=4 size=19 card=1)
2 2 2 INDEX RANGE SCAN I_IDL_SB41 (cr=5 pr=1 pw=0 time=2348 us cost=3 size=0 card=1)(object id 123)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
Disk file operations I/O 3 0.00 0.00
db file sequential read 8 0.00 0.03
********************************************************************************
SQL ID: c6awqs517jpj0 Plan Hash: 3800936087
select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece
from
idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 6 0.00 0.00 0 0 0 0
Execute 6 0.00 0.00 0 0 0 0
Fetch 10 0.00 0.02 6 30 0 4
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 22 0.00 0.02 6 30 0 4
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS BY INDEX ROWID IDL_CHAR$ (cr=5 pr=2 pw=0 time=5783 us cost=4 size=21 card=1)
1 1 1 INDEX RANGE SCAN I_IDL_CHAR1 (cr=4 pr=1 pw=0 time=243 us cost=3 size=0 card=1)(object id 121)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
Disk file operations I/O 2 0.00 0.00
db file sequential read 6 0.00 0.02
********************************************************************************
SQL ID: 39m4sx9k63ba2 Plan Hash: 2769382227
select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece
from
idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 6 0.00 0.00 0 0 0 0
Execute 6 0.00 0.00 0 0 0 0
Fetch 10 0.00 0.02 7 38 0 8
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 22 0.00 0.02 7 38 0 8
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
2 2 2 TABLE ACCESS BY INDEX ROWID IDL_UB2$ (cr=6 pr=2 pw=0 time=7739 us cost=4 size=21 card=1)
2 2 2 INDEX RANGE SCAN I_IDL_UB21 (cr=4 pr=1 pw=0 time=208 us cost=3 size=0 card=1)(object id 122)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 7 0.00 0.02
Disk file operations I/O 1 0.00 0.00
********************************************************************************
SQL ID: dcstr36r0vz0d Plan Hash: 3405580872
select procedure#,procedurename,properties,itypeobj#
from
procedureinfo$ where obj#=:1 order by procedurename desc, overload# desc
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 42 0.00 0.01 4 86 0 40
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 46 0.00 0.01 4 86 0 40
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
40 40 40 TABLE ACCESS BY INDEX ROWID PROCEDUREINFO$ (cr=83 pr=3 pw=0 time=8092 us cost=4 size=204 card=6)
40 40 40 INDEX RANGE SCAN DESCENDING I_PROCEDUREINFO1 (cr=43 pr=2 pw=0 time=3729 us cost=3 size=0 card=6)(object id 116)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 4 0.00 0.01
********************************************************************************
SQL ID: 32hbap2vtmf53 Plan Hash: 3991497838
select position#,sequence#,level#,argument,type#,charsetid,charsetform,
properties,nvl(length, 0), nvl(precision#, 0),nvl(scale, 0),nvl(radix, 0),
type_owner,type_name,type_subname,type_linkname,pls_type
from
argument$ where obj#=:1 and procedure#=:2 order by sequence# desc
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 40 0.00 0.00 0 0 0 0
Fetch 154 0.00 0.01 4 348 0 114
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 196 0.00 0.02 4 348 0 114
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
4 4 4 TABLE ACCESS BY INDEX ROWID ARGUMENT$ (cr=11 pr=3 pw=0 time=9967 us cost=4 size=83 card=1)
4 4 4 INDEX RANGE SCAN DESCENDING I_ARGUMENT2 (cr=7 pr=2 pw=0 time=3603 us cost=3 size=0 card=1)(object id 118)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 4 0.00 0.01
********************************************************************************
SQL ID: 9nxxx2b4ntf4m Plan Hash: 335949328
SELECT AI.INVOICE_NUM, PV.VENDOR_NAME,
CUX_GL_TRACE_PKG.GET_EMP_NAME(AI.LAST_UPDATED_BY, AI.LAST_UPDATE_DATE),
AI.DESCRIPTION
FROM
AP_INVOICES_ALL AI, PO_VENDORS PV WHERE AI.INVOICE_ID = :B1 AND AI.VENDOR_ID
= PV.VENDOR_ID(+)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 118 0.00 0.00 0 0 0 0
Fetch 118 0.00 0.01 0 944 0 118
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 236 0.01 0.01 0 944 0 118
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 44 (recursive depth: 1)
********************************************************************************
SQL ID: 2xgubd6ayhyb1 Plan Hash: 3071105960
select max(procedure#)
from
procedureplsql$ where obj#=:1
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.01 2 6 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.01 2 6 0 2
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=3 pr=1 pw=0 time=5672 us)
0 0 0 FIRST ROW (cr=3 pr=1 pw=0 time=5667 us cost=3 size=9 card=1)
0 0 0 INDEX RANGE SCAN (MIN/MAX) I_PROCEDUREPLSQL$ (cr=3 pr=1 pw=0 time=5666 us cost=3 size=9 card=1)(object id 248486)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.01
********************************************************************************
SQL ID: 1m97usnkj9wjr Plan Hash: 1546270724
SELECT DBMS_UTILITY.PORT_STRING
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.00 0.00 0 0 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.01 0 0 0 1
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 44 (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=3 us cost=2 size=0 card=1)
********************************************************************************
SQL ID: fmfdkztk8vx23 Plan Hash: 3675718404
SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY
FROM
FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND
LANGUAGE_CODE = :B3 AND ROWNUM = 1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 1 12 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 1 12 0 3
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 44
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
Disk file operations I/O 1 0.00 0.00
db file sequential read 1 0.00 0.00
SQL*Net message to client 3 0.00 0.00
SQL*Net message from client 3 492.43 492.43
********************************************************************************
SQL ID: 5km6gkvuh3n43 Plan Hash: 4232941284
select max(procedure#)
from
procedurejava$ where obj#=:1
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 1 4 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 1 4 0 2
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=2 pr=1 pw=0 time=6467 us)
0 0 0 FIRST ROW (cr=2 pr=1 pw=0 time=6460 us cost=2 size=9 card=1)
0 0 0 INDEX RANGE SCAN (MIN/MAX) I_PROCEDUREJAVA$ (cr=2 pr=1 pw=0 time=6459 us cost=2 size=9 card=1)(object id 315)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: bwkrmnpckyy21 Plan Hash: 664232721
SELECT NAME, VALUE
FROM
V$PARAMETER WHERE NAME='db_name' OR NAME LIKE 'user_dump%'
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 0 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.01 0 0 0 2
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 44 (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
2 2 2 HASH JOIN (cr=0 pr=0 pw=0 time=4202 us cost=2 size=54 card=1)
2 2 2 FIXED TABLE FULL X$KSPPI (cr=0 pr=0 pw=0 time=1406 us cost=1 size=36 card=1)
2751 2751 2751 FIXED TABLE FULL X$KSPPCV (cr=0 pr=0 pw=0 time=3257 us cost=1 size=49518 card=2751)
795
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
