TKPROF: Release 11.2.0.3.0 - Development on Wed Oct 16 13:07:22 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Trace file: betsyu1_ora_6609_NISHANT_RANJ_CR259240715.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: bx9t3u21munrx Plan Hash: 893180052 UPDATE RCV_RECEIVING_SUB_LEDGER RCV_SUB SET RCV_SUB.PA_ADDITION_FLAG = DECODE(RCV_SUB.PA_ADDITION_FLAG,'N','O','I','J'), RCV_SUB.REQUEST_ID = :B4 , RCV_SUB.LAST_UPDATE_DATE = SYSDATE, RCV_SUB.LAST_UPDATED_BY = :B3 , RCV_SUB.LAST_UPDATE_LOGIN = :B3 , RCV_SUB.PROGRAM_ID = :B2 , RCV_SUB.PROGRAM_APPLICATION_ID = :B1 , RCV_SUB.PROGRAM_UPDATE_DATE = SYSDATE WHERE EXISTS (SELECT 1 FROM RCV_TRANSACTIONS RCV_TXN, PO_DISTRIBUTIONS PO_DIST , PO_LINES_ALL POL WHERE ((RCV_TXN.DESTINATION_TYPE_CODE ='EXPENSE' ) OR (RCV_TXN.DESTINATION_TYPE_CODE = 'RECEIVING' AND (RCV_TXN.TRANSACTION_TYPE IN ('RETURN TO VENDOR','RETURN TO RECEIVING')))) AND TRUNC(RCV_TXN.TRANSACTION_DATE) <= TRUNC(NVL(:B6 ,RCV_TXN.TRANSACTION_DATE)) AND RCV_TXN.PO_DISTRIBUTION_ID = PO_DIST.PO_DISTRIBUTION_ID AND RCV_TXN.PO_LINE_ID = POL.PO_LINE_ID AND RCV_SUB.CODE_COMBINATION_ID = PO_DIST.CODE_COMBINATION_ID AND RCV_SUB.RCV_TRANSACTION_ID = RCV_TXN.TRANSACTION_ID AND TRUNC(PO_DIST.EXPENDITURE_ITEM_DATE) <= TRUNC(NVL(:B5 ,PO_DIST.EXPENDITURE_ITEM_DATE)) AND PO_DIST.PROJECT_ID > 0 AND PO_DIST.ACCRUE_ON_RECEIPT_FLAG= 'Y' AND ( (RCV_TXN.DESTINATION_TYPE_CODE = 'EXPENSE' AND (( RCV_TXN.TRANSACTION_TYPE = 'DELIVER' AND RCV_SUB.ENTERED_DR IS NOT NULL ) OR ( RCV_TXN.TRANSACTION_TYPE = 'RETURN TO RECEIVING' AND RCV_SUB.ENTERED_CR IS NOT NULL ) OR ( RCV_TXN.TRANSACTION_TYPE = 'CORRECT' AND ( RCV_SUB.ENTERED_CR IS NOT NULL OR RCV_SUB.ENTERED_DR IS NOT NULL )AND RCV_SUB.ACCOUNTING_LINE_TYPE='Charge' AND DECODE(POL.ORDER_TYPE_LOOKUP_CODE, 'RATE' , RCV_TXN.AMOUNT, 'FIXED PRICE', RCV_TXN.AMOUNT, RCV_TXN.PRIMARY_QUANTITY) < 0 ) OR ( RCV_TXN.TRANSACTION_TYPE = 'CORRECT' AND RCV_SUB.ENTERED_DR IS NOT NULL AND DECODE(POL.ORDER_TYPE_LOOKUP_CODE, 'RATE' , RCV_TXN.AMOUNT, 'FIXED PRICE', RCV_TXN.AMOUNT, RCV_TXN.PRIMARY_QUANTITY) >= 0 ) ) ) ) ) AND RCV_SUB.PA_ADDITION_FLAG IN ('N','I') AND RCV_SUB.ACTUAL_FLAG = 'A' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 339.81 4366.60 1346305 17820982 4 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 339.81 4366.60 1346305 17820982 4 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 UPDATE RCV_RECEIVING_SUB_LEDGER (cr=17820982 pr=1346305 pw=0 time=71622890 us) 0 0 0 FILTER (cr=17820982 pr=1346305 pw=0 time=71622882 us) 6079467 6079467 6079467 TABLE ACCESS FULL RCV_RECEIVING_SUB_LEDGER (cr=732433 pr=732265 pw=0 time=583123543 us cost=203825 size=2164234360 card=6079310) 0 0 0 NESTED LOOPS (cr=17088549 pr=614040 pw=0 time=3754070112 us cost=7 size=96 card=1) 259606 259606 259606 NESTED LOOPS (cr=16085723 pr=554142 pw=0 time=3036824111 us cost=5 size=74 card=1) 606954 606954 606954 TABLE ACCESS BY INDEX ROWID RCV_TRANSACTIONS (cr=13845417 pr=464870 pw=0 time=2030829699 us cost=3 size=59 card=1) 4596404 4596404 4596404 INDEX UNIQUE SCAN RCV_TRANSACTIONS_U1 (cr=9249013 pr=26408 pw=0 time=118469143 us cost=2 size=0 card=1)(object id 45286) 259606 259606 259606 TABLE ACCESS BY INDEX ROWID PO_LINES_ALL (cr=2240306 pr=89272 pw=0 time=999588896 us cost=2 size=89725950 card=5981730) 606954 606954 606954 INDEX UNIQUE SCAN PO_LINES_U1 (cr=1633350 pr=6553 pw=0 time=51025411 us cost=1 size=0 card=1)(object id 24505518) 0 0 0 TABLE ACCESS BY INDEX ROWID PO_DISTRIBUTIONS_ALL (cr=1002826 pr=59898 pw=0 time=710223086 us cost=2 size=22 card=1) 259604 259604 259604 INDEX UNIQUE SCAN PO_DISTRIBUTIONS_U1 (cr=743222 pr=8531 pw=0 time=72882793 us cost=1 size=0 card=1)(object id 45005) 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 614049 0.36 3580.05 db file scattered read 91973 0.26 517.41 latch: cache buffers chains 12 0.00 0.00 ******************************************************************************** SQL ID: 3ksgf7ccdk47j Plan Hash: 2864800797 UPDATE AP_INVOICE_DISTRIBUTIONS_ALL DIST SET DIST.PA_ADDITION_FLAG = 'N' , DIST.REQUEST_ID = :B1 WHERE DIST.PA_ADDITION_FLAG IN ('O','W') AND DIST.POSTED_FLAG||''= 'Y' AND DIST.PROJECT_ID >0 AND NOT EXISTS ( SELECT 'X' FROM PA_COST_DISTRIBUTION_LINES_ALL CDL WHERE CDL.SYSTEM_REFERENCE2 = TO_CHAR(DIST.INVOICE_ID) AND CDL.SYSTEM_REFERENCE3 = TO_CHAR(DIST.DISTRIBUTION_LINE_NUMBER) AND CDL.SYSTEM_REFERENCE4 IS NULL) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.02 0.46 21 23 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.02 0.46 21 23 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 UPDATE AP_INVOICE_DISTRIBUTIONS_ALL (cr=23 pr=21 pw=0 time=457323 us) 0 0 0 NESTED LOOPS ANTI (cr=23 pr=21 pw=0 time=457308 us cost=3443 size=207948 card=1612) 0 0 0 INLIST ITERATOR (cr=23 pr=21 pw=0 time=457281 us) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=23 pr=21 pw=0 time=457259 us cost=215 size=198276 card=1612) 0 0 0 INDEX RANGE SCAN AP_INVOICE_DISTRIBUTIONS_N14 (cr=23 pr=21 pw=0 time=457230 us cost=15 size=0 card=1614)(object id 28095) 0 0 0 INDEX RANGE SCAN PA_COST_DISTRIBUTION_LINES_N18 (cr=0 pr=0 pw=0 time=0 us cost=2 size=108 card=18)(object id 12681283) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 21 0.05 0.45 Disk file operations I/O 2 0.00 0.00 ******************************************************************************** SQL ID: cvn54b7yz0s8u Plan Hash: 2991757387 select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5 0.00 0.00 0 0 0 0 Execute 5 0.01 0.00 0 0 0 0 Fetch 21 0.00 0.41 28 79 0 19 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 31 0.01 0.41 28 79 0 19 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID IDL_UB1$ (cr=5 pr=2 pw=0 time=34695 us cost=4 size=22 card=1) 1 1 1 INDEX RANGE SCAN I_IDL_UB11 (cr=4 pr=1 pw=0 time=23084 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 ---------- ------------ Disk file operations I/O 4 0.00 0.00 db file sequential read 28 0.02 0.41 ******************************************************************************** SQL ID: 2zs1n9770s6g1 Plan Hash: 3456220322 INSERT INTO FND_CONCURRENT_REQUESTS ( REQUEST_ID, SECURITY_GROUP_ID, PHASE_CODE, STATUS_CODE, PRIORITY, PARENT_REQUEST_ID, PRIORITY_REQUEST_ID, DESCRIPTION, REQ_INFORMATION, IS_SUB_REQUEST, HAS_SUB_REQUEST, UPDATE_PROTECTED, HOLD_FLAG, ENFORCE_SERIALITY_FLAG, SINGLE_THREAD_FLAG, ARGUMENT_INPUT_METHOD_CODE, IMPLICIT_CODE, REQUEST_DATE, REQUESTED_START_DATE, REQUESTED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ORACLE_ID, CONC_LOGIN_ID, RESPONSIBILITY_ID, RESPONSIBILITY_APPLICATION_ID, NLS_LANGUAGE, NLS_TERRITORY, NLS_NUMERIC_CHARACTERS, PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID, QUEUE_METHOD_CODE, REQUEST_CLASS_APPLICATION_ID, CONCURRENT_REQUEST_CLASS_ID, PRINT_GROUP, PRINTER, PRINT_STYLE, NUMBER_OF_COPIES, SAVE_OUTPUT_FLAG, CRM_THRSHLD, RESUBMIT_TIME, RESUBMIT_INTERVAL, RESUBMIT_INTERVAL_UNIT_CODE, RESUBMIT_INTERVAL_TYPE_CODE, RESUBMIT_END_DATE, RESUBMITTED, CRITICAL, REQUEST_TYPE, RELEASE_CLASS_APP_ID, RELEASE_CLASS_ID, STALE_DATE, CANCEL_OR_HOLD, OUTPUT_FILE_TYPE, NLS_COMPLIANT, CD_ID, REQUEST_LIMIT, INCREMENT_DATES, ENABLE_TRACE, OPS_INSTANCE, ARGUMENT_TEXT, NUMBER_OF_ARGUMENTS, ARGUMENT1, ARGUMENT2, ARGUMENT3, ARGUMENT4, ARGUMENT5, ARGUMENT6, ARGUMENT7, ARGUMENT8, ARGUMENT9, ARGUMENT10, ARGUMENT11, ARGUMENT12, ARGUMENT13, ARGUMENT14, ARGUMENT15, ARGUMENT16, ARGUMENT17, ARGUMENT18, ARGUMENT19, ARGUMENT20, ARGUMENT21, ARGUMENT22, ARGUMENT23, ARGUMENT24, ARGUMENT25) SELECT :B73 , :B72 , :B71 , DECODE (:B70 , 'A', 'A', 'Z', 'Z', DECODE(FCP.QUEUE_METHOD_CODE, 'B', 'Q', DECODE (:B52 , 'Y', 'Q', DECODE(:B33 , 'Y', 'Q', 'I')))), DECODE (FCP.QUEUE_CONTROL_FLAG, 'Y', NVL(FCP.REQUEST_PRIORITY, 0), DECODE (:B69 , NULL, 50, :B69 )), DECODE (:B61 , 0, NULL, :B61 ), :B68 , :B67 , NULL, :B66 , 'N', :B65 , :B64 , 'Y', :B52 , 'S', :B63 , SYSDATE, DECODE (:B62 , '', (SYSDATE - :B60 ), GREATEST (:B62 , DECODE (:B61 , 0, (SYSDATE - :B60 ), FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001')))), :B59 , SYSDATE, :B59 , :B58 , ORACLE_ID, :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , FA.APPLICATION_ID, FCP.CONCURRENT_PROGRAM_ID, DECODE(:B33 , 'Y', 'B', DECODE(:B52 , 'N', FCP.QUEUE_METHOD_CODE, 'B')), FCP.CLASS_APPLICATION_ID, FCP.CONCURRENT_CLASS_ID, :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , DECODE (:B45 , '', NULL, TO_CHAR (FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001' || :B45 ), 'HH24:MI:SS')), DECODE (:B44 , '', NULL, :B44 ), :B43 , :B42 , :B41 , 'N', :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , FCP.OUTPUT_FILE_TYPE, FCP.NLS_COMPLIANT, :B34 , :B33 , :B32 , FCP.ENABLE_TRACE, :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 FROM FND_APPLICATION FA, FND_CONCURRENT_PROGRAMS FCP, FND_ORACLE_USERID WHERE ORACLE_USERNAME = :B3 AND FCP.ENABLED_FLAG = 'Y' AND (FCP.APPLICATION_ID = FA.APPLICATION_ID AND CONCURRENT_PROGRAM_NAME = UPPER (:B2 )) AND FA.APPLICATION_SHORT_NAME = UPPER (:B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.02 0.41 11 9 56 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.02 0.41 11 9 56 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=39 pr=11 pw=0 time=412679 us) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=101 us cost=3 size=66 card=1) 1 1 1 NESTED LOOPS (cr=4 pr=0 pw=0 time=57 us cost=2 size=20 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_ORACLE_USERID (cr=2 pr=0 pw=0 time=23 us cost=1 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN FND_ORACLE_USERID_U2 (cr=1 pr=0 pw=0 time=16 us cost=0 size=0 card=1)(object id 22604) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_APPLICATION (cr=2 pr=0 pw=0 time=26 us cost=1 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN FND_APPLICATION_U3 (cr=1 pr=0 pw=0 time=14 us cost=0 size=0 card=1)(object id 32806) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=37 us cost=1 size=46 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U2 (cr=2 pr=0 pw=0 time=22 us cost=0 size=0 card=1)(object id 33186) 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 11 0.11 0.40 ******************************************************************************** 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 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 91 0.00 0.35 35 281 0 87 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 99 0.00 0.36 35 281 0 87 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 ---------- ---------- ---------- --------------------------------------------------- 24 24 24 SORT ORDER BY (cr=78 pr=15 pw=0 time=125661 us cost=17 size=316 card=4) 24 24 24 NESTED LOOPS OUTER (cr=78 pr=15 pw=0 time=125424 us cost=16 size=316 card=4) 24 24 24 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (cr=5 pr=3 pw=0 time=32776 us cost=4 size=132 card=4) 24 24 24 INDEX RANGE SCAN I_DEPENDENCY1 (cr=3 pr=1 pw=0 time=13705 us cost=3 size=0 card=4)(object id 116) 24 24 24 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=73 pr=12 pw=0 time=92588 us cost=3 size=46 card=1) 24 24 24 INDEX RANGE SCAN I_OBJ1 (cr=50 pr=12 pw=0 time=92266 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 ---------- ------------ db file sequential read 35 0.02 0.35 Disk file operations I/O 1 0.00 0.00 ******************************************************************************** SQL ID: 39m4sx9k63ba2 Plan Hash: 2769382227 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 11 0.01 0.28 16 41 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21 0.01 0.29 16 41 0 7 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 7 7 7 TABLE ACCESS BY INDEX ROWID IDL_UB2$ (cr=16 pr=8 pw=0 time=136698 us cost=4 size=21 card=1) 7 7 7 INDEX RANGE SCAN I_IDL_UB21 (cr=9 pr=1 pw=0 time=27232 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 16 0.04 0.28 Disk file operations I/O 1 0.00 0.00 ******************************************************************************** SQL ID: 7sbvuwfkccb2h Plan Hash: 0 BEGIN PAAPIMP_PKG.PAAPIMP(:errbuf,:rc,:A0,:A1,:A2,:A3,:A4,:A5,:A6,:A7,:A8); END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.07 0.23 13 13 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.07 0.23 13 13 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 3 0.00 0.00 direct path read 6 0.03 0.10 utl_file I/O 52 0.00 0.00 log file sync 1 0.00 0.00 ******************************************************************************** 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.01 0.19 3 4 35 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.19 3 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=3 pw=0 time=194421 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=42 us cost=3 size=187 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=31 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 2 0.00 0.00 db file sequential read 3 0.15 0.19 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: c6awqs517jpj0 Plan Hash: 3800936087 select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.15 9 27 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.15 9 27 0 3 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 3 3 3 TABLE ACCESS BY INDEX ROWID IDL_CHAR$ (cr=9 pr=4 pw=0 time=60943 us cost=4 size=21 card=1) 3 3 3 INDEX RANGE SCAN I_IDL_CHAR1 (cr=6 pr=1 pw=0 time=20890 us cost=3 size=0 card=1)(object id 111) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 9 0.02 0.14 Disk file operations I/O 2 0.00 0.00 ******************************************************************************** SQL ID: b8drnk6b83t91 Plan Hash: 3579235443 UPDATE RCV_RECEIVING_SUB_LEDGER RRSL SET RRSL.PA_ADDITION_FLAG = 'N' , RRSL.REQUEST_ID = :B1 WHERE RRSL.PA_ADDITION_FLAG = 'O' AND NOT EXISTS (SELECT 'X' FROM PA_COST_DISTRIBUTION_LINES_ALL CDL WHERE CDL.SYSTEM_REFERENCE3 = RRSL.REFERENCE3 AND CDL.SYSTEM_REFERENCE4 = TO_CHAR(RRSL.RCV_TRANSACTION_ID) AND EXISTS (SELECT 1 FROM PO_DISTRIBUTIONS PO_DIST WHERE TO_CHAR(PO_DIST.PO_DISTRIBUTION_ID) = RRSL.REFERENCE3 AND PO_DIST.ACCRUE_ON_RECEIPT_FLAG= 'Y' AND PO_DIST.PROJECT_ID IS NOT NULL AND PO_DIST.PROJECT_ID = CDL.PROJECT_ID AND CDL.SYSTEM_REFERENCE2 = TO_CHAR(PO_DIST.PO_HEADER_ID) ) ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.04 0.14 3 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.04 0.14 3 3 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 UPDATE RCV_RECEIVING_SUB_LEDGER (cr=3 pr=3 pw=0 time=103086 us) 0 0 0 FILTER (cr=3 pr=3 pw=0 time=103072 us) 0 0 0 TABLE ACCESS BY INDEX ROWID RCV_RECEIVING_SUB_LEDGER (cr=3 pr=3 pw=0 time=103068 us cost=10 size=25988 card=73) 0 0 0 INDEX RANGE SCAN RCV_RECEIVING_SUB_LEDGER_N5 (cr=3 pr=3 pw=0 time=103063 us cost=3 size=0 card=73)(object id 3033299) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=18 size=31 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID PA_COST_DISTRIBUTION_LINES_ALL (cr=0 pr=0 pw=0 time=0 us cost=4 size=11 card=1) 0 0 0 INDEX RANGE SCAN PA_COST_DISTRIBUTION_LINES_N18 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=1)(object id 12681283) 0 0 0 INDEX RANGE SCAN PO_DISTRIBUTIONS_N9 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=29)(object id 44994) 0 0 0 TABLE ACCESS BY INDEX ROWID PO_DISTRIBUTIONS_ALL (cr=0 pr=0 pw=0 time=0 us cost=14 size=20 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 2 0.00 0.00 db file sequential read 3 0.04 0.10 ******************************************************************************** SQL ID: ga9j9xk5cy9s0 Plan Hash: 467424113 select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 10 0.01 0.12 8 30 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 20 0.01 0.12 8 30 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 ---------- ---------- ---------- --------------------------------------------------- 2 2 2 TABLE ACCESS BY INDEX ROWID IDL_SB4$ (cr=7 pr=3 pw=0 time=45246 us cost=4 size=19 card=1) 2 2 2 INDEX RANGE SCAN I_IDL_SB41 (cr=5 pr=1 pw=0 time=20009 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 8 0.02 0.12 Disk file operations I/O 1 0.00 0.00 ******************************************************************************** SQL ID: b1wc53ddd6h3p Plan Hash: 2848975084 select audit$,options from procedure$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.01 0.12 6 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.01 0.12 6 9 0 3 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID PROCEDURE$ (cr=3 pr=2 pw=0 time=37073 us cost=2 size=48 card=1) 1 1 1 INDEX UNIQUE SCAN I_PROCEDURE1 (cr=2 pr=1 pw=0 time=11166 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 6 0.03 0.12 ******************************************************************************** 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 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 90 0.00 0.11 8 184 0 86 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 98 0.00 0.11 8 184 0 86 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 ---------- ---------- ---------- --------------------------------------------------- 23 23 23 TABLE ACCESS BY INDEX ROWID ACCESS$ (cr=49 pr=2 pw=0 time=23011 us cost=5 size=360 card=8) 23 23 23 INDEX RANGE SCAN I_ACCESS1 (cr=26 pr=1 pw=0 time=6763 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 1 0.00 0.00 db file sequential read 8 0.02 0.11 ******************************************************************************** SQL ID: 11qf3jmt6b199 Plan Hash: 3112124945 SELECT AP.SET_OF_BOOKS_ID, PA.SET_OF_BOOKS_ID FROM AP_SYSTEM_PARAMETERS AP, PA_IMPLEMENTATIONS PA 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.09 22 23 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.09 22 23 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 MERGE JOIN CARTESIAN (cr=23 pr=22 pw=0 time=90182 us cost=13 size=16 card=1) 1 1 1 TABLE ACCESS FULL PA_IMPLEMENTATIONS_ALL (cr=22 pr=21 pw=0 time=76594 us cost=12 size=8 card=1) 1 1 1 BUFFER SORT (cr=1 pr=1 pw=0 time=13556 us cost=1 size=8 card=1) 1 1 1 INDEX FULL SCAN AP_SYSTEM_PARAMETERS_U1 (cr=1 pr=1 pw=0 time=13274 us cost=1 size=8 card=1)(object id 3022567) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 3 0.00 0.00 db file sequential read 2 0.01 0.02 db file scattered read 5 0.02 0.05 ******************************************************************************** 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 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.01 0.08 6 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.01 0.08 6 9 0 3 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID NCOMP_DLL$ (cr=3 pr=2 pw=0 time=25447 us cost=2 size=816 card=1) 1 1 1 INDEX UNIQUE SCAN I_NCOMP_DLL1 (cr=2 pr=1 pw=0 time=16110 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 6 0.02 0.08 ******************************************************************************** SQL ID: 5wxyshspv54v4 Plan Hash: 2381449488 select tc.type#,tc.intcol#,tc.position#,c.type#, c.length,c.scale, c.precision#,c.charsetid,c.charsetform, decode(bitand(c.property,8388608), 8388608, c.spare3, 0) from triggercol$ tc,col$ c, trigger$ tr where tc.obj#=:1 and tc.intcol#=c.intcol# and tr.obj# = tc.obj# and (bitand(tr.property,32) != 32 or bitand(tc.type#, 20) = 20) and ( c.obj#=:2 and (bitand(tc.type#, 1024) = :3 or tc.type# = 0) or c.obj#=:4 and bitand(tc.type#, 1024) = :5 or c.obj#=:6 and tc.type# = 0 and tc.position# = 0) union select type#,intcol#,position#,69, 0,0,0,0,0,0 from triggercol$ where obj#=:7 and intcol#=1001 union select tc.type#,tc.intcol#,tc.position#,121,0,0,0,0,0,0 from triggercol$ tc, trigger$ tr where tr.obj# = tc.obj# and bitand(tr.property,32) = 32 and tc.obj# = :8 and bitand(tc.type#,20) != 20 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 71 0.00 0.08 7 123 0 70 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 73 0.00 0.08 7 123 0 70 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 ---------- ---------- ---------- --------------------------------------------------- 70 70 70 SORT UNIQUE (cr=123 pr=7 pw=0 time=83969 us cost=23 size=410 card=12) 70 70 70 UNION-ALL (cr=123 pr=7 pw=0 time=83697 us) 70 70 70 CONCATENATION (cr=118 pr=7 pw=0 time=83535 us) 0 0 0 NESTED LOOPS (cr=6 pr=3 pw=0 time=19904 us) 0 0 0 NESTED LOOPS (cr=6 pr=3 pw=0 time=19900 us cost=5 size=62 card=1) 0 0 0 NESTED LOOPS (cr=6 pr=3 pw=0 time=19897 us cost=3 size=26 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=3 pr=0 pw=0 time=24 us cost=2 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=2 pr=0 pw=0 time=13 us cost=1 size=0 card=1)(object id 120) 0 0 0 INDEX RANGE SCAN I_TRIGGERCOL2 (cr=3 pr=3 pw=0 time=19868 us cost=1 size=16 card=1)(object id 122) 0 0 0 INDEX UNIQUE SCAN I_COL3 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 44) 0 0 0 TABLE ACCESS BY INDEX ROWID COL$ (cr=0 pr=0 pw=0 time=0 us cost=2 size=36 card=1) 70 70 70 NESTED LOOPS (cr=90 pr=4 pw=0 time=63067 us) 70 70 70 NESTED LOOPS (cr=20 pr=2 pw=0 time=44764 us cost=5 size=62 card=1) 70 70 70 NESTED LOOPS (cr=6 pr=0 pw=0 time=184 us cost=3 size=26 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=3 pr=0 pw=0 time=23 us cost=2 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=2 pr=0 pw=0 time=12 us cost=1 size=0 card=1)(object id 120) 70 70 70 INDEX RANGE SCAN I_TRIGGERCOL2 (cr=3 pr=0 pw=0 time=133 us cost=1 size=16 card=1)(object id 122) 70 70 70 INDEX UNIQUE SCAN I_COL3 (cr=14 pr=2 pw=0 time=44502 us cost=1 size=0 card=1)(object id 44) 70 70 70 TABLE ACCESS BY INDEX ROWID COL$ (cr=70 pr=2 pw=0 time=18223 us cost=2 size=36 card=1) 0 0 0 NESTED LOOPS (cr=22 pr=0 pw=0 time=510 us) 70 70 70 NESTED LOOPS (cr=20 pr=0 pw=0 time=353 us cost=5 size=62 card=1) 70 70 70 NESTED LOOPS (cr=6 pr=0 pw=0 time=168 us cost=3 size=26 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=3 pr=0 pw=0 time=34 us cost=2 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=2 pr=0 pw=0 time=20 us cost=1 size=0 card=1)(object id 120) 70 70 70 INDEX RANGE SCAN I_TRIGGERCOL2 (cr=3 pr=0 pw=0 time=109 us cost=1 size=16 card=1)(object id 122) 70 70 70 INDEX UNIQUE SCAN I_COL3 (cr=14 pr=0 pw=0 time=122 us cost=1 size=0 card=1)(object id 44) 0 0 0 TABLE ACCESS BY INDEX ROWID COL$ (cr=2 pr=0 pw=0 time=117 us cost=2 size=36 card=1) 0 0 0 INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=0 pw=0 time=10 us cost=2 size=16 card=1)(object id 122) 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=17 us cost=3 size=208 card=8) 0 0 0 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=3 pr=0 pw=0 time=15 us cost=2 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=2 pr=0 pw=0 time=7 us cost=1 size=0 card=1)(object id 120) 0 0 0 INDEX RANGE SCAN I_TRIGGERCOL2 (cr=0 pr=0 pw=0 time=0 us cost=1 size=128 card=8)(object id 122) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 7 0.02 0.08 ******************************************************************************** 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 63 0.00 0.00 0 0 0 0 Fetch 63 0.00 0.07 5 252 0 63 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 127 0.00 0.07 5 252 0 63 Misses in library cache during parse: 0 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=4 pr=2 pw=0 time=37055 us) 1 1 1 INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=3 pr=1 pw=0 time=16637 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.02 0.07 ******************************************************************************** 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 5 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.06 5 20 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 0.00 0.06 5 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=1 pw=0 time=30200 us cost=4 size=86 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=1 pw=0 time=30173 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 5 0.02 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.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.05 4 15 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.05 4 15 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 ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=8 us cost=4 size=33 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=5 us cost=3 size=0 card=1)(object id 26619161) 1 1 1 SORT ORDER BY (cr=15 pr=4 pw=0 time=58309 us cost=11 size=207 card=1) 1 1 1 NESTED LOOPS (cr=15 pr=4 pw=0 time=58059 us cost=10 size=207 card=1) 1 1 1 NESTED LOOPS (cr=10 pr=4 pw=0 time=57978 us cost=9 size=101 card=1) 1 1 1 NESTED LOOPS (cr=6 pr=3 pw=0 time=38082 us cost=6 size=64 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ5 (cr=3 pr=1 pw=0 time=16464 us cost=3 size=36 card=1)(object id 26619165) 1 1 1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=3 pr=2 pw=0 time=21606 us cost=3 size=56 card=2) 1 1 1 INDEX RANGE SCAN I_TRIGGER1 (cr=2 pr=1 pw=0 time=9547 us cost=1 size=0 card=2)(object id 119) 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=1 pw=0 time=19889 us cost=3 size=37 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=3 pr=1 pw=0 time=19555 us cost=2 size=0 card=1)(object id 26619161) 1 1 1 TABLE ACCESS CLUSTER USER$ (cr=5 pr=0 pw=0 time=72 us cost=1 size=106 card=1) 1 1 1 INDEX UNIQUE SCAN I_USER# (cr=2 pr=0 pw=0 time=23 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 4 0.01 0.05 ******************************************************************************** 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 1 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.05 3 5 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.05 3 5 0 3 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 3 3 3 SORT GROUP BY (cr=5 pr=3 pw=0 time=54096 us cost=6 size=68 card=4) 3 3 3 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=5 pr=3 pw=0 time=53959 us cost=5 size=68 card=4) 3 3 3 INDEX RANGE SCAN I_OBJAUTH1 (cr=3 pr=1 pw=0 time=12258 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 3 0.02 0.05 ******************************************************************************** SQL ID: gbd5g50k3q9dc Plan Hash: 246530440 SELECT ACTION_TYPE, DECODE(STATUS_S_FLAG, 'Y', 1, 0), DECODE(STATUS_W_FLAG, 'Y', 1, 0), DECODE(STATUS_F_FLAG, 'Y', 1, 0), PROGRAM_APPLICATION_ID, PROGRAM_ID, ARGUMENTS, NUMBER_OF_COPIES, SEQUENCE FROM FND_CONC_PP_ACTIONS WHERE CONCURRENT_REQUEST_ID= :reqid AND NVL(COMPLETED, 'N') = 'N' ORDER BY DECODE(ACTION_TYPE, 6, 0, ACTION_TYPE), SEQUENCE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.04 2 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.04 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=49304 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=49160 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=33322 us cost=3 size=0 card=1)(object id 34250) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.03 0.04 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 7akvnu9t168d3 Plan Hash: 3498663890 select baseobject,type#,update$,insert$,delete$,refnewname,refoldname, whenclause,definition,enabled,property,sys_evts,nttrigcol,nttrigatt, refprtname,rowid,actionlineno,trignameline,trignamecol, trignamecolofs, actioncolno from trigger$ where obj# =:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.04 4 5 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.04 4 5 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=5 pr=4 pw=0 time=47006 us cost=2 size=329 card=1) 1 1 1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=2 pr=2 pw=0 time=31444 us cost=1 size=0 card=1)(object id 120) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 4 0.01 0.04 ******************************************************************************** SQL ID: 91092j6z1cjx2 Plan Hash: 0 INSERT INTO DBMS_LOCK_ALLOCATED VALUES (:B3 , :B2 , SYSDATE + (:B1 /86400)) 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 6 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.04 2 1 6 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=43636 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.02 0.04 ******************************************************************************** SQL ID: 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.03 2 10 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.03 2 10 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=10 pr=2 pw=0 time=39191 us cost=5 size=190 card=1) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=61 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=20 us cost=3 size=143 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) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=36 us cost=1 size=395037 card=14631) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=22 us cost=0 size=0 card=1)(object id 33183) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_USER (cr=3 pr=2 pw=0 time=39115 us cost=1 size=857800 card=42890) 1 1 1 INDEX UNIQUE SCAN FND_USER_U1 (cr=2 pr=1 pw=0 time=30309 us cost=0 size=0 card=1)(object id 33427) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.03 0.03 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: 9md3j6kkst5ss Plan Hash: 1632356117 UPDATE RCV_RECEIVING_SUB_LEDGER RRSL SET RRSL.PA_ADDITION_FLAG = 'I' WHERE RRSL.PA_ADDITION_FLAG = 'J' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.03 2 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.03 2 3 0 0 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 ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE RCV_RECEIVING_SUB_LEDGER (cr=3 pr=2 pw=0 time=36893 us) 0 0 0 TABLE ACCESS BY INDEX ROWID RCV_RECEIVING_SUB_LEDGER (cr=3 pr=2 pw=0 time=36884 us cost=10 size=25988 card=73) 0 0 0 INDEX RANGE SCAN RCV_RECEIVING_SUB_LEDGER_N5 (cr=3 pr=2 pw=0 time=36880 us cost=3 size=0 card=73)(object id 3033299) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.02 0.03 ******************************************************************************** SQL ID: bbx5cf9sxcfrb Plan Hash: 3618260396 SELECT 'Y' FROM FND_CONCURRENT_REQUESTS REQ, FND_CONCURRENT_PROGRAMS PROG, FND_EXECUTABLES EXE WHERE REQ.PROGRAM_APPLICATION_ID = PROG.APPLICATION_ID AND REQ.CONCURRENT_PROGRAM_ID = PROG.CONCURRENT_PROGRAM_ID AND REQ.PHASE_CODE = 'R' AND REQ.REQUEST_ID <> :B1 AND PROG.EXECUTABLE_APPLICATION_ID = EXE.APPLICATION_ID AND PROG.EXECUTABLE_ID = EXE.EXECUTABLE_ID AND EXE.EXECUTABLE_NAME = 'PAAPIMP' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.01 0.02 2 25 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.03 2 25 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 NESTED LOOPS (cr=25 pr=2 pw=0 time=27566 us) 5 5 5 NESTED LOOPS (cr=20 pr=2 pw=0 time=27515 us cost=9 size=65 card=1) 5 5 5 MERGE JOIN CARTESIAN (cr=13 pr=2 pw=0 time=27422 us cost=6 size=135 card=3) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_EXECUTABLES (cr=3 pr=2 pw=0 time=27178 us cost=3 size=26 card=1) 1 1 1 INDEX RANGE SCAN FND_EXECUTABLES_U2 (cr=2 pr=2 pw=0 time=27088 us cost=2 size=0 card=1)(object id 33542) 5 5 5 BUFFER SORT (cr=10 pr=0 pw=0 time=229 us cost=3 size=57 card=3) 5 5 5 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=10 pr=0 pw=0 time=169 us cost=3 size=57 card=3) 6 6 6 INDEX RANGE SCAN FND_CONCURRENT_REQUESTS_N7 (cr=4 pr=0 pw=0 time=78 us cost=2 size=0 card=3)(object id 34533) 5 5 5 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=7 pr=0 pw=0 time=83 us cost=0 size=0 card=1)(object id 33183) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=5 pr=0 pw=0 time=35 us cost=1 size=20 card=1) 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: 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 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.02 2 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.02 2 4 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID SYN$ (cr=4 pr=2 pw=0 time=24847 us cost=3 size=34 card=1) 1 1 1 INDEX UNIQUE SCAN I_SYN1 (cr=3 pr=1 pw=0 time=10919 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.01 0.02 ******************************************************************************** SQL ID: 78agxmkjw5uq2 Plan Hash: 1666816048 UPDATE AP_INVOICE_DISTRIBUTIONS_ALL DIST SET DIST.PA_ADDITION_FLAG = 'F' WHERE DIST.PA_ADDITION_FLAG IN ('O','W') AND DIST.POSTED_FLAG||''= 'Y' AND DIST.PROJECT_ID >0 AND ( NVL(BASE_INVOICE_PRICE_VARIANCE, 0) <> 0 OR NVL(INVOICE_PRICE_VARIANCE, 0) <> 0 OR NVL(EXCHANGE_RATE_VARIANCE, 0) <> 0) AND EXISTS (SELECT 'X' FROM PA_COST_DISTRIBUTION_LINES_ALL CDL, PA_EXPENDITURE_ITEMS_ALL EI WHERE EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID AND EI.TRANSACTION_SOURCE ='AP VARIANCE' AND CDL.SYSTEM_REFERENCE2 = TO_CHAR(DIST.INVOICE_ID) AND CDL.SYSTEM_REFERENCE3 = TO_CHAR(DIST.DISTRIBUTION_LINE_NUMBER) AND CDL.SYSTEM_REFERENCE4 IS NOT NULL) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.02 0 0 0 0 Execute 1 0.00 0.00 0 23 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.02 0.02 0 23 0 0 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 ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE AP_INVOICE_DISTRIBUTIONS_ALL (cr=23 pr=0 pw=0 time=295 us) 0 0 0 FILTER (cr=23 pr=0 pw=0 time=289 us) 0 0 0 INLIST ITERATOR (cr=23 pr=0 pw=0 time=286 us) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=23 pr=0 pw=0 time=279 us cost=215 size=27306 card=222) 0 0 0 INDEX RANGE SCAN AP_INVOICE_DISTRIBUTIONS_N14 (cr=23 pr=0 pw=0 time=267 us cost=15 size=0 card=1614)(object id 28095) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=6 size=31 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID PA_COST_DISTRIBUTION_LINES_ALL (cr=0 pr=0 pw=0 time=0 us cost=4 size=12 card=1) 0 0 0 INDEX RANGE SCAN PA_COST_DISTRIBUTION_LINES_N5 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=1)(object id 40958) 0 0 0 INDEX UNIQUE SCAN PA_EXPENDITURE_ITEMS_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 41218) 0 0 0 TABLE ACCESS BY INDEX ROWID PA_EXPENDITURE_ITEMS_ALL (cr=0 pr=0 pw=0 time=0 us cost=2 size=19 card=1) ******************************************************************************** SQL ID: 4xq3d2v1y9j90 Plan Hash: 1998724675 SELECT NVL(NON_RECOVERABLE_TAX_FLAG,'N') FROM FINANCIALS_SYSTEM_PARAMETERS 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.01 9 10 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.02 9 10 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS FULL FINANCIALS_SYSTEM_PARAMS_ALL (cr=10 pr=9 pw=0 time=17535 us cost=6 size=6 card=1) 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 db file scattered read 2 0.00 0.00 ******************************************************************************** SQL ID: 3c9wuu2pxxr2f Plan Hash: 0 INSERT INTO FND_CONC_PP_ACTIONS (CONCURRENT_REQUEST_ID, ACTION_TYPE, STATUS_S_FLAG, STATUS_W_FLAG, STATUS_F_FLAG, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, CREATED_BY, ARGUMENTS, COMPLETED, NUMBER_OF_COPIES, SEQUENCE,OPS_INSTANCE) VALUES (:B8 , 1, 'Y', :B7 , 'N', SYSDATE, :B5 , SYSDATE, :B6 , :B5 , :B4 , 'N', :B3 , :B2 , :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.02 1 1 9 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.02 1 1 9 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=1 pw=0 time=20570 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 1 0.01 0.01 ******************************************************************************** SQL ID: f728g0x48xn2f Plan Hash: 2385124469 SELECT A.APPLICATION_ID, CONCURRENT_PROGRAM_ID, CD_PARAMETER, PRINTER_NAME, NVL(OUTPUT_PRINT_STYLE, 'PORTRAIT'), REQUIRED_STYLE, MINIMUM_WIDTH, MINIMUM_LENGTH, EXECUTION_METHOD_CODE, SAVE_OUTPUT_FLAG, PRINT_FLAG, QUEUE_CONTROL_FLAG, REQUEST_PRIORITY, REQUEST_SET_FLAG, DECODE(:B4 , 'EXPLICIT', NVL(:B3 ,NVL(P.INSTANCE_ID,FND_CONC_GLOBAL.OPS_INST_NUM)), -1), NVL(REFRESH_PORTLET, 'N'), NVL(ALLOW_MULTIPLE_PENDING_REQUEST,'Y') FROM FND_CONCURRENT_PROGRAMS P, FND_APPLICATION A WHERE UPPER(CONCURRENT_PROGRAM_NAME) = UPPER(:B2 ) AND P.APPLICATION_ID = A.APPLICATION_ID AND UPPER(A.APPLICATION_SHORT_NAME) = UPPER(:B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.02 2 16 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.02 2 16 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=16 pr=2 pw=0 time=20311 us) 1 1 1 NESTED LOOPS (cr=15 pr=2 pw=0 time=20261 us cost=8 size=316 card=4) 1 1 1 VIEW index$_join$_002 (cr=12 pr=0 pw=0 time=2070 us cost=3 size=30 card=3) 1 1 1 HASH JOIN (cr=12 pr=0 pw=0 time=2066 us) 317 317 317 INDEX FAST FULL SCAN FND_APPLICATION_U1 (cr=6 pr=0 pw=0 time=142 us cost=1 size=30 card=3)(object id 32802) 1 1 1 INDEX FAST FULL SCAN FND_APPLICATION_U3 (cr=6 pr=0 pw=0 time=172 us cost=1 size=30 card=3)(object id 32806) 1 1 1 INDEX RANGE SCAN FND_CONCURRENT_PROGRAMS_U2 (cr=3 pr=2 pw=0 time=18182 us cost=1 size=0 card=1)(object id 33186) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=1 pr=0 pw=0 time=34 us cost=2 size=69 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.01 0.01 ******************************************************************************** SQL ID: 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 9 0.00 0.00 0 0 0 0 Fetch 9 0.01 0.02 1 27 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.01 0.02 1 27 0 0 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 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTION_VALUES (cr=3 pr=0 pw=0 time=37 us cost=4 size=32 card=1) 0 0 0 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1 (cr=3 pr=0 pw=0 time=35 us cost=3 size=0 card=1)(object id 1391365) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 1 0.00 0.00 db file sequential read 1 0.01 0.01 ******************************************************************************** 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 17 0.00 0.00 0 0 0 0 Fetch 17 0.00 0.01 2 34 0 15 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 34 0.00 0.02 2 34 0 15 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 INDEX RANGE SCAN FND_PROFILE_OPTIONS_X99 (cr=2 pr=0 pw=0 time=97 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 2 0.01 0.01 ******************************************************************************** SQL ID: 8d27gqfbcyhb1 Plan Hash: 703862948 UPDATE RCV_RECEIVING_SUB_LEDGER RRSL SET RRSL.PA_ADDITION_FLAG = 'Y' WHERE RRSL.PA_ADDITION_FLAG IN ('O','W') AND EXISTS (SELECT 'X' FROM PA_COST_DISTRIBUTION_LINES_ALL CDL WHERE CDL.SYSTEM_REFERENCE3 = RRSL.REFERENCE3 AND CDL.SYSTEM_REFERENCE4 = TO_CHAR(RRSL.RCV_TRANSACTION_ID) AND EXISTS (SELECT 1 FROM PO_DISTRIBUTIONS PO_DIST WHERE TO_CHAR(PO_DIST.PO_DISTRIBUTION_ID) = RRSL.REFERENCE3 AND PO_DIST.ACCRUE_ON_RECEIPT_FLAG= 'Y' AND PO_DIST.PROJECT_ID IS NOT NULL AND PO_DIST.PROJECT_ID = CDL.PROJECT_ID AND CDL.SYSTEM_REFERENCE2 = TO_CHAR(PO_DIST.PO_HEADER_ID) ) ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 0 0 0 Execute 1 0.01 0.00 0 6 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.02 0.01 0 6 0 0 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 ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE RCV_RECEIVING_SUB_LEDGER (cr=6 pr=0 pw=0 time=79 us) 0 0 0 FILTER (cr=6 pr=0 pw=0 time=74 us) 0 0 0 INLIST ITERATOR (cr=6 pr=0 pw=0 time=71 us) 0 0 0 TABLE ACCESS BY INDEX ROWID RCV_RECEIVING_SUB_LEDGER (cr=6 pr=0 pw=0 time=65 us cost=17 size=51976 card=146) 0 0 0 INDEX RANGE SCAN RCV_RECEIVING_SUB_LEDGER_N5 (cr=6 pr=0 pw=0 time=60 us cost=4 size=0 card=146)(object id 3033299) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=18 size=31 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID PA_COST_DISTRIBUTION_LINES_ALL (cr=0 pr=0 pw=0 time=0 us cost=4 size=11 card=1) 0 0 0 INDEX RANGE SCAN PA_COST_DISTRIBUTION_LINES_N18 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=1)(object id 12681283) 0 0 0 INDEX RANGE SCAN PO_DISTRIBUTIONS_N9 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=29)(object id 44994) 0 0 0 TABLE ACCESS BY INDEX ROWID PO_DISTRIBUTIONS_ALL (cr=0 pr=0 pw=0 time=0 us cost=14 size=20 card=1) ******************************************************************************** SQL ID: 47r1y8yn34jmj Plan Hash: 3213098354 select default$ from col$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.01 1 6 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.01 1 6 0 3 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID COL$ (cr=1 pr=1 pw=0 time=17482 us cost=1 size=15 card=1) 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: 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=15814 us cost=2 size=67 card=1) 1 1 1 INDEX UNIQUE SCAN I_SEQ1 (cr=2 pr=0 pw=0 time=25 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: 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 34 0.00 0.00 0 0 0 0 Fetch 34 0.00 0.01 1 102 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 68 0.00 0.01 1 102 0 6 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=29 us cost=3 size=28 card=1)(object id 13748041) 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: 19x1189chq3xd Plan Hash: 1230426956 SELECT LOCKID FROM DBMS_LOCK_ALLOCATED WHERE NAME = :B1 FOR UPDATE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.01 1 3 0 0 Fetch 1 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.01 1 3 0 0 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 FOR UPDATE (cr=3 pr=1 pw=0 time=14764 us) 0 0 0 TABLE ACCESS BY INDEX ROWID DBMS_LOCK_ALLOCATED (cr=3 pr=1 pw=0 time=14758 us cost=3 size=37 card=1) 0 0 0 INDEX UNIQUE SCAN SYS_C00111358 (cr=3 pr=1 pw=0 time=14754 us cost=2 size=0 card=1)(object id 189077) 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: 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.01 1 13 1 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.01 1 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=1 pw=0 time=14007 us) 1 1 1 NESTED LOOPS (cr=6 pr=1 pw=0 time=13712 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=103 us cost=3 size=17 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=57 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=13602 us cost=0 size=951990 card=14646)(object id 194616) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=114 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=84 us cost=3 size=35 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=47 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONC_PROG_ONSITE_INFO (cr=3 pr=0 pw=0 time=21 us cost=1 size=585840 card=14646) 1 1 1 INDEX UNIQUE SCAN FND_CONC_PROG_ONSITE_INFO_U1 (cr=2 pr=0 pw=0 time=14 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 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: bkqxpv3sxaw48 Plan Hash: 1466524471 SELECT PO.SET_OF_BOOKS_ID FROM FINANCIALS_SYSTEM_PARAMETERS PO 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 1 1 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 1 1 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 INDEX FULL SCAN FINANCIALS_SYSTEM_PARAMS_U1 (cr=1 pr=1 pw=0 time=8014 us cost=1 size=8 card=1)(object id 3022578) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.00 0.00 ******************************************************************************** SQL ID: 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 2 0.01 0.00 0 0 0 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 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: 13ff3f1u2psy0 Plan Hash: 2752293381 SELECT PA_INTERFACE_ID_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 PA_INTERFACE_ID_S (cr=5 pr=0 pw=0 time=1363 us) 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=4 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: 9zc9w298dt0z4 Plan Hash: 1471572175 UPDATE AP_INVOICE_DISTRIBUTIONS_ALL DIST SET DIST.PA_ADDITION_FLAG = 'Y' WHERE DIST.PA_ADDITION_FLAG IN ('O','W') AND DIST.POSTED_FLAG||''= 'Y' AND DIST.PROJECT_ID >0 AND EXISTS ( SELECT 'X' FROM PA_COST_DISTRIBUTION_LINES_ALL CDL WHERE CDL.SYSTEM_REFERENCE2 = TO_CHAR(DIST.INVOICE_ID) AND CDL.SYSTEM_REFERENCE3 = TO_CHAR(DIST.DISTRIBUTION_LINE_NUMBER) AND CDL.SYSTEM_REFERENCE4 IS NULL) 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 23 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 23 0 0 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 ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE AP_INVOICE_DISTRIBUTIONS_ALL (cr=23 pr=0 pw=0 time=121 us) 0 0 0 NESTED LOOPS SEMI (cr=23 pr=0 pw=0 time=121 us cost=3443 size=645 card=5) 0 0 0 INLIST ITERATOR (cr=23 pr=0 pw=0 time=98 us) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=23 pr=0 pw=0 time=95 us cost=215 size=198276 card=1612) 0 0 0 INDEX RANGE SCAN AP_INVOICE_DISTRIBUTIONS_N14 (cr=23 pr=0 pw=0 time=91 us cost=15 size=0 card=1614)(object id 28095) 0 0 0 INDEX RANGE SCAN PA_COST_DISTRIBUTION_LINES_N18 (cr=0 pr=0 pw=0 time=0 us cost=2 size=433950 card=72325)(object id 12681283) ******************************************************************************** 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: 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.01 0.01 log file sync 1 0.00 0.00 ******************************************************************************** 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: 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 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 20 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 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=106 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_NEW_MESSAGES (cr=4 pr=0 pw=0 time=98 us cost=3 size=36 card=1) 1 1 1 INDEX UNIQUE SCAN FND_NEW_MESSAGES_PK (cr=3 pr=0 pw=0 time=46 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: 2bg73wmjuzhgz Plan Hash: 0 begin fnd_conc_stat.store_initial; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 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: 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 2 0.00 0.00 0 0 0 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 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 3 0.00 0.00 SQL*Net message from client 3 0.00 0.00 utl_file I/O 6 0.00 0.00 ******************************************************************************** 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: 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: 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=414 us) 2 2 2 NESTED LOOPS (cr=15 pr=0 pw=0 time=354 us cost=10 size=182 card=1) 1 1 1 NESTED LOOPS (cr=12 pr=0 pw=0 time=322 us cost=7 size=123 card=1) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=55 us cost=4 size=64 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=18 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=34 us cost=1 size=175572 card=14631) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=25 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=263 us cost=3 size=59 card=1) 2 2 2 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=3 pr=0 pw=0 time=43 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=26 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=51 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: dmgp4kwkyw9j4 Plan Hash: 2411438629 SELECT FC.CURRENCY_CODE, FC.MINIMUM_ACCOUNTABLE_UNIT, FC.PRECISION, FC.EXTENDED_PRECISION FROM FND_CURRENCIES FC, GL_SETS_OF_BOOKS GB, PA_IMPLEMENTATIONS IMP WHERE FC.CURRENCY_CODE = DECODE(IMP.SET_OF_BOOKS_ID, NULL, NULL,GB.CURRENCY_CODE) AND GB.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_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 26 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 26 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=26 pr=0 pw=0 time=554 us) 1 1 1 NESTED LOOPS (cr=25 pr=0 pw=0 time=537 us cost=14 size=40 card=1) 1 1 1 NESTED LOOPS (cr=24 pr=0 pw=0 time=510 us cost=13 size=16 card=1) 1 1 1 TABLE ACCESS FULL PA_IMPLEMENTATIONS_ALL (cr=22 pr=0 pw=0 time=427 us cost=12 size=8 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID GL_SETS_OF_BOOKS (cr=2 pr=0 pw=0 time=75 us cost=1 size=8 card=1) 1 1 1 INDEX UNIQUE SCAN GL_SETS_OF_BOOKS_U2 (cr=1 pr=0 pw=0 time=54 us cost=0 size=0 card=1)(object id 34341) 1 1 1 INDEX UNIQUE SCAN FND_CURRENCIES_U1 (cr=1 pr=0 pw=0 time=21 us cost=0 size=0 card=1)(object id 32944) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CURRENCIES (cr=1 pr=0 pw=0 time=6 us cost=1 size=24 card=1) ******************************************************************************** SQL ID: bxb110jg78d8h Plan Hash: 0 begin FND_LOG_REPOSITORY.METRICS_EVENT_INT_WITH_CONTEXT; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 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.01 0.00 0 5 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 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=363 us cost=4 size=59 card=1) 2 2 2 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=3 pr=0 pw=0 time=60 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: 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=293 us) 1 1 1 INDEX RANGE SCAN FND_CONC_PP_ACTIONS_N1 (cr=3 pr=0 pw=0 time=57 us cost=3 size=12 card=1)(object id 34250) ******************************************************************************** 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=114 us) 0 0 0 TABLE ACCESS FULL APPWORX_OA_REQUESTS (cr=8 pr=0 pw=0 time=111 us cost=6 size=7 card=1) ******************************************************************************** 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=309 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=15 us cost=3 size=33 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=11 us cost=2 size=0 card=1)(object id 34547) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 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 2 0.00 0.00 0 0 0 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 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 3 0.00 0.00 SQL*Net message from client 3 0.00 0.00 utl_file I/O 10 0.00 0.00 ******************************************************************************** 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.00 0 1 10 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 10 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=0 pw=0 time=469 us) ******************************************************************************** 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=337 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: fmpbxcbz6q0a1 Plan Hash: 2488038508 UPDATE FND_CONCURRENT_PROCESSES SET PROCESS_STATUS_CODE = 'C', LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = :mgrusrid, LAST_TXN_START = SYSDATE, LAST_TXN_END = NULL WHERE CONCURRENT_PROCESS_ID = :cpid call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 2 14 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 14 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE FND_CONCURRENT_PROCESSES (cr=2 pr=0 pw=0 time=341 us) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROCESSES_U1 (cr=2 pr=0 pw=0 time=29 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: 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.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=89 us cost=3 size=13 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=61 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: 6n8fupurfn65u Plan Hash: 0 INSERT INTO FND_LOGINS ( LOGIN_ID, USER_ID, START_TIME, END_TIME, PID, SPID, TERMINAL_ID, LOGIN_NAME, SUBMITTED_LOGIN_ID) VALUES ( :B3 , :B2 , SYSDATE, NULL, NULL, NULL, 'Concurrent', NULL, :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 1 9 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 9 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=0 pw=0 time=294 us) ******************************************************************************** SQL ID: 8kywbuyrsrs61 Plan Hash: 316359079 SELECT O.ORACLE_USERNAME FROM FND_DATA_GROUP_UNITS U, FND_RESPONSIBILITY R, FND_ORACLE_USERID O WHERE R.APPLICATION_ID = :B3 AND R.RESPONSIBILITY_ID = :B2 AND R.DATA_GROUP_ID = U.DATA_GROUP_ID AND O.ORACLE_ID = U.ORACLE_ID AND U.APPLICATION_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 8 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 8 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=8 pr=0 pw=0 time=175 us cost=4 size=36 card=1) 1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=138 us cost=3 size=26 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY (cr=3 pr=0 pw=0 time=74 us cost=2 size=13 card=1) 1 1 1 INDEX UNIQUE SCAN FND_RESPONSIBILITY_U1 (cr=2 pr=0 pw=0 time=51 us cost=1 size=0 card=1)(object id 33329) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_DATA_GROUP_UNITS (cr=3 pr=0 pw=0 time=57 us cost=1 size=78 card=6) 1 1 1 INDEX UNIQUE SCAN FND_DATA_GROUP_UNITS_U1 (cr=2 pr=0 pw=0 time=45 us cost=0 size=0 card=1)(object id 33145) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_ORACLE_USERID (cr=2 pr=0 pw=0 time=25 us cost=1 size=2740 card=274) 1 1 1 INDEX UNIQUE SCAN FND_ORACLE_USERID_U1 (cr=1 pr=0 pw=0 time=13 us cost=0 size=0 card=1)(object id 22603) ******************************************************************************** SQL ID: b5fkujz3m7d0n Plan Hash: 9647643 SELECT ORG_ID FROM PA_IMPLEMENTATIONS 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 22 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 22 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 FULL PA_IMPLEMENTATIONS_ALL (cr=22 pr=0 pw=0 time=289 us cost=12 size=4 card=1) ******************************************************************************** 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: dp3npaf9rbc6d Plan Hash: 1133168885 SELECT NUMBER_OF_COPIES, PRINT_STYLE, PRINTER, SAVE_OUTPUT_FLAG FROM FND_CONCURRENT_REQUESTS R WHERE R.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=46 us cost=3 size=33 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=34 us cost=2 size=0 card=1)(object id 34547) ******************************************************************************** SQL ID: 4zzxr8rvht74z Plan Hash: 3329548962 select case when (bitand(u.spare1, 16) = 0) then 0 when (u.type# = 2) then (u.spare2) else 1 end from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user# 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: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=52 us cost=4 size=32 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=3 pr=0 pw=0 time=31 us cost=3 size=10 card=1)(object id 26619161) 1 1 1 INDEX RANGE SCAN I_USER2 (cr=2 pr=0 pw=0 time=18 us cost=1 size=22 card=1)(object id 26619168) ******************************************************************************** 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=172 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=25 us cost=3 size=129 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) 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: 4qubzzmwfhjun Plan Hash: 0 SAVEPOINT PAAPIMP 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: a8jp42bm45y6m Plan Hash: 1335202565 SELECT WIDTH, LENGTH FROM FND_PRINTER_STYLES WHERE PRINTER_STYLE_NAME = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_PRINTER_STYLES (cr=2 pr=0 pw=0 time=44 us cost=1 size=24 card=1) 1 1 1 INDEX UNIQUE SCAN FND_PRINTER_STYLES_U1 (cr=1 pr=0 pw=0 time=23 us cost=0 size=0 card=1)(object id 32929) ******************************************************************************** SQL ID: 11q8rsmgwdk2v Plan Hash: 3938761318 SELECT COUNT(*) FROM FND_LANGUAGES L WHERE NLS_LANGUAGE = :B1 AND L.INSTALLED_FLAG IN ('I', 'B') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 4 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=2 pr=0 pw=0 time=46 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LANGUAGES (cr=2 pr=0 pw=0 time=32 us cost=1 size=12 card=1) 1 1 1 INDEX UNIQUE SCAN FND_LANGUAGES_U5 (cr=1 pr=0 pw=0 time=15 us cost=0 size=0 card=1)(object id 33042) ******************************************************************************** SQL ID: 69t3guckz55cv Plan Hash: 3104236589 SELECT DECODE(O.AW_AGENT_STATE,' ','N',NULL,'N',O.AW_AGENT_STATE) FROM APPWORX_AGENT_TABLE O call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS FULL APPWORX_AGENT_TABLE (cr=2 pr=0 pw=0 time=65 us cost=4 size=2 card=1) ******************************************************************************** SQL ID: 94c3fmw2bkjnq Plan Hash: 797509339 SELECT FND_LOGINS_S.NEXTVAL FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SEQUENCE FND_LOGINS_S (cr=0 pr=0 pw=0 time=87 us) 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=2 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: am4qbdr7da9wj Plan Hash: 2863542513 select owner#, status from obj$ o where obj# = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 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: 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=49 us cost=4 size=13 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=3 pr=0 pw=0 time=40 us cost=3 size=0 card=1)(object id 26619161) ******************************************************************************** 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=28 us) 0 0 0 INDEX RANGE SCAN FND_LOG_METRICS_N1 (cr=0 pr=0 pw=0 time=10 us cost=1 size=13 card=1)(object id 253051) ******************************************************************************** SQL ID: dpunsxc5h18jk Plan Hash: 908228062 SELECT PRINTER_TYPE FROM FND_PRINTER WHERE PRINTER_NAME = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_PRINTER (cr=3 pr=0 pw=0 time=37 us cost=2 size=27 card=1) 1 1 1 INDEX UNIQUE SCAN FND_PRINTER_U1 (cr=2 pr=0 pw=0 time=24 us cost=1 size=0 card=1)(object id 32810) ******************************************************************************** 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=28 us cost=2 size=40 card=2) 0 0 0 INDEX RANGE SCAN FND_LOG_TRANSACTION_CONTEXT_N2 (cr=2 pr=0 pw=0 time=26 us cost=1 size=0 card=2)(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: 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: 8kkvf5rdy9ay6 Plan Hash: 1394681996 SELECT PRINTER_STYLE_NAME FROM FND_PRINTER_STYLES WHERE PRINTER_STYLE_NAME = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 1 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 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 INDEX UNIQUE SCAN FND_PRINTER_STYLES_U1 (cr=1 pr=0 pw=0 time=15 us cost=0 size=16 card=1)(object id 32929) ******************************************************************************** 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=32 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=10 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=12 us cost=1 size=175572 card=14631) 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: 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=17 us cost=3 size=11 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=10 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: 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=19 us cost=3 size=34 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=13 us cost=2 size=0 card=1)(object id 34547) ******************************************************************************** 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=39 us) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=15 us cost=2 size=7 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=1 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: 5cnnyd0zar0bq Plan Hash: 3541374276 SELECT DBMS_LOCK_ID.NEXTVAL 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: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SEQUENCE DBMS_LOCK_ID (cr=0 pr=0 pw=0 time=43 us) 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=2 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: 90kv3kupxjg3a Plan Hash: 0 lock table FND_CONCURRENT_REQUESTS in share update mode call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 9uv7yykmy4s7b Plan Hash: 1546270724 SELECT SUBSTR(USERENV('LANGUAGE'),1, INSTR(USERENV('LANGUAGE'), '_') -1) FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: g62g971m56fp6 Plan Hash: 4085560204 SELECT 'X' FROM FND_PRINTER_INFORMATION WHERE PRINTER_STYLE = :B2 AND PRINTER_TYPE = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 INDEX UNIQUE SCAN FND_PRINTER_INFORMATION_U1 (cr=2 pr=0 pw=0 time=20 us cost=1 size=25 card=1)(object id 32893) ******************************************************************************** SQL ID: 95w5r9gccgbpd Plan Hash: 3491039489 SELECT FND_CONCURRENT_REQUESTS_S.NEXTVAL FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SEQUENCE FND_CONCURRENT_REQUESTS_S (cr=0 pr=0 pw=0 time=54 us) 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=2 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: gg2vzguu4z5nn Plan Hash: 1546270724 SELECT SUBSTR ( USERENV('LANGUAGE') , INSTR ( USERENV('LANGUAGE') , '_') + 1, (INSTR ( USERENV('LANGUAGE') , '.') - 1 - INSTR ( USERENV('LANGUAGE') , '_') )) FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: dgxcxyvy4gb1a Plan Hash: 3491373453 SELECT SUBMITTED_LOGIN_ID FROM FND_LOGINS WHERE LOGIN_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOGINS (cr=3 pr=0 pw=0 time=34 us cost=3 size=13 card=1) 1 1 1 INDEX UNIQUE SCAN FND_LOGINS_U1 (cr=2 pr=0 pw=0 time=24 us cost=2 size=0 card=1)(object id 33197) ******************************************************************************** SQL ID: 6wb81d55us7fp Plan Hash: 0 SAVEPOINT START_OF_SUBMISSION call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 173 (recursive depth: 1) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 28 0.00 0.00 0 0 0 0 Execute 35 0.09 0.45 17 40 55 19 Fetch 15 0.01 0.09 4 73 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 78 0.10 0.55 21 113 55 33 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 71 0.00 0.00 SQL*Net message from client 71 0.01 0.03 Disk file operations I/O 3 0.00 0.00 db file sequential read 9 0.15 0.30 direct path read 6 0.03 0.10 utl_file I/O 90 0.00 0.00 log file sync 5 0.00 0.00 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 92 0.05 0.07 0 0 0 0 Execute 220 339.91 4367.76 1346346 17821092 99 7 Fetch 479 0.08 2.33 188 1427 1 411 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 791 340.04 4370.17 1346534 17822519 100 418 Misses in library cache during parse: 12 Misses in library cache during execute: 4 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 34 0.00 0.00 db file sequential read 614253 0.36 3583.41 db file scattered read 91980 0.26 517.47 latch: cache buffers chains 12 0.00 0.00 71 user SQL statements in session. 24 internal SQL statements in session. 95 SQL statements in session. 0 statements EXPLAINed in this session. ******************************************************************************** Trace file: betsyu1_ora_6609_NISHANT_RANJ_CR259240715.trc Trace file compatibility: 11.1.0.7 Sort options: prsela exeela fchela 1 session in tracefile. 71 user SQL statements in trace file. 24 internal SQL statements in trace file. 95 SQL statements in trace file. 95 unique SQL statements in trace file. 717148 lines in trace file. 4370 elapsed seconds in trace file.