TKPROF: Release 19.0.0.0.0 - Development on Thu Nov 21 11:13:15 2024
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Trace file: UPANB1_ora_68727_A08527_CR16623574_1121_102813.trc
Sort options: exeela fchela
********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
********************************************************************************
SQL ID: 7tdzht6rt7mjx Plan Hash: 3649782554
SELECT 1 REC_SEQ ,CPCMB.BALANCE_LINE_ID ,CPCMB.IR_MATCH_ID ,
CPCMB.PROCVAR_MATCH_ID ,CPCMB.INVOICE_ID ,CPCMB.INVOICE_DISTRIBUTION_ID ,
NULL IPV_CCID ,NULL ERV_CCID ,CPCMB.INVOICE_DATE ,CPCMB.INVOICE_NUM ,
CPCMB.INVOICE_LINE_NUMBER ,CPCMB.INVENTORY_ITEM_ID ,NULL
DISTRIBUTION_AMOUNT ,NULL QUANTITY_INVOICED ,CPCMB.MATCH_LINE_UOM
INVOICE_UOM ,NULL ORGANIZATION_ID ,CPCMB.BALANCE_QUANTITY MATCHED_QUANTITY ,
CPCMB.BALANCE_IPV MATCHED_IPV ,CPCMB.BALANCE_ERV MATCHED_ERV ,NULL
PO_DISTRIBUTION_ID
FROM
CLE_F145_PC_CM_MATCH_BAL CPCMB WHERE NVL ( CPCMB.MATCHED_FLAG, 'N' ) = 'N'
AND CPCMB.LEGAL_ENTITY_ID = :B3 AND CPCMB.COST_GROUP_ID = :B2 AND
CPCMB.COST_TYPE_ID = :B1 AND EXISTS ( SELECT 1 FROM XLE_LE_OU_LEDGER_V XLE
WHERE CPCMB.ORG_ID = XLE.OPERATING_UNIT_ID AND XLE.LEGAL_ENTITY_ID = :B3 )
UNION SELECT 2 REC_SEQ ,NULL BALANCE_LINE_ID ,NULL IR_MATCH_ID ,
CPM.PROCVAR_MATCH_ID ,CPM.INVOICE_ID ,CPM.INVOICE_DISTRIBUTION_ID ,
CPM.IPV_CCID ,CPM.ERV_CCID ,CPM.INVOICE_DATE ,CPM.INVOICE_NUM ,
CPM.INVOICE_LINE_NUMBER ,CPM.INVENTORY_ITEM_ID ,DECODE (
AIA.INVOICE_CURRENCY_CODE ,:B5 , AILA.AMOUNT ,AILA.BASE_AMOUNT )
DISTRIBUTION_AMOUNT ,AILA.QUANTITY_INVOICED ,AILA.UNIT_MEAS_LOOKUP_CODE
INVOICE_UOM ,RCT.ORGANIZATION_ID ,CPM.MATCHED_QUANTITY ,CPM.MATCHED_IPV ,
CPM.MATCHED_ERV ,RCT.PO_DISTRIBUTION_ID FROM CLE_F145_PROCVAR_MATCHES CPM ,
AP_INVOICE_DISTRIBUTIONS AID ,AP_INVOICES AIA ,AP_INVOICE_LINES AILA ,
RCV_TRANSACTIONS RCT WHERE CPM.LEGAL_ENTITY_ID = :B3 AND CPM.COST_TYPE_ID =
:B1 AND CPM.COST_GROUP_ID = :B2 AND CPM.PROCESSED_PERIOD_ID = :B4 AND
CPM.INVOICE_ID = AIA.INVOICE_ID AND AIA.INVOICE_ID = AID.INVOICE_ID AND
AILA.INVOICE_ID = AIA.INVOICE_ID AND AILA.LINE_NUMBER =
CPM.INVOICE_LINE_NUMBER AND RCT.TRANSACTION_ID = CPM.RCV_TRANSACTION_ID AND
CPM.INVOICE_DISTRIBUTION_ID = AID.INVOICE_DISTRIBUTION_ID AND
CPM.PROCESSED_FLAG = 'Y' AND NVL ( CPM.OP_FLAG, 'N' ) = 'N' AND NOT EXISTS
( SELECT 1 FROM CLE_F145_PC_CM_MATCH_DATA CPCMD WHERE
CPCMD.PROCVAR_MATCH_ID = CPM.PROCVAR_MATCH_ID ) AND NOT EXISTS ( SELECT 1
FROM CLE_F145_PC_CM_MATCH_BAL CPCMB WHERE CPCMB.PROCVAR_MATCH_ID =
CPM.PROCVAR_MATCH_ID AND CPCMB.MATCHED_FLAG = 'Y' ) AND EXISTS ( SELECT 1
FROM AP_INVOICE_LINES AILA1 WHERE AILA1.CORRECTED_INV_ID = CPM.INVOICE_ID
AND AILA1.CORRECTED_LINE_NUMBER = CPM.INVOICE_LINE_NUMBER ) AND EXISTS (
SELECT 1 FROM XLE_LE_OU_LEDGER_V XLE WHERE CPM.ORG_ID =
XLE.OPERATING_UNIT_ID AND XLE.LEGAL_ENTITY_ID = :B3 ) UNION SELECT 2
REC_SEQ ,NULL BALANCE_LINE_ID ,CIRM.IR_MATCH_ID ,NULL PROCVAR_MATCH_ID ,
CIRM.INVOICE_ID ,CIRM.INVOICE_DISTRIBUTION_ID ,NULL IPV_CCID ,NULL ERV_CCID
,CIRM.INVOICE_DATE ,CIRM.INVOICE_NUM ,CIRM.INVOICE_LINE_NUMBER ,
CIRM.INVENTORY_ITEM_ID ,DECODE ( AIA.INVOICE_CURRENCY_CODE ,:B5 ,
AILA.AMOUNT ,AILA.BASE_AMOUNT ) DISTRIBUTION_AMOUNT ,AILA.QUANTITY_INVOICED
,AILA.UNIT_MEAS_LOOKUP_CODE INVOICE_UOM ,RCT.ORGANIZATION_ID ,
CIRM.MATCHED_QUANTITY ,CIRM.MATCHED_IPV ,CIRM.MATCHED_ERV ,
RCT.PO_DISTRIBUTION_ID FROM CLE_F145_INV_RECEIPT_MATCHES CIRM ,
AP_INVOICE_DISTRIBUTIONS AID ,AP_INVOICES AIA ,AP_INVOICE_LINES AILA ,
RCV_TRANSACTIONS RCT WHERE CIRM.LEGAL_ENTITY_ID = :B3 AND CIRM.COST_TYPE_ID
= :B1 AND CIRM.COST_GROUP_ID = :B2 AND CIRM.INVOICE_ID = AIA.INVOICE_ID AND
AIA.INVOICE_ID = AID.INVOICE_ID AND AILA.INVOICE_ID = AIA.INVOICE_ID AND
AILA.LINE_NUMBER = CIRM.INVOICE_LINE_NUMBER AND RCT.TRANSACTION_ID =
CIRM.RCV_TRANSACTION_ID AND CIRM.INVOICE_DISTRIBUTION_ID =
AID.INVOICE_DISTRIBUTION_ID AND NVL ( CIRM.OP_FLAG, 'N' ) = 'N' AND NOT
EXISTS ( SELECT 1 FROM CLE_F145_PC_CM_MATCH_DATA CPCMD WHERE
CPCMD.IR_MATCH_ID = CIRM.IR_MATCH_ID ) AND NOT EXISTS ( SELECT 1 FROM
CLE_F145_PC_CM_MATCH_BAL CPCMB WHERE CPCMB.IR_MATCH_ID = CIRM.IR_MATCH_ID
AND CPCMB.MATCHED_FLAG = 'Y' ) AND (EXISTS (SELECT 1 FROM
AP_INVOICE_DISTRIBUTIONS AID2, CST_PAC_PERIODS CPP WHERE CPP.LEGAL_ENTITY =
:B3 AND CPP.COST_TYPE_ID = :B1 AND CPP.PAC_PERIOD_ID = :B4 AND
AID2.CORRECTED_INVOICE_DIST_ID = AID.INVOICE_DISTRIBUTION_ID AND
TRUNC(AID2.ACCOUNTING_DATE) BETWEEN CPP.PERIOD_START_DATE AND
CPP.PERIOD_END_DATE) OR EXISTS (SELECT 1 FROM AP_INVOICE_DISTRIBUTIONS AID3,
CST_PAC_PERIODS CPP WHERE CPP.LEGAL_ENTITY = :B3 AND CPP.COST_TYPE_ID =
:B1 AND CPP.PAC_PERIOD_ID = :B4 AND AID3.PARENT_INVOICE_ID = AID.INVOICE_ID
AND AID3.PO_DISTRIBUTION_ID = AID.PO_DISTRIBUTION_ID AND
TRUNC(AID3.ACCOUNTING_DATE) BETWEEN CPP.PERIOD_START_DATE AND
CPP.PERIOD_END_DATE) ) AND EXISTS ( SELECT 1 FROM XLE_LE_OU_LEDGER_V XLE
WHERE CIRM.ORG_ID = XLE.OPERATING_UNIT_ID AND XLE.LEGAL_ENTITY_ID = :B3 )
ORDER BY REC_SEQ, INVOICE_DATE
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.06 0.06 0 6 0 0
Execute 1 3.27 3.32 0 0 0 0
Fetch 1 1790.81 1936.00 82979 95350 56374 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 1794.16 1939.40 82979 95356 56374 0
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 SORT UNIQUE (cr=0 pr=0 pw=0 time=16 us starts=1 cost=33161 size=1342 card=3)
0 0 0 UNION-ALL (cr=0 pr=0 pw=0 time=12 us starts=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=37 us starts=1 cost=9 size=407 card=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=36 us starts=1 cost=9 size=407 card=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=36 us starts=1 cost=8 size=387 card=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=36 us starts=1 cost=8 size=383 card=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=35 us starts=1 cost=7 size=364 card=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=35 us starts=1 cost=7 size=360 card=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=35 us starts=1 cost=6 size=347 card=1)
0 0 0 MERGE JOIN CARTESIAN (cr=2 pr=0 pw=0 time=35 us starts=1 cost=5 size=330 card=1)
0 0 0 MERGE JOIN CARTESIAN (cr=2 pr=0 pw=0 time=32 us starts=1 cost=4 size=301 card=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=26 us starts=1 cost=3 size=270 card=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=26 us starts=1 cost=3 size=270 card=2)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=26 us starts=1 cost=3 size=241 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID XLE_ENTITY_PROFILES (cr=2 pr=0 pw=0 time=21 us starts=1 cost=1 size=7 card=1)
1 1 1 INDEX UNIQUE SCAN XLE_ENTITY_PROFILES_U1 (cr=1 pr=0 pw=0 time=7 us starts=1 cost=0 size=0 card=1)(object id 8443303)
0 0 0 TABLE ACCESS FULL CLE_F145_PC_CM_MATCH_BAL (cr=0 pr=0 pw=0 time=5 us starts=1 cost=2 size=234 card=1)
0 0 0 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=2)(object id 8406447)
0 0 0 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=29 card=1)
0 0 0 BUFFER SORT (cr=0 pr=0 pw=0 time=0 us starts=0 cost=4 size=31 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED XLE_REGISTRATIONS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=31 card=1)
0 0 0 INDEX RANGE SCAN XLE_REGISTRATIONS_N2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 8429964)
0 0 0 BUFFER SORT (cr=0 pr=0 pw=0 time=0 us starts=0 cost=4 size=58 card=2)
0 0 0 INDEX SKIP SCAN GL_LEDGER_RELATIONSHIPS_U2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=58 card=2)(object id 8437308)
0 0 0 TABLE ACCESS BY INDEX ROWID GL_LEDGERS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=17 card=1)
0 0 0 INDEX UNIQUE SCAN GL_LEDGERS_U2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 8442265)
0 0 0 TABLE ACCESS BY INDEX ROWID GL_LEDGERS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=13 card=1)
0 0 0 INDEX UNIQUE SCAN GL_LEDGERS_U2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 8442265)
0 0 0 INDEX UNIQUE SCAN GL_LEDGER_CONFIGURATIONS_U1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=4 card=1)(object id 8433389)
0 0 0 INDEX RANGE SCAN GL_LEDGER_CONFIG_DETAILS_U1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=95 card=5)(object id 8425766)
0 0 0 INDEX UNIQUE SCAN HR_LOCATIONS_PK (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=4 card=1)(object id 8429013)
0 0 0 INDEX RANGE SCAN XXPLSTR_MTL_MATERIAL_TRANS_N1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 8406448)
0 0 0 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=20 card=1)
0 0 0 HASH JOIN ANTI (cr=22 pr=0 pw=0 time=1312 us starts=1 cost=19 size=527 card=1)
0 0 0 HASH JOIN ANTI (cr=22 pr=0 pw=0 time=1165 us starts=1 cost=17 size=512 card=1)
0 0 0 NESTED LOOPS SEMI (cr=22 pr=0 pw=0 time=1067 us starts=1 cost=15 size=499 card=1)
0 0 0 NESTED LOOPS (cr=22 pr=0 pw=0 time=1064 us starts=1 cost=15 size=492 card=1)
0 0 0 NESTED LOOPS (cr=22 pr=0 pw=0 time=1064 us starts=1 cost=14 size=477 card=1)
0 0 0 NESTED LOOPS (cr=22 pr=0 pw=0 time=1064 us starts=1 cost=13 size=450 card=1)
0 0 0 NESTED LOOPS (cr=22 pr=0 pw=0 time=1063 us starts=1 cost=12 size=434 card=1)
0 0 0 HASH JOIN (cr=22 pr=0 pw=0 time=1062 us starts=1 cost=12 size=421 card=1)
1 1 1 NESTED LOOPS (cr=22 pr=0 pw=0 time=861 us starts=1 cost=10 size=173 card=1)
1 1 1 MERGE JOIN CARTESIAN (cr=21 pr=0 pw=0 time=858 us starts=1 cost=10 size=169 card=1)
1 1 1 NESTED LOOPS (cr=19 pr=0 pw=0 time=803 us starts=1 cost=9 size=138 card=1)
1 1 1 NESTED LOOPS (cr=18 pr=0 pw=0 time=611 us starts=1 cost=8 size=119 card=1)
1 1 1 NESTED LOOPS (cr=16 pr=0 pw=0 time=603 us starts=1 cost=7 size=90 card=1)
2 2 2 NESTED LOOPS (cr=13 pr=0 pw=0 time=573 us starts=1 cost=6 size=70 card=1)
2 2 2 NESTED LOOPS (cr=11 pr=0 pw=0 time=357 us starts=1 cost=6 size=66 card=1)
2 2 2 NESTED LOOPS (cr=7 pr=0 pw=0 time=349 us starts=1 cost=4 size=98 card=2)
2 2 2 NESTED LOOPS (cr=3 pr=0 pw=0 time=326 us starts=1 cost=2 size=72 card=2)
1 1 1 TABLE ACCESS BY INDEX ROWID XLE_ENTITY_PROFILES (cr=2 pr=0 pw=0 time=6 us starts=1 cost=1 size=7 card=1)
1 1 1 INDEX UNIQUE SCAN XLE_ENTITY_PROFILES_U1 (cr=1 pr=0 pw=0 time=4 us starts=1 cost=0 size=0 card=1)(object id 8443303)
2 2 2 INDEX SKIP SCAN GL_LEDGER_RELATIONSHIPS_U2 (cr=1 pr=0 pw=0 time=319 us starts=1 cost=1 size=58 card=2)(object id 8437308)
2 2 2 TABLE ACCESS BY INDEX ROWID GL_LEDGERS (cr=4 pr=0 pw=0 time=21 us starts=2 cost=1 size=13 card=1)
2 2 2 INDEX UNIQUE SCAN GL_LEDGERS_U2 (cr=2 pr=0 pw=0 time=7 us starts=2 cost=0 size=0 card=1)(object id 8442265)
2 2 2 TABLE ACCESS BY INDEX ROWID GL_LEDGERS (cr=4 pr=0 pw=0 time=4 us starts=2 cost=1 size=17 card=1)
2 2 2 INDEX UNIQUE SCAN GL_LEDGERS_U2 (cr=2 pr=0 pw=0 time=1 us starts=2 cost=0 size=0 card=1)(object id 8442265)
2 2 2 INDEX UNIQUE SCAN GL_LEDGER_CONFIGURATIONS_U1 (cr=2 pr=0 pw=0 time=215 us starts=2 cost=0 size=4 card=1)(object id 8433389)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED HR_ORGANIZATION_INFORMATION (cr=3 pr=0 pw=0 time=25 us starts=2 cost=1 size=20 card=1)
1 1 1 INDEX RANGE SCAN XXPLSTR_MTL_MATERIAL_TRANS_N1 (cr=2 pr=0 pw=0 time=18 us starts=2 cost=0 size=0 card=1)(object id 8406448)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED HR_ORGANIZATION_INFORMATION (cr=2 pr=0 pw=0 time=8 us starts=1 cost=1 size=29 card=1)
1 1 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_IX1 (cr=1 pr=0 pw=0 time=4 us starts=1 cost=0 size=0 card=1)(object id 8406446)
1 1 1 INDEX RANGE SCAN GL_LEDGER_CONFIG_DETAILS_U1 (cr=1 pr=0 pw=0 time=191 us starts=1 cost=1 size=95 card=5)(object id 8425766)
1 1 1 BUFFER SORT (cr=2 pr=0 pw=0 time=52 us starts=1 cost=9 size=31 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED XLE_REGISTRATIONS (cr=2 pr=0 pw=0 time=9 us starts=1 cost=1 size=31 card=1)
1 1 1 INDEX RANGE SCAN XLE_REGISTRATIONS_N2 (cr=1 pr=0 pw=0 time=4 us starts=1 cost=0 size=0 card=1)(object id 8429964)
1 1 1 INDEX UNIQUE SCAN HR_LOCATIONS_PK (cr=1 pr=0 pw=0 time=2 us starts=1 cost=0 size=4 card=1)(object id 8429013)
0 0 0 TABLE ACCESS FULL CLE_F145_PROCVAR_MATCHES (cr=0 pr=0 pw=0 time=4 us starts=1 cost=2 size=248 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=13 card=1)
0 0 0 INDEX UNIQUE SCAN AP_INVOICES_U1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 8429576)
0 0 0 TABLE ACCESS BY INDEX ROWID RCV_TRANSACTIONS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=16 card=1)
0 0 0 INDEX UNIQUE SCAN RCV_TRANSACTIONS_U1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 8402558)
0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_LINES_ALL (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=27 card=1)
0 0 0 INDEX UNIQUE SCAN AP_INVOICE_LINES_U1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 8443677)
0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=15 card=1)
0 0 0 INDEX UNIQUE SCAN AP_INVOICE_DISTRIBUTIONS_U2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 8428209)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED AP_INVOICE_LINES_ALL (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=7 card=1)
0 0 0 INDEX RANGE SCAN AP_INVOICE_LINES_N6 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 8443684)
0 0 0 TABLE ACCESS FULL CLE_F145_PC_CM_MATCH_DATA (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=13 card=1)
0 0 0 TABLE ACCESS FULL CLE_F145_PC_CM_MATCH_BAL (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=15 card=1)
0 0 0 MERGE JOIN (cr=0 pr=0 pw=0 time=21 us starts=1 cost=33133 size=408 card=1)
0 0 0 SORT JOIN (cr=0 pr=0 pw=0 time=21 us starts=1 cost=33129 size=678888 card=1796)
2182911330 2182911330 2182911330 MERGE JOIN CARTESIAN (cr=95326 pr=82973 pw=0 time=338302182 us starts=1 cost=33128 size=678888 card=1796)
1559 1559 1559 NESTED LOOPS ANTI (cr=15273 pr=3032 pw=0 time=1027943 us starts=1 cost=11361 size=360 card=1)
1559 1559 1559 NESTED LOOPS ANTI (cr=15273 pr=3032 pw=0 time=1020971 us starts=1 cost=11361 size=347 card=1)
1559 1559 1559 NESTED LOOPS (cr=15273 pr=3032 pw=0 time=1016413 us starts=1 cost=11361 size=332 card=1)
1559 1559 1559 NESTED LOOPS (cr=11512 pr=3030 pw=0 time=992311 us starts=1 cost=11359 size=316 card=1)
1559 1559 1559 HASH JOIN (cr=10082 pr=2900 pw=0 time=889089 us starts=1 cost=11091 size=39932 card=134)
68929 68929 68929 HASH JOIN (cr=9241 pr=2212 pw=0 time=356928 us starts=1 cost=2823 size=4235188 card=15628)
102159 102159 102159 TABLE ACCESS FULL AP_INVOICES_ALL (cr=6143 pr=40 pw=0 time=127693 us starts=1 cost=1659 size=1328067 card=102159)
68929 68929 68929 HASH JOIN (cr=3098 pr=2172 pw=0 time=245908 us starts=1 cost=842 size=4032024 card=15628)
1 1 1 NESTED LOOPS (cr=45 pr=3 pw=0 time=2766 us starts=1 cost=16 size=173 card=1)
1 1 1 NESTED LOOPS (cr=44 pr=3 pw=0 time=2761 us starts=1 cost=16 size=173 card=1)
2 2 2 NESTED LOOPS (cr=42 pr=3 pw=0 time=2528 us starts=1 cost=15 size=160 card=1)
1 1 1 HASH JOIN (cr=41 pr=3 pw=0 time=2742 us starts=1 cost=14 size=131 card=1)
1 1 1 NESTED LOOPS (cr=11 pr=0 pw=0 time=79 us starts=1 cost=5 size=114 card=1)
1 1 1 MERGE JOIN CARTESIAN (cr=10 pr=0 pw=0 time=76 us starts=1 cost=5 size=110 card=1)
1 1 1 NESTED LOOPS (cr=9 pr=0 pw=0 time=60 us starts=1 cost=4 size=91 card=1)
1 1 1 NESTED LOOPS (cr=8 pr=0 pw=0 time=58 us starts=1 cost=4 size=87 card=1)
1 1 1 MERGE JOIN CARTESIAN (cr=6 pr=0 pw=0 time=53 us starts=1 cost=3 size=67 card=1)
1 1 1 NESTED LOOPS (cr=4 pr=0 pw=0 time=25 us starts=1 cost=2 size=36 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID XLE_ENTITY_PROFILES (cr=2 pr=0 pw=0 time=13 us starts=1 cost=1 size=7 card=1)
1 1 1 INDEX UNIQUE SCAN XLE_ENTITY_PROFILES_U1 (cr=1 pr=0 pw=0 time=7 us starts=1 cost=0 size=0 card=1)(object id 8443303)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED HR_ORGANIZATION_INFORMATION (cr=2 pr=0 pw=0 time=9 us starts=1 cost=1 size=29 card=1)
1 1 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_IX1 (cr=1 pr=0 pw=0 time=5 us starts=1 cost=0 size=0 card=1)(object id 8406446)
1 1 1 BUFFER SORT (cr=2 pr=0 pw=0 time=22 us starts=1 cost=2 size=31 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED XLE_REGISTRATIONS (cr=2 pr=0 pw=0 time=13 us starts=1 cost=1 size=31 card=1)
1 1 1 INDEX RANGE SCAN XLE_REGISTRATIONS_N2 (cr=1 pr=0 pw=0 time=4 us starts=1 cost=0 size=0 card=1)(object id 8429964)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED HR_ORGANIZATION_INFORMATION (cr=2 pr=0 pw=0 time=5 us starts=1 cost=1 size=20 card=1)
1 1 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (cr=1 pr=0 pw=0 time=4 us starts=1 cost=0 size=0 card=1)(object id 8406447)
1 1 1 INDEX UNIQUE SCAN HR_LOCATIONS_PK (cr=1 pr=0 pw=0 time=2 us starts=1 cost=0 size=4 card=1)(object id 8429013)
1 1 1 BUFFER SORT (cr=1 pr=0 pw=0 time=11 us starts=1 cost=5 size=95 card=5)
1 1 1 INDEX SKIP SCAN GL_LEDGER_CONFIG_DETAILS_U1 (cr=1 pr=0 pw=0 time=8 us starts=1 cost=1 size=95 card=5)(object id 8425766)
1 1 1 INDEX UNIQUE SCAN GL_LEDGER_CONFIGURATIONS_U1 (cr=1 pr=0 pw=0 time=2 us starts=1 cost=0 size=4 card=1)(object id 8433389)
1 1 1 TABLE ACCESS FULL GL_LEDGERS (cr=30 pr=3 pw=0 time=2386 us starts=1 cost=9 size=17 card=1)
2 2 2 INDEX FULL SCAN GL_LEDGER_RELATIONSHIPS_U2 (cr=1 pr=0 pw=0 time=10 us starts=1 cost=1 size=29 card=1)(object id 8437308)
1 1 1 INDEX UNIQUE SCAN GL_LEDGERS_U2 (cr=2 pr=0 pw=0 time=6 us starts=2 cost=0 size=0 card=1)(object id 8442265)
1 1 1 TABLE ACCESS BY INDEX ROWID GL_LEDGERS (cr=1 pr=0 pw=0 time=3 us starts=1 cost=1 size=13 card=1)
68929 68929 68929 TABLE ACCESS FULL CLE_F145_INV_RECEIPT_MATCHES (cr=3053 pr=2169 pw=0 time=240037 us starts=1 cost=826 size=5858965 card=68929)
14523 14523 14523 TABLE ACCESS FULL AP_INVOICE_LINES_ALL (cr=841 pr=688 pw=0 time=21285 us starts=1 cost=7188 size=12714246 card=470898)
1559 1559 1559 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=1430 pr=130 pw=0 time=274702 us starts=1559 cost=2 size=18 card=1)
1559 1559 1559 INDEX UNIQUE SCAN AP_INVOICE_DISTRIBUTIONS_U2 (cr=1054 pr=8 pw=0 time=19404 us starts=1559 cost=1 size=0 card=1)(object id 8428209)
1559 1559 1559 TABLE ACCESS BY INDEX ROWID RCV_TRANSACTIONS (cr=3761 pr=2 pw=0 time=26231 us starts=1559 cost=2 size=16 card=1)
1559 1559 1559 INDEX UNIQUE SCAN RCV_TRANSACTIONS_U1 (cr=2202 pr=2 pw=0 time=14446 us starts=1559 cost=1 size=0 card=1)(object id 8402558)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED CLE_F145_PC_CM_MATCH_BAL (cr=0 pr=0 pw=0 time=3460 us starts=1559 cost=0 size=15 card=1)
0 0 0 INDEX RANGE SCAN CLE_F145_PC_CM_MATCH_BAL_N1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 8404090)
0 0 0 INDEX RANGE SCAN CLE_F145_PC_CM_MATCH_DATA_N1 (cr=0 pr=0 pw=0 time=2993 us starts=1559 cost=0 size=13 card=1)(object id 8441814)
2182911330 2182911330 2182911330 BUFFER SORT (cr=80053 pr=79941 pw=0 time=180301953 us starts=1559 cost=33128 size=25212582 card=1400699)
1400699 1400699 1400699 TABLE ACCESS FULL AP_INVOICE_DISTRIBUTIONS_ALL (cr=80053 pr=79941 pw=0 time=2734376 us starts=1 cost=21767 size=25212582 card=1400699)
0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 SORT JOIN (cr=0 pr=0 pw=0 time=0 us starts=0 cost=4 size=1260 card=42)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED CST_PAC_PERIODS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=3 size=1260 card=42)
0 0 0 BITMAP CONVERSION TO ROWIDS (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 BITMAP OR (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 BITMAP CONVERSION FROM ROWIDS (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 INDEX RANGE SCAN CST_PAC_PERIODS_U1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=0)(object id 8434107)
0 0 0 BITMAP CONVERSION FROM ROWIDS (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 INDEX RANGE SCAN CST_PAC_PERIODS_U1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=0)(object id 8434107)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
0 SORT (UNIQUE)
0 UNION-ALL
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 MERGE JOIN (CARTESIAN)
0 MERGE JOIN (CARTESIAN)
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY
INDEX ROWID) OF 'XLE_ENTITY_PROFILES' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE
SCAN) OF 'XLE_ENTITY_PROFILES_U1' (INDEX (UNIQUE)
)
0 TABLE ACCESS MODE: ANALYZED (FULL)
OF 'CLE_F145_PC_CM_MATCH_BAL' (TABLE)
0 INDEX MODE: ANALYZED (RANGE SCAN) OF
'HR_ORGANIZATION_INFORMATIO_FK2' (INDEX)
0 TABLE ACCESS MODE: ANALYZED (BY INDEX
ROWID) OF 'HR_ORGANIZATION_INFORMATION' (TABLE)
0 BUFFER (SORT)
0 TABLE ACCESS MODE: ANALYZED (BY INDEX
ROWID BATCHED) OF 'XLE_REGISTRATIONS' (TABLE)
0 INDEX MODE: ANALYZED (RANGE SCAN) OF
'XLE_REGISTRATIONS_N2' (INDEX)
0 BUFFER (SORT)
0 INDEX MODE: ANALYZED (SKIP SCAN) OF
'GL_LEDGER_RELATIONSHIPS_U2' (INDEX (UNIQUE))
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID)
OF 'GL_LEDGERS' (TABLE)
0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'GL_LEDGERS_U2' (INDEX (UNIQUE))
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID)
OF 'GL_LEDGERS' (TABLE)
0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'GL_LEDGERS_U2' (INDEX (UNIQUE))
0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'GL_LEDGER_CONFIGURATIONS_U1' (INDEX (UNIQUE))
0 INDEX MODE: ANALYZED (RANGE SCAN) OF
'GL_LEDGER_CONFIG_DETAILS_U1' (INDEX (UNIQUE))
0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'HR_LOCATIONS_PK' (INDEX (UNIQUE))
0 INDEX MODE: ANALYZED (RANGE SCAN) OF
'XXPLSTR_MTL_MATERIAL_TRANS_N1' (INDEX)
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'HR_ORGANIZATION_INFORMATION' (TABLE)
0 FILTER
0 NESTED LOOPS
0 MERGE JOIN (CARTESIAN)
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 HASH JOIN
1 HASH JOIN (ANTI)
1 HASH JOIN (ANTI)
1 NESTED LOOPS
1 NESTED LOOPS
1 NESTED LOOPS
2 NESTED LOOPS
2 NESTED LOOPS
2 NESTED LOOPS
2 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS MODE:
ANALYZED (BY INDEX ROWID) OF
'XLE_ENTITY_PROFILES' (TABLE)
2 INDEX MODE: ANALYZED
(UNIQUE SCAN) OF 'XLE_ENTITY_PROFILES_U1'
(INDEX (UNIQUE))
2 TABLE ACCESS MODE:
ANALYZED (FULL) OF 'CLE_F145_PROCVAR_MATCHE
S' (TABLE)
2 TABLE ACCESS MODE:
ANALYZED (BY INDEX ROWID BATCHED) OF
'HR_ORGANIZATION_INFORMATION' (TABLE)
2 INDEX MODE: ANALYZED
(RANGE SCAN) OF 'HR_ORGANIZATION_INFORMATIO
_FK2' (INDEX)
2 TABLE ACCESS MODE:
ANALYZED (BY INDEX ROWID BATCHED) OF
'HR_ORGANIZATION_INFORMATION' (TABLE)
2 INDEX MODE: ANALYZED
(RANGE SCAN) OF 'HR_ORGANIZATION_INFORMATIO_
FK2' (INDEX)
1 TABLE ACCESS MODE: ANALYZED
(BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE)
1 INDEX MODE: ANALYZED
(UNIQUE SCAN) OF 'AP_INVOICES_U1' (INDEX
(UNIQUE))
1 TABLE ACCESS MODE: ANALYZED
(BY INDEX ROWID) OF 'RCV_TRANSACTIONS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE
SCAN) OF 'RCV_TRANSACTIONS_U1' (INDEX (UNIQUE))
1 TABLE ACCESS MODE: ANALYZED (BY
INDEX ROWID) OF 'AP_INVOICE_LINES_ALL' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE
SCAN) OF 'AP_INVOICE_LINES_U1' (INDEX (UNIQUE))
1 INDEX MODE: ANALYZED (UNIQUE SCAN)
OF 'AP_INVOICE_DISTRIBUTIONS_U2' (INDEX (UNIQUE))
1 TABLE ACCESS MODE: ANALYZED (BY
INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL'
(TABLE)
1 TABLE ACCESS MODE: ANALYZED (FULL) OF
'CLE_F145_PC_CM_MATCH_BAL' (TABLE)
0 TABLE ACCESS MODE: ANALYZED (FULL) OF
'CLE_F145_PC_CM_MATCH_DATA' (TABLE)
0 TABLE ACCESS MODE: ANALYZED (FULL) OF
'GL_LEDGERS' (TABLE)
0 INDEX MODE: ANALYZED (FULL SCAN) OF
'GL_LEDGER_RELATIONSHIPS_U2' (INDEX (UNIQUE))
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID)
OF 'GL_LEDGERS' (TABLE)
0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'GL_LEDGERS_U2' (INDEX (UNIQUE))
0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'GL_LEDGER_CONFIGURATIONS_U1' (INDEX (UNIQUE))
0 INDEX MODE: ANALYZED (RANGE SCAN) OF
'GL_LEDGER_CONFIG_DETAILS_U1' (INDEX (UNIQUE))
0 BUFFER (SORT)
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID
BATCHED) OF 'XLE_REGISTRATIONS' (TABLE)
0 INDEX MODE: ANALYZED (RANGE SCAN) OF
'XLE_REGISTRATIONS_N2' (INDEX)
0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'HR_LOCATIONS_PK' (INDEX (UNIQUE))
0 FILTER
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
2182911330 HASH JOIN
1559 NESTED LOOPS
1559 NESTED LOOPS
1559 NESTED LOOPS (ANTI)
1559 HASH JOIN (RIGHT ANTI)
1559 INDEX MODE: ANALYZED (FULL SCAN) OF
'CLE_F145_PC_CM_MATCH_DATA_N1' (INDEX)
68929 HASH JOIN
102159 NESTED LOOPS
68929 MERGE JOIN (CARTESIAN)
1 NESTED LOOPS
1 NESTED LOOPS
2 NESTED LOOPS
1 NESTED LOOPS
1 NESTED LOOPS
1 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS MODE:
ANALYZED (BY INDEX ROWID) OF
'XLE_ENTITY_PROFILES' (TABLE)
1 INDEX MODE:
ANALYZED (UNIQUE SCAN) OF
'XLE_ENTITY_PROFILES_U1' (INDEX (UNIQUE))
1 TABLE ACCESS MODE:
ANALYZED (FULL) OF 'GL_LEDGERS' (TABLE)
1 TABLE ACCESS MODE:
ANALYZED (BY INDEX ROWID BATCHED) OF
'HR_ORGANIZATION_INFORMATION' (TABLE)
1 INDEX MODE: ANALYZED
(RANGE SCAN) OF 'XXPLSTR_MTL_MATERIAL_TRAN
S_N1' (INDEX)
1 TABLE ACCESS MODE:
ANALYZED (BY INDEX ROWID BATCHED) OF
'HR_ORGANIZATION_INFORMATION' (TABLE)
1 INDEX MODE: ANALYZED
(RANGE SCAN) OF 'HR_ORGANIZATION_INFORMATIO
_IX1' (INDEX)
1 INDEX MODE: ANALYZED (FULL
SCAN) OF 'GL_LEDGER_RELATIONSHIPS_U2' (INDEX
(UNIQUE))
1 TABLE ACCESS MODE: ANALYZED
(BY INDEX ROWID) OF 'GL_LEDGERS' (TABLE)
1 INDEX MODE: ANALYZED
(UNIQUE SCAN) OF 'GL_LEDGERS_U2' (INDEX
(UNIQUE))
1 INDEX MODE: ANALYZED (UNIQUE
SCAN) OF 'GL_LEDGER_CONFIGURATIONS_U1' (INDEX
(UNIQUE))
1 INDEX MODE: ANALYZED (RANGE SCAN)
OF 'GL_LEDGER_CONFIG_DETAILS_U1' (INDEX (UNIQUE)
)
1 BUFFER (SORT)
1 TABLE ACCESS MODE: ANALYZED (BY
INDEX ROWID BATCHED) OF 'XLE_REGISTRATIONS'
(TABLE)
1 INDEX MODE: ANALYZED (RANGE
SCAN) OF 'XLE_REGISTRATIONS_N2' (INDEX)
1 INDEX MODE: ANALYZED (UNIQUE SCAN)
OF 'HR_LOCATIONS_PK' (INDEX (UNIQUE))
1 TABLE ACCESS MODE: ANALYZED (FULL) OF
'CLE_F145_INV_RECEIPT_MATCHES' (TABLE)
2 TABLE ACCESS MODE: ANALYZED (BY INDEX
ROWID BATCHED) OF 'CLE_F145_PC_CM_MATCH_BAL' (TABLE)
1 INDEX MODE: ANALYZED (RANGE SCAN) OF
'CLE_F145_PC_CM_MATCH_BAL_N1' (INDEX)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'AP_INVOICE_DISTRIBUTIONS_U2' (INDEX (UNIQUE))
68929 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID)
OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE)
14523 TABLE ACCESS MODE: ANALYZED (FULL) OF
'AP_INVOICES_ALL' (TABLE)
1559 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'RCV_TRANSACTIONS' (TABLE)
1559 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'RCV_TRANSACTIONS_U1' (INDEX (UNIQUE))
1559 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'AP_INVOICE_LINES_U1' (INDEX (UNIQUE))
1559 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'AP_INVOICE_LINES_ALL' (TABLE)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 450 0.00 0.00
library cache lock 48 0.00 0.00
library cache pin 58 0.00 0.00
Disk file operations I/O 38 0.00 0.00
gc current block 2-way 800 0.00 0.12
enq: JZ - Join group dictionary 1 0.00 0.00
gc cr multi block mixed 51 0.00 0.01
db file sequential read 216 0.11 0.21
gc cr grant busy 62 0.00 0.01
db file scattered read 276 0.00 0.16
gc cr multi block grant 137 0.00 0.03
reliable message 1 0.00 0.00
enq: KO - fast object checkpoint 2 0.00 0.00
ASM IO for non-blocking poll 2916178 0.00 4.75
direct path read 2610 0.00 1.63
db file parallel read 16 0.00 0.00
CSS initialization 2 0.00 0.00
CSS operation: query 6 0.00 0.00
CSS operation: action 2 0.00 0.00
direct path write temp 13444 0.25 58.76
gc cr grant 2-way 27 0.00 0.00
gc current grant busy 8 0.00 0.00
gc current grant 2-way 6 0.00 0.00
local write wait 12324 0.01 9.81
enq: TS - contention 47 0.00 0.01
enq: SS - contention 10 0.00 0.00
DFS lock handle 139 0.71 10.47
latch: cache buffers chains 2 0.00 0.00
buffer busy waits 1 0.00 0.00
********************************************************************************
SQL ID: 2bg73wmjuzhgz Plan Hash: 0
begin fnd_conc_stat.store_initial; end;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 2 0.04 0.06 0 128 0 2
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.04 0.06 0 128 0 2
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 1 0.00 0.00
SQL*Net message to client 2 0.00 0.00
SQL*Net message from client 2 0.00 0.00
********************************************************************************
SQL ID: f8bjw7z1gf5ux Plan Hash: 0
BEGIN CLE_F145_IC_VAR_ADJUST_PKG.adjust_variances(:errbuf,:rc,:A0,:A1,:A2,:A3)
; END;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.03 0.03 0 0 0 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.03 0.03 0 0 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
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
enq: RC - Result Cache: Contention 2 0.00 0.00
utl_file I/O 96 0.00 0.00
PGA memory operation 1 0.03 0.03
********************************************************************************
DECLARE
begin
-- FND_LOG.STRING( log_level => 1, module => 'FND_TRACE', message => 'in logoff trigger...sid/serial/spid/module/action: ' ||
-- fnd_trace.SESSION_ID_G ||'/'|| fnd_trace.SERIAL#_G ||'/'|| fnd_trace.SPID ||'/'|| fnd_trace.G_MODULE ||'/'|| fnd_trace.G_ACTION); --xxxremove
if fnd_trace.g_trace_enabled
then
fnd_trace.stop_trace(fnd_trace.g_trace_type);
end if;
END fnd_trace_off;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.01 0 0 0 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.01 0 0 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
utl_file I/O 24 0.00 0.01
********************************************************************************
SQL ID: ah8xzfvxpm9w7 Plan Hash: 2722549137
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.01 0 0 0 0
Fetch 1 0.00 0.00 0 16 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.01 0.01 0 16 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 HASH JOIN (cr=16 pr=0 pw=0 time=355 us starts=1 cost=11 size=301 card=1)
1 1 1 NESTED LOOPS (cr=11 pr=0 pw=0 time=106 us starts=1 cost=7 size=182 card=1)
1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=17 us starts=1 cost=3 size=63 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=3 pr=0 pw=0 time=11 us starts=1 cost=2 size=47 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=7 us starts=1 cost=1 size=0 card=1)(object id 8441788)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=6 us starts=1 cost=1 size=16 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=4 us starts=1 cost=0 size=0 card=1)(object id 8410480)
1 1 1 VIEW FND_LOOKUP_VALUES# (cr=5 pr=0 pw=0 time=87 us starts=1 cost=4 size=119 card=1)
18 18 18 TABLE ACCESS BY INDEX ROWID BATCHED FND_LOOKUP_VALUES (cr=5 pr=0 pw=0 time=40 us starts=1 cost=4 size=118 card=2)
36 36 36 INDEX RANGE SCAN XXPLS_FND_LOOKUPVALUES_IDX3 (cr=3 pr=0 pw=0 time=11 us starts=1 cost=3 size=0 card=4)(object id 8427596)
4 4 4 VIEW FND_LOOKUP_VALUES# (cr=5 pr=0 pw=0 time=28 us starts=1 cost=4 size=238 card=2)
4 4 4 TABLE ACCESS BY INDEX ROWID BATCHED FND_LOOKUP_VALUES (cr=5 pr=0 pw=0 time=14 us starts=1 cost=4 size=118 card=2)
8 8 8 INDEX RANGE SCAN XXPLS_FND_LOOKUPVALUES_IDX3 (cr=3 pr=0 pw=0 time=9 us starts=1 cost=3 size=0 card=4)(object id 8427596)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 HASH JOIN
1 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_PROGRAMS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_PROGRAMS_U1' (INDEX (UNIQUE))
1 VIEW OF 'FND_LOOKUP_VALUES#' (VIEW)
18 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF
'FND_LOOKUP_VALUES' (TABLE)
36 INDEX MODE: ANALYZED (RANGE SCAN) OF
'XXPLS_FND_LOOKUPVALUES_IDX3' (INDEX)
4 VIEW OF 'FND_LOOKUP_VALUES#' (VIEW)
4 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF
'FND_LOOKUP_VALUES' (TABLE)
8 INDEX MODE: ANALYZED (RANGE SCAN) OF
'XXPLS_FND_LOOKUPVALUES_IDX3' (INDEX)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 7 0.00 0.00
library cache lock 3 0.00 0.00
library cache pin 3 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: 02mw0404x4y40 Plan Hash: 1309933889
SELECT HLE.NAME
FROM
HR_LEGAL_ENTITIES HLE WHERE HLE.ORGANIZATION_ID = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 1 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 1 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=7 us starts=1 cost=3 size=82 card=1)
0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=7 us starts=1 cost=2 size=53 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID HR_ALL_ORGANIZATION_UNITS_TL (cr=1 pr=0 pw=0 time=7 us starts=1 cost=1 size=46 card=1)
0 0 0 INDEX UNIQUE SCAN HR_ALL_ORGANIZATION_UNTS_TL_PK (cr=1 pr=0 pw=0 time=6 us starts=1 cost=0 size=0 card=1)(object id 8421022)
0 0 0 TABLE ACCESS BY INDEX ROWID HR_ALL_ORGANIZATION_UNITS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=7 card=1)
0 0 0 INDEX UNIQUE SCAN HR_ORGANIZATION_UNITS_PK (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 8427962)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED HR_ORGANIZATION_INFORMATION (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=29 card=1)
0 0 0 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 8406447)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
0 NESTED LOOPS
0 NESTED LOOPS
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'HR_ALL_ORGANIZATION_UNITS_TL' (TABLE)
0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'HR_ALL_ORGANIZATION_UNTS_TL_PK' (INDEX (UNIQUE))
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'HR_ALL_ORGANIZATION_UNITS' (TABLE)
0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'HR_ORGANIZATION_UNITS_PK' (INDEX (UNIQUE))
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF
'HR_ORGANIZATION_INFORMATION' (TABLE)
0 INDEX MODE: ANALYZED (RANGE SCAN) OF
'HR_ORGANIZATION_INFORMATIO_FK2' (INDEX)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache pin 2 0.00 0.00
********************************************************************************
SQL ID: 01xcmn3zpj49d Plan Hash: 1728800778
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: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (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=4 us starts=1)
0 0 0 INDEX RANGE SCAN FND_LOG_METRICS_N1 (cr=0 pr=0 pw=0 time=1 us starts=1 cost=1 size=13 card=1)(object id 8403927)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 SORT (AGGREGATE)
0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_LOG_METRICS_N1'
(INDEX)
********************************************************************************
SQL ID: bf28w5utux79y Plan Hash: 2171291493
SELECT FFCU.COLUMN_SEQ_NUM ,FFCU.END_USER_COLUMN_NAME ,FFCU.FORM_LEFT_PROMPT ,
FFCU.APPLICATION_ID
FROM
FND_DESCR_FLEX_COL_USAGE_VL FFCU WHERE FFCU.DESCRIPTIVE_FLEXFIELD_NAME =
'$SRS$.' || :B2 AND FFCU.APPLICATION_ID = :B1 AND FFCU.ENABLED_FLAG = 'Y'
ORDER BY FFCU.COLUMN_SEQ_NUM
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 5 19 0 4
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 5 19 0 4
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
4 4 4 SORT ORDER BY (cr=19 pr=5 pw=0 time=3389 us starts=1 cost=7 size=165 card=1)
4 4 4 NESTED LOOPS (cr=19 pr=5 pw=0 time=4030 us starts=1 cost=6 size=165 card=1)
4 4 4 NESTED LOOPS (cr=15 pr=2 pw=0 time=1615 us starts=1 cost=6 size=165 card=1)
4 4 4 TABLE ACCESS BY INDEX ROWID BATCHED FND_DESCR_FLEX_COLUMN_USAGES (cr=5 pr=0 pw=0 time=38 us starts=1 cost=4 size=83 card=1)
4 4 4 INDEX RANGE SCAN FND_DESCR_FLEX_COL_USAGES_U1 (cr=3 pr=0 pw=0 time=18 us starts=1 cost=3 size=0 card=1)(object id 8407154)
4 4 4 INDEX UNIQUE SCAN FND_DESCR_FLEX_COL_USAGE_TL_U1 (cr=10 pr=2 pw=0 time=1573 us starts=4 cost=1 size=0 card=1)(object id 8408195)
4 4 4 TABLE ACCESS BY INDEX ROWID FND_DESCR_FLEX_COL_USAGE_TL (cr=4 pr=3 pw=0 time=1764 us starts=4 cost=2 size=82 card=1)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
4 SORT (ORDER BY)
4 NESTED LOOPS
4 NESTED LOOPS
4 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF
'FND_DESCR_FLEX_COLUMN_USAGES' (TABLE)
4 INDEX MODE: ANALYZED (RANGE SCAN) OF
'FND_DESCR_FLEX_COL_USAGES_U1' (INDEX (UNIQUE))
4 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_DESCR_FLEX_COL_USAGE_TL_U1' (INDEX (UNIQUE))
4 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_DESCR_FLEX_COL_USAGE_TL' (TABLE)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 5 0.00 0.00
library cache pin 2 0.00 0.00
Disk file operations I/O 3 0.00 0.00
gc cr grant busy 4 0.00 0.00
db file sequential read 5 0.00 0.00
********************************************************************************
SQL ID: 7gp4fjrdkp1mw Plan Hash: 2144206549
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 2 0
Execute 1 0.00 0.00 0 12 2 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 12 4 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
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=12 pr=0 pw=0 time=326 us starts=1)
1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=17 us starts=1 cost=3 size=57 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=3 pr=0 pw=0 time=11 us starts=1 cost=2 size=14 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=7 us starts=1 cost=1 size=0 card=1)(object id 8441788)
1 1 1 INDEX UNIQUE SCAN FND_CONC_PROG_ONSITE_INFO_U1 (cr=2 pr=0 pw=0 time=4 us starts=1 cost=0 size=43 card=1)(object id 8419060)
1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=28 us starts=1 cost=3 size=54 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=3 pr=0 pw=0 time=8 us starts=1 cost=2 size=32 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=3 us starts=1 cost=1 size=0 card=1)(object id 8441788)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONC_PROG_ONSITE_INFO (cr=4 pr=0 pw=0 time=18 us starts=1 cost=1 size=22 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONC_PROG_ONSITE_INFO_U1 (cr=2 pr=0 pw=0 time=2 us starts=1 cost=0 size=0 card=1)(object id 8419060)
Rows Execution Plan
------- ---------------------------------------------------
0 UPDATE STATEMENT MODE: ALL_ROWS
0 UPDATE OF 'FND_CONC_PROG_ONSITE_INFO'
1 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONC_PROG_ONSITE_INFO_U1' (INDEX (UNIQUE))
1 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONC_PROG_ONSITE_INFO' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONC_PROG_ONSITE_INFO_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 8 0.00 0.00
library cache pin 11 0.00 0.00
enq: TM - contention 1 0.00 0.00
gc current grant busy 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: 6ja8mjk9v08su Plan Hash: 4273626101
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(to_number(:b10),
'-1',null ,to_number(:b10)),LFile_Size=decode(to_number(:b12),'-1',null ,
to_number(:b12)),node_name1=decode(:b14,'Y',:b15,node_name1)
where
Request_Id=:b16
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 2 0
Execute 1 0.00 0.00 3 2 26 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 3 2 28 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 UPDATE FND_CONCURRENT_REQUESTS (cr=2 pr=3 pw=0 time=2021 us starts=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=7 us starts=1 cost=1 size=105 card=1)(object id 8441788)
Rows Execution Plan
------- ---------------------------------------------------
0 UPDATE STATEMENT MODE: ALL_ROWS
0 UPDATE OF 'FND_CONCURRENT_REQUESTS'
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 13 0.00 0.00
library cache pin 7 0.00 0.00
db file sequential read 3 0.00 0.00
gc current grant 2-way 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: 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: ALL_ROWS
Parsing user id: 119 (APPS)
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: 8kubp71731tnc Plan Hash: 3192772278
select ON_FAILURE_LOG_LEVEL ,USER_CONCURRENT_PROGRAM_NAME into :b0:b1,:b2
from
FND_CONCURRENT_REQUESTS FCR ,FND_CONC_PROG_ONSITE_INFO FCP ,
FND_CONCURRENT_PROGRAMS_VL FCPVL where ((((FCR.REQUEST_ID=:b3 and
FCR.CONCURRENT_PROGRAM_ID=FCP.CONCURRENT_PROGRAM_ID) and
FCR.PROGRAM_APPLICATION_ID=FCP.PROGRAM_APPLICATION_ID) and
FCPVL.CONCURRENT_PROGRAM_ID=FCP.CONCURRENT_PROGRAM_ID) and
FCPVL.APPLICATION_ID=FCP.PROGRAM_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 11 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 11 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 NESTED LOOPS (cr=11 pr=0 pw=0 time=33 us starts=1 cost=4 size=99 card=1)
1 1 1 NESTED LOOPS (cr=8 pr=0 pw=0 time=25 us starts=1 cost=3 size=43 card=1)
1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=20 us starts=1 cost=3 size=29 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=3 pr=0 pw=0 time=13 us starts=1 cost=2 size=14 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=7 us starts=1 cost=1 size=0 card=1)(object id 8441788)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONC_PROG_ONSITE_INFO (cr=3 pr=0 pw=0 time=6 us starts=1 cost=1 size=15 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONC_PROG_ONSITE_INFO_U1 (cr=2 pr=0 pw=0 time=5 us starts=1 cost=0 size=0 card=1)(object id 8419060)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=4 us starts=1 cost=0 size=14 card=1)(object id 8410480)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS_TL (cr=3 pr=0 pw=0 time=7 us starts=1 cost=1 size=56 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_TL_U1 (cr=2 pr=0 pw=0 time=5 us starts=1 cost=0 size=0 card=1)(object id 8426639)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 NESTED LOOPS
1 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONC_PROG_ONSITE_INFO' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONC_PROG_ONSITE_INFO_U1' (INDEX (UNIQUE))
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_PROGRAMS_U1' (INDEX (UNIQUE))
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_PROGRAMS_TL' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_PROGRAMS_TL_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 6 0.00 0.00
library cache pin 4 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: 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: ALL_ROWS
Parsing user id: 119 (APPS)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
utl_file I/O 8 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: 7qwsx7rw0s3a5 Plan Hash: 624732679
SELECT PROFILE_OPTION_VALUE
FROM
FND_PROFILE_VALUES_USER_V WHERE PROFILE_OPTION_ID = :B3 AND APPLICATION_ID =
:B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 5 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 5 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 NESTED LOOPS (cr=5 pr=0 pw=0 time=564 us starts=1 cost=4 size=53 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTIONS (cr=3 pr=0 pw=0 time=336 us starts=1 cost=2 size=25 card=1)
1 1 1 INDEX UNIQUE SCAN FND_PROFILE_OPTIONS_U1 (cr=2 pr=0 pw=0 time=321 us starts=1 cost=1 size=0 card=1)(object id 8442242)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED FND_PROFILE_OPTION_VALUES (cr=2 pr=0 pw=0 time=228 us starts=1 cost=2 size=28 card=1)
0 0 0 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1 (cr=2 pr=0 pw=0 time=227 us starts=1 cost=1 size=0 card=1)(object id 8400572)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
0 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_PROFILE_OPTIONS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_PROFILE_OPTIONS_U1' (INDEX (UNIQUE))
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF
'FND_PROFILE_OPTION_VALUES' (TABLE)
0 INDEX MODE: ANALYZED (RANGE SCAN) OF
'FND_PROFILE_OPTION_VALUES_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 3 0.00 0.00
library cache pin 4 0.00 0.00
Disk file operations I/O 2 0.00 0.00
gc current block 2-way 2 0.00 0.00
********************************************************************************
SQL ID: 09kmr4mvh2rcr Plan Hash: 2722163325
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, TO_CHAR(R.OFILE_SIZE)
FROM
FND_CONCURRENT_REQUESTS R, FND_USER U, FND_CONCURRENT_PROGRAMS P WHERE
R.REQUEST_ID = :reqid AND R.REQUESTED_BY = U.USER_ID AND
R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID AND
R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 9 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 9 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 NESTED LOOPS (cr=9 pr=0 pw=0 time=26 us starts=1 cost=4 size=189 card=1)
1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=20 us starts=1 cost=3 size=176 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=3 pr=0 pw=0 time=12 us starts=1 cost=2 size=148 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=6 us starts=1 cost=1 size=0 card=1)(object id 8441788)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=7 us starts=1 cost=1 size=28 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=4 us starts=1 cost=0 size=0 card=1)(object id 8410480)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_USER (cr=3 pr=0 pw=0 time=6 us starts=1 cost=1 size=13 card=1)
1 1 1 INDEX UNIQUE SCAN FND_USER_U1 (cr=2 pr=0 pw=0 time=4 us starts=1 cost=0 size=0 card=1)(object id 8440767)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_PROGRAMS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_PROGRAMS_U1' (INDEX (UNIQUE))
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_USER'
(TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_USER_U1' (INDEX
(UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache pin 1 0.00 0.00
library cache lock 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: 1hz00txs5dyw2 Plan Hash: 3236433071
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 2 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 2 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 VIEW FND_LOOKUP_VALUES# (cr=4 pr=0 pw=0 time=116 us starts=1 cost=4 size=119 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED FND_LOOKUP_VALUES (cr=4 pr=0 pw=0 time=37 us starts=1 cost=4 size=59 card=1)
1 1 1 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (cr=3 pr=0 pw=0 time=31 us starts=1 cost=3 size=0 card=1)(object id 8427593)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 VIEW OF 'FND_LOOKUP_VALUES#' (VIEW)
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF
'FND_LOOKUP_VALUES' (TABLE)
1 INDEX MODE: ANALYZED (RANGE SCAN) OF
'FND_LOOKUP_VALUES_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache pin 2 0.00 0.00
library cache lock 4 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: 8bp3g63uq54pa Plan Hash: 1270949144
update Fnd_Concurrent_Requests set Phase_Code='P',Status_Code='I',
Last_Update_Date=Sysdate,Last_Updated_By=:b0,Last_Update_Login=:b1
where
((Request_ID=:b2 and Status_Code='W') and not exists (select null from
Fnd_Concurrent_Requests R where (((Parent_Request_Id=:b2 and
Request_Id<>:b4) and Is_Sub_Request='Y') and Status_Code between 'I' and
'W')))
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 7 20 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 7 20 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 UPDATE FND_CONCURRENT_REQUESTS (cr=7 pr=0 pw=0 time=1250 us starts=1)
1 1 1 FILTER (cr=7 pr=0 pw=0 time=25 us starts=1)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=3 pr=0 pw=0 time=6 us starts=1 cost=2 size=48 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=3 us starts=1 cost=1 size=0 card=1)(object id 8441788)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=15 us starts=1 cost=4 size=16 card=1)
1 1 1 INDEX RANGE SCAN FND_CONCURRENT_REQUESTS_N3 (cr=3 pr=0 pw=0 time=12 us starts=1 cost=3 size=0 card=1)(object id 8441782)
Rows Execution Plan
------- ---------------------------------------------------
0 UPDATE STATEMENT MODE: ALL_ROWS
0 UPDATE OF 'FND_CONCURRENT_REQUESTS'
1 FILTER
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (RANGE SCAN) OF
'FND_CONCURRENT_REQUESTS_N3' (INDEX)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 1 0.00 0.00
gc current grant 2-way 3 0.00 0.00
gc current block 2-way 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: fmpbxcbz6q0a1 Plan Hash: 3315420623
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 10 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 2 10 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
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=467 us starts=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROCESSES_U1 (cr=2 pr=0 pw=0 time=6 us starts=1 cost=1 size=29 card=1)(object id 8423310)
Rows Execution Plan
------- ---------------------------------------------------
0 UPDATE STATEMENT MODE: ALL_ROWS
0 UPDATE OF 'FND_CONCURRENT_PROCESSES'
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_PROCESSES_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 6 0.00 0.00
library cache pin 4 0.00 0.00
gc current block 2-way 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: 2tyrw6s0jvap7 Plan Hash: 255874495
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 6 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 6 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=20 us starts=1 cost=3 size=102 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=3 pr=0 pw=0 time=11 us starts=1 cost=2 size=86 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=6 us starts=1 cost=1 size=0 card=1)(object id 8441788)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=7 us starts=1 cost=1 size=16 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=4 us starts=1 cost=0 size=0 card=1)(object id 8410480)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_PROGRAMS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_PROGRAMS_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 2 0.00 0.00
library cache pin 1 0.00 0.00
SQL*Net message to client 1 0.00 0.00
SQL*Net message from client 1 0.02 0.02
********************************************************************************
SQL ID: 0mcwzxa8uk2n4 Plan Hash: 624732679
SELECT PROFILE_OPTION_VALUE
FROM
FND_PROFILE_VALUES_APPL_V WHERE PROFILE_OPTION_ID = :B3 AND APPLICATION_ID =
:B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 15 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.00 0.00 0 15 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 NESTED LOOPS (cr=5 pr=0 pw=0 time=21 us starts=1 cost=4 size=53 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTIONS (cr=3 pr=0 pw=0 time=14 us starts=1 cost=2 size=25 card=1)
1 1 1 INDEX UNIQUE SCAN FND_PROFILE_OPTIONS_U1 (cr=2 pr=0 pw=0 time=5 us starts=1 cost=1 size=0 card=1)(object id 8442242)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED FND_PROFILE_OPTION_VALUES (cr=2 pr=0 pw=0 time=5 us starts=1 cost=2 size=28 card=1)
0 0 0 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1 (cr=2 pr=0 pw=0 time=5 us starts=1 cost=1 size=0 card=1)(object id 8400572)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
0 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_PROFILE_OPTIONS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_PROFILE_OPTIONS_U1' (INDEX (UNIQUE))
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF
'FND_PROFILE_OPTION_VALUES' (TABLE)
0 INDEX MODE: ANALYZED (RANGE SCAN) OF
'FND_PROFILE_OPTION_VALUES_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache pin 2 0.00 0.00
library cache lock 1 0.00 0.00
********************************************************************************
SQL ID: 37gfbt3mkzxgk Plan Hash: 3854651072
SELECT FCP.CONCURRENT_PROGRAM_ID ,FCP.CONCURRENT_PROGRAM_NAME ,
FCP.APPLICATION_ID ,FCP.USER_CONCURRENT_PROGRAM_NAME
FROM
FND_CONCURRENT_PROGRAMS_VL FCP WHERE FCP.CONCURRENT_PROGRAM_ID = :B2 AND
FCP.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 6 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 6 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=17 us starts=1 cost=3 size=82 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=10 us starts=1 cost=2 size=26 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=7 us starts=1 cost=1 size=0 card=1)(object id 8410480)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS_TL (cr=3 pr=0 pw=0 time=7 us starts=1 cost=1 size=56 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_TL_U1 (cr=2 pr=0 pw=0 time=5 us starts=1 cost=0 size=0 card=1)(object id 8426639)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_PROGRAMS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_PROGRAMS_U1' (INDEX (UNIQUE))
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_PROGRAMS_TL' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_PROGRAMS_TL_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 3 0.00 0.00
library cache pin 1 0.00 0.00
********************************************************************************
SQL ID: 9k7gd9pn661pj Plan Hash: 3678836942
SELECT PROFILE_OPTION_VALUE
FROM
FND_PROFILE_VALUES_RESP_V WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID =
:B3 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND
PROFILE_OPTION_VALUE IS NOT NULL
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 21 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.00 0.00 0 21 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 NESTED LOOPS (cr=7 pr=0 pw=0 time=44 us starts=1 cost=4 size=55 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTIONS (cr=3 pr=0 pw=0 time=16 us starts=1 cost=2 size=25 card=1)
1 1 1 INDEX UNIQUE SCAN FND_PROFILE_OPTIONS_U1 (cr=2 pr=0 pw=0 time=6 us starts=1 cost=1 size=0 card=1)(object id 8442242)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED FND_PROFILE_OPTION_VALUES (cr=4 pr=0 pw=0 time=27 us starts=1 cost=2 size=30 card=1)
8 8 8 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_N1 (cr=2 pr=0 pw=0 time=16 us starts=1 cost=1 size=0 card=1)(object id 8400573)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
0 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_PROFILE_OPTIONS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_PROFILE_OPTIONS_U1' (INDEX (UNIQUE))
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF
'FND_PROFILE_OPTION_VALUES' (TABLE)
8 INDEX MODE: ANALYZED (RANGE SCAN) OF
'FND_PROFILE_OPTION_VALUES_N1' (INDEX)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache pin 1 0.00 0.00
********************************************************************************
SQL ID: gj84g2yx56u2q Plan Hash: 624732679
SELECT PROFILE_OPTION_VALUE
FROM
FND_PROFILE_VALUES_SITE_V WHERE PROFILE_OPTION_ID = :B2 AND APPLICATION_ID =
:B1 AND PROFILE_OPTION_VALUE IS NOT NULL
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 6 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 6 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=31 us starts=1 cost=4 size=53 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTIONS (cr=3 pr=0 pw=0 time=18 us starts=1 cost=2 size=25 card=1)
1 1 1 INDEX UNIQUE SCAN FND_PROFILE_OPTIONS_U1 (cr=2 pr=0 pw=0 time=7 us starts=1 cost=1 size=0 card=1)(object id 8442242)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED FND_PROFILE_OPTION_VALUES (cr=3 pr=0 pw=0 time=11 us starts=1 cost=2 size=28 card=1)
1 1 1 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1 (cr=2 pr=0 pw=0 time=8 us starts=1 cost=1 size=0 card=1)(object id 8400572)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_PROFILE_OPTIONS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_PROFILE_OPTIONS_U1' (INDEX (UNIQUE))
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF
'FND_PROFILE_OPTION_VALUES' (TABLE)
1 INDEX MODE: ANALYZED (RANGE SCAN) OF
'FND_PROFILE_OPTION_VALUES_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache pin 2 0.00 0.00
library cache lock 1 0.00 0.00
********************************************************************************
SQL ID: 0jkur63f4p125 Plan Hash: 1128988361
SELECT CCU.TRANSACTION_INTERFACE_ID ,CCU.INVENTORY_ITEM_ID ,
CCU.ORGANIZATION_ID ,CCU.MATERIAL_ACCOUNT ,CCU.MATERIAL_OVERHEAD_ACCOUNT ,
CCU.RESOURCE_ACCOUNT ,CCU.OUTSIDE_PROCESSING_ACCOUNT ,CCU.OVERHEAD_ACCOUNT ,
CCU.TRANSACTION_UOM ,(-1 * CCU.VALUE_CHANGE) VALUE_CHANGE ,CCU.PERIOD_ID ,
CCU.PROGRAM_ID ,CCU.PROGRAM_APPLICATION_ID ,CCU.COST_GROUP_ID ,
CCU.COST_TYPE_ID ,CCU.LEGAL_ENTITY_ID ,CCU.REQUEST_ID ,TRANSACTION_BATCH_ID
,TRANSACTION_REFERENCE ,SOURCE_LINE_ID
FROM
CLE_F145_COST_UPDATES CCU WHERE CCU.PROGRAM_ID = :B6 AND
PROGRAM_APPLICATION_ID = :B5 AND LEGAL_ENTITY_ID = :B4 AND COST_TYPE_ID =
:B3 AND COST_GROUP_ID = :B2 AND PERIOD_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 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED CLE_F145_COST_UPDATES (cr=0 pr=0 pw=0 time=1 us starts=1 cost=1 size=478 card=1)
0 0 0 INDEX RANGE SCAN CLE_F145_COST_UPDATES_N3 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 8444285)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF
'CLE_F145_COST_UPDATES' (TABLE)
0 INDEX MODE: ANALYZED (RANGE SCAN) OF
'CLE_F145_COST_UPDATES_N3' (INDEX)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache pin 5 0.00 0.00
library cache lock 2 0.00 0.00
********************************************************************************
SQL ID: 3bk36g1dkwa8x Plan Hash: 531587196
DELETE FROM CLE_F145_DET_SUBLEDGER_INFO
WHERE
LEGAL_ENTITY_ID = :B5 AND COST_TYPE_ID = :B4 AND PERIOD_ID = :B3 AND
COST_GROUP_ID = :B2 AND PROGRAM_ID = :B1 AND NVL ( POSTED_FLAG, 'N' ) = 'N'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 DELETE CLE_F145_DET_SUBLEDGER_INFO (cr=0 pr=0 pw=0 time=16 us starts=1)
0 0 0 INDEX RANGE SCAN CLE_F145_DET_SUBLEDGER_INFO_N4 (cr=0 pr=0 pw=0 time=1 us starts=1 cost=0 size=93 card=1)(object id 8439975)
Rows Execution Plan
------- ---------------------------------------------------
0 DELETE STATEMENT MODE: ALL_ROWS
0 DELETE OF 'CLE_F145_DET_SUBLEDGER_INFO'
0 INDEX MODE: ANALYZED (RANGE SCAN) OF
'CLE_F145_DET_SUBLEDGER_INFO_N4' (INDEX)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache pin 6 0.00 0.00
library cache lock 3 0.00 0.00
********************************************************************************
SQL ID: 5a8x3htf0hvuk Plan Hash: 3902224044
SELECT 1 DATA_EXISTS
FROM
CLE_F145_PC_CM_MATCH_DATA WHERE PERIOD_ID = :B3 AND COST_GROUP_ID = :B2 AND
LEGAL_ENTITY_ID = :B1 UNION ALL SELECT 1 DATA_EXISTS FROM
CLE_F145_PC_CM_MATCH_BAL WHERE PERIOD_ID = :B3 AND COST_GROUP_ID = :B2 AND
LEGAL_ENTITY_ID = :B1 UNION ALL SELECT 1 DATA_EXISTS FROM
CLE_F145_PC_CM_BALANCES WHERE PERIOD_ID = :B3 AND COST_GROUP_ID = :B2 AND
LEGAL_ENTITY_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 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 UNION-ALL (cr=0 pr=0 pw=0 time=8 us starts=1)
0 0 0 TABLE ACCESS FULL CLE_F145_PC_CM_MATCH_DATA (cr=0 pr=0 pw=0 time=4 us starts=1 cost=2 size=39 card=1)
0 0 0 TABLE ACCESS FULL CLE_F145_PC_CM_MATCH_BAL (cr=0 pr=0 pw=0 time=1 us starts=1 cost=2 size=39 card=1)
0 0 0 TABLE ACCESS FULL CLE_F145_PC_CM_BALANCES (cr=0 pr=0 pw=0 time=0 us starts=1 cost=2 size=39 card=1)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
0 UNION-ALL
0 TABLE ACCESS MODE: ANALYZED (FULL) OF
'CLE_F145_PC_CM_MATCH_DATA' (TABLE)
0 TABLE ACCESS MODE: ANALYZED (FULL) OF
'CLE_F145_PC_CM_MATCH_BAL' (TABLE)
0 TABLE ACCESS MODE: ANALYZED (FULL) OF
'CLE_F145_PC_CM_BALANCES' (TABLE)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 6 0.00 0.00
library cache pin 7 0.00 0.00
********************************************************************************
SQL ID: bn5kvv5zgxdrw Plan Hash: 327318521
DELETE FROM CLE_F145_PC_CM_BALANCES
WHERE
PERIOD_ID = :B3 AND LEGAL_ENTITY_ID = :B2 AND COST_GROUP_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 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 DELETE CLE_F145_PC_CM_BALANCES (cr=0 pr=0 pw=0 time=5 us starts=1)
0 0 0 TABLE ACCESS FULL CLE_F145_PC_CM_BALANCES (cr=0 pr=0 pw=0 time=3 us starts=1 cost=2 size=65 card=1)
Rows Execution Plan
------- ---------------------------------------------------
0 DELETE STATEMENT MODE: ALL_ROWS
0 DELETE OF 'CLE_F145_PC_CM_BALANCES'
0 TABLE ACCESS MODE: ANALYZED (FULL) OF
'CLE_F145_PC_CM_BALANCES' (TABLE)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 4 0.00 0.00
library cache pin 3 0.00 0.00
enq: TM - contention 1 0.00 0.00
********************************************************************************
SQL ID: bg6n1u3cnbb11 Plan Hash: 3413675966
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, 100, ACTION_TYPE) DESC, 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.00 0 2 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 SORT ORDER BY (cr=2 pr=0 pw=0 time=19 us starts=1 cost=4 size=34 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED FND_CONC_PP_ACTIONS (cr=2 pr=0 pw=0 time=11 us starts=1 cost=3 size=34 card=1)
0 0 0 INDEX RANGE SCAN FND_CONC_PP_ACTIONS_N1 (cr=2 pr=0 pw=0 time=10 us starts=1 cost=2 size=0 card=1)(object id 8411548)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
0 SORT (ORDER BY)
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF
'FND_CONC_PP_ACTIONS' (TABLE)
0 INDEX MODE: ANALYZED (RANGE SCAN) OF
'FND_CONC_PP_ACTIONS_N1' (INDEX)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache pin 4 0.00 0.00
library cache lock 3 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: bwyarw3qva2j3 Plan Hash: 2981213471
SELECT LEDGER_ID ,COGS_IPV_ACCOUNT ,COGS_ERV_ACCOUNT
FROM
CLE_F145_SPECIAL_ACCOUNTS CSA WHERE CSA.COST_TYPE_ID = :B4 AND
CSA.COST_GROUP_ID = :B3 AND CSA.LEGAL_ENTITY_ID = :B2 AND CSA.LEDGER_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 2 2 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 2 2 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (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 CLE_F145_SPECIAL_ACCOUNTS (cr=2 pr=2 pw=0 time=1310 us starts=1 cost=1 size=25 card=1)
1 1 1 INDEX UNIQUE SCAN CLE_F145_SPECIAL_ACCOUNTS_U1 (cr=1 pr=1 pw=0 time=660 us starts=1 cost=0 size=0 card=1)(object id 8435004)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'CLE_F145_SPECIAL_ACCOUNTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'CLE_F145_SPECIAL_ACCOUNTS_U1' (INDEX (UNIQUE))
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.00 0.00
gc cr grant busy 1 0.00 0.00
********************************************************************************
SQL ID: 43nh2sn7y18jx Plan Hash: 1371595657
DELETE FROM CLE_F145_PC_CM_MATCH_BAL
WHERE
PERIOD_ID = :B3 AND LEGAL_ENTITY_ID = :B2 AND COST_GROUP_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 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 DELETE CLE_F145_PC_CM_MATCH_BAL (cr=0 pr=0 pw=0 time=5 us starts=1)
0 0 0 TABLE ACCESS FULL CLE_F145_PC_CM_MATCH_BAL (cr=0 pr=0 pw=0 time=3 us starts=1 cost=2 size=65 card=1)
Rows Execution Plan
------- ---------------------------------------------------
0 DELETE STATEMENT MODE: ALL_ROWS
0 DELETE OF 'CLE_F145_PC_CM_MATCH_BAL'
0 TABLE ACCESS MODE: ANALYZED (FULL) OF
'CLE_F145_PC_CM_MATCH_BAL' (TABLE)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 4 0.00 0.00
library cache pin 3 0.00 0.00
********************************************************************************
SQL ID: g90k5xtu46wmp Plan Hash: 0
begin fnd_file.close; end;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
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: 1aq3xz5df6m8u Plan Hash: 3678267265
SELECT CLCT.SET_OF_BOOKS_ID ,GLL.CURRENCY_CODE
FROM
CST_LE_COST_TYPES CLCT ,GL_LEDGERS GLL WHERE CLCT.COST_TYPE_ID = :B2 AND
CLCT.LEGAL_ENTITY = :B1 AND CLCT.SET_OF_BOOKS_ID = GLL.LEDGER_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 4 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 4 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 NESTED LOOPS (cr=4 pr=0 pw=0 time=23 us starts=1 cost=2 size=21 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID CST_LE_COST_TYPES (cr=2 pr=0 pw=0 time=19 us starts=1 cost=1 size=13 card=1)
1 1 1 INDEX UNIQUE SCAN CST_LE_COST_TYPES_U1 (cr=1 pr=0 pw=0 time=5 us starts=1 cost=0 size=0 card=1)(object id 8407296)
1 1 1 TABLE ACCESS BY INDEX ROWID GL_LEDGERS (cr=2 pr=0 pw=0 time=4 us starts=1 cost=1 size=8 card=1)
1 1 1 INDEX UNIQUE SCAN GL_LEDGERS_U2 (cr=1 pr=0 pw=0 time=2 us starts=1 cost=0 size=0 card=1)(object id 8442265)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'CST_LE_COST_TYPES' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'CST_LE_COST_TYPES_U1' (INDEX (UNIQUE))
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_LEDGERS'
(TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_LEDGERS_U2'
(INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 1 0.00 0.00
library cache pin 1 0.00 0.00
********************************************************************************
SQL ID: 3zzukafurd5zz Plan Hash: 3503122885
DELETE FROM CLE_F145_PC_CM_MATCH_DATA
WHERE
PERIOD_ID = :B3 AND LEGAL_ENTITY_ID = :B2 AND COST_GROUP_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 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 DELETE CLE_F145_PC_CM_MATCH_DATA (cr=0 pr=0 pw=0 time=5 us starts=1)
0 0 0 TABLE ACCESS FULL CLE_F145_PC_CM_MATCH_DATA (cr=0 pr=0 pw=0 time=3 us starts=1 cost=2 size=78 card=1)
Rows Execution Plan
------- ---------------------------------------------------
0 DELETE STATEMENT MODE: ALL_ROWS
0 DELETE OF 'CLE_F145_PC_CM_MATCH_DATA'
0 TABLE ACCESS MODE: ANALYZED (FULL) OF
'CLE_F145_PC_CM_MATCH_DATA' (TABLE)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 3 0.00 0.00
library cache pin 1 0.00 0.00
enq: TM - contention 1 0.00 0.00
********************************************************************************
SQL ID: 0rtzxn94w591n Plan Hash: 4273626101
update fnd_concurrent_requests set ofile_size=decode(to_number(:b0),'-1',
null ,to_number(:b0))
where
request_id=:b2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 4 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 6 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 UPDATE FND_CONCURRENT_REQUESTS (cr=2 pr=0 pw=0 time=55 us starts=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=6 us starts=1 cost=1 size=9 card=1)(object id 8441788)
Rows Execution Plan
------- ---------------------------------------------------
0 UPDATE STATEMENT MODE: ALL_ROWS
0 UPDATE OF 'FND_CONCURRENT_REQUESTS'
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 2 0.00 0.00
library cache pin 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: 9ap33r3ru9a8p Plan Hash: 167795121
UPDATE CLE_F145_PC_CM_BALANCES SET MATCHED_FLAG = NULL ,PROCESSED_FLAG = NULL
WHERE
MATCHED_PERIOD_ID = :B3 AND LEGAL_ENTITY_ID = :B2 AND COST_GROUP_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 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 UPDATE CLE_F145_PC_CM_BALANCES (cr=0 pr=0 pw=0 time=5 us starts=1)
0 0 0 TABLE ACCESS FULL CLE_F145_PC_CM_BALANCES (cr=0 pr=0 pw=0 time=3 us starts=1 cost=2 size=43 card=1)
Rows Execution Plan
------- ---------------------------------------------------
0 UPDATE STATEMENT MODE: ALL_ROWS
0 UPDATE OF 'CLE_F145_PC_CM_BALANCES'
0 TABLE ACCESS MODE: ANALYZED (FULL) OF
'CLE_F145_PC_CM_BALANCES' (TABLE)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 2 0.00 0.00
library cache pin 3 0.00 0.00
********************************************************************************
SQL ID: 2arzph8dcnpya Plan Hash: 3780052156
SELECT CLCT.COST_TYPE_ID
FROM
CST_LE_COST_TYPES CLCT, CST_COST_TYPES CCT WHERE CLCT.LEGAL_ENTITY = :B2 AND
CLCT.COST_TYPE_ID = :B1 AND CLCT.COST_TYPE_ID = CCT.COST_TYPE_ID AND NVL
(CCT.DISABLE_DATE, SYSDATE +1) > SYSDATE
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: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 NESTED LOOPS (cr=3 pr=0 pw=0 time=16 us starts=1 cost=1 size=19 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID CST_COST_TYPES (cr=2 pr=0 pw=0 time=13 us starts=1 cost=1 size=10 card=1)
1 1 1 INDEX UNIQUE SCAN CST_COST_TYPES_U1 (cr=1 pr=0 pw=0 time=5 us starts=1 cost=0 size=0 card=1)(object id 8419356)
1 1 1 INDEX UNIQUE SCAN CST_LE_COST_TYPES_U1 (cr=1 pr=0 pw=0 time=3 us starts=1 cost=0 size=9 card=1)(object id 8407296)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'CST_COST_TYPES' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'CST_COST_TYPES_U1'
(INDEX (UNIQUE))
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'CST_LE_COST_TYPES_U1'
(INDEX (UNIQUE))
********************************************************************************
SQL ID: axr70dk1d24cw Plan Hash: 2703352742
select priority 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 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
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=3 pr=0 pw=0 time=12 us starts=1 cost=2 size=9 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=7 us starts=1 cost=1 size=0 card=1)(object id 8441788)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 1 0.00 0.00
library cache pin 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: g4pana8z054f8 Plan Hash: 3769421323
SELECT CCT.COST_TYPE
FROM
CST_COST_TYPES CCT WHERE CCT.COST_TYPE_ID = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 2 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (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 CST_COST_TYPES (cr=2 pr=0 pw=0 time=8 us starts=1 cost=1 size=16 card=1)
1 1 1 INDEX UNIQUE SCAN CST_COST_TYPES_U1 (cr=1 pr=0 pw=0 time=4 us starts=1 cost=0 size=0 card=1)(object id 8419356)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'CST_COST_TYPES' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'CST_COST_TYPES_U1'
(INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 1 0.00 0.00
library cache pin 1 0.00 0.00
********************************************************************************
SQL ID: 2n11d838tu3s2 Plan Hash: 2041065141
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: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED FND_LOG_TRANSACTION_CONTEXT (cr=2 pr=0 pw=0 time=8 us starts=1 cost=2 size=32 card=2)
0 0 0 INDEX RANGE SCAN FND_LOG_TRANSACTION_CONTEXT_N2 (cr=2 pr=0 pw=0 time=7 us starts=1 cost=1 size=0 card=2)(object id 8433818)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF
'FND_LOG_TRANSACTION_CONTEXT' (TABLE)
0 INDEX MODE: ANALYZED (RANGE SCAN) OF
'FND_LOG_TRANSACTION_CONTEXT_N2' (INDEX)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 1 0.00 0.00
library cache pin 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: 9gut0j2v6npp7 Plan Hash: 1299350769
select 'X' into :b0
from
Fnd_Concurrent_Requests where Request_ID=:b1 for update of Status_Code
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 6 3 0
Fetch 2 0.00 0.00 0 0 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 0 6 3 2
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
Number of plan statistics captured: 2
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 FOR UPDATE (cr=3 pr=0 pw=0 time=103 us starts=1)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=3 pr=0 pw=0 time=9 us starts=1 cost=2 size=8 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=6 us starts=1 cost=1 size=0 card=1)(object id 8441788)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 FOR UPDATE
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache pin 1 0.00 0.00
SQL*Net message to client 2 0.00 0.00
SQL*Net message from client 2 0.00 0.00
********************************************************************************
SQL ID: 34fcz3tzdav4q Plan Hash: 316165216
UPDATE CLE_F145_PC_CM_MATCH_BAL SET MATCHED_FLAG = NULL ,PROCESSED_FLAG =
NULL
WHERE
MATCHED_PERIOD_ID = :B3 AND LEGAL_ENTITY_ID = :B2 AND COST_GROUP_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 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 UPDATE CLE_F145_PC_CM_MATCH_BAL (cr=0 pr=0 pw=0 time=6 us starts=1)
0 0 0 TABLE ACCESS FULL CLE_F145_PC_CM_MATCH_BAL (cr=0 pr=0 pw=0 time=3 us starts=1 cost=2 size=43 card=1)
Rows Execution Plan
------- ---------------------------------------------------
0 UPDATE STATEMENT MODE: ALL_ROWS
0 UPDATE OF 'CLE_F145_PC_CM_MATCH_BAL'
0 TABLE ACCESS MODE: ANALYZED (FULL) OF
'CLE_F145_PC_CM_MATCH_BAL' (TABLE)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 2 0.00 0.00
library cache pin 1 0.00 0.00
********************************************************************************
SQL ID: 1aka8anm4f9rq Plan Hash: 2363221084
SELECT CPP.PAC_PERIOD_ID
FROM
CST_PAC_PERIODS CPP WHERE CPP.OPEN_FLAG = 'Y' AND CPP.LEGAL_ENTITY = :B3 AND
CPP.COST_TYPE_ID = :B2 AND CPP.PAC_PERIOD_ID = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 2 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (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 CST_PAC_PERIODS (cr=2 pr=0 pw=0 time=9 us starts=1 cost=1 size=16 card=1)
1 1 1 INDEX UNIQUE SCAN CST_PAC_PERIODS_U1 (cr=1 pr=0 pw=0 time=5 us starts=1 cost=0 size=0 card=1)(object id 8434107)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'CST_PAC_PERIODS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'CST_PAC_PERIODS_U1'
(INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache pin 1 0.00 0.00
library cache lock 1 0.00 0.00
********************************************************************************
SQL ID: g06jv0t9fhj99 Plan Hash: 107478325
SELECT 1
FROM
CLE_F145_DET_SUBLEDGER_INFO WHERE LEGAL_ENTITY_ID = :B5 AND COST_TYPE_ID =
:B4 AND PERIOD_ID = :B3 AND COST_GROUP_ID = :B2 AND PROGRAM_ID = :B1 AND
POSTED_FLAG = 'Y'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 INDEX RANGE SCAN CLE_F145_DET_SUBLEDGER_INFO_N4 (cr=0 pr=0 pw=0 time=2 us starts=1 cost=1 size=67 card=1)(object id 8439975)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
0 INDEX MODE: ANALYZED (RANGE SCAN) OF
'CLE_F145_DET_SUBLEDGER_INFO_N4' (INDEX)
********************************************************************************
SQL ID: b0d48mhx23uxz Plan Hash: 4052093401
SELECT CCG.COST_GROUP_ID
FROM
CST_COST_GROUPS CCG WHERE CCG.LEGAL_ENTITY = :B2 AND CCG.COST_GROUP_ID = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 2 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (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 CST_COST_GROUPS (cr=2 pr=0 pw=0 time=9 us starts=1 cost=1 size=11 card=1)
1 1 1 INDEX UNIQUE SCAN CST_COST_GROUPS_U1 (cr=1 pr=0 pw=0 time=4 us starts=1 cost=0 size=0 card=1)(object id 8441460)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'CST_COST_GROUPS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'CST_COST_GROUPS_U1'
(INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 1 0.00 0.00
********************************************************************************
SQL ID: 39918s1sdb8b1 Plan Hash: 2703352742
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 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
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=3 pr=0 pw=0 time=11 us starts=1 cost=2 size=10 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=7 us starts=1 cost=1 size=0 card=1)(object id 8441788)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache pin 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: 2pc7ccuj1qq7h Plan Hash: 1299350769
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 2 0
Execute 1 0.00 0.00 0 3 1 0
Fetch 1 0.00 0.00 0 0 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 3 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 FOR UPDATE (cr=3 pr=0 pw=0 time=17 us starts=1)
1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=3 pr=0 pw=0 time=12 us starts=1 cost=2 size=146 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=7 us starts=1 cost=1 size=0 card=1)(object id 8441788)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 FOR UPDATE
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
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: 17yur8k0p6rx5 Plan Hash: 2363221084
SELECT PERIOD_START_DATE ,PERIOD_END_DATE
FROM
CST_PAC_PERIODS CPP WHERE CPP.PAC_PERIOD_ID= :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 2 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (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 CST_PAC_PERIODS (cr=2 pr=0 pw=0 time=7 us starts=1 cost=1 size=21 card=1)
1 1 1 INDEX UNIQUE SCAN CST_PAC_PERIODS_U1 (cr=1 pr=0 pw=0 time=5 us starts=1 cost=0 size=0 card=1)(object id 8434107)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'CST_PAC_PERIODS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'CST_PAC_PERIODS_U1'
(INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 1 0.00 0.00
library cache pin 1 0.00 0.00
********************************************************************************
SQL ID: 6u1t58whn2248 Plan Hash: 3478112908
SELECT CLCT.COST_TYPE_ID
FROM
CST_LE_COST_TYPES CLCT WHERE CLCT.LEGAL_ENTITY = :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: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 INDEX RANGE SCAN CST_LE_COST_TYPES_U1 (cr=1 pr=0 pw=0 time=8 us starts=1 cost=1 size=9 card=1)(object id 8407296)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'CST_LE_COST_TYPES_U1'
(INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 1 0.00 0.00
library cache pin 2 0.00 0.00
********************************************************************************
SQL ID: g0m4nwxsys2b5 Plan Hash: 4052093401
SELECT CCG.COST_GROUP
FROM
CST_COST_GROUPS CCG WHERE CCG.COST_GROUP_ID = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 2 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (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 CST_COST_GROUPS (cr=2 pr=0 pw=0 time=7 us starts=1 cost=1 size=17 card=1)
1 1 1 INDEX UNIQUE SCAN CST_COST_GROUPS_U1 (cr=1 pr=0 pw=0 time=5 us starts=1 cost=0 size=0 card=1)(object id 8441460)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'CST_COST_GROUPS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'CST_COST_GROUPS_U1'
(INDEX (UNIQUE))
********************************************************************************
SQL ID: 4cuxzknhvd6m8 Plan Hash: 4052093401
SELECT CCG.ORGANIZATION_ID
FROM
CST_COST_GROUPS CCG WHERE CCG.COST_GROUP_ID = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 2 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (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 CST_COST_GROUPS (cr=2 pr=0 pw=0 time=8 us starts=1 cost=1 size=13 card=1)
1 1 1 INDEX UNIQUE SCAN CST_COST_GROUPS_U1 (cr=1 pr=0 pw=0 time=4 us starts=1 cost=0 size=0 card=1)(object id 8441460)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'CST_COST_GROUPS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'CST_COST_GROUPS_U1'
(INDEX (UNIQUE))
********************************************************************************
SQL ID: 3kv2s06jgd6vh Plan Hash: 2363221084
SELECT CPP.PERIOD_NAME
FROM
CST_PAC_PERIODS CPP WHERE CPP.PAC_PERIOD_ID = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 2 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (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 CST_PAC_PERIODS (cr=2 pr=0 pw=0 time=8 us starts=1 cost=1 size=11 card=1)
1 1 1 INDEX UNIQUE SCAN CST_PAC_PERIODS_U1 (cr=1 pr=0 pw=0 time=5 us starts=1 cost=0 size=0 card=1)(object id 8434107)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'CST_PAC_PERIODS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'CST_PAC_PERIODS_U1'
(INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 1 0.00 0.00
library cache pin 1 0.00 0.00
********************************************************************************
SQL ID: 0fc939qqgtd2j Plan Hash: 2363221084
SELECT CPP.PERIOD_START_DATE ,CPP.PERIOD_END_DATE
FROM
CST_PAC_PERIODS CPP WHERE CPP.PAC_PERIOD_ID = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 2 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (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 CST_PAC_PERIODS (cr=2 pr=0 pw=0 time=8 us starts=1 cost=1 size=21 card=1)
1 1 1 INDEX UNIQUE SCAN CST_PAC_PERIODS_U1 (cr=1 pr=0 pw=0 time=5 us starts=1 cost=0 size=0 card=1)(object id 8434107)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'CST_PAC_PERIODS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'CST_PAC_PERIODS_U1'
(INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 1 0.00 0.00
library cache pin 1 0.00 0.00
********************************************************************************
SQL ID: fmfdkztk8vx23 Plan Hash: 3528876040
SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY
FROM
FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND
LANGUAGE_CODE = :B3 AND ROWNUM = 1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 2 12 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 2 12 0 3
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
0 COUNT (STOPKEY)
0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_NEW_MESSAGES' (TABLE)
0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_NEW_MESSAGES_PK' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
Disk file operations I/O 2 0.00 0.00
db file sequential read 2 0.00 0.00
SQL*Net message to client 3 0.00 0.00
SQL*Net message from client 3 0.00 0.00
********************************************************************************
SQL ID: cbdgufzbmwrtj Plan Hash: 0
BEGIN :v_status := FND_CONCURRENT_BUSINESS_EVENT.RAISE_CP_BI_EVENT(:requestid,
fnd_concurrent_business_event.program_completed); 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: ALL_ROWS
Parsing user id: 119 (APPS)
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
enq: RC - Result Cache: Contention 1 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: ALL_ROWS
Parsing user id: 119 (APPS)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
enq: RC - Result Cache: Contention 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: 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: ALL_ROWS
Parsing user id: 119 (APPS)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
utl_file I/O 38 0.00 0.00
SQL*Net message to client 2 0.00 0.00
SQL*Net message from client 2 0.00 0.00
********************************************************************************
SQL ID: 7wktnkta97u1a Plan Hash: 2947407126
SELECT FCP.CONCURRENT_PROGRAM_ID
FROM
FND_CONCURRENT_PROGRAMS FCP ,FND_APPLICATION FA WHERE FCP.APPLICATION_ID =
FA.APPLICATION_ID AND FCP.CONCURRENT_PROGRAM_NAME = 'CLEF145OSPVAR'
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 82 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 82 0 1
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 NESTED LOOPS (cr=82 pr=0 pw=0 time=570 us starts=1 cost=144 size=36 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED FND_CONCURRENT_PROGRAMS (cr=80 pr=0 pw=0 time=563 us starts=1 cost=144 size=26 card=1)
1 1 1 INDEX SKIP SCAN FND_CONCURRENT_PROGRAMS_U2 (cr=79 pr=0 pw=0 time=558 us starts=1 cost=142 size=0 card=1)(object id 8410479)
1 1 1 INDEX UNIQUE SCAN FND_APPLICATION_U1 (cr=2 pr=0 pw=0 time=7 us starts=1 cost=0 size=10 card=1)(object id 8410336)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF
'FND_CONCURRENT_PROGRAMS' (TABLE)
1 INDEX MODE: ANALYZED (SKIP SCAN) OF
'FND_CONCURRENT_PROGRAMS_U2' (INDEX (UNIQUE))
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_APPLICATION_U1'
(INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 3 0.00 0.00
********************************************************************************
SQL ID: 7w3rwbxfn1sr8 Plan Hash: 2947407126
SELECT FCP.CONCURRENT_PROGRAM_ID
FROM
FND_CONCURRENT_PROGRAMS FCP ,FND_APPLICATION FA WHERE FCP.APPLICATION_ID =
FA.APPLICATION_ID AND FCP.CONCURRENT_PROGRAM_NAME = 'CLEF145INFADJ'
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 82 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 82 0 1
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 NESTED LOOPS (cr=82 pr=0 pw=0 time=491 us starts=1 cost=144 size=36 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED FND_CONCURRENT_PROGRAMS (cr=80 pr=0 pw=0 time=484 us starts=1 cost=144 size=26 card=1)
1 1 1 INDEX SKIP SCAN FND_CONCURRENT_PROGRAMS_U2 (cr=79 pr=0 pw=0 time=481 us starts=1 cost=142 size=0 card=1)(object id 8410479)
1 1 1 INDEX UNIQUE SCAN FND_APPLICATION_U1 (cr=2 pr=0 pw=0 time=5 us starts=1 cost=0 size=10 card=1)(object id 8410336)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 NESTED LOOPS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF
'FND_CONCURRENT_PROGRAMS' (TABLE)
1 INDEX MODE: ANALYZED (SKIP SCAN) OF
'FND_CONCURRENT_PROGRAMS_U2' (INDEX (UNIQUE))
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_APPLICATION_U1'
(INDEX (UNIQUE))
********************************************************************************
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: ALL_ROWS
Parsing user id: 119 (APPS)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 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: 7uddh9khgb2f1 Plan Hash: 0
begin :v_status := FND_CONCURRENT_BUSINESS_EVENT.RAISE_CP_BI_EVENT(:requestid,
:eventid); 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: ALL_ROWS
Parsing user id: 119 (APPS)
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: a8p3z4425fk6x Plan Hash: 0
alter session set events 'sql_trace wait=true, plan_stat=adaptive'
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: 119 (APPS) (recursive depth: 1)
********************************************************************************
SQL ID: c9h14xw3t88q4 Plan Hash: 0
alter session set events 'sql_trace off'
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: 119 (APPS) (recursive depth: 2)
********************************************************************************
SQL ID: 924k0uck6anwh Plan Hash: 0
begin fnd_file_private.outfile_get(:s, :b); end;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
utl_file 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: 9w6s483fdm8tg Plan Hash: 0
declare b boolean; begin b := fnd_debug.disable_db_rules; if (b) then
:eget := 1; else :eget := 0; end if; end;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
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: cbcx3uthspn8h Plan Hash: 0
BEGIN :v_status := FND_CONCURRENT_BUSINESS_EVENT.RAISE_CP_BI_EVENT(:requestid,
fnd_concurrent_business_event.request_completed); 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: ALL_ROWS
Parsing user id: 119 (APPS)
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: 2450j0nxcnga5 Plan Hash: 0
declare sql_dummy1 boolean;begin fnd_profile.get_specific(:name, :userid,
:respid, :applid, :val, sql_dummy1, :org_id, :server_id);end;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 0.00 0.00 0 0 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
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: ALL_ROWS
Parsing user id: 119 (APPS)
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: 357ymr0xrucg6 Plan Hash: 0
begin :con := "MO_GLOBAL"."ORG_SECURITY"(:sn, :on); 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: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 2)
********************************************************************************
SQL ID: 8fs25raprhuhg Plan Hash: 2703352742
SELECT argument1
FROM
fnd_concurrent_requests where request_id = 16623574
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: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (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=3 pr=0 pw=0 time=10 us starts=1 cost=2 size=9 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=7 us starts=1 cost=1 size=0 card=1)(object id 8441788)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 1 0.00 0.00
library cache pin 1 0.00 0.00
********************************************************************************
SQL ID: g8pvv9yjq4wg2 Plan Hash: 3275353204
DELETE FROM CLE_F145_PC_CM_TEMP_DATA
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 DELETE CLE_F145_PC_CM_TEMP_DATA (cr=0 pr=0 pw=0 time=4 us starts=1)
0 0 0 TABLE ACCESS FULL CLE_F145_PC_CM_TEMP_DATA (cr=0 pr=0 pw=0 time=3 us starts=1 cost=2 size=13 card=1)
Rows Execution Plan
------- ---------------------------------------------------
0 DELETE STATEMENT MODE: ALL_ROWS
0 DELETE OF 'CLE_F145_PC_CM_TEMP_DATA'
0 TABLE ACCESS MODE: ANALYZED (FULL) OF
'CLE_F145_PC_CM_TEMP_DATA' (TABLE)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 2 0.00 0.00
library cache pin 1 0.00 0.00
********************************************************************************
SQL ID: 9kn8rfjs9r2vg Plan Hash: 0
savepoint FND_LOCK_REQUEST
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: 119 (APPS)
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: atjxwzvr5ywmz Plan Hash: 2703352742
SELECT argument2
FROM
fnd_concurrent_requests where request_id = 16623574
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: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (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=3 pr=0 pw=0 time=7 us starts=1 cost=2 size=10 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=5 us starts=1 cost=1 size=0 card=1)(object id 8441788)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
********************************************************************************
SQL ID: 7b55b10zn5uhn Plan Hash: 2703352742
SELECT argument4
FROM
fnd_concurrent_requests where request_id = 16623574
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: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (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=3 pr=0 pw=0 time=7 us starts=1 cost=2 size=10 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=5 us starts=1 cost=1 size=0 card=1)(object id 8441788)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
********************************************************************************
SQL ID: 8388nw15wqpc2 Plan Hash: 2703352742
SELECT argument3
FROM
fnd_concurrent_requests where request_id = 16623574
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: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS) (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=3 pr=0 pw=0 time=8 us starts=1 cost=2 size=9 card=1)
1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=5 us starts=1 cost=1 size=0 card=1)(object id 8441788)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
********************************************************************************
SQL ID: f9159w8dphnaw 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: 1
Optimizer mode: ALL_ROWS
Parsing user id: 119 (APPS)
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
********************************************************************************
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 33 0.00 0.00 0 0 12 0
Execute 40 0.13 0.19 3 162 64 23
Fetch 15 0.00 0.00 2 68 0 13
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 88 0.13 0.20 5 230 76 36
Misses in library cache during parse: 17
Misses in library cache during execute: 16
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 107 0.03 0.04
SQL*Net message to client 46 0.00 0.00
SQL*Net message from client 46 0.02 0.04
enq: RC - Result Cache: Contention 4 0.00 0.00
library cache lock 57 0.00 0.00
library cache pin 45 0.00 0.00
Disk file operations I/O 2 0.00 0.00
gc current block 2-way 2 0.00 0.00
utl_file I/O 157 0.00 0.01
db file sequential read 5 0.00 0.00
enq: TM - contention 1 0.00 0.00
gc current grant busy 1 0.00 0.00
gc current grant 2-way 4 0.00 0.00
log file sync 2 0.00 0.00
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 72 0.08 0.09 0 6 0 0
Execute 149 3.35 3.44 0 0 0 2
Fetch 195 1790.96 1936.34 82986 95984 56374 159
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 416 1794.40 1939.88 82986 95990 56374 161
Misses in library cache during parse: 43
Misses in library cache during execute: 33
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 364 0.00 0.00
library cache lock 95 0.00 0.01
library cache pin 109 0.00 0.01
Disk file operations I/O 47 0.00 0.00
gc current block 2-way 807 0.00 0.13
utl_file I/O 24 0.00 0.01
db file sequential read 230 0.11 0.22
gc cr grant busy 67 0.00 0.01
enq: TM - contention 2 0.00 0.00
enq: JZ - Join group dictionary 1 0.00 0.00
gc cr multi block mixed 51 0.00 0.01
db file scattered read 276 0.00 0.16
gc cr multi block grant 137 0.00 0.03
reliable message 3 0.00 0.00
enq: KO - fast object checkpoint 2 0.00 0.00
ASM IO for non-blocking poll 2916178 0.00 4.75
direct path read 2610 0.00 1.63
db file parallel read 16 0.00 0.00
CSS initialization 2 0.00 0.00
CSS operation: query 6 0.00 0.00
CSS operation: action 2 0.00 0.00
direct path write temp 13444 0.25 58.76
gc cr grant 2-way 27 0.00 0.00
gc current grant busy 8 0.00 0.00
gc current grant 2-way 6 0.00 0.00
local write wait 12324 0.01 9.81
enq: TS - contention 47 0.00 0.01
enq: SS - contention 10 0.00 0.00
DFS lock handle 139 0.71 10.47
latch: cache buffers chains 2 0.00 0.00
buffer busy waits 1 0.00 0.00
ASM file metadata operation 1 0.30 0.30
Sync ASM rebalance 5 0.02 0.02
PX Deq: reap credit 33 0.00 0.00
PX Deq: Join ACK 2 0.00 0.00
PX Deq: Parse Reply 2 0.00 0.00
PX Deq: Execute Reply 2 0.00 0.00
PX Deq: Signal ACK EXT 2 0.00 0.00
IPC send completion sync 2 0.00 0.00
PX Deq: Slave Session Stats 2 0.00 0.00
enq: PS - contention 2 0.00 0.00
76 user SQL statements in session.
27 internal SQL statements in session.
103 SQL statements in session.
54 statements EXPLAINed in this session.
********************************************************************************
Trace file: UPANB1_ora_68727_A08527_CR16623574_1121_102813.trc
Trace file compatibility: 12.2.0.0
Sort options: exeela fchela
1 session in tracefile.
76 user SQL statements in trace file.
27 internal SQL statements in trace file.
103 SQL statements in trace file.
101 unique SQL statements in trace file.
54 SQL statements EXPLAINed using schema:
APPS.prof$plan_table
Default table was used.
Table was created.
Table was dropped.
2953528 lines in trace file.
1940 elapsed seconds in trace file.