TKPROF: Release 11.2.0.3.0 - Development on Thu Sep 12 09:25:44 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Trace file: betsyu1_ora_10865_NISHANT_RANJ_CR253164478.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 ******************************************************************************** Error in CREATE TABLE of EXPLAIN PLAN table: APPS.prof$plan_table ORA-00955: name is already used by an existing object parse error offset: 18 EXPLAIN PLAN option disabled. ******************************************************************************** SQL ID: 1abgtnmrafuff Plan Hash: 900675135 SELECT RTRIM(XBDI.ASSEMBLY_ITEM_NAME) ASSEMBLY_ITEM_NAME , XBDI.ORGANIZATION_CODE ,NVL(XBDI.START_EFFECTIVE_DATE, TRUNC(SYSDATE+1)) START_EFFECTIVE_DATE ,NVL(XBDI.OPERATION_SEQUENCE_NUMBER,1) OPERATION_SEQUENCE_NUMBER ,RTRIM(XBDI.COMPONENT_ITEM_NAME) COMPONENT_ITEM_NAME ,XBDI.REFERENCE_DESIGNATOR_NAME , XBDI.REF_DESIGNATOR_COMMENT ,XBDI.ATTRIBUTE1 ,XBDI.ATTRIBUTE2 , XBDI.ATTRIBUTE3 FROM XXBOM_DESIGNATOR_IFACE_VA XBDI WHERE RTRIM(XBDI.ASSEMBLY_ITEM_NAME) = :B4 AND XBDI.ORGANIZATION_CODE = :B3 AND RTRIM(XBDI.COMPONENT_ITEM_NAME) = :B2 AND NVL(XBDI.OPERATION_SEQUENCE_NUMBER,-999) = NVL(:B1 , NVL(XBDI.OPERATION_SEQUENCE_NUMBER,-999)) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 170211 5.57 5.89 0 0 0 0 Fetch 170211 15254.16 15312.80 5383 916926657 170211 32501 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 340423 15259.73 15318.70 5383 916926657 170211 32501 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 FULL XXBOM_DESIGNATOR_IFACE_VA (cr=5387 pr=5383 pw=0 time=8562556 us cost=1450 size=880 card=11) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 6 0.03 0.05 db file parallel read 2 1.30 1.46 db file scattered read 673 0.11 6.78 latch: cache buffers chains 340 0.00 0.01 ******************************************************************************** SQL ID: ahwyj27k0svcf Plan Hash: 0 BEGIN XXBOM_IMPORT_VA_PRC(:errbuf,:rc); END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 225.08 225.43 32 32 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 225.08 225.44 32 32 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 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 direct path read 12 0.04 0.25 utl_file I/O 214811 0.00 1.07 Disk file operations I/O 1 0.00 0.00 log file sync 1 0.00 0.00 ******************************************************************************** SQL ID: a04sryztpukht Plan Hash: 315795964 SELECT RTRIM(ASSEMBLY_ITEM_NUMBER) ASSEMBLY_ITEM_NUMBER ,ORGANIZATION_CODE , NVL(EFFECTIVITY_DATE, TRUNC(SYSDATE+1)) EFFECTIVITY_DATE ,DISABLE_DATE , NVL(OPERATION_SEQ_NUM,1) OPERATION_SEQ_NUM ,COMPONENT_ITEM_NUMBER , COMPONENT_QUANTITY ,COMPONENT_SEQUENCE_ID ,WIP_SUPPLY_TYPE , SUPPLY_SUBINVENTORY ,LOCATION_NAME ,OPTIONAL ,MUTUALLY_EXCLUSIVE_OPTIONS , LOW_QUANTITY ,HIGH_QUANTITY ,CHECK_ATP ,SHIPPING_ALLOWED ,REQUIRED_TO_SHIP , REQUIRED_FOR_REVENUE ,INCLUDE_ON_SHIP_DOCS FROM XXBOM_INV_COMPS_IFACE_VA WHERE RTRIM(ASSEMBLY_ITEM_NUMBER) = :B2 AND ORGANIZATION_CODE = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6719 0.27 0.26 0 0 0 0 Fetch 6779 3.71 92.82 9293 30514 0 170323 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13499 3.98 93.09 9293 30514 0 170323 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 ---------- ---------- ---------- --------------------------------------------------- 2 2 2 TABLE ACCESS BY INDEX ROWID XXBOM_INV_COMPS_IFACE_VA (cr=4 pr=4 pw=0 time=190124 us cost=4 size=1909 card=23) 2 2 2 INDEX RANGE SCAN XXBOM_INV_COMPS_IFACE_VA_N2 (cr=3 pr=3 pw=0 time=100017 us cost=3 size=0 card=23)(object id 9262697) 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 9293 0.27 89.82 ******************************************************************************** SQL ID: bm5pj2hmg5qqj Plan Hash: 1753274927 SELECT MSI.SEGMENT1 FROM MTL_SYSTEM_ITEMS MSI WHERE MSI.SEGMENT1 = :B2 AND MSI.ORGANIZATION_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 176940 22.73 23.14 0 0 0 0 Fetch 176940 11.59 56.43 2188 708598 0 176930 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 353882 34.32 79.58 2188 708598 0 176930 Misses in library cache during parse: 1 Misses in library cache during execute: 2 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 INDEX RANGE SCAN MTL_SYSTEM_ITEMS_B_N1 (cr=4 pr=2 pw=0 time=89478 us cost=4 size=17 card=1)(object id 37999) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 8 0.00 0.00 db file sequential read 2188 0.17 45.28 latch: shared pool 1 0.00 0.00 ******************************************************************************** SQL ID: 26kujk2c55hyj Plan Hash: 3109850079 SELECT INVENTORY_ITEM_ID FROM MTL_SYSTEM_ITEMS_KFV WHERE CONCATENATED_SEGMENTS = :B2 AND ORGANIZATION_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6711 0.20 0.20 0 0 0 0 Fetch 6711 1.06 59.39 3484 33555 0 6711 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13423 1.26 59.59 3484 33555 0 6711 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_SYSTEM_ITEMS_B (cr=5 pr=1 pw=0 time=50921 us cost=5 size=23 card=1) 1 1 1 INDEX RANGE SCAN MTL_SYSTEM_ITEMS_B_N1 (cr=4 pr=0 pw=0 time=36 us cost=4 size=0 card=1)(object id 37999) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 12 0.00 0.00 db file sequential read 3484 0.21 58.63 ******************************************************************************** SQL ID: 7r7masjf8sggc Plan Hash: 1136939801 SELECT ASSEMBLY_ITEM_ID , ORGANIZATION_ID , ALTERNATE_BOM_DESIGNATOR , COMMON_ASSEMBLY_ITEM_ID , COMMON_ORGANIZATION_ID , SPECIFIC_ASSEMBLY_COMMENT , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ASSEMBLY_TYPE , COMMON_BILL_SEQUENCE_ID , BILL_SEQUENCE_ID , STRUCTURE_TYPE_ID , IMPLEMENTATION_DATE FROM BOM_STRUCTURES_B WHERE ASSEMBLY_ITEM_ID = :B4 AND ORGANIZATION_ID = :B3 AND NVL(ALTERNATE_BOM_DESIGNATOR, 'XXXX') = NVL(DECODE( :B1 ,:B2 , NULL, :B1 ), 'XXXX') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6711 0.31 0.25 0 0 0 0 Fetch 6711 0.68 25.90 1422 26872 0 6711 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13423 0.99 26.16 1422 26872 0 6711 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 BOM_STRUCTURES_B (cr=4 pr=3 pw=0 time=77849 us cost=4 size=109 card=1) 1 1 1 INDEX RANGE SCAN BOM_STRUCTURES_B_N2 (cr=3 pr=2 pw=0 time=40808 us cost=3 size=0 card=1)(object id 3033254) 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 1422 0.16 25.31 ******************************************************************************** SQL ID: 1606uup9r1yqh Plan Hash: 2687984926 UPDATE XXBOM_BILL_OF_MTLS_IFACE_VA SET STATUS = 'ERRINT', BATCH_NUM = :B4 , ORAC_ERROR_DESC = :B3 , LAST_UPDATE_DATE =SYSDATE, LAST_UPDATED_BY = FND_GLOBAL.USER_ID WHERE ORGANIZATION_CODE = :B2 AND RTRIM(ITEM_NUMBER) = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6711 3.14 13.21 764 25922 38770 6711 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6712 3.14 13.22 764 25922 38770 6711 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 UPDATE XXBOM_BILL_OF_MTLS_IFACE_VA (cr=3 pr=2 pw=0 time=54686 us) 1 1 1 TABLE ACCESS BY INDEX ROWID XXBOM_BILL_OF_MTLS_IFACE_VA (cr=3 pr=2 pw=0 time=54223 us cost=2 size=164 card=1) 1 1 1 INDEX UNIQUE SCAN XXBOM_BILL_OF_MTLS_IFACE_VA_U1 (cr=2 pr=2 pw=0 time=54198 us cost=1 size=0 card=1)(object id 9192108) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 764 0.13 9.88 Disk file operations I/O 15 0.00 0.00 ******************************************************************************** SQL ID: 61g378ad37spp Plan Hash: 146674794 SELECT RTRIM(XBOMI.ITEM_NUMBER) ITEM_NUMBER ,XBOMI.ORGANIZATION_CODE ORGANIZATION_CODE ,XBOMI.ASSEMBLY_TYPE ,XBOMI.SPECIFIC_ASSEMBLY_COMMENT , XBOMI.DATA_FLOW ,XBOMI.STATUS ,XBOMI.RECORD_TYPE FROM XXBOM_BILL_OF_MTLS_IFACE_VA XBOMI WHERE XBOMI.STATUS IN ('PICK', 'ERRSTG', 'ERRINT') AND XBOMI.DATA_FLOW = 'C' AND XBOMI.RECORD_TYPE = 'A' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 68 0.21 4.57 2103 2317 0 6721 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 70 0.23 4.58 2103 2317 0 6721 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 ---------- ---------- ---------- --------------------------------------------------- 6721 6721 6721 TABLE ACCESS FULL XXBOM_BILL_OF_MTLS_IFACE_VA (cr=2317 pr=2103 pw=0 time=4543145 us cost=564 size=2702210 card=38603) 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.09 0.15 db file scattered read 273 0.08 4.26 ******************************************************************************** SQL ID: fp4puq6jrnm04 Plan Hash: 0 declare p varchar2(32767); begin p := "BOM_ALT_DESIGS_POLICY"."GET_ALT_PREDICATE"(:sn, :on); :v1 := substr(p,1,4000); :v2 := substr(p,4001,4000); :v3 := substr(p,8001,4000); :v4 := substr(p,12001,4000); :v5 := substr(p,16001,4000); :v6 := substr(p,20001,4000); :v7 := substr(p,24001,4000); :v8 := substr(p,28001,4000); :v9 := substr(p,32001,767); :v10 := substr(p, 4001, 1); :v11 := substr(p,8001,1); :v12 := substr(p, 12001, 1); :v13 := substr(p,16001,1); :v14 := substr(p, 20001, 1); :v15 := substr(p,24001,1); :v16 := substr(p, 28001, 1); :v17 := substr(p,32001,1); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 13422 0.53 0.50 0 0 0 0 Execute 13422 3.39 3.39 0 0 0 13422 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 26844 3.92 3.89 0 0 0 13422 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 2) ******************************************************************************** SQL ID: bjkzscgk5yvk0 Plan Hash: 1548917657 SELECT DECODE(ENABLE_UNIMPLEMENTED_BOMS,'Y',NULL, SYSDATE) FROM BOM_STRUCTURE_TYPES_B STYPE, BOM_ALTERNATE_DESIGNATORS ALT WHERE ALT.ALTERNATE_DESIGNATOR_CODE IS NULL AND STYPE.STRUCTURE_TYPE_ID = ALT.STRUCTURE_TYPE_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6711 2.21 2.23 0 0 0 0 Execute 6711 1.28 1.11 0 0 0 0 Fetch 6711 0.57 0.52 3 26844 0 6711 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 20133 4.06 3.87 3 26844 0 6711 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 6711 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=4 pr=0 pw=0 time=58 us) 1 1 1 NESTED LOOPS (cr=3 pr=0 pw=0 time=48 us cost=3 size=17 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID BOM_ALTERNATE_DESIGNATORS (cr=2 pr=0 pw=0 time=33 us cost=2 size=12 card=1) 1 1 1 INDEX RANGE SCAN BOM_ALTERNATE_DESIGNATORS_U1 (cr=1 pr=0 pw=0 time=16 us cost=1 size=0 card=1)(object id 29781) 1 1 1 INDEX UNIQUE SCAN BOM_STRUCTURE_TYPES_B_U2 (cr=1 pr=0 pw=0 time=9 us cost=0 size=0 card=1)(object id 749863) 1 1 1 TABLE ACCESS BY INDEX ROWID BOM_STRUCTURE_TYPES_B (cr=1 pr=0 pw=0 time=3 us cost=1 size=5 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ latch: row cache objects 2 0.00 0.00 Disk file operations I/O 1 0.00 0.00 db file sequential read 3 0.02 0.04 ******************************************************************************** SQL ID: g4r2bvat5skm1 Plan Hash: 2009447203 SELECT OOD.ORGANIZATION_ID, OOD.ORGANIZATION_CODE FROM ORG_ORGANIZATION_DEFINITIONS OOD WHERE OOD.ORGANIZATION_CODE = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6721 0.41 0.43 0 0 0 0 Fetch 6721 3.17 3.29 1 114257 0 6721 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13443 3.58 3.72 1 114257 0 6721 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 NESTED LOOPS (cr=44 pr=1 pw=0 time=33188 us cost=9 size=83 card=1) 1 1 1 NESTED LOOPS (cr=43 pr=1 pw=0 time=33167 us cost=9 size=79 card=1) 1 1 1 NESTED LOOPS (cr=41 pr=1 pw=0 time=33149 us cost=8 size=52 card=1) 1 1 1 NESTED LOOPS (cr=38 pr=1 pw=0 time=33084 us cost=6 size=23 card=1) 1 1 1 NESTED LOOPS (cr=26 pr=1 pw=0 time=30758 us cost=6 size=16 card=1) 1 1 1 MERGE JOIN CARTESIAN (cr=6 pr=1 pw=0 time=26430 us cost=5 size=8 card=1) 1 1 1 TABLE ACCESS FULL FND_PRODUCT_GROUPS (cr=4 pr=0 pw=0 time=63 us cost=4 size=0 card=1) 1 1 1 BUFFER SORT (cr=2 pr=1 pw=0 time=26359 us cost=1 size=8 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID MTL_PARAMETERS (cr=2 pr=1 pw=0 time=26329 us cost=1 size=8 card=1) 1 1 1 INDEX RANGE SCAN MTL_PARAMETERS_N98 (cr=1 pr=1 pw=0 time=26318 us cost=0 size=0 card=1)(object id 14622521) 1 1 1 TABLE ACCESS BY INDEX ROWID HR_ALL_ORGANIZATION_UNITS (cr=20 pr=0 pw=0 time=4323 us cost=1 size=8 card=1) 1 1 1 INDEX UNIQUE SCAN HR_ORGANIZATION_UNITS_PK (cr=2 pr=0 pw=0 time=14 us cost=0 size=0 card=1)(object id 43498) 1 1 1 INDEX UNIQUE SCAN HR_ALL_ORGANIZATION_UNTS_TL_PK (cr=12 pr=0 pw=0 time=2322 us cost=0 size=7 card=1)(object id 44637) 1 1 1 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=3 pr=0 pw=0 time=62 us cost=2 size=29 card=1) 1 1 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_X99 (cr=2 pr=0 pw=0 time=21 us cost=1 size=0 card=1)(object id 14622722) 1 1 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_X99 (cr=2 pr=0 pw=0 time=14 us cost=1 size=27 card=1)(object id 14622722) 1 1 1 INDEX RANGE SCAN GL_SETS_OF_BOOKS_X99 (cr=1 pr=0 pw=0 time=15 us cost=0 size=4 card=1)(object id 14622583) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 1 0.00 0.00 db file sequential read 1 0.02 0.02 ******************************************************************************** SQL ID: 64mx7bd496xax Plan Hash: 166764703 SELECT COMPONENT_QUANTITY FROM BOM_INVENTORY_COMPONENTS WHERE COMPONENT_SEQUENCE_ID = :B1 AND QUANTITY_RELATED = 1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 170165 2.71 2.75 0 0 0 0 Fetch 170165 0.48 0.50 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 340331 3.19 3.25 0 0 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 BOM_COMPONENTS_B (cr=0 pr=0 pw=0 time=16 us cost=4 size=43 card=1) 0 0 0 INDEX UNIQUE SCAN BOM_COMPONENTS_B_U2 (cr=0 pr=0 pw=0 time=9 us cost=3 size=0 card=1)(object id 29528) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ latch: shared pool 2 0.00 0.00 ******************************************************************************** SQL ID: 9ypfg0htnjj6r Plan Hash: 166764703 SELECT CREATION_DATE ,CREATED_BY FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 170165 2.83 2.66 0 0 0 0 Fetch 170165 0.50 0.53 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 340331 3.33 3.19 0 0 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 BOM_COMPONENTS_B (cr=0 pr=0 pw=0 time=3 us cost=4 size=19 card=1) 0 0 0 INDEX UNIQUE SCAN BOM_COMPONENTS_B_U2 (cr=0 pr=0 pw=0 time=1 us cost=3 size=0 card=1)(object id 29528) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ latch: shared pool 1 0.00 0.00 ******************************************************************************** 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 155 2.51 2.51 0 0 0 155 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 156 2.51 2.51 0 0 0 155 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 156 0.00 0.00 SQL*Net message from client 156 0.00 0.10 utl_file I/O 80548 0.00 0.28 SQL*Net more data to client 2459 0.00 0.03 ******************************************************************************** SQL ID: 1hc19ahqrgpz8 Plan Hash: 2385214914 SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6711 0.68 0.87 0 0 0 0 Fetch 6711 0.46 0.52 0 13422 0 6711 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13423 1.14 1.39 0 13422 0 6711 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=31 us cost=2 size=8 card=1) 1 1 1 INDEX RANGE SCAN MTL_PARAMETERS_N98 (cr=1 pr=0 pw=0 time=20 us cost=1 size=0 card=1)(object id 14622521) ******************************************************************************** SQL ID: f5wbpv7hkn1wq Plan Hash: 1546270724 SELECT FND_GLOBAL.RESP_APPL_ID FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6711 0.13 0.17 0 0 0 0 Fetch 6711 1.16 1.17 0 0 0 6711 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13423 1.29 1.34 0 0 0 6711 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=8 us cost=2 size=0 card=1) ******************************************************************************** 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 22 0.00 0.00 0 0 0 0 Execute 22 0.00 0.00 0 0 0 0 Fetch 213 0.04 1.33 62 670 0 191 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 257 0.04 1.33 62 670 0 191 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 ---------- ---------- ---------- --------------------------------------------------- 17 17 17 SORT ORDER BY (cr=53 pr=7 pw=0 time=148036 us cost=17 size=316 card=4) 17 17 17 NESTED LOOPS OUTER (cr=53 pr=7 pw=0 time=147919 us cost=16 size=316 card=4) 17 17 17 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (cr=4 pr=3 pw=0 time=61507 us cost=4 size=132 card=4) 17 17 17 INDEX RANGE SCAN I_DEPENDENCY1 (cr=3 pr=2 pw=0 time=50726 us cost=3 size=0 card=4)(object id 116) 17 17 17 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=49 pr=4 pw=0 time=86382 us cost=3 size=46 card=1) 17 17 17 INDEX RANGE SCAN I_OBJ1 (cr=36 pr=3 pw=0 time=69245 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 4 0.00 0.00 db file sequential read 62 0.06 1.31 ******************************************************************************** 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 19 0.00 0.00 0 0 0 0 Execute 19 0.01 0.00 0 0 0 0 Fetch 58 0.01 0.92 49 222 0 56 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 96 0.02 0.92 49 222 0 56 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID IDL_UB1$ (cr=5 pr=2 pw=0 time=38992 us cost=4 size=22 card=1) 1 1 1 INDEX RANGE SCAN I_IDL_UB11 (cr=4 pr=1 pw=0 time=1099 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 49 0.07 0.91 ******************************************************************************** SQL ID: 2g0a1aa03ngs0 Plan Hash: 769824144 SELECT FPI.STATUS, FPI.INDUSTRY, FPI.PRODUCT_VERSION, FOU.ORACLE_USERNAME, FPI.TABLESPACE, FPI.INDEX_TABLESPACE, FPI.TEMPORARY_TABLESPACE, FPI.SIZING_FACTOR FROM FND_PRODUCT_INSTALLATIONS FPI, FND_ORACLE_USERID FOU, FND_APPLICATION FA WHERE FPI.APPLICATION_ID = FA.APPLICATION_ID AND FPI.ORACLE_ID = FOU.ORACLE_ID AND FA.APPLICATION_SHORT_NAME = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6711 0.28 0.26 0 0 0 0 Fetch 13422 0.34 0.47 0 46977 0 6711 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 20134 0.62 0.74 0 46977 0 6711 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=7 pr=0 pw=0 time=116 us) 1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=102 us cost=4 size=58 card=1) 1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=90 us cost=3 size=48 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_APPLICATION (cr=2 pr=0 pw=0 time=38 us cost=1 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN FND_APPLICATION_U3 (cr=1 pr=0 pw=0 time=24 us cost=0 size=0 card=1)(object id 32806) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_PRODUCT_INSTALLATIONS (cr=3 pr=0 pw=0 time=47 us cost=2 size=38 card=1) 1 1 1 INDEX RANGE SCAN FND_PRODUCT_INSTALLATIONS_PK (cr=2 pr=0 pw=0 time=28 us cost=1 size=0 card=1)(object id 22589) 1 1 1 INDEX UNIQUE SCAN FND_ORACLE_USERID_U1 (cr=1 pr=0 pw=0 time=8 us cost=0 size=0 card=1)(object id 22603) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_ORACLE_USERID (cr=1 pr=0 pw=0 time=6 us cost=1 size=10 card=1) ******************************************************************************** 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 19 0.00 0.00 0 0 0 0 Execute 19 0.00 0.00 0 0 0 0 Fetch 40 0.00 0.61 23 120 0 21 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 78 0.00 0.61 23 120 0 21 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 2 2 2 TABLE ACCESS BY INDEX ROWID IDL_SB4$ (cr=7 pr=2 pw=0 time=45055 us cost=4 size=19 card=1) 2 2 2 INDEX RANGE SCAN I_IDL_SB41 (cr=5 pr=1 pw=0 time=32495 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 ---------- ------------ db file sequential read 23 0.12 0.60 ******************************************************************************** SQL ID: 1vkncqgvdn9zx Plan Hash: 2293208712 SELECT STRUCTURE_TYPE_ID FROM BOM_STRUCTURE_TYPES_B WHERE STRUCTURE_TYPE_NAME = NVL(:B1 ,'All-Structure Types') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6711 0.22 0.22 0 0 0 0 Fetch 6711 0.10 0.21 2 13422 0 6711 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13423 0.32 0.44 2 13422 0 6711 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 BOM_STRUCTURE_TYPES_B (cr=2 pr=2 pw=0 time=54322 us cost=1 size=20 card=1) 1 1 1 INDEX UNIQUE SCAN BOM_STRUCTURE_TYPES_B_U1 (cr=1 pr=1 pw=0 time=27921 us cost=0 size=0 card=1)(object id 749857) 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 2 0.02 0.05 ******************************************************************************** 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 22 0.00 0.00 0 0 0 0 Execute 22 0.00 0.00 0 0 0 0 Fetch 185 0.01 0.41 23 392 0 163 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 229 0.01 0.42 23 392 0 163 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 ---------- ---------- ---------- --------------------------------------------------- 15 15 15 TABLE ACCESS BY INDEX ROWID ACCESS$ (cr=33 pr=3 pw=0 time=74171 us cost=5 size=360 card=8) 15 15 15 INDEX RANGE SCAN I_ACCESS1 (cr=18 pr=2 pw=0 time=46336 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 ---------- ------------ Disk file operations I/O 2 0.00 0.00 db file sequential read 23 0.03 0.41 ******************************************************************************** SQL ID: gtqm5aujbaxvg Plan Hash: 1546270724 SELECT SYS_CONTEXT('Struct_Type_Ctx', 'appl_id') FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 13422 0.21 0.24 0 0 0 0 Fetch 13422 0.13 0.11 0 0 0 13422 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 26845 0.34 0.36 0 0 0 13422 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 3) 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: 8sst43uk9rk8q Plan Hash: 0 ROLLBACK call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6711 0.38 0.35 0 6 46 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6712 0.38 0.35 0 6 46 0 Misses in library cache during parse: 0 Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: 3837wmp2h0hzq Plan Hash: 1546270724 SELECT DECODE(:B1 , :B2 , 'Missing', NULL, 'XXXX', :B1 ) FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6711 0.34 0.28 0 0 0 0 Fetch 6711 0.08 0.05 0 0 0 6711 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13423 0.42 0.34 0 0 0 6711 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=9 us cost=2 size=0 card=1) ******************************************************************************** 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 12 0.00 0.00 0 0 0 0 Execute 12 0.00 0.00 0 0 0 0 Fetch 12 0.00 0.31 17 37 0 12 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 36 0.00 0.32 17 37 0 12 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID NCOMP_DLL$ (cr=3 pr=2 pw=0 time=31674 us cost=2 size=816 card=1) 1 1 1 INDEX UNIQUE SCAN I_NCOMP_DLL1 (cr=2 pr=1 pw=0 time=19049 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 17 0.03 0.31 ******************************************************************************** SQL ID: 7jzjkv596n0u1 Plan Hash: 2687984926 UPDATE XXBOM_BILL_OF_MTLS_IFACE_VA SET STATUS = 'ERRSTG', BATCH_NUM = :B4 , ORAC_ERROR_DESC = :B3 , LAST_UPDATE_DATE =SYSDATE, LAST_UPDATED_BY = FND_GLOBAL.USER_ID WHERE ORGANIZATION_CODE = :B2 AND RTRIM(ITEM_NUMBER) = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 10 0.01 0.30 7 31 32 10 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.01 0.30 7 31 32 10 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 ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE XXBOM_BILL_OF_MTLS_IFACE_VA (cr=3 pr=1 pw=0 time=17052 us) 1 1 1 TABLE ACCESS BY INDEX ROWID XXBOM_BILL_OF_MTLS_IFACE_VA (cr=3 pr=1 pw=0 time=16571 us cost=2 size=164 card=1) 1 1 1 INDEX UNIQUE SCAN XXBOM_BILL_OF_MTLS_IFACE_VA_U1 (cr=2 pr=1 pw=0 time=16544 us cost=1 size=0 card=1)(object id 9192108) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 7 0.16 0.29 ******************************************************************************** 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 19 0.00 0.00 0 0 0 0 Execute 19 0.00 0.00 0 0 0 0 Fetch 21 0.00 0.27 7 67 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 59 0.00 0.27 7 67 0 4 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 2 2 2 TABLE ACCESS BY INDEX ROWID IDL_UB2$ (cr=6 pr=2 pw=0 time=154512 us cost=4 size=21 card=1) 2 2 2 INDEX RANGE SCAN I_IDL_UB21 (cr=4 pr=1 pw=0 time=124182 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 7 0.12 0.27 ******************************************************************************** SQL ID: b1wc53ddd6h3p Plan Hash: 2848975084 select audit$,options from procedure$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 17 0.01 0.00 0 0 0 0 Execute 17 0.00 0.00 0 0 0 0 Fetch 17 0.00 0.25 11 51 0 17 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 51 0.01 0.25 11 51 0 17 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID PROCEDURE$ (cr=3 pr=2 pw=0 time=51606 us cost=2 size=48 card=1) 1 1 1 INDEX UNIQUE SCAN I_PROCEDURE1 (cr=2 pr=1 pw=0 time=32922 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 11 0.04 0.24 ******************************************************************************** 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 19 0.00 0.00 0 0 0 0 Execute 19 0.00 0.00 0 0 0 0 Fetch 21 0.00 0.22 7 63 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 59 0.00 0.22 7 63 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID IDL_CHAR$ (cr=5 pr=2 pw=0 time=67156 us cost=4 size=21 card=1) 1 1 1 INDEX RANGE SCAN I_IDL_CHAR1 (cr=4 pr=1 pw=0 time=47734 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 ---------- ------------ Disk file operations I/O 2 0.00 0.00 db file sequential read 7 0.06 0.22 ******************************************************************************** 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 1 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 128 0.00 0.22 11 34 0 124 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 133 0.00 0.22 11 34 0 124 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 SORT GROUP BY (cr=4 pr=3 pw=0 time=85584 us cost=6 size=68 card=4) 2 2 2 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=4 pr=3 pw=0 time=85385 us cost=5 size=68 card=4) 2 2 2 INDEX RANGE SCAN I_OBJAUTH1 (cr=3 pr=2 pw=0 time=46697 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 11 0.03 0.21 ******************************************************************************** SQL ID: gsxnqu9gqdtbv Plan Hash: 2293208712 SELECT STRUCTURE_TYPE_ID FROM BOM_STRUCTURE_TYPES_B WHERE STRUCTURE_TYPE_NAME = 'Packaging Hierarchy' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6711 0.09 0.15 0 0 0 0 Fetch 6711 0.02 0.06 0 13422 0 6711 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13423 0.11 0.21 0 13422 0 6711 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 BOM_STRUCTURE_TYPES_B (cr=2 pr=0 pw=0 time=17 us cost=1 size=20 card=1) 1 1 1 INDEX UNIQUE SCAN BOM_STRUCTURE_TYPES_B_U1 (cr=1 pr=0 pw=0 time=11 us cost=0 size=0 card=1)(object id 749857) ******************************************************************************** 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 1 0.00 0.00 0 0 0 0 Execute 31 0.00 0.00 0 0 0 0 Fetch 31 0.00 0.19 10 124 0 31 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 63 0.00 0.20 10 124 0 31 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=1 pw=0 time=15364 us cost=4 size=86 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=1 pw=0 time=15348 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 ---------- ------------ Disk file operations I/O 1 0.00 0.00 db file sequential read 10 0.03 0.19 ******************************************************************************** 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 8 0.00 0.00 0 0 0 0 Fetch 8 0.01 0.19 8 32 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 17 0.01 0.19 8 32 0 8 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=2 pw=0 time=62442 us cost=3 size=67 card=1) 1 1 1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=3 pr=1 pw=0 time=42262 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 8 0.04 0.19 ******************************************************************************** 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 43 0.00 0.00 0 0 0 0 Fetch 43 0.00 0.17 5 172 0 43 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 87 0.00 0.17 5 172 0 43 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=3 pw=0 time=124873 us) 1 1 1 INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=3 pr=2 pw=0 time=90141 us)(object id 194) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 5 0.07 0.17 ******************************************************************************** SQL ID: bkaaqaa5aj3gf Plan Hash: 2797573680 SELECT MESSAGE_TEXT, MESSAGE_NUMBER, TYPE, FND_LOG_SEVERITY, CATEGORY, SEVERITY FROM FND_NEW_MESSAGES M, FND_APPLICATION A WHERE :B3 = M.MESSAGE_NAME AND :B2 = M.LANGUAGE_CODE AND :B1 = A.APPLICATION_SHORT_NAME AND M.APPLICATION_ID = A.APPLICATION_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.13 7 18 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.13 7 18 0 3 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=6 pr=3 pw=0 time=55393 us cost=3 size=138 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_APPLICATION (cr=2 pr=0 pw=0 time=56 us cost=1 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN FND_APPLICATION_U3 (cr=1 pr=0 pw=0 time=39 us cost=0 size=0 card=1)(object id 32806) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_NEW_MESSAGES (cr=4 pr=3 pw=0 time=55324 us cost=2 size=128 card=1) 1 1 1 INDEX UNIQUE SCAN FND_NEW_MESSAGES_PK (cr=3 pr=2 pw=0 time=46924 us cost=1 size=0 card=1)(object id 33198) 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 7 0.07 0.13 ******************************************************************************** SQL ID: 30qw3zbtwhn3d Plan Hash: 1653615965 select gname,pname,stmt_type,check_opt,enable_flag,pfschma,ppname,pfname from rls$ 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.11 3 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.11 3 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 RLS$ (cr=4 pr=3 pw=0 time=110392 us cost=2 size=78 card=1) 1 1 1 INDEX RANGE SCAN I_RLS2 (cr=3 pr=2 pw=0 time=79201 us cost=1 size=0 card=1)(object id 112111) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.06 0.10 ******************************************************************************** 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.00 0.08 5 4 35 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.08 5 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=5 pw=0 time=86515 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=62 us cost=3 size=186 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=42 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 5 0.02 0.08 Disk file operations I/O 1 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: 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 5 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.06 2 20 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 0.00 0.06 2 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 BY INDEX ROWID SYN$ (cr=4 pr=2 pw=0 time=63764 us cost=3 size=34 card=1) 1 1 1 INDEX UNIQUE SCAN I_SYN1 (cr=3 pr=1 pw=0 time=20573 us cost=2 size=0 card=1)(object id 98) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.04 0.06 ******************************************************************************** SQL ID: a9u0s3g93f47z Plan Hash: 2094022552 select decode(u.type#, 2, u.ext_username, u.name), o.name, t.update$, t.insert$, t.delete$, t.enabled, decode(bitand(t.property, 8192), 8192, 1, 0), decode(bitand(t.property, 65536), 65536, 1, 0), decode(bitand(t.property, 131072), 131072, 1, 0), (select o.name from obj$ o where o.obj# = u.spare2 and o.type# =57) from sys.obj$ o, sys.user$ u, sys.trigger$ t, sys.obj$ bo where t.baseobject=bo.obj# and bo.name = :1 and bo.spare3 = :2 and bo.namespace = 1 and t.obj#=o.obj# and o.owner#=u.user# and o.type# = 12 and bitand(property,16)=0 and bitand(property,8)=0 order by o.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.06 3 5 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.06 3 5 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 OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=4 size=33 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=1)(object id 26619161) 0 0 0 SORT ORDER BY (cr=5 pr=3 pw=0 time=64056 us cost=11 size=207 card=1) 0 0 0 NESTED LOOPS (cr=5 pr=3 pw=0 time=64014 us cost=10 size=207 card=1) 0 0 0 NESTED LOOPS (cr=5 pr=3 pw=0 time=64009 us cost=9 size=101 card=1) 0 0 0 NESTED LOOPS (cr=5 pr=3 pw=0 time=64006 us cost=6 size=64 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ5 (cr=3 pr=2 pw=0 time=33942 us cost=3 size=36 card=1)(object id 26619165) 0 0 0 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=1 pw=0 time=30053 us cost=3 size=56 card=2) 0 0 0 INDEX RANGE SCAN I_TRIGGER1 (cr=2 pr=1 pw=0 time=30012 us cost=1 size=0 card=2)(object id 119) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=3 size=37 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 26619161) 0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=106 card=1) 0 0 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 11) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.02 0.06 ******************************************************************************** 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.04 2 1 11 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.04 2 1 11 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=2 pw=0 time=49706 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 2 0.02 0.04 ******************************************************************************** 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 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.04 3 20 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.04 3 20 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 MERGE JOIN OUTER (cr=6 pr=1 pw=0 time=18411 us cost=5 size=182 card=1) 1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=4 pr=1 pw=0 time=18339 us cost=4 size=143 card=1) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=20 us cost=2 size=0 card=1)(object id 3) 0 0 0 BUFFER SORT (cr=2 pr=0 pw=0 time=61 us cost=1 size=39 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID TAB_STATS$ (cr=2 pr=0 pw=0 time=29 us cost=1 size=39 card=1) 0 0 0 INDEX UNIQUE SCAN I_TAB_STATS$_OBJ# (cr=2 pr=0 pw=0 time=27 us cost=0 size=0 card=1)(object id 9228132) 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: 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.01 0.03 2 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.03 2 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=2 pw=0 time=38380 us cost=5 size=36 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONC_PP_ACTIONS (cr=4 pr=2 pw=0 time=38317 us cost=4 size=36 card=1) 1 1 1 INDEX RANGE SCAN FND_CONC_PP_ACTIONS_N1 (cr=3 pr=1 pw=0 time=23755 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 ---------- ------------ Disk file operations I/O 2 0.00 0.00 db file sequential read 2 0.02 0.03 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** 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 3 0.00 0.00 0 0 0 0 Fetch 8 0.01 0.03 3 32 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.01 0.03 3 32 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 SORT ORDER BY (cr=10 pr=3 pw=0 time=34435 us cost=10 size=390 card=2) 1 1 1 HASH JOIN OUTER (cr=10 pr=3 pw=0 time=34204 us cost=9 size=390 card=2) 1 1 1 NESTED LOOPS OUTER (cr=5 pr=0 pw=0 time=43 us cost=4 size=304 card=2) 1 1 1 TABLE ACCESS CLUSTER IND$ (cr=4 pr=0 pw=0 time=28 us cost=4 size=200 card=2) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=16 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=8 us cost=0 size=52 card=1) 0 0 0 INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=1 pr=0 pw=0 time=6 us cost=0 size=0 card=1)(object id 9228134) 0 0 0 VIEW (cr=5 pr=3 pw=0 time=32407 us cost=4 size=43 card=1) 0 0 0 SORT GROUP BY (cr=5 pr=3 pw=0 time=32402 us cost=4 size=16 card=1) 0 0 0 TABLE ACCESS CLUSTER CDEF$ (cr=5 pr=3 pw=0 time=32324 us cost=3 size=16 card=1) 1 1 1 INDEX UNIQUE SCAN I_COBJ# (cr=3 pr=1 pw=0 time=503 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 3 0.01 0.03 ******************************************************************************** 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 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.03 2 10 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.03 2 10 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=4 pr=2 pw=0 time=30554 us cost=5 size=17 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=4 pr=2 pw=0 time=30488 us cost=4 size=17 card=1) 0 0 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=4 pr=2 pw=0 time=30476 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 2 0.01 0.02 ******************************************************************************** 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.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 17 0.00 0.02 2 39 0 12 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 23 0.00 0.02 2 39 0 12 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 ICOL$ (cr=7 pr=1 pw=0 time=14139 us cost=4 size=58 card=2) 2 2 2 INDEX RANGE SCAN I_ICOL1 (cr=5 pr=1 pw=0 time=14098 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 2 0.01 0.02 ******************************************************************************** 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.02 2 13 1 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.02 2 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=2 pw=0 time=24289 us) 1 1 1 NESTED LOOPS (cr=6 pr=1 pw=0 time=10766 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=44 us cost=3 size=17 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) 1 1 1 INDEX UNIQUE SCAN FND_CONC_PROG_ONSITE_INFO_U1 (cr=2 pr=1 pw=0 time=10719 us cost=0 size=950495 card=14623)(object id 194616) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=43 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=27 us cost=3 size=35 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=17 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=13 us cost=1 size=584920 card=14623) 1 1 1 INDEX UNIQUE SCAN FND_CONC_PROG_ONSITE_INFO_U1 (cr=2 pr=0 pw=0 time=8 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 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: 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 0 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.02 1 20 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 20 0.00 0.02 1 20 0 3 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 INDEX RANGE SCAN FND_PROFILE_OPTIONS_X99 (cr=2 pr=0 pw=0 time=100 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 1 0.02 0.02 ******************************************************************************** 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 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.02 1 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 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 TABLE ACCESS BY INDEX ROWID CDEF$ (cr=2 pr=1 pw=0 time=21245 us cost=2 size=112 card=4) 0 0 0 INDEX RANGE SCAN I_CDEF3 (cr=2 pr=1 pw=0 time=21242 us cost=1 size=0 card=1)(object id 49) 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: axmdf8vq7k1rh Plan Hash: 2252041172 select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$, flags from seq$ 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.01 1 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.01 1 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 SEQ$ (cr=3 pr=1 pw=0 time=19531 us cost=2 size=67 card=1) 1 1 1 INDEX UNIQUE SCAN I_SEQ1 (cr=2 pr=0 pw=0 time=23 us cost=1 size=0 card=1)(object id 99) 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: 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 5 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.01 1 20 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 0.00 0.01 1 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 BY INDEX ROWID OBJ$ (cr=4 pr=0 pw=0 time=72 us cost=4 size=42 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=3 pr=0 pw=0 time=55 us cost=3 size=0 card=1)(object id 26619161) 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: 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=15074 us cost=3 size=13 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=1 pw=0 time=15063 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 ---------- ------------ Disk file operations I/O 1 0.00 0.00 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: 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 2 0.01 0.01 0 0 0 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 0 0 0 2 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 ******************************************************************************** SQL ID: 6g9u6nqp02gmc Plan Hash: 1139816351 SELECT XXFND_JOB_S.NEXTVAL FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 1 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 0 1 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 SEQUENCE XXFND_JOB_S (cr=5 pr=0 pw=0 time=1159 us) 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=3 us cost=2 size=0 card=1) ******************************************************************************** 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.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 12 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: 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 15 0.01 0.00 0 0 0 0 Fetch 30 0.00 0.00 2 78 0 15 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 46 0.01 0.00 2 78 0 15 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=2078 us cost=4 size=18 card=1) 1 1 1 INDEX RANGE SCAN I_CCOL1 (cr=4 pr=2 pw=0 time=2073 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.00 0.00 ******************************************************************************** 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 3 0.00 0.00 0 0 0 0 Fetch 193 0.00 0.00 0 32 0 190 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 197 0.00 0.00 0 32 0 190 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 ---------- ---------- ---------- --------------------------------------------------- 60 60 60 SORT ORDER BY (cr=4 pr=0 pw=0 time=385 us cost=5 size=2992 card=44) 60 60 60 TABLE ACCESS CLUSTER COL$ (cr=4 pr=0 pw=0 time=103 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) ******************************************************************************** SQL ID: 22nharvcdzu2p Plan Hash: 758244094 SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = :B2 AND LOOKUP_CODE = :B1 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 12 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 12 0 2 Misses in library cache during parse: 0 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=6 pr=0 pw=0 time=1373 us) 1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=1359 us cost=4 size=104 card=1) 1 1 1 VIEW VW_SQ_1 (cr=2 pr=0 pw=0 time=1330 us cost=2 size=43 card=1) 1 1 1 HASH GROUP BY (cr=2 pr=0 pw=0 time=1328 us cost=2 size=27 card=1) 1 1 1 INDEX RANGE SCAN FND_LOOKUP_TYPES_U1 (cr=2 pr=0 pw=0 time=56 us cost=2 size=54 card=2)(object id 32859) 1 1 1 INDEX UNIQUE SCAN FND_LOOKUP_VALUES_U1 (cr=3 pr=0 pw=0 time=27 us cost=1 size=0 card=1)(object id 32878) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=1 pr=0 pw=0 time=10 us cost=2 size=61 card=1) ******************************************************************************** SQL ID: bd4bznqbq73hk Plan Hash: 4271409967 select bo#, intcol# from icoldep$ 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 5 0.00 0.00 2 10 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.00 0.00 2 10 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 ---------- ---------- ---------- --------------------------------------------------- 2 2 2 TABLE ACCESS BY INDEX ROWID ICOLDEP$ (cr=6 pr=1 pw=0 time=686 us cost=2 size=75 card=5) 2 2 2 INDEX RANGE SCAN I_ICOLDEP$_OBJ (cr=4 pr=1 pw=0 time=673 us cost=1 size=0 card=5)(object id 300) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 ******************************************************************************** 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.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: bsa0wjtftg3uw Plan Hash: 690176192 select file# from file$ where ts#=: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 96 0.01 0.00 0 198 0 90 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 108 0.01 0.00 0 198 0 90 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 ---------- ---------- ---------- --------------------------------------------------- 15 15 15 TABLE ACCESS BY INDEX ROWID FILE$ (cr=33 pr=0 pw=0 time=122 us cost=3 size=16 card=2) 15 15 15 INDEX RANGE SCAN I_FILE2 (cr=17 pr=0 pw=0 time=63 us cost=2 size=0 card=1)(object id 39) ******************************************************************************** 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: 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=107 us) 0 0 0 TABLE ACCESS FULL APPWORX_OA_REQUESTS (cr=8 pr=0 pw=0 time=104 us cost=6 size=7 card=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=2 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: 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.00 0.00 log file sync 1 0.00 0.00 ******************************************************************************** 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: 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.00 0 17 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 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=0 pw=0 time=256 us) 2 2 2 NESTED LOOPS (cr=15 pr=0 pw=0 time=215 us cost=10 size=182 card=1) 1 1 1 NESTED LOOPS (cr=12 pr=0 pw=0 time=191 us cost=7 size=123 card=1) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=40 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=17 us cost=3 size=52 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=21 us cost=1 size=175296 card=14608) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=15 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=146 us cost=3 size=59 card=1) 2 2 2 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=3 pr=0 pw=0 time=33 us cost=2 size=0 card=1)(object id 14622584) 2 2 2 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=3 pr=0 pw=0 time=20 us cost=2 size=0 card=1)(object id 14622584) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=2 pr=0 pw=0 time=37 us cost=3 size=59 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: 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 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 1 0.00 0.00 ******************************************************************************** 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 3 0.00 0.00 0 0 0 0 Fetch 18 0.00 0.00 0 30 0 15 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 22 0.00 0.00 0 30 0 15 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 ---------- ---------- ---------- --------------------------------------------------- 5 5 5 TABLE ACCESS CLUSTER CDEF$ (cr=10 pr=0 pw=0 time=56 us cost=3 size=300 card=6) 1 1 1 INDEX UNIQUE SCAN I_COBJ# (cr=3 pr=0 pw=0 time=20 us cost=2 size=0 card=1)(object id 27) ******************************************************************************** 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.00 0 20 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10 0.00 0.00 0 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=0 pw=0 time=45 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_NEW_MESSAGES (cr=4 pr=0 pw=0 time=40 us cost=3 size=36 card=1) 1 1 1 INDEX UNIQUE SCAN FND_NEW_MESSAGES_PK (cr=3 pr=0 pw=0 time=20 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 ---------- ------------ SQL*Net message to client 5 0.00 0.00 SQL*Net message from client 5 0.00 0.00 ******************************************************************************** SQL ID: 4m7m0t6fjcs5x Plan Hash: 89955185 update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6, cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 2 2 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 2 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 ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE SEQ$ (cr=2 pr=0 pw=0 time=268 us) 1 1 1 INDEX UNIQUE SCAN I_SEQ1 (cr=2 pr=0 pw=0 time=8 us cost=1 size=67 card=1)(object id 99) ******************************************************************************** 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=231 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=15 us cost=3 size=32 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) 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: 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=41 us cost=3 size=11 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=32 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: 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.00 0 5 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 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=0 pw=0 time=273 us cost=4 size=59 card=1) 2 2 2 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=3 pr=0 pw=0 time=34 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 ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** 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 0 0.00 0.00 0 0 0 0 Execute 7 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.00 0 21 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.00 0.00 0 21 0 1 Misses in library cache during parse: 0 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 ---------- ---------- ---------- --------------------------------------------------- 0 0 0 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_X99 (cr=3 pr=0 pw=0 time=44 us cost=3 size=29 card=1)(object id 13748041) ******************************************************************************** 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 11 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 11 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=218 us) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROCESSES_U1 (cr=2 pr=0 pw=0 time=19 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: 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=188 us) 1 1 1 INDEX RANGE SCAN FND_CONC_PP_ACTIONS_N1 (cr=3 pr=0 pw=0 time=21 us cost=3 size=12 card=1)(object id 34250) ******************************************************************************** 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: aw7fu9a9bdyus Plan Hash: 510263741 SELECT * FROM PER_SECURITY_PROFILES WHERE SECURITY_PROFILE_ID = :B1 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.00 0 6 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 0.00 0.00 0 6 0 3 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 TABLE ACCESS BY INDEX ROWID PER_SECURITY_PROFILES (cr=2 pr=0 pw=0 time=16 us cost=1 size=109 card=1) 1 1 1 INDEX UNIQUE SCAN PER_SECURITY_PROFILES_PK (cr=1 pr=0 pw=0 time=8 us cost=0 size=0 card=1)(object id 44492) ******************************************************************************** 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: 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=181 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=16 us cost=3 size=129 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=12 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: 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.00 0.00 0 10 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 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=0 pw=0 time=65 us cost=5 size=190 card=1) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=41 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=18 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=23 us cost=1 size=394416 card=14608) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=16 us cost=0 size=0 card=1)(object id 33183) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_USER (cr=3 pr=0 pw=0 time=18 us cost=1 size=839260 card=41963) 1 1 1 INDEX UNIQUE SCAN FND_USER_U1 (cr=2 pr=0 pw=0 time=11 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 ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: f2tzfzy3qw2bp Plan Hash: 1511344495 SELECT DECODE(READ_ONLY_FLAG,'U', 'Y' ,'M', 'Y' ,'K', 'Y' ,'N') SCHEMA_MODE, DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1),' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1, 10)) FROM FND_ORACLE_USERID WHERE ORACLE_USERNAME = USER 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 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 4 0 2 Misses in library cache during parse: 0 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 TABLE ACCESS BY INDEX ROWID FND_ORACLE_USERID (cr=2 pr=0 pw=0 time=37 us cost=1 size=7 card=1) 1 1 1 INDEX UNIQUE SCAN FND_ORACLE_USERID_U2 (cr=1 pr=0 pw=0 time=27 us cost=0 size=0 card=1)(object id 22604) ******************************************************************************** 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 0 0.00 0.00 0 0 0 0 Execute 2 0.01 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.00 0 6 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 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTION_VALUES (cr=3 pr=0 pw=0 time=61 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=54 us cost=3 size=0 card=1)(object id 1391365) ******************************************************************************** SQL ID: 8gxrsat9m0dc2 Plan Hash: 0 alter session set NLS_TERRITORY = "AMERICA" 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: 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=33 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: 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: 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=28 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=15 us cost=3 size=80 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) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=10 us cost=1 size=175296 card=14608) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=6 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.00 0.00 ******************************************************************************** SQL ID: 404g2bvgmf03m Plan Hash: 0 alter session set NLS_LANGUAGE = "AMERICAN" 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: 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=15 us cost=3 size=34 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=8 us cost=2 size=0 card=1)(object id 34547) ******************************************************************************** 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=3 us cost=2 size=0 card=1) ******************************************************************************** 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.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: 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=0 pw=0 time=17 us cost=2 size=21 card=1) 0 0 0 INDEX RANGE SCAN FND_LOG_TRANSACTION_CONTEXT_N2 (cr=2 pr=0 pw=0 time=14 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 ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** 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=15 us) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=10 us cost=2 size=7 card=1)(object id 34547) ******************************************************************************** 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: 98j69vs3ymzjv Plan Hash: 1846972739 SELECT DECODE(:B2 , 'UTF8', FL.UTF8_DATE_LANGUAGE, 'AL32UTF8', FL.UTF8_DATE_LANGUAGE, FL.LOCAL_DATE_LANGUAGE ) DATA_RTN FROM FND_LANGUAGES FL WHERE FL.NLS_LANGUAGE = :B1 AND FL.INSTALLED_FLAG <>'D' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 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_LANGUAGES (cr=2 pr=0 pw=0 time=27 us cost=1 size=38 card=1) 1 1 1 INDEX UNIQUE SCAN FND_LANGUAGES_U5 (cr=1 pr=0 pw=0 time=14 us cost=0 size=0 card=1)(object id 33042) ******************************************************************************** SQL ID: 32adfj23k25z0 Plan Hash: 2325295079 SELECT FU.USER_NAME FROM FND_USER FU WHERE FU.USER_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 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_USER (cr=3 pr=0 pw=0 time=27 us cost=2 size=20 card=1) 1 1 1 INDEX UNIQUE SCAN FND_USER_U1 (cr=2 pr=0 pw=0 time=17 us cost=1 size=0 card=1)(object id 33427) ******************************************************************************** SQL ID: cjd5ryf2wfqs1 Plan Hash: 0 alter session set NLS_DATE_FORMAT = "DD-MON-RR" 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: at2h5x34yj2c4 Plan Hash: 1546270724 SELECT NLS_CHARSET_ID(:B1 ) FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 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=2 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: g1bvmkr52kdxp Plan Hash: 0 alter session set NLS_SORT = "BINARY" 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: 2fgjgudmx0yac Plan Hash: 0 alter session set NLS_DATE_LANGUAGE = "AMERICAN" 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: f2f0ypsk4x8n1 Plan Hash: 0 alter session set NLS_NUMERIC_CHARACTERS = ".," 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: 595qpkr7b4a4t Plan Hash: 1546270724 SELECT NLS_CHARSET_NAME(:B1 ) FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 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) ******************************************************************************** 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 187 227.60 228.09 39 59 52 171 Fetch 15 0.01 0.05 3 73 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 229 227.61 228.15 42 132 52 185 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 221 0.00 0.00 SQL*Net message from client 221 0.00 0.12 Disk file operations I/O 5 0.00 0.00 db file sequential read 10 0.02 0.15 direct path read 12 0.04 0.25 utl_file I/O 295382 0.00 1.36 log file sync 5 0.01 0.02 SQL*Net more data to client 2459 0.00 0.03 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 20346 2.78 2.78 0 0 0 0 Execute 801943 45.21 56.30 773 25973 38864 20146 Fetch 782789 15278.51 15565.17 24145 917959450 170212 468058 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1605078 15326.50 15624.26 24918 917985423 209076 488204 Misses in library cache during parse: 17 Misses in library cache during execute: 14 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 62 0.00 0.00 db file sequential read 17445 0.27 235.33 db file scattered read 946 0.11 11.05 db file parallel read 2 1.30 1.46 latch: cache buffers chains 340 0.00 0.01 latch: row cache objects 2 0.00 0.00 latch: shared pool 4 0.00 0.00 latch: In memory undo latch 1 0.00 0.00 6789 user SQL statements in session. 29 internal SQL statements in session. 6818 SQL statements in session. 0 statements EXPLAINed in this session. ******************************************************************************** Trace file: betsyu1_ora_10865_NISHANT_RANJ_CR253164478.trc Trace file compatibility: 11.1.0.7 Sort options: prsela exeela fchela 1 session in tracefile. 6789 user SQL statements in trace file. 29 internal SQL statements in trace file. 6818 SQL statements in trace file. 103 unique SQL statements in trace file. 2850806 lines in trace file. 15853 elapsed seconds in trace file.