TKPROF: Release 11.2.0.4.0 - Development on Sat Apr 16 12:18:22 2016 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Trace file: igproddb_ora_13473.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 ******************************************************************************** The following statement encountered a error during parse: SELECT * FROM material_onhand_v where order_number = '1008306' Error encountered: ORA-00942 ******************************************************************************** SQL ID: 4kvc1pjyh5n7x Plan Hash: 0 ALTER SESSION SET SQL_TRACE=TRUE 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS ******************************************************************************** SQL ID: grwydz59pu6mc Plan Hash: 3684871272 select text from view$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.18 0 0 0 0 Fetch 4 0.00 0.00 0 9 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.18 0 9 0 4 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=11 us cost=1 size=15 card=1) ******************************************************************************** SQL ID: 3xxa5r91yd32k Plan Hash: 2712432565 SELECT * FROM image.material_onhand_v where order_number = '1008306' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 2.40 2.53 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 3 4.32 5.20 0 216846 0 18 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 6.72 7.74 0 216846 0 18 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 16 16 16 SORT AGGREGATE (cr=11392 pr=0 pw=0 time=115052 us) 0 0 0 TABLE ACCESS FULL RCV_ROLL_TRANSACTIONS (cr=11392 pr=0 pw=0 time=114925 us cost=171 size=27468 card=2289) 18 18 18 HASH JOIN (cr=205454 pr=0 pw=0 time=5093617 us cost=78064 size=61857 card=29) 18 18 18 HASH JOIN OUTER (cr=205443 pr=0 pw=0 time=5093357 us cost=78062 size=13416 card=12) 18 18 18 HASH JOIN RIGHT OUTER (cr=143679 pr=0 pw=0 time=2610811 us cost=45804 size=11016 card=12) 1 1 1 VIEW (cr=1952 pr=0 pw=0 time=13603 us cost=500 size=200 card=1) 1 1 1 HASH GROUP BY (cr=1952 pr=0 pw=0 time=13599 us cost=500 size=58 card=1) 1 1 1 TABLE ACCESS FULL ORDER_PEGGING (cr=1952 pr=0 pw=0 time=13398 us cost=499 size=58 card=1) 18 18 18 HASH JOIN OUTER (cr=141727 pr=0 pw=0 time=2597039 us cost=45304 size=8616 card=12) 18 18 18 NESTED LOOPS (cr=77377 pr=0 pw=0 time=577979 us cost=21453 size=6216 card=12) 18 18 18 HASH JOIN OUTER (cr=77346 pr=0 pw=0 time=577564 us cost=21429 size=4368 card=12) 18 18 18 HASH JOIN OUTER (cr=12996 pr=0 pw=0 time=78326 us cost=6264 size=1968 card=12) 18 18 18 TABLE ACCESS FULL MATERIAL_ONHAND_QUANTITIES (cr=504 pr=0 pw=0 time=6990 us cost=136 size=660 card=12) 0 0 0 VIEW (cr=12492 pr=0 pw=0 time=74268 us cost=6128 size=16786 card=154) 0 0 0 HASH GROUP BY (cr=12492 pr=0 pw=0 time=74266 us cost=6128 size=35112 card=154) 0 0 0 NESTED LOOPS (cr=12492 pr=0 pw=0 time=74159 us cost=6127 size=35112 card=154) 0 0 0 NESTED LOOPS (cr=12492 pr=0 pw=0 time=74155 us cost=6127 size=35112 card=154) 0 0 0 HASH JOIN (cr=12492 pr=0 pw=0 time=74153 us cost=5974 size=15147 card=153) 0 0 0 TABLE ACCESS FULL PACKING_CARTONS (cr=12492 pr=0 pw=0 time=74062 us cost=3450 size=14558 card=502) 0 0 0 VIEW (cr=0 pr=0 pw=0 time=0 us cost=2523 size=6101690 card=87167) 0 0 0 SORT UNIQUE (cr=0 pr=0 pw=0 time=0 us cost=2523 size=8475258 card=87167) 0 0 0 UNION-ALL (cr=0 pr=0 pw=0 time=0 us) 0 0 0 HASH JOIN (cr=0 pr=0 pw=0 time=0 us cost=319 size=2900370 card=30855) 0 0 0 TABLE ACCESS FULL ORDER_PACKING_DEFINITION (cr=0 pr=0 pw=0 time=0 us cost=25 size=247809 card=4859) 0 0 0 TABLE ACCESS FULL ITEM# (cr=0 pr=0 pw=0 time=0 us cost=293 size=1773449 card=41243) 0 0 0 HASH JOIN (cr=0 pr=0 pw=0 time=0 us cost=268 size=5574888 card=56312) 0 0 0 TABLE ACCESS FULL ORDER_PACKING_DEFINITION (cr=0 pr=0 pw=0 time=0 us cost=25 size=247809 card=4859) 0 0 0 TABLE ACCESS FULL PACKING_COMBINATION_IDS_LOOSE (cr=0 pr=0 pw=0 time=0 us cost=243 size=2702976 card=56312) 0 0 0 INDEX UNIQUE SCAN ITEMS_PK (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 88350) 0 0 0 TABLE ACCESS BY INDEX ROWID ITEMS (cr=0 pr=0 pw=0 time=0 us cost=1 size=129 card=1) 601 601 601 VIEW (cr=64350 pr=0 pw=0 time=498670 us cost=15165 size=529800 card=2649) 601 601 601 HASH GROUP BY (cr=64350 pr=0 pw=0 time=498427 us cost=15165 size=161589 card=2649) 715 715 715 TABLE ACCESS FULL MOVE_ORDER_LINES (cr=64350 pr=0 pw=0 time=731486 us cost=15164 size=161589 card=2649) 18 18 18 INDEX RANGE SCAN ITEMS_IDX (cr=31 pr=0 pw=0 time=147 us cost=2 size=154 card=1)(object id 88351) 602125 602125 602125 VIEW (cr=64350 pr=0 pw=0 time=1825193 us cost=23850 size=117658200 card=588291) 602125 602125 602125 HASH GROUP BY (cr=64350 pr=0 pw=0 time=1701950 us cost=23850 size=35885751 card=588291) 621198 621198 621198 TABLE ACCESS FULL MOVE_ORDER_LINES (cr=64350 pr=0 pw=0 time=677328 us cost=15169 size=35885751 card=588291) 630710 630710 630710 VIEW (cr=61764 pr=0 pw=0 time=2277690 us cost=32256 size=125637000 card=628185) 630710 630710 630710 HASH GROUP BY (cr=61764 pr=0 pw=0 time=2159046 us cost=32256 size=69728535 card=628185) 671579 671579 671579 HASH JOIN RIGHT OUTER (cr=61764 pr=0 pw=0 time=2322255 us cost=16462 size=69728535 card=628185) 254 254 254 VIEW (cr=6928 pr=0 pw=0 time=66155 us cost=2364 size=14202 card=263) 254 254 254 NESTED LOOPS OUTER (cr=6928 pr=0 pw=0 time=66025 us cost=2364 size=23407 card=263) 254 254 254 HASH JOIN OUTER (cr=6431 pr=0 pw=0 time=64236 us cost=2102 size=19575 card=261) 254 254 254 NESTED LOOPS OUTER (cr=6261 pr=0 pw=0 time=23011 us cost=2024 size=16182 card=261) 254 254 254 NESTED LOOPS (cr=5494 pr=0 pw=0 time=21219 us cost=1506 size=10360 card=259) 254 254 254 TABLE ACCESS FULL DYED_INSPECTION_REPORT_D (cr=5292 pr=0 pw=0 time=19931 us cost=1506 size=9065 card=259) 254 254 254 INDEX UNIQUE SCAN DYED_INSPECTION_REP_M_PK (cr=202 pr=0 pw=0 time=525 us cost=0 size=5 card=1)(object id 88048) 254 254 254 TABLE ACCESS BY INDEX ROWID RCV_TRANSACTIONS (cr=767 pr=0 pw=0 time=1554 us cost=2 size=22 card=1) 254 254 254 INDEX UNIQUE SCAN RCV_TRANSACTIONS_PK (cr=513 pr=0 pw=0 time=814 us cost=1 size=0 card=1)(object id 88649) 41751 41751 41751 VIEW (cr=170 pr=0 pw=0 time=27396 us cost=78 size=542828 card=41756) 41751 41751 41751 HASH JOIN (cr=170 pr=0 pw=0 time=19861 us cost=78 size=542828 card=41756) 779 779 779 INDEX FAST FULL SCAN SUPPLIER_IDX (cr=7 pr=0 pw=0 time=368 us cost=4 size=3016 card=754)(object id 88782) 41898 41898 41898 INDEX FAST FULL SCAN POM_IDX (cr=163 pr=0 pw=0 time=5889 us cost=74 size=370818 card=41202)(object id 88591) 254 254 254 TABLE ACCESS BY INDEX ROWID ITEMS (cr=497 pr=0 pw=0 time=904 us cost=1 size=14 card=1) 254 254 254 INDEX UNIQUE SCAN ITEMS_PK (cr=243 pr=0 pw=0 time=503 us cost=0 size=0 card=1)(object id 88350) 671577 671577 671577 TABLE ACCESS FULL RCV_TRANSACTIONS (cr=54836 pr=0 pw=0 time=1837069 us cost=14097 size=35806545 card=628185) 26 26 26 VIEW MATERIAL_SUBINVENTORY_V (cr=11 pr=0 pw=0 time=168 us cost=2 size=38570 card=38) 26 26 26 UNION-ALL (cr=11 pr=0 pw=0 time=168 us) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=2 us) 0 0 0 INDEX FAST FULL SCAN SUPPLIER_IDX (cr=0 pr=0 pw=0 time=0 us cost=4 size=19578 card=753)(object id 88782) 26 26 26 TABLE ACCESS BY INDEX ROWID FND_FLEX_VALUES (cr=11 pr=0 pw=0 time=161 us cost=2 size=1369 card=37) 26 26 26 INDEX RANGE SCAN FND_FLEX_VALUES_IDX (cr=3 pr=0 pw=0 time=52 us cost=1 size=0 card=37)(object id 88235) ******************************************************************************** SQL ID: dbmdavb6ydwb4 Plan Hash: 0 ALTER SESSION SET SQL_TRACE=FALSE 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 2.40 2.53 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 4.32 5.20 0 216846 0 18 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 6.72 7.74 0 216846 0 18 Misses in library cache during parse: 2 Misses in library cache during execute: 1 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.18 0 0 0 0 Fetch 4 0.00 0.00 0 9 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.18 0 9 0 4 Misses in library cache during parse: 1 Misses in library cache during execute: 1 3 user SQL statements in session. 3 internal SQL statements in session. 6 SQL statements in session. ******************************************************************************** Trace file: igproddb_ora_13473.trc Trace file compatibility: 11.1.0.7 Sort options: default 1 session in tracefile. 3 user SQL statements in trace file. 3 internal SQL statements in trace file. 6 SQL statements in trace file. 4 unique SQL statements in trace file. 151 lines in trace file. 41 elapsed seconds in trace file.