TKPROF: Release 11.2.0.3.0 - Development on Fri Oct 18 07:47:23 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Trace file: betsyu1_ora_5166_NISHANT_RANJ_CR259246393.trc Sort options: prsela exeela 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: 91uxr89bas26k Plan Hash: 1352001002 SELECT OOL.INVENTORY_ITEM_ID FROM OE_ORDER_LINES OOL, MTL_SYSTEM_ITEMS_B MSIB WHERE OOL.TOP_MODEL_LINE_ID = :B4 AND OOL.HEADER_ID = :B3 AND MSIB.ITEM_TYPE IN (:B2 , :B1 ) AND OOL.INVENTORY_ITEM_ID = MSIB.INVENTORY_ITEM_ID AND OOL.SHIP_FROM_ORG_ID = MSIB.ORGANIZATION_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 12166 0.72 0.79 0 0 0 0 Fetch 12178 153.73 5089.92 475806 4102075 0 499422 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 24345 154.46 5090.71 475806 4102075 0 499422 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 58 58 58 NESTED LOOPS (cr=428 pr=48 pw=0 time=518741 us) 130 130 130 NESTED LOOPS (cr=313 pr=47 pw=0 time=489367 us cost=18 size=47 card=1) 130 130 130 TABLE ACCESS BY INDEX ROWID OE_ORDER_LINES_ALL (cr=49 pr=46 pw=0 time=465198 us cost=16 size=27 card=1) 130 130 130 INDEX RANGE SCAN OE_ORDER_LINES_ALL_X14 (cr=5 pr=2 pw=0 time=44479 us cost=4 size=0 card=29)(object id 13249355) 130 130 130 INDEX UNIQUE SCAN MTL_SYSTEM_ITEMS_B_U1 (cr=264 pr=1 pw=0 time=23875 us cost=1 size=0 card=1)(object id 38017) 58 58 58 TABLE ACCESS BY INDEX ROWID MTL_SYSTEM_ITEMS_B (cr=115 pr=1 pw=0 time=29228 us cost=2 size=20 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 475806 0.45 4970.34 read by other session 1 0.00 0.00 latch: cache buffers chains 2 0.00 0.00 Disk file operations I/O 12 0.00 0.00 ******************************************************************************** SQL ID: 8q1vnusn7aw6k Plan Hash: 2292281581 SELECT FDFC.APPLICATION_COLUMN_NAME, FLV.TAG, MSIE.C_EXT_ATTR1, MSIE.C_EXT_ATTR2, MSIE.C_EXT_ATTR3, MSIE.C_EXT_ATTR4, MSIE.C_EXT_ATTR5, MSIE.C_EXT_ATTR6, MSIE.C_EXT_ATTR7, MSIE.C_EXT_ATTR8, MSIE.C_EXT_ATTR9, MSIE.C_EXT_ATTR10, MSIE.C_EXT_ATTR11, MSIE.C_EXT_ATTR12, MSIE.C_EXT_ATTR13, MSIE.C_EXT_ATTR14, MSIE.C_EXT_ATTR15, MSIE.C_EXT_ATTR16, MSIE.C_EXT_ATTR17, MSIE.C_EXT_ATTR18, MSIE.C_EXT_ATTR19, MSIE.C_EXT_ATTR20, MSIE.C_EXT_ATTR21, MSIE.C_EXT_ATTR22, MSIE.C_EXT_ATTR23, MSIE.C_EXT_ATTR24, MSIE.C_EXT_ATTR25, MSIE.C_EXT_ATTR26, MSIE.C_EXT_ATTR27, MSIE.C_EXT_ATTR28, MSIE.C_EXT_ATTR29, MSIE.C_EXT_ATTR30, MSIE.C_EXT_ATTR31, MSIE.C_EXT_ATTR32, MSIE.C_EXT_ATTR33, MSIE.C_EXT_ATTR34, MSIE.C_EXT_ATTR35, MSIE.C_EXT_ATTR36, MSIE.C_EXT_ATTR37, MSIE.C_EXT_ATTR38, MSIE.C_EXT_ATTR39, MSIE.C_EXT_ATTR40 FROM EGO_MTL_SY_ITEMS_EXT_B MSIE, EGO_FND_DSC_FLX_CTX_EXT EFDE, MTL_PARAMETERS MP, FND_DESCR_FLEX_COL_USAGE_TL FDFC, FND_LOOKUP_VALUES FLV WHERE 1 = 1 AND MSIE.INVENTORY_ITEM_ID = :B2 AND MP.MASTER_ORGANIZATION_ID = MSIE.ORGANIZATION_ID AND MP.ORGANIZATION_ID = :B1 AND MSIE.ATTR_GROUP_ID = EFDE.ATTR_GROUP_ID AND FDFC.APPLICATION_ID = EFDE.APPLICATION_ID AND FDFC.DESCRIPTIVE_FLEX_CONTEXT_CODE = EFDE.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.LANGUAGE = USERENV('LANG') AND FDFC.LANGUAGE = USERENV('LANG') AND FDFC.FORM_LEFT_PROMPT = FLV.MEANING AND FLV.ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN NVL(FLV.START_DATE_ACTIVE, TRUNC(SYSDATE)) AND NVL(FLV.END_DATE_ACTIVE, TRUNC(SYSDATE)) AND FLV.LOOKUP_TYPE = 'EMR OM VALVELINK VLVS' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 499422 37.66 38.40 0 0 0 0 Fetch 499422 3700.13 4929.15 103380 552510836 0 1095452 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 998845 3737.79 4967.56 103380 552510836 0 1095452 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 13 13 13 NESTED LOOPS (cr=1522 pr=50 pw=0 time=893906 us) 528 528 528 NESTED LOOPS (cr=1071 pr=33 pw=0 time=660742 us cost=18 size=269 card=1) 539 539 539 MERGE JOIN CARTESIAN (cr=35 pr=22 pw=0 time=566798 us cost=12 size=209 card=1) 11 11 11 NESTED LOOPS (cr=28 pr=17 pw=0 time=507372 us) 11 11 11 NESTED LOOPS (cr=17 pr=14 pw=0 time=491145 us cost=7 size=152 card=1) 11 11 11 NESTED LOOPS (cr=13 pr=13 pw=0 time=455333 us cost=6 size=122 card=1) 1 1 1 INDEX SKIP SCAN MTL_PARAMETERS_N99 (cr=1 pr=1 pw=0 time=37436 us cost=1 size=8 card=1)(object id 12150541) 11 11 11 TABLE ACCESS BY GLOBAL INDEX ROWID EGO_MTL_SY_ITEMS_EXT_B PARTITION: ROW LOCATION ROW LOCATION (cr=12 pr=12 pw=0 time=417862 us cost=5 size=114 card=1) 11 11 11 INDEX RANGE SCAN EGO_MTL_SY_ITEMS_EXT_B_U2 (cr=4 pr=4 pw=0 time=120340 us cost=3 size=0 card=1)(object id 28956907) 11 11 11 INDEX UNIQUE SCAN EGO_FND_DSC_FLX_CTX_EXT_U1 (cr=4 pr=1 pw=0 time=35765 us cost=0 size=0 card=1)(object id 329255) 11 11 11 TABLE ACCESS BY INDEX ROWID EGO_FND_DSC_FLX_CTX_EXT (cr=11 pr=3 pw=0 time=16192 us cost=1 size=30 card=1) 539 539 539 BUFFER SORT (cr=7 pr=5 pw=0 time=59107 us cost=11 size=57 card=1) 49 49 49 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=7 pr=5 pw=0 time=58495 us cost=5 size=57 card=1) 49 49 49 INDEX RANGE SCAN XXAR_FND_LOOKUP_VALUES_N1 (cr=3 pr=1 pw=0 time=27232 us cost=2 size=0 card=13)(object id 1405422) 528 528 528 INDEX RANGE SCAN FND_DESCR_FLEX_COL_USAGE_TL_N1 (cr=1036 pr=11 pw=0 time=93291 us cost=2 size=0 card=4)(object id 33644) 13 13 13 TABLE ACCESS BY INDEX ROWID FND_DESCR_FLEX_COL_USAGE_TL (cr=451 pr=17 pw=0 time=232787 us cost=6 size=60 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 13 0.00 0.00 db file sequential read 103377 0.31 1231.76 db file parallel read 1 0.02 0.02 latch: cache buffers chains 158 0.00 0.00 latch: shared pool 1 0.00 0.00 ******************************************************************************** SQL ID: 0xr5sf9f0d3kw Plan Hash: 1061663294 SELECT DISTINCT OOH.ATTRIBUTE3 REP_ORDER_NBR, OOL_1.ATTRIBUTE10 ITEM_NBR, XVS.SERIAL_NUMBER SERIAL_NBR, XVS.ASSEMBLY_TAG TAG_NBR, TRUNC(OOL_1.REQUEST_DATE) SHIP_DATE, OOL_1.LINE_ID TOP_LINE_ID, OOL_1.HEADER_ID HEADER_ID FROM OE_ORDER_HEADERS OOH, OE_ORDER_LINES OOL_1, XXOM_VLVS_SERIALIZATION XVS WHERE XVS.SALES_ORDER_NUMBER = OOH.ORDER_NUMBER AND XVS.SALES_ORDER_LINE_ID = OOL_1.LINE_ID AND OOL_1.ORG_ID = OOH.ORG_ID AND OOL_1.ORG_ID = :B3 AND OOH.HEADER_ID = OOL_1.HEADER_ID AND OOL_1.LINE_NUMBER = SUBSTR(XVS.SALES_ORDER_LINE_NUMBER, 1, INSTR(XVS.SALES_ORDER_LINE_NUMBER, '.', -1, 1) - 1) AND OOL_1.ITEM_TYPE_CODE = 'MODEL' AND OOL_1.SHIP_FROM_ORG_ID = :B2 AND OOL_1.FLOW_STATUS_CODE NOT IN ('CLOSED', 'CANCELLED') AND EXISTS (SELECT 1 FROM OE_ORDER_LINES OOL_2, MTL_SYSTEM_ITEMS_B MSIB WHERE MSIB.ITEM_TYPE IN (:B5 , :B4 ) AND OOL_2.HEADER_ID = OOL_1.HEADER_ID AND OOL_2.TOP_MODEL_LINE_ID = OOL_1.TOP_MODEL_LINE_ID AND OOL_2.INVENTORY_ITEM_ID = MSIB.INVENTORY_ITEM_ID AND OOL_2.SHIP_FROM_ORG_ID = MSIB.ORGANIZATION_ID) AND XVS.SERIAL_NUMBER = NVL(:B1 , XVS.SERIAL_NUMBER) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.15 0.16 0 0 0 0 Fetch 122 150.61 3594.22 388838 4235157 0 12166 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 124 150.76 3594.39 388838 4235157 0 12166 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 12166 12166 12166 HASH UNIQUE (cr=4235157 pr=388838 pw=0 time=2856368741 us cost=2195 size=160 card=1) 499551 499551 499551 CONCATENATION (cr=4235157 pr=388838 pw=0 time=2852623817 us) 499551 499551 499551 FILTER (cr=4235157 pr=388838 pw=0 time=2852325244 us) 499551 499551 499551 NESTED LOOPS (cr=4235157 pr=388838 pw=0 time=2852050551 us) 1232478 1232478 1232478 NESTED LOOPS (cr=3112613 pr=373298 pw=0 time=2600637928 us cost=2169 size=160 card=1) 1232478 1232478 1232478 NESTED LOOPS (cr=654497 pr=361558 pw=0 time=2422796114 us cost=2167 size=140 card=1) 12174 12174 12174 NESTED LOOPS (cr=173169 pr=63729 pw=0 time=187790873 us cost=2152 size=113 card=1) 12174 12174 12174 NESTED LOOPS (cr=154933 pr=61376 pw=0 time=146785956 us cost=2150 size=93 card=1) 7791 7791 7791 TABLE ACCESS BY INDEX ROWID OE_ORDER_LINES_ALL (cr=139389 pr=58636 pw=0 time=104345925 us cost=2141 size=232 card=4) 80640 80640 80640 INDEX RANGE SCAN OE_ORDER_LINES_X101 (cr=409 pr=408 pw=0 time=2819593 us cost=42 size=0 card=6089)(object id 23970466) 12174 12174 12174 TABLE ACCESS BY INDEX ROWID XXOM_VLVS_SERIALIZATION (cr=15544 pr=2740 pw=0 time=42379769 us cost=3 size=35 card=1) 12174 12174 12174 INDEX RANGE SCAN XXOM_VLVS_SERIALIZATION_N2 (cr=12154 pr=888 pw=0 time=13020434 us cost=2 size=0 card=4)(object id 10008247) 12174 12174 12174 TABLE ACCESS BY INDEX ROWID OE_ORDER_HEADERS_ALL (cr=18236 pr=2353 pw=0 time=40951822 us cost=2 size=20 card=1) 12174 12174 12174 INDEX UNIQUE SCAN OE_ORDER_HEADERS_U1 (cr=15084 pr=126 pw=0 time=2562756 us cost=1 size=0 card=1)(object id 41952) 1232478 1232478 1232478 TABLE ACCESS BY INDEX ROWID OE_ORDER_LINES_ALL (cr=481328 pr=297829 pw=0 time=2234095908 us cost=15 size=27 card=1) 1232478 1232478 1232478 INDEX RANGE SCAN OE_ORDER_LINES_ALL_X14 (cr=38487 pr=9465 pw=0 time=126996456 us cost=3 size=0 card=29)(object id 13249355) 1232478 1232478 1232478 INDEX UNIQUE SCAN MTL_SYSTEM_ITEMS_B_U1 (cr=2458116 pr=11740 pw=0 time=175905615 us cost=1 size=0 card=1)(object id 38017) 499551 499551 499551 TABLE ACCESS BY INDEX ROWID MTL_SYSTEM_ITEMS_B (cr=1122544 pr=15540 pw=0 time=250018714 us cost=2 size=20 card=1) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=3 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=25 size=160 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=23 size=140 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=8 size=113 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=6 size=93 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID XXOM_VLVS_SERIALIZATION (cr=0 pr=0 pw=0 time=0 us cost=4 size=35 card=1) 0 0 0 INDEX RANGE SCAN XXOM_VLVS_SERIALIZATION_N3 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=1)(object id 10008262) 0 0 0 TABLE ACCESS BY INDEX ROWID OE_ORDER_LINES_ALL (cr=0 pr=0 pw=0 time=0 us cost=2 size=58 card=1) 0 0 0 INDEX UNIQUE SCAN OE_ORDER_LINES_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 42102) 0 0 0 TABLE ACCESS BY INDEX ROWID OE_ORDER_HEADERS_ALL (cr=0 pr=0 pw=0 time=0 us cost=2 size=20 card=1) 0 0 0 INDEX UNIQUE SCAN OE_ORDER_HEADERS_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 41952) 0 0 0 TABLE ACCESS BY INDEX ROWID OE_ORDER_LINES_ALL (cr=0 pr=0 pw=0 time=0 us cost=15 size=27 card=1) 0 0 0 INDEX RANGE SCAN OE_ORDER_LINES_ALL_X14 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=29)(object id 13249355) 0 0 0 INDEX UNIQUE SCAN MTL_SYSTEM_ITEMS_B_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 38017) 0 0 0 TABLE ACCESS BY INDEX ROWID MTL_SYSTEM_ITEMS_B (cr=0 pr=0 pw=0 time=0 us cost=2 size=20 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 48 0.00 0.00 db file sequential read 388838 0.47 3476.07 latch: cache buffers chains 1 0.00 0.00 ******************************************************************************** SQL ID: 74zqrynnr4yb6 Plan Hash: 0 BEGIN xxom_valvelink_vlvs_pkg.xxom_valvelink_prc(:errbuf,:rc,:A0,:A1); END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 429.62 443.77 4 4 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 429.62 443.77 4 4 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 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 3 0.00 0.00 direct path read 2 0.04 0.06 utl_file I/O 9025385 0.11 35.57 ******************************************************************************** SQL ID: c4wtbv2xcmq78 Plan Hash: 0 begin fnd_file_private.logfile_get(:s, :b); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1567 90.10 90.87 0 0 0 1567 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1568 90.10 90.87 0 0 0 1567 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1568 0.00 0.00 SQL*Net message from client 1568 0.02 1.38 utl_file I/O 2980063 0.00 6.23 SQL*Net more data to client 25047 0.00 0.50 ******************************************************************************** SQL ID: 924k0uck6anwh Plan Hash: 0 begin fnd_file_private.outfile_get(:s, :b); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 189 0.84 0.84 0 0 0 189 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 190 0.84 0.84 0 0 0 189 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 190 0.00 0.00 SQL*Net message from client 190 0.00 0.10 utl_file I/O 12168 0.00 0.25 SQL*Net more data to client 2994 0.00 0.06 ******************************************************************************** SQL ID: 193prv72cnbc6 Plan Hash: 1383971625 SELECT FLV.LOOKUP_CODE FROM FND_LOOKUP_VALUES FLV WHERE FLV.LOOKUP_TYPE = 'ITEM_TYPE' AND FLV.MEANING = 'EM DESCRIPTOR' AND NVL(FLV.START_DATE_ACTIVE, SYSDATE - 1) <= SYSDATE AND NVL(FLV.END_DATE_ACTIVE, SYSDATE + 1) >= SYSDATE AND FLV.ENABLED_FLAG = 'Y' AND LANGUAGE = USERENV('LANG') 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.02 0.67 47 49 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.67 47 49 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (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 FND_LOOKUP_VALUES (cr=49 pr=47 pw=0 time=673908 us cost=6 size=64 card=1) 258 258 258 INDEX RANGE SCAN XXAR_FND_LOOKUP_VALUES_N1 (cr=4 pr=3 pw=0 time=62858 us cost=3 size=0 card=13)(object id 1405422) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 6 0.00 0.00 db file sequential read 47 0.04 0.66 ******************************************************************************** SQL ID: 3ktacv9r56b51 Plan Hash: 458693102 select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(property,0),subname,type#,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order# 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 45 0.01 0.35 18 151 0 39 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 57 0.01 0.35 18 151 0 39 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT ORDER BY (cr=9 pr=4 pw=0 time=61908 us cost=17 size=316 card=4) 1 1 1 NESTED LOOPS OUTER (cr=9 pr=4 pw=0 time=61769 us cost=16 size=316 card=4) 1 1 1 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (cr=5 pr=4 pw=0 time=61667 us cost=4 size=132 card=4) 1 1 1 INDEX RANGE SCAN I_DEPENDENCY1 (cr=4 pr=3 pw=0 time=53333 us cost=3 size=0 card=4)(object id 116) 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=0 pw=0 time=84 us cost=3 size=46 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=3 pr=0 pw=0 time=61 us cost=2 size=0 card=1)(object id 26619161) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 6 0.00 0.00 db file sequential read 18 0.06 0.34 ******************************************************************************** SQL ID: 2q93zsrvbdw48 Plan Hash: 3286988581 select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 55 0.02 0.26 17 33 0 51 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 61 0.02 0.26 17 33 0 51 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 2 3 4 SORT GROUP BY (cr=6 pr=4 pw=0 time=59837 us cost=6 size=68 card=4) 2 3 4 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=6 pr=4 pw=0 time=59686 us cost=5 size=68 card=4) 2 3 4 INDEX RANGE SCAN I_OBJAUTH1 (cr=4 pr=2 pw=0 time=35669 us cost=3 size=0 card=4)(object id 100) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 17 0.03 0.25 ******************************************************************************** SQL ID: btr0bhgjk33jv Plan Hash: 4248856682 SELECT DIRECTORY_NAME FROM DBA_DIRECTORIES WHERE DIRECTORY_PATH = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.02 0.02 0 0 0 0 Fetch 2 0.02 0.18 46 104 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.04 0.20 46 104 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=52 pr=23 pw=0 time=92836 us cost=16 size=74 card=1) 1 1 1 NESTED LOOPS (cr=50 pr=23 pw=0 time=92794 us cost=15 size=70 card=1) 1 1 1 TABLE ACCESS FULL DIR$ (cr=46 pr=22 pw=0 time=86768 us cost=12 size=37 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=0 pw=0 time=6018 us cost=3 size=33 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=3 pr=0 pw=0 time=5948 us cost=2 size=0 card=1)(object id 26619161) 1 1 1 INDEX RANGE SCAN I_USER2 (cr=2 pr=0 pw=0 time=34 us cost=1 size=4 card=1)(object id 26619168) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.01 0.02 db file scattered read 8 0.03 0.15 ******************************************************************************** SQL ID: 8swypbbr0m372 Plan Hash: 872636971 select order#,columns,types from access$ where d_obj#=:1 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 35 0.00 0.17 9 77 0 29 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 47 0.00 0.17 9 77 0 29 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID ACCESS$ (cr=3 pr=2 pw=0 time=53164 us cost=5 size=360 card=8) 0 0 0 INDEX RANGE SCAN I_ACCESS1 (cr=3 pr=2 pw=0 time=53157 us cost=3 size=0 card=8)(object id 118) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 9 0.05 0.17 ******************************************************************************** SQL ID: 17rbp3s86rzza Plan Hash: 1884197401 update Fnd_Concurrent_Requests set Phase_Code=DECODE(phase_code,'C', phase_code,:b0),Status_Code=DECODE(phase_code,'C',DECODE(status_code,'C', DECODE(:b1,'W','W','C'),status_code),:b1),Completion_Text= DECODE(Completion_Text,null ,:b3,Completion_Text),Has_Sub_Request= DECODE(Has_Sub_Request,'Y','Y',:b4),Req_Information=:b5, Actual_Completion_Date=sysdate ,Requested_Start_Date=DECODE(:b6,'Y', TO_DATE(:b7,'YYYY/MM/DD HH24:MI:SS'),Requested_Start_Date),Resubmitted=:b6, Outcome_Product=:b9,Outcome_Code=null ,OFile_Size=decode(:b10,'-1',null , :b10),LFile_Size=decode(:b12,'-1',null ,:b12) where Request_Id=:b14 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.02 0.16 14 4 35 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.02 0.16 14 4 35 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE FND_CONCURRENT_REQUESTS (cr=12 pr=14 pw=0 time=165832 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=84 us cost=3 size=186 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=53 us cost=2 size=0 card=1)(object id 34547) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 14 0.01 0.15 Disk file operations I/O 5 0.00 0.00 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** 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 5 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 13 0.01 0.15 7 46 0 11 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 23 0.01 0.15 7 46 0 11 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) 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=78166 us cost=4 size=22 card=1) 1 1 1 INDEX RANGE SCAN I_IDL_UB11 (cr=4 pr=1 pw=0 time=59978 us cost=3 size=0 card=1)(object id 110) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 7 0.05 0.14 Disk file operations I/O 3 0.00 0.00 ******************************************************************************** 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 5 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 12 0.00 0.11 5 36 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 22 0.00 0.11 5 36 0 7 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) 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=49736 us cost=4 size=19 card=1) 2 2 2 INDEX RANGE SCAN I_IDL_SB41 (cr=5 pr=1 pw=0 time=20137 us cost=3 size=0 card=1)(object id 113) 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 5 0.02 0.11 ******************************************************************************** SQL ID: 1hz00txs5dyw2 Plan Hash: 2774165112 SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'CP_STATUS_CODE' AND LOOKUP_CODE = :code 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.10 5 5 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.10 5 5 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=5 pr=5 pw=0 time=107260 us cost=4 size=59 card=1) 2 2 2 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=3 pr=3 pw=0 time=74647 us cost=3 size=0 card=1)(object id 14622584) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 5 0.04 0.10 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 893s4vm787w7a Plan Hash: 2531403236 update FND_CONC_PROG_ONSITE_INFO set (LAST_RUN_DATE,LAST_RUN_REQUEST_ID, OUTCOME,SUCCESSFUL_COMPLETION,WARNING_COMPLETION,ERROR_COMPLETION, LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,MIN_RUN_TIME, MAX_RUN_TIME,AVG_RUN_TIME)=(select sysdate ,R.request_id ,STATUS_CODE , (NVL(SUCCESSFUL_COMPLETION,0)+DECODE(STATUS_CODE,'C',1,0)) , (NVL(WARNING_COMPLETION,0)+DECODE(STATUS_CODE,'G',1,0)) , (NVL(ERROR_COMPLETION,0)+DECODE(STATUS_CODE,'E',1,0)) ,sysdate ,:b0 ,:b0 , DECODE(STATUS_CODE,'C',LEAST(NVL(MIN_RUN_TIME, ((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)* 86400)), ((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)* 86400)),MIN_RUN_TIME) , DECODE(STATUS_CODE,'C',GREATEST(NVL(MAX_RUN_TIME, ((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)* 86400)), ((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)* 86400)),MAX_RUN_TIME) , DECODE(STATUS_CODE,'C',(((NVL(AVG_RUN_TIME,0)* NVL(SUCCESSFUL_COMPLETION,0)) +((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)* 86400)) /DECODE(NVL(AVG_RUN_TIME,0),0,1,(NVL(SUCCESSFUL_COMPLETION,0)+1))), AVG_RUN_TIME) from FND_CONCURRENT_REQUESTS R ,FND_CONC_PROG_ONSITE_INFO O where ((R.program_application_id=O.Program_Application_Id and R.Concurrent_Program_Id=O.concurrent_program_id) and R.request_id=:b2)) where (Program_Application_Id,Concurrent_Program_Id) in (select program_application_id ,concurrent_program_id from fnd_concurrent_requests where request_id=:b2) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.09 3 13 1 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.09 3 13 1 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE FND_CONC_PROG_ONSITE_INFO (cr=13 pr=3 pw=0 time=99265 us) 1 1 1 NESTED LOOPS (cr=6 pr=2 pw=0 time=71356 us cost=4 size=82 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=62 us cost=3 size=17 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=38 us cost=2 size=0 card=1)(object id 34547) 1 1 1 INDEX UNIQUE SCAN FND_CONC_PROG_ONSITE_INFO_U1 (cr=2 pr=2 pw=0 time=71286 us cost=0 size=952445 card=14653)(object id 194616) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=105 us cost=4 size=75 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=72 us cost=3 size=35 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=41 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONC_PROG_ONSITE_INFO (cr=3 pr=0 pw=0 time=22 us cost=1 size=586120 card=14653) 1 1 1 INDEX UNIQUE SCAN FND_CONC_PROG_ONSITE_INFO_U1 (cr=2 pr=0 pw=0 time=15 us cost=0 size=0 card=1)(object id 194616) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.04 0.09 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 96g93hntrzjtr Plan Hash: 841937906 select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 7 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.09 6 30 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 15 0.00 0.09 6 30 0 7 Misses in library cache during parse: 0 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=4 pr=2 pw=0 time=27272 us) 1 1 1 INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=3 pr=1 pw=0 time=12947 us)(object id 194) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 6 0.02 0.09 ******************************************************************************** SQL ID: gbd5g50k3q9dc Plan Hash: 246530440 SELECT ACTION_TYPE, DECODE(STATUS_S_FLAG, 'Y', 1, 0), DECODE(STATUS_W_FLAG, 'Y', 1, 0), DECODE(STATUS_F_FLAG, 'Y', 1, 0), PROGRAM_APPLICATION_ID, PROGRAM_ID, ARGUMENTS, NUMBER_OF_COPIES, SEQUENCE FROM FND_CONC_PP_ACTIONS WHERE CONCURRENT_REQUEST_ID= :reqid AND NVL(COMPLETED, 'N') = 'N' ORDER BY DECODE(ACTION_TYPE, 6, 0, ACTION_TYPE), SEQUENCE 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.09 4 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.09 4 4 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT ORDER BY (cr=4 pr=4 pw=0 time=95658 us cost=5 size=36 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONC_PP_ACTIONS (cr=4 pr=4 pw=0 time=95531 us cost=4 size=36 card=1) 1 1 1 INDEX RANGE SCAN FND_CONC_PP_ACTIONS_N1 (cr=3 pr=3 pw=0 time=68680 us cost=3 size=0 card=1)(object id 34250) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 4 0.05 0.09 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 3nkd3g3ju5ph1 Plan Hash: 853875749 select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 14 0.00 0.00 0 0 0 0 Fetch 14 0.00 0.08 5 56 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 30 0.00 0.08 5 56 0 14 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=0 pw=0 time=4744 us cost=4 size=86 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=4730 us cost=3 size=0 card=1)(object id 26619162) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 5 0.03 0.08 ******************************************************************************** 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 5 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.07 7 20 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10 0.00 0.07 7 20 0 5 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 COUNT STOPKEY (cr=4 pr=2 pw=0 time=37451 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_NEW_MESSAGES (cr=4 pr=2 pw=0 time=37442 us cost=3 size=36 card=1) 1 1 1 INDEX UNIQUE SCAN FND_NEW_MESSAGES_PK (cr=3 pr=1 pw=0 time=20096 us cost=2 size=0 card=1)(object id 33198) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 7 0.02 0.07 SQL*Net message to client 5 0.00 0.00 SQL*Net message from client 5 0.00 0.00 ******************************************************************************** SQL ID: 5n1fs4m2n2y0r Plan Hash: 992489688 select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 11 0.00 0.07 3 26 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.01 0.07 3 26 0 7 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID ICOL$ (cr=5 pr=1 pw=0 time=24294 us cost=4 size=58 card=2) 1 1 1 INDEX RANGE SCAN I_ICOL1 (cr=4 pr=1 pw=0 time=24263 us cost=3 size=0 card=2)(object id 37) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.03 0.07 ******************************************************************************** SQL ID: d0zc37r8b5gqh Plan Hash: 1502255019 select /*+ index(ncomp_dll$ i_ncomp_dll1) +*/ dll from ncomp_dll$ where obj#=:1 and version=:2 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.06 3 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.06 3 6 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID NCOMP_DLL$ (cr=3 pr=1 pw=0 time=34225 us cost=2 size=816 card=1) 1 1 1 INDEX UNIQUE SCAN I_NCOMP_DLL1 (cr=2 pr=0 pw=0 time=23 us cost=1 size=0 card=1)(object id 9226815) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.03 0.06 ******************************************************************************** SQL ID: 55dc767ajydh3 Plan Hash: 2802907561 SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 18 0.00 0.00 0 0 0 0 Fetch 18 0.00 0.06 4 55 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 37 0.00 0.06 4 55 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 2) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTION_VALUES (cr=3 pr=0 pw=0 time=40 us cost=4 size=33 card=1) 0 0 0 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1 (cr=3 pr=0 pw=0 time=36 us cost=3 size=0 card=1)(object id 1391365) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 4 0.02 0.06 Disk file operations I/O 1 0.00 0.00 ******************************************************************************** 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 5 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.06 4 21 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 17 0.00 0.06 4 21 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) 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=40162 us cost=4 size=21 card=1) 1 1 1 INDEX RANGE SCAN I_IDL_CHAR1 (cr=4 pr=1 pw=0 time=27954 us cost=3 size=0 card=1)(object id 111) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 4 0.02 0.06 ******************************************************************************** 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 5 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.05 4 25 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 17 0.00 0.05 4 25 0 4 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) 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=24975 us cost=4 size=21 card=1) 2 2 2 INDEX RANGE SCAN I_IDL_UB21 (cr=4 pr=1 pw=0 time=11201 us cost=3 size=0 card=1)(object id 112) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 4 0.02 0.05 Disk file operations I/O 1 0.00 0.00 ******************************************************************************** SQL ID: db78fxqxwxt7r Plan Hash: 2324581405 select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 13 0.00 0.00 0 0 0 0 Fetch 13 0.00 0.05 4 65 0 255 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 27 0.00 0.05 4 65 0 255 Misses in library cache during parse: 0 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 20 20 20 SORT ORDER BY (cr=5 pr=4 pw=0 time=55505 us cost=0 size=0 card=0) 20 20 20 TABLE ACCESS CLUSTER HISTGRM$ (cr=5 pr=4 pw=0 time=55380 us) 1 1 1 INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=2 pr=1 pw=0 time=25838 us)(object id 189) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 4 0.02 0.05 ******************************************************************************** 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 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.05 3 11 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.05 3 11 0 4 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) 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=55877 us cost=4 size=83 card=1) 4 4 4 INDEX RANGE SCAN DESCENDING I_ARGUMENT2 (cr=7 pr=2 pw=0 time=39259 us cost=3 size=0 card=1)(object id 765432) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.01 0.05 Disk file operations I/O 1 0.00 0.00 ******************************************************************************** SQL ID: 53saa2zkr6wc3 Plan Hash: 2631433895 select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=: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 0 0 0 Fetch 2 0.00 0.05 2 5 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.05 2 5 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID CCOL$ (cr=5 pr=2 pw=0 time=55291 us cost=4 size=18 card=1) 1 1 1 INDEX RANGE SCAN I_CCOL1 (cr=4 pr=2 pw=0 time=55270 us cost=3 size=0 card=1)(object id 51) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.03 0.05 ******************************************************************************** SQL ID: 2px9nkqfdvrtd Plan Hash: 3905985053 select Phase_Code ,Status_Code ,Completion_Text ,Phase.Lookup_Code , Status.Lookup_Code ,Phase.Meaning ,Status.Meaning into :b0,:b1,:b2,:b3,:b4, :b5,:b6 from Fnd_Lookups Phase ,Fnd_Lookups Status ,Fnd_Concurrent_programs P , Fnd_Concurrent_Requests R where (((((R.Request_Id=:b7 and (P.Concurrent_Program_Id=R.Concurrent_program_ID and P.Application_ID= R.Program_Application_ID)) and Phase.Lookup_Type=:b8) and Phase.Lookup_Code= Decode(Status.Lookup_Code,'H','I','S','I','U','I','M','I',R.Phase_Code)) and Status.Lookup_Type=:b9) and Status.Lookup_Code=Decode(R.Phase_Code,'P', Decode(R.Hold_Flag,'Y','H',Decode(P.Enabled_Flag,'N','U', Decode(Sign((R.Requested_Start_Date-sysdate )),1,'P',R.Status_Code))),'R', Decode(R.Hold_Flag,'Y','S',Decode(R.Status_Code,'Q','B','I','B', R.Status_Code)),R.Status_Code)) 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.05 2 17 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.05 2 17 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=17 pr=2 pw=0 time=54849 us) 2 2 2 NESTED LOOPS (cr=15 pr=1 pw=0 time=29866 us cost=10 size=182 card=1) 1 1 1 NESTED LOOPS (cr=12 pr=0 pw=0 time=322 us cost=7 size=123 card=1) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=55 us cost=4 size=64 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=20 us cost=3 size=52 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=14 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=26 us cost=1 size=175656 card=14638) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=17 us cost=0 size=0 card=1)(object id 33183) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=5 pr=0 pw=0 time=261 us cost=3 size=59 card=1) 2 2 2 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=3 pr=0 pw=0 time=56 us cost=2 size=0 card=1)(object id 14622584) 2 2 2 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=3 pr=1 pw=0 time=29514 us cost=2 size=0 card=1)(object id 14622584) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=2 pr=1 pw=0 time=24957 us cost=3 size=59 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.02 0.05 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 9tgj4g8y4rwy8 Plan Hash: 3632979230 select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts, NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0), NVL(scanhint,0),NVL(bitmapranges,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.04 3 20 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 0.00 0.04 3 20 0 5 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS CLUSTER SEG$ (cr=4 pr=0 pw=0 time=39 us cost=3 size=67 card=1) 1 1 1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=3 pr=0 pw=0 time=25 us cost=2 size=0 card=1)(object id 9) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.02 0.04 ******************************************************************************** SQL ID: 7qs7fx89194u1 Plan Hash: 1990737700 SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 58 0.00 0.00 0 0 0 0 Fetch 58 0.01 0.04 5 174 0 13 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 117 0.01 0.04 5 174 0 13 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 2) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 1 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_X99 (cr=3 pr=0 pw=0 time=31 us cost=3 size=29 card=1)(object id 13748041) 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 5 0.01 0.04 ******************************************************************************** SQL ID: b1wc53ddd6h3p Plan Hash: 2848975084 select audit$,options from procedure$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.04 4 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.04 4 9 0 3 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID PROCEDURE$ (cr=3 pr=2 pw=0 time=45918 us cost=2 size=48 card=1) 1 1 1 INDEX UNIQUE SCAN I_PROCEDURE1 (cr=2 pr=1 pw=0 time=19143 us cost=1 size=0 card=1)(object id 107) 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 4 0.02 0.04 ******************************************************************************** SQL ID: 3c9wuu2pxxr2f Plan Hash: 0 INSERT INTO FND_CONC_PP_ACTIONS (CONCURRENT_REQUEST_ID, ACTION_TYPE, STATUS_S_FLAG, STATUS_W_FLAG, STATUS_F_FLAG, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, CREATED_BY, ARGUMENTS, COMPLETED, NUMBER_OF_COPIES, SEQUENCE,OPS_INSTANCE) VALUES (:B8 , 1, 'Y', :B7 , 'N', SYSDATE, :B5 , SYSDATE, :B6 , :B5 , :B4 , 'N', :B3 , :B2 , :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.04 2 1 8 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.04 2 1 8 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=2 pw=0 time=46327 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.02 0.04 ******************************************************************************** SQL ID: 2qa192hnrrk40 Plan Hash: 0 begin fnd_file_private.close; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.02 0.04 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.02 0.04 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ utl_file I/O 12 0.03 0.04 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 67n5u0a0q4d7u Plan Hash: 1507419447 select audit$, os_path from dir$ 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.04 3 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.04 3 6 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID DIR$ (cr=3 pr=2 pw=0 time=20824 us cost=2 size=75 card=1) 1 1 1 INDEX UNIQUE SCAN I_DIR1 (cr=2 pr=1 pw=0 time=14332 us cost=1 size=0 card=1)(object id 114) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.01 0.04 ******************************************************************************** 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 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.04 3 5 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.04 3 5 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID PROCEDUREINFO$ (cr=5 pr=3 pw=0 time=40154 us cost=5 size=204 card=6) 1 1 1 INDEX RANGE SCAN DESCENDING I_PROCEDUREINFO1 (cr=4 pr=2 pw=0 time=21823 us cost=3 size=0 card=6)(object id 765431) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.01 0.03 ******************************************************************************** SQL ID: f946p6b0qhh5t Plan Hash: 789926538 SELECT /*+ INDEX(sqlobj$ (signature category obj_type plan_id)) */ DISTINCT category FROM sqlobj$ WHERE signature = :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 0 0 0 Fetch 2 0.00 0.02 2 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.02 2 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT UNIQUE NOSORT (cr=2 pr=2 pw=0 time=27634 us cost=3 size=20 card=1) 1 1 1 INDEX RANGE SCAN SQLOBJ$_PKEY (cr=2 pr=2 pw=0 time=27617 us cost=2 size=20 card=1)(object id 26593328) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.02 0.02 ******************************************************************************** SQL ID: 7ng34ruy5awxq Plan Hash: 3984801583 select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property, i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey, i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#, nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256), i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null, null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer,1))) deferrable#,min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj# 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.02 2 11 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.02 2 11 0 4 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 4 4 4 SORT ORDER BY (cr=11 pr=2 pw=0 time=27023 us cost=10 size=390 card=2) 4 4 4 HASH JOIN OUTER (cr=11 pr=2 pw=0 time=26716 us cost=9 size=390 card=2) 4 4 4 NESTED LOOPS OUTER (cr=7 pr=0 pw=0 time=62 us cost=4 size=304 card=2) 4 4 4 TABLE ACCESS CLUSTER IND$ (cr=6 pr=0 pw=0 time=40 us cost=4 size=200 card=2) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=13 us cost=2 size=0 card=1)(object id 3) 0 0 0 TABLE ACCESS BY INDEX ROWID IND_STATS$ (cr=1 pr=0 pw=0 time=14 us cost=0 size=52 card=1) 0 0 0 INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=1 pr=0 pw=0 time=8 us cost=0 size=0 card=1)(object id 9228134) 0 0 0 VIEW (cr=4 pr=2 pw=0 time=22243 us cost=4 size=43 card=1) 0 0 0 SORT GROUP BY (cr=4 pr=2 pw=0 time=22239 us cost=4 size=16 card=1) 0 0 0 TABLE ACCESS CLUSTER CDEF$ (cr=4 pr=2 pw=0 time=22152 us cost=3 size=16 card=1) 1 1 1 INDEX UNIQUE SCAN I_COBJ# (cr=3 pr=1 pw=0 time=7999 us cost=2 size=0 card=1)(object id 27) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.01 0.02 ******************************************************************************** SQL ID: 9gdxsmyzbrdkr Plan Hash: 1883182706 SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG, APP_ENABLED_FLAG, RESP_ENABLED_FLAG, USER_ENABLED_FLAG, ORG_ENABLED_FLAG, SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 24 0.00 0.00 0 0 0 0 Fetch 24 0.00 0.02 3 48 0 22 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 49 0.00 0.02 3 48 0 22 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 2) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 INDEX RANGE SCAN FND_PROFILE_OPTIONS_X99 (cr=2 pr=0 pw=0 time=71 us cost=1 size=69 card=1)(object id 14622582) 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 3 0.02 0.02 ******************************************************************************** SQL ID: f711myt0q6cma Plan Hash: 0 insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid, userhost,terminal,action#,returncode, logoff$lread,logoff$pread, logoff$lwrite,logoff$dead, logoff$time,comment$text,spare1,clientid, sessioncpu,proxy$sid,user$guid, instance#,process#,auditid,dbid) values (:1,:2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date),:13,:14,:15,:16,:17, :18, :19,:20,:21,:22) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.02 3 1 10 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.02 3 1 10 1 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 ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=3 pw=0 time=26005 us) 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 3 0.02 0.02 ******************************************************************************** SQL ID: afmkwyhjj2ygy Plan Hash: 3085211511 SELECT R.PRINT_STYLE, U.USER_NAME, R.REQUEST_ID, R.OUTFILE_NAME, R.OUTFILE_NODE_NAME, R.PRINT_GROUP, R.PRIORITY_REQUEST_ID, R.REQUESTED_BY, R.RESPONSIBILITY_APPLICATION_ID, R.RESPONSIBILITY_ID, R.SECURITY_GROUP_ID, R.CONC_LOGIN_ID, R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID, R.NUMBER_OF_COPIES, P.PRINT_FLAG, R.SAVE_OUTPUT_FLAG, R.ARGUMENT1, P.CONCURRENT_PROGRAM_NAME FROM FND_CONCURRENT_REQUESTS R, FND_USER U, FND_CONCURRENT_PROGRAMS P WHERE R.REQUEST_ID = :reqid AND R.REQUESTED_BY = U.USER_ID AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID AND R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID 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.02 2 10 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.02 2 10 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=10 pr=2 pw=0 time=24338 us cost=5 size=190 card=1) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=48 us cost=4 size=170 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=21 us cost=3 size=143 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=11 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=24 us cost=1 size=395226 card=14638) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=14 us cost=0 size=0 card=1)(object id 33183) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_USER (cr=3 pr=2 pw=0 time=24274 us cost=1 size=852600 card=42630) 1 1 1 INDEX UNIQUE SCAN FND_USER_U1 (cr=2 pr=1 pw=0 time=19594 us cost=0 size=0 card=1)(object id 33427) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.01 0.02 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 6aq34nj2zb2n7 Plan Hash: 3286988581 select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.02 1 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.02 1 6 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 SORT GROUP BY (cr=3 pr=1 pw=0 time=20499 us cost=5 size=17 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=3 pr=1 pw=0 time=20376 us cost=4 size=17 card=1) 0 0 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=3 pr=1 pw=0 time=20370 us cost=3 size=0 card=1)(object id 100) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.02 0.02 ******************************************************************************** SQL ID: 69subccxd9b03 Plan Hash: 2462372880 SELECT signature, inuse_features, flags FROM sql$ WHERE signature = :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 0 0 0 Fetch 1 0.00 0.02 2 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.02 2 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID SQL$ (cr=2 pr=2 pw=0 time=20131 us cost=1 size=18 card=1) 1 1 1 INDEX UNIQUE SCAN I_SQL$_PKEY (cr=1 pr=1 pw=0 time=7549 us cost=0 size=0 card=1)(object id 26597299) 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 2 0.01 0.01 ******************************************************************************** SQL ID: gth4651h7jn4t Plan Hash: 1546270724 SELECT XXFND_FTP_PATH_LKP('outfile', :B1 ) FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.02 0.01 0 0 0 0 Fetch 1 0.01 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.03 0.01 0 0 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) 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=7 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: 2xgubd6ayhyb1 Plan Hash: 3071105960 select max(procedure#) from procedureplsql$ 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 0 0 0 Fetch 1 0.00 0.01 1 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 1 3 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) 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=18114 us) 0 0 0 FIRST ROW (cr=3 pr=1 pw=0 time=18105 us cost=3 size=10 card=1) 0 0 0 INDEX RANGE SCAN (MIN/MAX) I_PROCEDUREPLSQL$ (cr=3 pr=1 pw=0 time=18102 us cost=3 size=10 card=1)(object id 9226819) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.01 0.01 ******************************************************************************** SQL ID: g3wrkmxkxzhf2 Plan Hash: 1439190645 select cols,audit$,textlength,intcols,property,flags,rowid from view$ 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 0 0 0 Fetch 1 0.00 0.01 2 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 2 4 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID VIEW$ (cr=4 pr=2 pw=0 time=17240 us cost=3 size=59 card=1) 1 1 1 INDEX UNIQUE SCAN I_VIEW1 (cr=3 pr=1 pw=0 time=2169 us cost=2 size=0 card=1)(object id 96) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.01 0.01 ******************************************************************************** SQL ID: 83taa7kaw59c1 Plan Hash: 2783779297 select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2, nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182, scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$, rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2, nvl(spare3,0) from col$ where obj#=:1 order by intcol# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 33 0.00 0.01 1 10 0 31 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 36 0.00 0.01 1 10 0 31 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 3 3 3 SORT ORDER BY (cr=4 pr=1 pw=0 time=16120 us cost=5 size=2992 card=44) 3 3 3 TABLE ACCESS CLUSTER COL$ (cr=4 pr=1 pw=0 time=15939 us cost=4 size=2992 card=44) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=39 us cost=2 size=0 card=1)(object id 3) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.01 0.01 ******************************************************************************** SQL ID: 2n11d838tu3s2 Plan Hash: 1567616234 select transaction_context_id into :b0 from fnd_log_transaction_context where (transaction_type='REQUEST' and transaction_id=:b1) 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.01 2 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 2 2 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID FND_LOG_TRANSACTION_CONTEXT (cr=2 pr=2 pw=0 time=14862 us cost=2 size=21 card=1) 0 0 0 INDEX RANGE SCAN FND_LOG_TRANSACTION_CONTEXT_N2 (cr=2 pr=2 pw=0 time=14853 us cost=1 size=0 card=1)(object id 302509) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.01 0.01 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: d1fv0kpyztkkz Plan Hash: 1133168885 select To_Char(To_Date(Decode(Resubmit_Time,null ,'00:00:00',Resubmit_Time), 'HH24:MI:SS')) into :b0 from Fnd_Concurrent_Requests where Request_ID=:b1 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.01 1 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 1 4 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=1 pw=0 time=10302 us cost=3 size=13 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=1 pw=0 time=10289 us cost=2 size=0 card=1)(object id 34547) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.01 0.01 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 2zs1n9770s6g1 Plan Hash: 3456220322 INSERT INTO FND_CONCURRENT_REQUESTS ( REQUEST_ID, SECURITY_GROUP_ID, PHASE_CODE, STATUS_CODE, PRIORITY, PARENT_REQUEST_ID, PRIORITY_REQUEST_ID, DESCRIPTION, REQ_INFORMATION, IS_SUB_REQUEST, HAS_SUB_REQUEST, UPDATE_PROTECTED, HOLD_FLAG, ENFORCE_SERIALITY_FLAG, SINGLE_THREAD_FLAG, ARGUMENT_INPUT_METHOD_CODE, IMPLICIT_CODE, REQUEST_DATE, REQUESTED_START_DATE, REQUESTED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ORACLE_ID, CONC_LOGIN_ID, RESPONSIBILITY_ID, RESPONSIBILITY_APPLICATION_ID, NLS_LANGUAGE, NLS_TERRITORY, NLS_NUMERIC_CHARACTERS, PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID, QUEUE_METHOD_CODE, REQUEST_CLASS_APPLICATION_ID, CONCURRENT_REQUEST_CLASS_ID, PRINT_GROUP, PRINTER, PRINT_STYLE, NUMBER_OF_COPIES, SAVE_OUTPUT_FLAG, CRM_THRSHLD, RESUBMIT_TIME, RESUBMIT_INTERVAL, RESUBMIT_INTERVAL_UNIT_CODE, RESUBMIT_INTERVAL_TYPE_CODE, RESUBMIT_END_DATE, RESUBMITTED, CRITICAL, REQUEST_TYPE, RELEASE_CLASS_APP_ID, RELEASE_CLASS_ID, STALE_DATE, CANCEL_OR_HOLD, OUTPUT_FILE_TYPE, NLS_COMPLIANT, CD_ID, REQUEST_LIMIT, INCREMENT_DATES, ENABLE_TRACE, OPS_INSTANCE, ARGUMENT_TEXT, NUMBER_OF_ARGUMENTS, ARGUMENT1, ARGUMENT2, ARGUMENT3, ARGUMENT4, ARGUMENT5, ARGUMENT6, ARGUMENT7, ARGUMENT8, ARGUMENT9, ARGUMENT10, ARGUMENT11, ARGUMENT12, ARGUMENT13, ARGUMENT14, ARGUMENT15, ARGUMENT16, ARGUMENT17, ARGUMENT18, ARGUMENT19, ARGUMENT20, ARGUMENT21, ARGUMENT22, ARGUMENT23, ARGUMENT24, ARGUMENT25) SELECT :B73 , :B72 , :B71 , DECODE (:B70 , 'A', 'A', 'Z', 'Z', DECODE(FCP.QUEUE_METHOD_CODE, 'B', 'Q', DECODE (:B52 , 'Y', 'Q', DECODE(:B33 , 'Y', 'Q', 'I')))), DECODE (FCP.QUEUE_CONTROL_FLAG, 'Y', NVL(FCP.REQUEST_PRIORITY, 0), DECODE (:B69 , NULL, 50, :B69 )), DECODE (:B61 , 0, NULL, :B61 ), :B68 , :B67 , NULL, :B66 , 'N', :B65 , :B64 , 'Y', :B52 , 'S', :B63 , SYSDATE, DECODE (:B62 , '', (SYSDATE - :B60 ), GREATEST (:B62 , DECODE (:B61 , 0, (SYSDATE - :B60 ), FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001')))), :B59 , SYSDATE, :B59 , :B58 , ORACLE_ID, :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , FA.APPLICATION_ID, FCP.CONCURRENT_PROGRAM_ID, DECODE(:B33 , 'Y', 'B', DECODE(:B52 , 'N', FCP.QUEUE_METHOD_CODE, 'B')), FCP.CLASS_APPLICATION_ID, FCP.CONCURRENT_CLASS_ID, :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , DECODE (:B45 , '', NULL, TO_CHAR (FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001' || :B45 ), 'HH24:MI:SS')), DECODE (:B44 , '', NULL, :B44 ), :B43 , :B42 , :B41 , 'N', :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , FCP.OUTPUT_FILE_TYPE, FCP.NLS_COMPLIANT, :B34 , :B33 , :B32 , FCP.ENABLE_TRACE, :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 FROM FND_APPLICATION FA, FND_CONCURRENT_PROGRAMS FCP, FND_ORACLE_USERID WHERE ORACLE_USERNAME = :B3 AND FCP.ENABLED_FLAG = 'Y' AND (FCP.APPLICATION_ID = FA.APPLICATION_ID AND CONCURRENT_PROGRAM_NAME = UPPER (:B2 )) AND FA.APPLICATION_SHORT_NAME = UPPER (:B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.01 0 7 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.01 0 7 0 0 Misses in library cache during parse: 0 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=7 pr=0 pw=0 time=79 us) 0 0 0 NESTED LOOPS (cr=7 pr=0 pw=0 time=65 us cost=3 size=66 card=1) 1 1 1 NESTED LOOPS (cr=4 pr=0 pw=0 time=41 us cost=2 size=20 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_ORACLE_USERID (cr=2 pr=0 pw=0 time=20 us cost=1 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN FND_ORACLE_USERID_U2 (cr=1 pr=0 pw=0 time=15 us cost=0 size=0 card=1)(object id 22604) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_APPLICATION (cr=2 pr=0 pw=0 time=18 us cost=1 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN FND_APPLICATION_U3 (cr=1 pr=0 pw=0 time=10 us cost=0 size=0 card=1)(object id 32806) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=24 us cost=1 size=46 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U2 (cr=2 pr=0 pw=0 time=16 us cost=0 size=0 card=1)(object id 33186) ******************************************************************************** SQL ID: bd8t3zuwtaqx2 Plan Hash: 1383971625 SELECT FLV.LOOKUP_CODE FROM FND_LOOKUP_VALUES FLV WHERE FLV.LOOKUP_TYPE = 'ITEM_TYPE' AND FLV.MEANING = 'EM MODULE' AND NVL(FLV.START_DATE_ACTIVE, SYSDATE - 1) <= SYSDATE AND NVL(FLV.END_DATE_ACTIVE, SYSDATE + 1) >= SYSDATE AND FLV.ENABLED_FLAG = 'Y' AND LANGUAGE = USERENV('LANG') 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 49 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 49 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (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 FND_LOOKUP_VALUES (cr=49 pr=0 pw=0 time=1267 us cost=6 size=64 card=1) 258 258 258 INDEX RANGE SCAN XXAR_FND_LOOKUP_VALUES_N1 (cr=4 pr=0 pw=0 time=338 us cost=3 size=0 card=13)(object id 1405422) ******************************************************************************** SQL ID: 645duukfuwc50 Plan Hash: 1546270724 SELECT XXFND_FTP_PATH_LKP('archive', :B1 ) 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.00 0 0 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) 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=2 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: f728g0x48xn2f Plan Hash: 2385124469 SELECT A.APPLICATION_ID, CONCURRENT_PROGRAM_ID, CD_PARAMETER, PRINTER_NAME, NVL(OUTPUT_PRINT_STYLE, 'PORTRAIT'), REQUIRED_STYLE, MINIMUM_WIDTH, MINIMUM_LENGTH, EXECUTION_METHOD_CODE, SAVE_OUTPUT_FLAG, PRINT_FLAG, QUEUE_CONTROL_FLAG, REQUEST_PRIORITY, REQUEST_SET_FLAG, DECODE(:B4 , 'EXPLICIT', NVL(:B3 ,NVL(P.INSTANCE_ID,FND_CONC_GLOBAL.OPS_INST_NUM)), -1), NVL(REFRESH_PORTLET, 'N'), NVL(ALLOW_MULTIPLE_PENDING_REQUEST,'Y') FROM FND_CONCURRENT_PROGRAMS P, FND_APPLICATION A WHERE UPPER(CONCURRENT_PROGRAM_NAME) = UPPER(:B2 ) AND P.APPLICATION_ID = A.APPLICATION_ID AND UPPER(A.APPLICATION_SHORT_NAME) = UPPER(:B1 ) 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 16 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 16 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=16 pr=0 pw=0 time=3952 us) 1 1 1 NESTED LOOPS (cr=15 pr=0 pw=0 time=3934 us cost=8 size=316 card=4) 1 1 1 VIEW index$_join$_002 (cr=12 pr=0 pw=0 time=3832 us cost=3 size=30 card=3) 1 1 1 HASH JOIN (cr=12 pr=0 pw=0 time=3826 us) 317 317 317 INDEX FAST FULL SCAN FND_APPLICATION_U1 (cr=6 pr=0 pw=0 time=142 us cost=1 size=30 card=3)(object id 32802) 1 1 1 INDEX FAST FULL SCAN FND_APPLICATION_U3 (cr=6 pr=0 pw=0 time=133 us cost=1 size=30 card=3)(object id 32806) 1 1 1 INDEX RANGE SCAN FND_CONCURRENT_PROGRAMS_U2 (cr=3 pr=0 pw=0 time=97 us cost=1 size=0 card=1)(object id 33186) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=1 pr=0 pw=0 time=11 us cost=2 size=69 card=1) ******************************************************************************** SQL ID: 74h24psnnu7wk Plan Hash: 3053170185 SELECT LOWER(INSTANCE_NAME) INSTANCE_NAME FROM V$INSTANCE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 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 0 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 0 0 2 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=60 us) 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=34 us) 1 1 1 FIXED TABLE FULL X$QUIESCE (cr=0 pr=0 pw=0 time=16 us) 1 1 1 FIXED TABLE FULL X$KVIT (cr=0 pr=0 pw=0 time=15 us) 1 1 1 FIXED TABLE FULL X$KSUXSINST (cr=0 pr=0 pw=0 time=19 us) ******************************************************************************** SQL ID: 6vy6k7qmf9avj Plan Hash: 3794564613 SELECT ORGANIZATION_CODE FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = :B1 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: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (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 MTL_PARAMETERS (cr=2 pr=0 pw=0 time=65 us cost=1 size=8 card=1) 1 1 1 INDEX UNIQUE SCAN MTL_PARAMETERS_U1 (cr=1 pr=0 pw=0 time=36 us cost=0 size=0 card=1)(object id 37657) ******************************************************************************** SQL ID: 4y01xvq9jxrg4 Plan Hash: 0 DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN UPDATE FND_CONC_PP_ACTIONS SET COMPLETED = 'Y' WHERE CONCURRENT_REQUEST_ID= :reqid AND SEQUENCE = :seq; COMMIT; END; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 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 log file sync 1 0.00 0.00 ******************************************************************************** SQL ID: fxr5kcfdxsjcj Plan Hash: 1473858840 UPDATE APPWORX_OA_REQUESTS SET REQUEST_ID =REQUEST_ID WHERE REQUEST_ID = :B1 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 8 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 8 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE APPWORX_OA_REQUESTS (cr=8 pr=0 pw=0 time=212 us) 0 0 0 TABLE ACCESS FULL APPWORX_OA_REQUESTS (cr=8 pr=0 pw=0 time=209 us cost=6 size=7 card=1) ******************************************************************************** SQL ID: fh7xtfp2uknqx Plan Hash: 0 begin fnd_file_private.open (:l, :o); end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 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 utl_file I/O 8 0.00 0.00 ******************************************************************************** SQL ID: 2bg73wmjuzhgz Plan Hash: 0 begin fnd_conc_stat.store_initial; end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 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: fmpbxcbz6q0a1 Plan Hash: 2488038508 UPDATE FND_CONCURRENT_PROCESSES SET PROCESS_STATUS_CODE = 'C', LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = :mgrusrid, LAST_TXN_START = SYSDATE, LAST_TXN_END = NULL WHERE CONCURRENT_PROCESS_ID = :cpid 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 2 14 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 14 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE FND_CONCURRENT_PROCESSES (cr=2 pr=0 pw=0 time=624 us) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROCESSES_U1 (cr=2 pr=0 pw=0 time=58 us cost=1 size=40 card=1)(object id 33070) 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: g90k5xtu46wmp Plan Hash: 0 begin fnd_file.close; end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ utl_file I/O 2 0.00 0.00 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: dsfhqj1u06df6 Plan Hash: 2514398774 SELECT NULL FROM FND_CONCURRENT_PROGRAMS WHERE APPLICATION_ID = :B2 AND UPPER (CONCURRENT_PROGRAM_NAME) = UPPER (:B1 ) AND ENABLED_FLAG = 'Y' 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: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=4 pr=0 pw=0 time=89 us cost=3 size=22 card=1) 1 1 1 INDEX RANGE SCAN FND_CONCURRENT_PROGRAMS_U2 (cr=3 pr=0 pw=0 time=81 us cost=2 size=0 card=1)(object id 33186) ******************************************************************************** SQL ID: 2xvvm81avq7q1 Plan Hash: 0 alter session set events='10046 trace name context forever, level 8' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: a3pqbc9cxyfub Plan Hash: 1546270724 select FND_CONC_PRIVATE_UTILS.get_resub_time(:b0) into :b1:b2 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.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 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=4 us cost=2 size=0 card=1) 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: 88maya168wkas Plan Hash: 1884197401 update fnd_concurrent_requests set ofile_size=decode(:b0,'-1',null ,:b0) where request_id=:b2 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 4 2 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 4 2 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=460 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=30 us cost=3 size=32 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=24 us cost=2 size=0 card=1)(object id 34547) 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: grwydz59pu6mc Plan Hash: 1028580536 select text from view$ where rowid=:1 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 6 0.00 0.00 0 12 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 12 0 6 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 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=16 us cost=1 size=15 card=1) ******************************************************************************** SQL ID: bxb110jg78d8h Plan Hash: 0 begin FND_LOG_REPOSITORY.METRICS_EVENT_INT_WITH_CONTEXT; end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 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: 8ggw94h7mvxd7 Plan Hash: 0 COMMIT 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 2 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 2 0 Misses in library cache during parse: 0 Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: 9w6s483fdm8tg Plan Hash: 0 declare b boolean; begin b := fnd_debug.disable_db_rules; if (b) then :eget := 1; else :eget := 0; end if; end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 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: 1gu8t96d0bdmu Plan Hash: 17605035 select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols, nvl(t.clucols,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans, t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln, t.analyzetime,t.samplesize,t.cols,t.property,nvl(t.degree,1), nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag, 0), nvl(t.spare1,0),nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+) 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 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 7 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 MERGE JOIN OUTER (cr=7 pr=0 pw=0 time=215 us cost=5 size=182 card=1) 1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=5 pr=0 pw=0 time=87 us cost=4 size=143 card=1) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=49 us cost=2 size=0 card=1)(object id 3) 0 0 0 BUFFER SORT (cr=2 pr=0 pw=0 time=114 us cost=1 size=39 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID TAB_STATS$ (cr=2 pr=0 pw=0 time=41 us cost=1 size=39 card=1) 0 0 0 INDEX UNIQUE SCAN I_TAB_STATS$_OBJ# (cr=2 pr=0 pw=0 time=38 us cost=0 size=0 card=1)(object id 9228132) ******************************************************************************** SQL ID: g8q9bvv51p2zr Plan Hash: 970439650 UPDATE FND_CONC_PP_ACTIONS SET COMPLETED = 'Y' WHERE CONCURRENT_REQUEST_ID= :B2 AND SEQUENCE = :B1 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 3 3 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 3 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE FND_CONC_PP_ACTIONS (cr=3 pr=0 pw=0 time=373 us) 1 1 1 INDEX RANGE SCAN FND_CONC_PP_ACTIONS_N1 (cr=3 pr=0 pw=0 time=127 us cost=3 size=12 card=1)(object id 34250) ******************************************************************************** SQL ID: 3w4qs0tbpmxr6 Plan Hash: 3924106966 select con#,obj#,rcon#,enabled,nvl(defer,0),spare2,spare3 from cdef$ where robj#=: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 0 0 0 Fetch 1 0.00 0.00 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID CDEF$ (cr=2 pr=0 pw=0 time=40 us cost=2 size=112 card=4) 0 0 0 INDEX RANGE SCAN I_CDEF3 (cr=2 pr=0 pw=0 time=37 us cost=1 size=0 card=1)(object id 49) ******************************************************************************** SQL ID: 834xg0b9c6r6z Plan Hash: 0 begin fnd_conc_stat.store_final; end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 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: 2tyrw6s0jvap7 Plan Hash: 1934133821 select nvl(CP.DELETE_LOG_FILE,'N') ,CR.LOGFILE_NAME ,STATUS_CODE ,PHASE_CODE into :b0,:b1,:b2,:b3 from FND_CONCURRENT_REQUESTS CR ,FND_CONCURRENT_PROGRAMS CP where ((CR.REQUEST_ID= :b4 and CR.CONCURRENT_PROGRAM_ID=CP.CONCURRENT_PROGRAM_ID) and CR.PROGRAM_APPLICATION_ID=CP.APPLICATION_ID) 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 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 7 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=142 us cost=4 size=92 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=82 us cost=3 size=80 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=40 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=48 us cost=1 size=175656 card=14638) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=36 us cost=0 size=0 card=1)(object id 33183) 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.02 0.02 ******************************************************************************** SQL ID: 1mjd9xp80vuqa Plan Hash: 2984635380 select node,owner,name from syn$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 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 8 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 8 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID SYN$ (cr=4 pr=0 pw=0 time=64 us cost=3 size=34 card=1) 1 1 1 INDEX UNIQUE SCAN I_SYN1 (cr=3 pr=0 pw=0 time=45 us cost=2 size=0 card=1)(object id 98) ******************************************************************************** SQL ID: 87gaftwrm2h68 Plan Hash: 2863542513 select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname from obj$ o where o.obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 16 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 16 0 4 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=0 pw=0 time=36 us cost=4 size=42 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=3 pr=0 pw=0 time=26 us cost=3 size=0 card=1)(object id 26619161) ******************************************************************************** SQL ID: 47y3mqvyhpkvs Plan Hash: 2043798786 SELECT obj_type, plan_id, name, flags, last_executed FROM sqlobj$ WHERE signature = :1 AND category = :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 2 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 INDEX RANGE SCAN SQLOBJ$_PKEY (cr=3 pr=0 pw=0 time=58 us cost=2 size=65 card=1)(object id 26593328) ******************************************************************************** SQL ID: 7nuw4xwrnuwxq Plan Hash: 2149108588 select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID COLTYPE$ (cr=2 pr=0 pw=0 time=49 us cost=3 size=192 card=4) 0 0 0 INDEX RANGE SCAN DESCENDING I_COLTYPE2 (cr=2 pr=0 pw=0 time=42 us cost=2 size=0 card=4)(object id 243) ******************************************************************************** SQL ID: 8wutkrpf8j81q Plan Hash: 3701884280 select max(procedure#) from procedurec$ 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 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: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=2 pr=0 pw=0 time=60 us) 0 0 0 FIRST ROW (cr=2 pr=0 pw=0 time=40 us cost=2 size=10 card=1) 0 0 0 INDEX RANGE SCAN (MIN/MAX) I_PROCEDUREC$ (cr=2 pr=0 pw=0 time=35 us cost=2 size=10 card=1)(object id 765434) ******************************************************************************** SQL ID: 2pc7ccuj1qq7h Plan Hash: 4290205421 select Has_Sub_Request ,Status_Code ,Outfile_Name ,Logfile_name into :b0,:b1, :b2,:b3 from Fnd_Concurrent_Requests where Request_ID=:b4 for update of Status_Code 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 4 3 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 3 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FOR UPDATE (cr=4 pr=0 pw=0 time=197 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=65 us cost=3 size=129 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=47 us cost=2 size=0 card=1)(object id 34547) 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: 47r1y8yn34jmj Plan Hash: 3213098354 select default$ from col$ where rowid=:1 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 6 0.00 0.00 0 12 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 12 0 6 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID COL$ (cr=1 pr=0 pw=0 time=15 us cost=1 size=15 card=1) ******************************************************************************** SQL ID: gx4mv66pvj3xz Plan Hash: 3886069984 select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0), rowid,cols,nvl(defer,0),mtime,nvl(spare1,0),spare2,spare3 from cdef$ 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 0 0 0 Fetch 2 0.00 0.00 0 5 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 5 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS CLUSTER CDEF$ (cr=5 pr=0 pw=0 time=77 us cost=3 size=300 card=6) 1 1 1 INDEX UNIQUE SCAN I_COBJ# (cr=3 pr=0 pw=0 time=45 us cost=2 size=0 card=1)(object id 27) ******************************************************************************** SQL ID: 95w5r9gccgbpd Plan Hash: 3491039489 SELECT FND_CONCURRENT_REQUESTS_S.NEXTVAL FROM SYS.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.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SEQUENCE FND_CONCURRENT_REQUESTS_S (cr=0 pr=0 pw=0 time=72 us) 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=4 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: 5km6gkvuh3n43 Plan Hash: 4232941284 select max(procedure#) from procedurejava$ 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 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: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=2 pr=0 pw=0 time=40 us) 0 0 0 FIRST ROW (cr=2 pr=0 pw=0 time=24 us cost=2 size=10 card=1) 0 0 0 INDEX RANGE SCAN (MIN/MAX) I_PROCEDUREJAVA$ (cr=2 pr=0 pw=0 time=23 us cost=2 size=10 card=1)(object id 765436) ******************************************************************************** SQL ID: 4bva0zun7asy4 Plan Hash: 0 ROLLBACK TO START_OF_SUBMISSION 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 6 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 6 0 Misses in library cache during parse: 0 Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: 90kv3kupxjg3a Plan Hash: 0 lock table FND_CONCURRENT_REQUESTS in share update mode 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: 0 Optimizer mode: CHOOSE Parsing user id: 173 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: 8kywbuyrsrs61 Plan Hash: 316359079 SELECT O.ORACLE_USERNAME FROM FND_DATA_GROUP_UNITS U, FND_RESPONSIBILITY R, FND_ORACLE_USERID O WHERE R.APPLICATION_ID = :B3 AND R.RESPONSIBILITY_ID = :B2 AND R.DATA_GROUP_ID = U.DATA_GROUP_ID AND O.ORACLE_ID = U.ORACLE_ID AND U.APPLICATION_ID = :B1 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 8 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 8 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=8 pr=0 pw=0 time=87 us cost=4 size=36 card=1) 1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=63 us cost=3 size=26 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY (cr=3 pr=0 pw=0 time=31 us cost=2 size=13 card=1) 1 1 1 INDEX UNIQUE SCAN FND_RESPONSIBILITY_U1 (cr=2 pr=0 pw=0 time=20 us cost=1 size=0 card=1)(object id 33329) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_DATA_GROUP_UNITS (cr=3 pr=0 pw=0 time=29 us cost=1 size=78 card=6) 1 1 1 INDEX UNIQUE SCAN FND_DATA_GROUP_UNITS_U1 (cr=2 pr=0 pw=0 time=24 us cost=0 size=0 card=1)(object id 33145) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_ORACLE_USERID (cr=2 pr=0 pw=0 time=17 us cost=1 size=2740 card=274) 1 1 1 INDEX UNIQUE SCAN FND_ORACLE_USERID_U1 (cr=1 pr=0 pw=0 time=10 us cost=0 size=0 card=1)(object id 22603) ******************************************************************************** SQL ID: 32bhha21dkv0v Plan Hash: 2783779297 select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc 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 4 0.00 0.00 0 4 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 4 0 3 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 3 3 3 SORT ORDER BY (cr=4 pr=0 pw=0 time=90 us cost=5 size=924 card=44) 3 3 3 TABLE ACCESS CLUSTER COL$ (cr=4 pr=0 pw=0 time=50 us cost=4 size=924 card=44) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=27 us cost=2 size=0 card=1)(object id 3) ******************************************************************************** SQL ID: dgxcxyvy4gb1a Plan Hash: 3491373453 SELECT SUBMITTED_LOGIN_ID FROM FND_LOGINS WHERE LOGIN_ID = :B1 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: CHOOSE Parsing user id: 173 (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 FND_LOGINS (cr=3 pr=0 pw=0 time=86 us cost=2 size=13 card=1) 1 1 1 INDEX UNIQUE SCAN FND_LOGINS_U1 (cr=2 pr=0 pw=0 time=47 us cost=1 size=0 card=1)(object id 33197) ******************************************************************************** SQL ID: 11q8rsmgwdk2v Plan Hash: 3938761318 SELECT COUNT(*) FROM FND_LANGUAGES L WHERE NLS_LANGUAGE = :B1 AND L.INSTALLED_FLAG IN ('I', 'B') 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 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 4 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=2 pr=0 pw=0 time=30 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LANGUAGES (cr=2 pr=0 pw=0 time=19 us cost=1 size=12 card=1) 1 1 1 INDEX UNIQUE SCAN FND_LANGUAGES_U5 (cr=1 pr=0 pw=0 time=6 us cost=0 size=0 card=1)(object id 33042) ******************************************************************************** SQL ID: 2s6ru6rvfbjxk Plan Hash: 0 begin fnd_conc_global.get_req_globals( conc_status => :status, request_data => :request_data, conc_restart_time => :restart, release_sub_request => :release); end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 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: 01xcmn3zpj49d Plan Hash: 3839144519 SELECT COUNT(1) FROM FND_LOG_METRICS WHERE TRANSACTION_CONTEXT_ID = :B1 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.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=0 pr=0 pw=0 time=24 us) 0 0 0 INDEX RANGE SCAN FND_LOG_METRICS_N1 (cr=0 pr=0 pw=0 time=8 us cost=1 size=13 card=1)(object id 253051) ******************************************************************************** SQL ID: 6qz82dptj0qr7 Plan Hash: 1038336071 select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID LOB$ (cr=2 pr=0 pw=0 time=20 us cost=3 size=114 card=2) 0 0 0 INDEX RANGE SCAN I_LOB1 (cr=2 pr=0 pw=0 time=16 us cost=2 size=0 card=2)(object id 252) ******************************************************************************** SQL ID: 1mr4u2r99v9vc Plan Hash: 3905985053 SELECT PHASE_CODE, STATUS_CODE, COMPLETION_TEXT, PHASE.LOOKUP_CODE, STATUS.LOOKUP_CODE, PHASE.MEANING, STATUS.MEANING FROM FND_CONCURRENT_REQUESTS R, FND_CONCURRENT_PROGRAMS P, FND_LOOKUPS PHASE, FND_LOOKUPS STATUS WHERE PHASE.LOOKUP_TYPE = :B3 AND PHASE.LOOKUP_CODE = DECODE(STATUS.LOOKUP_CODE, 'H', 'I', 'S', 'I', 'U', 'I', 'M', 'I', R.PHASE_CODE) AND STATUS.LOOKUP_TYPE = :B2 AND STATUS.LOOKUP_CODE = DECODE(R.PHASE_CODE, 'P', DECODE(R.HOLD_FLAG, 'Y', 'H', DECODE(P.ENABLED_FLAG, 'N', 'U', DECODE(SIGN(R.REQUESTED_START_DATE - SYSDATE),1,'P', R.STATUS_CODE))), 'R', DECODE(R.HOLD_FLAG, 'Y', 'S', DECODE(R.STATUS_CODE, 'Q', 'B', 'I', 'B', R.STATUS_CODE)), R.STATUS_CODE) AND (R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID AND R.PROGRAM_APPLICATION_ID= P.APPLICATION_ID ) AND REQUEST_ID = :B1 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: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=36 us) 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=34 us cost=10 size=182 card=1) 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=32 us cost=7 size=123 card=1) 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=30 us cost=4 size=64 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=3 pr=0 pw=0 time=28 us cost=3 size=52 card=1) 0 0 0 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=26 us cost=2 size=0 card=1)(object id 34547) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=0 pr=0 pw=0 time=0 us cost=1 size=175656 card=14638) 0 0 0 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 33183) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=0 pr=0 pw=0 time=0 us cost=3 size=59 card=1) 0 0 0 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 14622584) 0 0 0 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 14622584) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=0 pr=0 pw=0 time=0 us cost=3 size=59 card=1) ******************************************************************************** SQL ID: 94c3fmw2bkjnq Plan Hash: 797509339 SELECT FND_LOGINS_S.NEXTVAL FROM SYS.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.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SEQUENCE FND_LOGINS_S (cr=0 pr=0 pw=0 time=74 us) 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=1 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: 9rfqm06xmuwu0 Plan Hash: 3426108880 select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc 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: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID SUBCOLTYPE$ (cr=1 pr=0 pw=0 time=32 us cost=3 size=390 card=6) 0 0 0 INDEX RANGE SCAN I_SUBCOLTYPE1 (cr=1 pr=0 pw=0 time=29 us cost=1 size=0 card=6)(object id 765429) ******************************************************************************** SQL ID: 971vpk0tp7ahm Plan Hash: 2845986334 select procedure#,entrypoint# from procedurec$ where obj#=:1 order by procedure# 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID PROCEDUREC$ (cr=2 pr=0 pw=0 time=30 us cost=3 size=84 card=7) 0 0 0 INDEX RANGE SCAN I_PROCEDUREC$ (cr=2 pr=0 pw=0 time=26 us cost=2 size=0 card=7)(object id 765434) ******************************************************************************** SQL ID: 6wb81d55us7fp Plan Hash: 0 SAVEPOINT START_OF_SUBMISSION 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: 0 Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: 9g485acn2n30m Plan Hash: 3112729412 select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc 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: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID REFCON$ (cr=1 pr=0 pw=0 time=27 us cost=2 size=45 card=3) 0 0 0 INDEX RANGE SCAN I_REFCON2 (cr=1 pr=0 pw=0 time=23 us cost=1 size=0 card=3)(object id 298) ******************************************************************************** SQL ID: 6fpgjh9367r2n Plan Hash: 1133168885 SELECT RESUBMIT_TIME, RESUBMIT_INTERVAL_TYPE_CODE, REQUESTED_START_DATE, RESUBMIT_INTERVAL_UNIT_CODE, RESUBMIT_INTERVAL, SYSDATE, RELEASE_CLASS_ID, RELEASE_CLASS_APP_ID, RESUBMIT_END_DATE FROM FND_CONCURRENT_REQUESTS WHERE REQUEST_ID = :B1 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: CHOOSE Parsing user id: 173 (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 FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=16 us cost=3 size=34 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=9 us cost=2 size=0 card=1)(object id 34547) ******************************************************************************** SQL ID: 9uv7yykmy4s7b Plan Hash: 1546270724 SELECT SUBSTR(USERENV('LANGUAGE'),1, INSTR(USERENV('LANGUAGE'), '_') -1) 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.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) 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=1 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: 0fr8zhn4ymu3v Plan Hash: 3355330683 select intcol#,type,flags,lobcol,objcol,extracol,schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc 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: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID OPQTYPE$ (cr=1 pr=0 pw=0 time=25 us cost=2 size=26 card=1) 0 0 0 INDEX RANGE SCAN I_OPQTYPE1 (cr=1 pr=0 pw=0 time=22 us cost=1 size=0 card=1)(object id 765439) ******************************************************************************** SQL ID: 39918s1sdb8b1 Plan Hash: 1133168885 select phase_code,status_code into :p,:s from fnd_concurrent_requests where request_id=:r 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: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=15 us cost=3 size=11 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=11 us cost=2 size=0 card=1)(object id 34547) 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: f3g84j69n0tjh Plan Hash: 760139525 select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc 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: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID NTAB$ (cr=1 pr=0 pw=0 time=17 us cost=2 size=34 card=2) 0 0 0 INDEX RANGE SCAN I_NTAB2 (cr=1 pr=0 pw=0 time=13 us cost=1 size=0 card=2)(object id 290) ******************************************************************************** SQL ID: 2rda1m6x0jjbt Plan Hash: 1546270724 SELECT TO_NUMBER(((TO_CHAR(SYSDATE, 'J') - 1 ) * 86400) + TO_CHAR(SYSDATE, 'SSSSS')) FROM SYS.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.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) 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=0 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: a8jp42bm45y6m Plan Hash: 1335202565 SELECT WIDTH, LENGTH FROM FND_PRINTER_STYLES WHERE PRINTER_STYLE_NAME = :B1 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: CHOOSE Parsing user id: 173 (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 FND_PRINTER_STYLES (cr=2 pr=0 pw=0 time=19 us cost=1 size=24 card=1) 1 1 1 INDEX UNIQUE SCAN FND_PRINTER_STYLES_U1 (cr=1 pr=0 pw=0 time=11 us cost=0 size=0 card=1)(object id 32929) ******************************************************************************** SQL ID: bgjhtnqhr5u9h Plan Hash: 4106726438 select procedure#,entrypoint# from procedureplsql$ where obj#=:1 order by procedure# 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: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID PROCEDUREPLSQL$ (cr=3 pr=0 pw=0 time=20 us cost=4 size=55 card=5) 0 0 0 INDEX RANGE SCAN I_PROCEDUREPLSQL$ (cr=3 pr=0 pw=0 time=17 us cost=3 size=0 card=5)(object id 9226819) ******************************************************************************** SQL ID: 9jzpjbrt45jgm Plan Hash: 537836892 SELECT COUNT(*) FROM FND_CONCURRENT_REQUESTS WHERE REQUEST_ID = :B1 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: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=3 pr=0 pw=0 time=22 us) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=16 us cost=2 size=7 card=1)(object id 34547) ******************************************************************************** SQL ID: gg2vzguu4z5nn Plan Hash: 1546270724 SELECT SUBSTR ( USERENV('LANGUAGE') , INSTR ( USERENV('LANGUAGE') , '_') + 1, (INSTR ( USERENV('LANGUAGE') , '.') - 1 - INSTR ( USERENV('LANGUAGE') , '_') )) 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.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) 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=1 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: 5j4c2v06qdhqq Plan Hash: 2257988360 select procedure#,ownerlength,classlength,methodlength,siglength, flagslength, cookiesize from procedurejava$ where obj#=:1 order by procedure# 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID PROCEDUREJAVA$ (cr=2 pr=0 pw=0 time=9 us cost=4 size=270 card=9) 0 0 0 INDEX RANGE SCAN I_PROCEDUREJAVA$ (cr=2 pr=0 pw=0 time=7 us cost=2 size=0 card=9)(object id 765436) ******************************************************************************** SQL ID: g4cn8fyry077m Plan Hash: 1546270724 SELECT TO_CHAR(DECODE(:B1 , NULL, DECODE (:B4 , 'START', :B3 , :B2 ) + DECODE(:B6 , 'MINUTES', :B5 /1440, 'HOURS', :B5 /24, 'DAYS', :B5 , 'MONTHS', ADD_MONTHS( DECODE(:B4 , 'START', :B3 , :B2 ), :B5 ) - DECODE(:B4 , 'START', :B3 , :B2 )), TO_DATE (TO_CHAR (:B2 , 'DD-MON-YYYY') || ' ' || :B1 , 'DD-MON-YYYY HH24:MI:SS') + DECODE( SIGN(TO_DATE(TO_CHAR(:B2 , 'HH24:MI:SS'), 'HH24:MI:SS') - TO_DATE(:B1 , 'HH24:MI:SS') ), 1, 1, 0)), 'DD-MON-YYYY HH24:MI:SS') 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.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) 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=1 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: 83cq1aqjw5gmg Plan Hash: 0 select ownername,classname,methodname,signature,flags from procedurejava$ where obj#=:1 and procedure#=:2 order by procedure# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 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 1 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 27 0.00 0.00 0 0 0 0 Execute 1786 520.60 535.81 21 31 55 1770 Fetch 15 0.01 0.38 23 73 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1828 520.61 536.20 44 104 55 1784 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1822 0.00 0.00 SQL*Net message from client 1822 0.02 1.55 Disk file operations I/O 5 0.00 0.00 db file sequential read 40 0.05 0.63 direct path read 2 0.04 0.06 utl_file I/O 12017638 0.11 42.11 SQL*Net more data to client 28041 0.00 0.56 log file sync 4 0.00 0.00 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 129 0.02 0.02 0 0 0 0 Execute 511857 38.59 39.49 5 20 29 3 Fetch 512172 4004.59 13616.30 968243 560849350 0 1607609 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1024158 4043.20 13655.83 968248 560849370 29 1607612 Misses in library cache during parse: 11 Misses in library cache during execute: 9 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 99 0.00 0.01 db file sequential read 968202 0.47 9681.01 db file scattered read 8 0.03 0.15 latch: cache buffers chains 161 0.00 0.00 db file parallel read 1 0.02 0.02 latch: shared pool 1 0.00 0.00 read by other session 1 0.00 0.00 70 user SQL statements in session. 50 internal SQL statements in session. 120 SQL statements in session. 0 statements EXPLAINed in this session. ******************************************************************************** Trace file: betsyu1_ora_5166_NISHANT_RANJ_CR259246393.trc Trace file compatibility: 11.1.0.7 Sort options: prsela exeela fchela 1 session in tracefile. 70 user SQL statements in trace file. 50 internal SQL statements in trace file. 120 SQL statements in trace file. 112 unique SQL statements in trace file. 14584948 lines in trace file. 14194 elapsed seconds in trace file.