TKPROF: Release 11.2.0.3.0 - Development on Mon Dec 16 14:28:03 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Trace file: betsyu1_ora_7522_APPS.trc Sort options: prsela exeela fchela ******************************************************************************** count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call ******************************************************************************** SQL ID: 13r6stb80zdja Plan Hash: 1740397874 SELECT /*+ INDEX_ASC ( aid AP_INVOICE_DISTRIBUTIONS_X7) */AID.INVOICE_ID, GCC.SEGMENT1,AID.LINE_TYPE_LOOKUP_CODE,SUM(NVL(AID.BASE_AMOUNT,AID.AMOUNT)) AMOUNT FROM AP_INVOICE_DISTRIBUTIONS AID,GL_CODE_COMBINATIONS GCC WHERE AID.ORG_ID = :b1 AND AID.LINE_TYPE_LOOKUP_CODE = 'ITEM' AND NVL(AID.BASE_AMOUNT, AID.AMOUNT) != 0 AND AID.ACCOUNTING_DATE BETWEEN :b2 AND :b3 AND AID.ACCOUNTING_DATE <= :b4 AND GCC.CODE_COMBINATION_ID = AID.DIST_CODE_COMBINATION_ID AND AID.INVOICE_ID IN (SELECT AI.INVOICE_ID FROM AP_INVOICES AI WHERE NVL(:b5,AI.VENDOR_ID) = AI.VENDOR_ID AND NVL(:b6,AI.INVOICE_TYPE_LOOKUP_CODE) = AI.INVOICE_TYPE_LOOKUP_CODE AND (AI.CANCELLED_DATE IS NULL OR (AI.CANCELLED_DATE IS NOT NULL AND AI.CANCELLED_DATE > :b4 ))) GROUP BY AID.INVOICE_ID,GCC.SEGMENT1, AID.LINE_TYPE_LOOKUP_CODE HAVING SUM(NVL(AID.BASE_AMOUNT,AID.AMOUNT)) != 0 UNION ALL SELECT /*+ INDEX_ASC ( aid AP_INVOICE_DISTRIBUTIONS_X7) */AID.INVOICE_ID,GCC.SEGMENT1,AID.LINE_TYPE_LOOKUP_CODE, SUM(NVL(AID.BASE_AMOUNT,AID.AMOUNT)) AMOUNT FROM AP_INVOICE_DISTRIBUTIONS AID,GL_CODE_COMBINATIONS GCC WHERE AID.ORG_ID = :b1 AND AID.LINE_TYPE_LOOKUP_CODE = 'TAX' AND NVL(AID.BASE_AMOUNT,AID.AMOUNT) != 0 AND AID.ACCOUNTING_DATE BETWEEN :b2 AND :b3 AND AID.ACCOUNTING_DATE <= :b4 AND GCC.CODE_COMBINATION_ID = AID.DIST_CODE_COMBINATION_ID AND AID.INVOICE_ID IN (SELECT AI.INVOICE_ID FROM AP_INVOICES AI WHERE NVL(:b5,AI.VENDOR_ID) = AI.VENDOR_ID AND NVL(:b6, AI.INVOICE_TYPE_LOOKUP_CODE) = AI.INVOICE_TYPE_LOOKUP_CODE AND (AI.CANCELLED_DATE IS NULL OR (AI.CANCELLED_DATE IS NOT NULL AND AI.CANCELLED_DATE > :b4 ))) AND (NOT EXISTS (SELECT 1 FROM AP_INVOICE_DISTRIBUTIONS AID2 WHERE AID2.INVOICE_ID = AID.INVOICE_ID AND AID2.LINE_TYPE_LOOKUP_CODE IN ( 'WTH','ITEM','PREPAY' ) AND AID2.ACCOUNTING_DATE <= :b4 ) OR EXISTS (SELECT SUM(NVL(AID8.BASE_AMOUNT, AID8.AMOUNT)) FROM AP_INVOICE_DISTRIBUTIONS AID8 WHERE AID8.INVOICE_ID = AID.INVOICE_ID AND AID8.LINE_TYPE_LOOKUP_CODE = 'ITEM' AND AID8.ACCOUNTING_DATE <= :b4 GROUP BY AID8.LINE_TYPE_LOOKUP_CODE HAVING SUM(NVL(AID8.BASE_AMOUNT,AID8.AMOUNT)) = 0 ) ) GROUP BY AID.INVOICE_ID, GCC.SEGMENT1,AID.LINE_TYPE_LOOKUP_CODE HAVING SUM(NVL(AID.BASE_AMOUNT, AID.AMOUNT)) != 0 UNION ALL SELECT /*+ INDEX_ASC ( aid AP_INVOICE_DISTRIBUTIONS_X7) */AID.INVOICE_ID,GCC.SEGMENT1, AID.LINE_TYPE_LOOKUP_CODE,SUM(NVL(AID.BASE_AMOUNT,AID.AMOUNT)) AMOUNT FROM AP_INVOICE_DISTRIBUTIONS AID,GL_CODE_COMBINATIONS GCC WHERE AID.ORG_ID = :b1 AND AID.LINE_TYPE_LOOKUP_CODE = 'FREIGHT' AND NVL(AID.BASE_AMOUNT,AID.AMOUNT) != 0 AND AID.ACCOUNTING_DATE BETWEEN :b2 AND :b3 AND AID.ACCOUNTING_DATE <= :b4 AND GCC.CODE_COMBINATION_ID = AID.DIST_CODE_COMBINATION_ID AND AID.INVOICE_ID IN (SELECT AI.INVOICE_ID FROM AP_INVOICES AI WHERE NVL(:b5,AI.VENDOR_ID) = AI.VENDOR_ID AND NVL(:b6,AI.INVOICE_TYPE_LOOKUP_CODE) = AI.INVOICE_TYPE_LOOKUP_CODE AND (AI.CANCELLED_DATE IS NULL OR (AI.CANCELLED_DATE IS NOT NULL AND AI.CANCELLED_DATE > :b4 ))) AND (NOT EXISTS (SELECT 1 FROM AP_INVOICE_DISTRIBUTIONS AID2 WHERE AID2.INVOICE_ID = AID.INVOICE_ID AND AID2.LINE_TYPE_LOOKUP_CODE IN ( 'WTH','ITEM','PREPAY' ) AND AID2.ACCOUNTING_DATE <= :b4 ) OR EXISTS (SELECT SUM(NVL(AID8.BASE_AMOUNT, AID8.AMOUNT)) FROM AP_INVOICE_DISTRIBUTIONS AID8 WHERE AID8.INVOICE_ID = AID.INVOICE_ID AND AID8.LINE_TYPE_LOOKUP_CODE = 'ITEM' AND AID8.ACCOUNTING_DATE <= :b4 GROUP BY AID8.LINE_TYPE_LOOKUP_CODE HAVING SUM(NVL(AID8.BASE_AMOUNT,AID8.AMOUNT)) = 0 ) ) GROUP BY AID.INVOICE_ID, GCC.SEGMENT1,AID.LINE_TYPE_LOOKUP_CODE HAVING SUM(NVL(AID.BASE_AMOUNT, AID.AMOUNT)) != 0 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.01 0 0 0 0 Execute 330 0.15 0.17 0 0 0 0 Fetch 529837 111.40 1876.08 151301 2384537 0 529507 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 530168 111.57 1876.27 151301 2384537 0 529507 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UNION-ALL (cr=12 pr=4 pw=0 time=111437 us) 0 0 0 FILTER (cr=4 pr=4 pw=0 time=110944 us) 0 0 0 HASH GROUP BY (cr=4 pr=4 pw=0 time=110941 us) 0 0 0 CONCATENATION (cr=4 pr=4 pw=0 time=110759 us) 0 0 0 FILTER (cr=4 pr=4 pw=0 time=110732 us) 0 0 0 NESTED LOOPS (cr=4 pr=4 pw=0 time=110728 us) 0 0 0 NESTED LOOPS (cr=4 pr=4 pw=0 time=110720 us cost=17 size=74 card=1) 0 0 0 NESTED LOOPS (cr=4 pr=4 pw=0 time=110717 us cost=15 size=47 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=4 pr=4 pw=0 time=110711 us cost=13 size=36 card=1) 0 0 0 INDEX RANGE SCAN AP_INVOICE_DISTRIBUTIONS_X6 (cr=4 pr=4 pw=0 time=110704 us cost=12 size=0 card=2)(object id 9278695) 0 0 0 TABLE ACCESS BY INDEX ROWID GL_CODE_COMBINATIONS (cr=0 pr=0 pw=0 time=0 us cost=2 size=11 card=1) 0 0 0 INDEX UNIQUE SCAN GL_CODE_COMBINATIONS_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 33901) 0 0 0 INDEX UNIQUE SCAN AP_INVOICES_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 27998) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=0 pr=0 pw=0 time=0 us cost=2 size=27 card=1) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=8 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=10 size=74 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=8 size=63 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=0 pr=0 pw=0 time=0 us cost=4 size=27 card=1) 0 0 0 INDEX RANGE SCAN AP_INVOICES_U2 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=1)(object id 28004) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=0 pr=0 pw=0 time=0 us cost=4 size=36 card=1) 0 0 0 INDEX RANGE SCAN XXAP_AP_INVOICE_DISTRI_X2 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=1)(object id 2527394) 0 0 0 INDEX UNIQUE SCAN GL_CODE_COMBINATIONS_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 33901) 0 0 0 TABLE ACCESS BY INDEX ROWID GL_CODE_COMBINATIONS (cr=0 pr=0 pw=0 time=0 us cost=2 size=11 card=1) 0 0 0 FILTER (cr=4 pr=0 pw=0 time=388 us) 0 0 0 HASH GROUP BY (cr=4 pr=0 pw=0 time=387 us) 0 0 0 CONCATENATION (cr=4 pr=0 pw=0 time=252 us) 0 0 0 FILTER (cr=4 pr=0 pw=0 time=243 us) 0 0 0 FILTER (cr=4 pr=0 pw=0 time=241 us) 0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=239 us) 0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=237 us cost=17 size=74 card=1) 0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=234 us cost=15 size=47 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=4 pr=0 pw=0 time=231 us cost=13 size=36 card=1) 0 0 0 INDEX RANGE SCAN AP_INVOICE_DISTRIBUTIONS_X6 (cr=4 pr=0 pw=0 time=227 us cost=12 size=0 card=2)(object id 9278695) 0 0 0 TABLE ACCESS BY INDEX ROWID GL_CODE_COMBINATIONS (cr=0 pr=0 pw=0 time=0 us cost=2 size=11 card=1) 0 0 0 INDEX UNIQUE SCAN GL_CODE_COMBINATIONS_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 33901) 0 0 0 INDEX UNIQUE SCAN AP_INVOICES_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 27998) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=0 pr=0 pw=0 time=0 us cost=2 size=27 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=0 pr=0 pw=0 time=0 us cost=5 size=23 card=1) 0 0 0 INDEX RANGE SCAN XXAP_AP_INVOICE_DISTRI_X2 (cr=0 pr=0 pw=0 time=0 us cost=4 size=0 card=1)(object id 2527394) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us) 0 0 0 SORT GROUP BY NOSORT (cr=0 pr=0 pw=0 time=0 us cost=5 size=30 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=0 pr=0 pw=0 time=0 us cost=5 size=30 card=1) 0 0 0 INDEX RANGE SCAN XXAP_AP_INVOICE_DISTRI_X2 (cr=0 pr=0 pw=0 time=0 us cost=4 size=0 card=1)(object id 2527394) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=2 us) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=1 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=10 size=74 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=8 size=63 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=0 pr=0 pw=0 time=0 us cost=4 size=27 card=1) 0 0 0 INDEX RANGE SCAN AP_INVOICES_U2 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=1)(object id 28004) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=0 pr=0 pw=0 time=0 us cost=4 size=36 card=1) 0 0 0 INDEX RANGE SCAN XXAP_AP_INVOICE_DISTRI_X2 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=1)(object id 2527394) 0 0 0 INDEX UNIQUE SCAN GL_CODE_COMBINATIONS_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 33901) 0 0 0 TABLE ACCESS BY INDEX ROWID GL_CODE_COMBINATIONS (cr=0 pr=0 pw=0 time=0 us cost=2 size=11 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=0 pr=0 pw=0 time=0 us cost=5 size=23 card=1) 0 0 0 INDEX RANGE SCAN XXAP_AP_INVOICE_DISTRI_X2 (cr=0 pr=0 pw=0 time=0 us cost=4 size=0 card=1)(object id 2527394) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us) 0 0 0 SORT GROUP BY NOSORT (cr=0 pr=0 pw=0 time=0 us cost=5 size=30 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=0 pr=0 pw=0 time=0 us cost=5 size=30 card=1) 0 0 0 INDEX RANGE SCAN XXAP_AP_INVOICE_DISTRI_X2 (cr=0 pr=0 pw=0 time=0 us cost=4 size=0 card=1)(object id 2527394) 0 0 0 FILTER (cr=4 pr=0 pw=0 time=83 us) 0 0 0 HASH GROUP BY (cr=4 pr=0 pw=0 time=82 us) 0 0 0 CONCATENATION (cr=4 pr=0 pw=0 time=46 us) 0 0 0 FILTER (cr=4 pr=0 pw=0 time=39 us) 0 0 0 FILTER (cr=4 pr=0 pw=0 time=36 us) 0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=32 us) 0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=31 us cost=17 size=74 card=1) 0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=29 us cost=15 size=47 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=4 pr=0 pw=0 time=28 us cost=13 size=36 card=1) 0 0 0 INDEX RANGE SCAN AP_INVOICE_DISTRIBUTIONS_X6 (cr=4 pr=0 pw=0 time=21 us cost=12 size=0 card=2)(object id 9278695) 0 0 0 TABLE ACCESS BY INDEX ROWID GL_CODE_COMBINATIONS (cr=0 pr=0 pw=0 time=0 us cost=2 size=11 card=1) 0 0 0 INDEX UNIQUE SCAN GL_CODE_COMBINATIONS_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 33901) 0 0 0 INDEX UNIQUE SCAN AP_INVOICES_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 27998) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=0 pr=0 pw=0 time=0 us cost=2 size=27 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=0 pr=0 pw=0 time=0 us cost=5 size=23 card=1) 0 0 0 INDEX RANGE SCAN XXAP_AP_INVOICE_DISTRI_X2 (cr=0 pr=0 pw=0 time=0 us cost=4 size=0 card=1)(object id 2527394) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us) 0 0 0 SORT GROUP BY NOSORT (cr=0 pr=0 pw=0 time=0 us cost=5 size=30 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=0 pr=0 pw=0 time=0 us cost=5 size=30 card=1) 0 0 0 INDEX RANGE SCAN XXAP_AP_INVOICE_DISTRI_X2 (cr=0 pr=0 pw=0 time=0 us cost=4 size=0 card=1)(object id 2527394) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=3 us) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=1 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=10 size=74 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=8 size=63 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=0 pr=0 pw=0 time=0 us cost=4 size=27 card=1) 0 0 0 INDEX RANGE SCAN AP_INVOICES_U2 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=1)(object id 28004) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=0 pr=0 pw=0 time=0 us cost=4 size=36 card=1) 0 0 0 INDEX RANGE SCAN XXAP_AP_INVOICE_DISTRI_X2 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=1)(object id 2527394) 0 0 0 INDEX UNIQUE SCAN GL_CODE_COMBINATIONS_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 33901) 0 0 0 TABLE ACCESS BY INDEX ROWID GL_CODE_COMBINATIONS (cr=0 pr=0 pw=0 time=0 us cost=2 size=11 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=0 pr=0 pw=0 time=0 us cost=5 size=23 card=1) 0 0 0 INDEX RANGE SCAN XXAP_AP_INVOICE_DISTRI_X2 (cr=0 pr=0 pw=0 time=0 us cost=4 size=0 card=1)(object id 2527394) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us) 0 0 0 SORT GROUP BY NOSORT (cr=0 pr=0 pw=0 time=0 us cost=5 size=30 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=0 pr=0 pw=0 time=0 us cost=5 size=30 card=1) 0 0 0 INDEX RANGE SCAN XXAP_AP_INVOICE_DISTRI_X2 (cr=0 pr=0 pw=0 time=0 us cost=4 size=0 card=1)(object id 2527394) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 UNION-ALL 0 FILTER 0 HASH (GROUP BY) 0 CONCATENATION 0 FILTER 0 NESTED LOOPS 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_DISTRIBUTIONS_X6' (INDEX) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_CODE_COMBINATIONS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_CODE_COMBINATIONS_U1' (INDEX (UNIQUE)) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_INVOICES_U1' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 0 FILTER 0 NESTED LOOPS 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICES_U2' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_AP_INVOICE_DISTRI_X2' (INDEX) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_CODE_COMBINATIONS_U1' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_CODE_COMBINATIONS' (TABLE) 0 FILTER 0 HASH (GROUP BY) 0 CONCATENATION 0 FILTER 0 FILTER 0 NESTED LOOPS 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_DISTRIBUTIONS_X6' (INDEX) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_CODE_COMBINATIONS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_CODE_COMBINATIONS_U1' (INDEX (UNIQUE)) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_INVOICES_U1' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_AP_INVOICE_DISTRI_X2' (INDEX) 0 FILTER 0 SORT (GROUP BY NOSORT) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_AP_INVOICE_DISTRI_X2' (INDEX) 0 FILTER 0 FILTER 0 NESTED LOOPS 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICES_U2' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_AP_INVOICE_DISTRI_X2' (INDEX) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_CODE_COMBINATIONS_U1' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_CODE_COMBINATIONS' (TABLE) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_AP_INVOICE_DISTRI_X2' (INDEX) 0 FILTER 0 SORT (GROUP BY NOSORT) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_AP_INVOICE_DISTRI_X2' (INDEX) 0 FILTER 0 HASH (GROUP BY) 0 CONCATENATION 0 FILTER 0 FILTER 0 NESTED LOOPS 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_DISTRIBUTIONS_X6' (INDEX) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_CODE_COMBINATIONS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_CODE_COMBINATIONS_U1' (INDEX (UNIQUE)) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_INVOICES_U1' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_AP_INVOICE_DISTRI_X2' (INDEX) 0 FILTER 0 SORT (GROUP BY NOSORT) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_AP_INVOICE_DISTRI_X2' (INDEX) 0 FILTER 0 FILTER 0 NESTED LOOPS 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICES_U2' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_AP_INVOICE_DISTRI_X2' (INDEX) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_CODE_COMBINATIONS_U1' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_CODE_COMBINATIONS' (TABLE) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_AP_INVOICE_DISTRI_X2' (INDEX) 0 FILTER 0 SORT (GROUP BY NOSORT) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_AP_INVOICE_DISTRI_X2' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 530498 0.00 0.40 SQL*Net message from client 530498 0.00 54.45 db file sequential read 151301 0.31 1777.22 Disk file operations I/O 8 0.00 0.00 ******************************************************************************** SQL ID: bap0ggm0bt6m3 Plan Hash: 1790540045 SELECT PS.DUE_DATE,PS.AMOUNT_REMAINING FROM AP_PAYMENT_SCHEDULES PS WHERE PS.INVOICE_ID = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 445765 12.18 12.00 0 0 0 0 Fetch 445765 47.44 533.77 47426 1786771 0 445765 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 891531 59.62 545.78 47426 1786771 0 445765 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID AP_PAYMENT_SCHEDULES_ALL (cr=4 pr=4 pw=0 time=155116 us cost=4 size=21 card=1) 1 1 1 INDEX RANGE SCAN AP_PAYMENT_SCHEDULES_U1 (cr=3 pr=3 pw=0 time=110555 us cost=3 size=0 card=1)(object id 27622) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_PAYMENT_SCHEDULES_ALL' (TABLE) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_PAYMENT_SCHEDULES_U1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1337296 0.00 1.04 SQL*Net message from client 1337296 0.01 71.98 db file sequential read 47426 0.22 490.62 latch: cache buffers chains 1 0.00 0.00 ******************************************************************************** SQL ID: 956b1622psput Plan Hash: 1421515667 SELECT COUNT(1) FROM AP_INVOICE_PAYMENTS AIP,AP_CHECKS AC WHERE AIP.CHECK_ID = AC.CHECK_ID AND AIP.INVOICE_ID = :b1 AND AIP.ACCOUNTING_DATE > :b2 AND DECODE(AC.STATUS_LOOKUP_CODE,'VOIDED','Y','N') = 'N' AND ROWNUM = 1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 431190 21.52 20.59 0 0 0 0 Fetch 431190 44.68 476.90 34847 1684232 0 431190 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 862381 66.20 497.49 34847 1684232 0 431190 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=10 pr=10 pw=0 time=272044 us) 0 0 0 COUNT STOPKEY (cr=10 pr=10 pw=0 time=272023 us) 0 0 0 NESTED LOOPS (cr=10 pr=10 pw=0 time=271997 us) 0 0 0 NESTED LOOPS (cr=10 pr=10 pw=0 time=271994 us cost=6 size=50 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_PAYMENTS_ALL (cr=10 pr=10 pw=0 time=271989 us cost=4 size=24 card=1) 7 7 7 INDEX RANGE SCAN AP_INVOICE_PAYMENTS_N1 (cr=3 pr=3 pw=0 time=83215 us cost=3 size=0 card=1)(object id 27688) 0 0 0 INDEX UNIQUE SCAN AP_CHECKS_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 27616) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_CHECKS_ALL (cr=0 pr=0 pw=0 time=0 us cost=2 size=26 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 SORT (AGGREGATE) 0 COUNT (STOPKEY) 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_PAYMENTS_ALL' (TABLE) 7 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_PAYMENTS_N1' (INDEX) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_CHECKS_U1' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_CHECKS_ALL' (TABLE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1293571 0.00 1.00 SQL*Net message from client 1293571 0.02 65.98 db file sequential read 34847 0.17 434.89 Disk file operations I/O 2 0.00 0.00 latch: cache buffers chains 3 0.00 0.00 ******************************************************************************** SQL ID: 2x4jgc4vsgm5c Plan Hash: 1925498678 SELECT COUNT(1) FROM AP_INVOICE_DISTRIBUTIONS WHERE INVOICE_ID = :b1 AND LINE_TYPE_LOOKUP_CODE = 'PREPAY' AND ACCOUNTING_DATE > :b2 AND ROWNUM = 1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 431057 18.03 17.61 0 0 0 0 Fetch 431057 39.86 435.29 27296 1731254 0 431057 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 862115 57.89 452.90 27296 1731254 0 431057 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=5 pr=5 pw=0 time=96679 us) 0 0 0 COUNT STOPKEY (cr=5 pr=5 pw=0 time=96659 us) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=5 pr=5 pw=0 time=96649 us cost=5 size=23 card=1) 0 0 0 INDEX RANGE SCAN XXAP_AP_INVOICE_DISTRI_X2 (cr=5 pr=5 pw=0 time=96645 us cost=4 size=0 card=1)(object id 2527394) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 SORT (AGGREGATE) 0 COUNT (STOPKEY) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_AP_INVOICE_DISTRI_X2' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1293172 0.00 1.02 SQL*Net message from client 1293172 0.01 79.44 db file sequential read 27296 0.20 398.24 latch: cache buffers chains 1 0.00 0.00 ******************************************************************************** SQL ID: 5mx2x973sg86s Plan Hash: 933695613 SELECT T.DESCRIPTION,FFV.PARENT_FLEX_VALUE FROM FND_FLEX_VALUES_TL T,FND_FLEX_VALUES B,FND_FLEX_VALUE_NORM_HIERARCHY FFV WHERE B.FLEX_VALUE_ID = T.FLEX_VALUE_ID AND T.LANGUAGE = USERENV('LANG') AND B.FLEX_VALUE = :b1 AND B.FLEX_VALUE_SET_ID = :b2 AND FFV.FLEX_VALUE_SET_ID = :b2 AND :b1 BETWEEN FFV.CHILD_FLEX_VALUE_LOW AND FFV.CHILD_FLEX_VALUE_HIGH AND FFV.PARENT_FLEX_VALUE BETWEEN :b5 AND :b6 AND FFV.PARENT_FLEX_VALUE NOT LIKE '2ZZ%' AND B.SUMMARY_FLAG = 'N' AND B.ENABLED_FLAG = 'Y' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 514799 22.49 22.47 0 0 0 0 Fetch 514799 70.25 70.91 26 4595718 0 445765 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1029599 92.75 93.39 26 4595718 0 445765 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 FILTER (cr=2 pr=2 pw=0 time=32305 us) 0 0 0 NESTED LOOPS (cr=2 pr=2 pw=0 time=32297 us) 0 0 0 NESTED LOOPS (cr=2 pr=2 pw=0 time=32290 us cost=7 size=79 card=1) 0 0 0 MERGE JOIN CARTESIAN (cr=2 pr=2 pw=0 time=32286 us cost=5 size=51 card=1) 0 0 0 INDEX RANGE SCAN FND_FLEX_VALUE_NORM_HIER_U1 (cr=2 pr=2 pw=0 time=32280 us cost=2 size=25 card=1)(object id 33575) 0 0 0 BUFFER SORT (cr=0 pr=0 pw=0 time=0 us cost=3 size=26 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_FLEX_VALUES (cr=0 pr=0 pw=0 time=0 us cost=3 size=26 card=1) 0 0 0 INDEX RANGE SCAN FND_FLEX_VALUES_N1 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 3053899) 0 0 0 INDEX UNIQUE SCAN FND_FLEX_VALUES_TL_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 33908) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_FLEX_VALUES_TL (cr=0 pr=0 pw=0 time=0 us cost=2 size=56 card=2) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 FILTER 0 NESTED LOOPS 0 NESTED LOOPS 0 MERGE JOIN (CARTESIAN) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_FLEX_VALUE_NORM_HIER_U1' (INDEX (UNIQUE)) 0 BUFFER (SORT) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_FLEX_VALUES' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_FLEX_VALUES_N1' (INDEX) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_FLEX_VALUES_TL_U1' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_FLEX_VALUES_TL' (TABLE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1544398 0.00 1.19 SQL*Net message from client 1544398 0.01 85.30 db file sequential read 26 0.05 0.50 Disk file operations I/O 2 0.00 0.00 latch: cache buffers chains 4 0.00 0.00 ******************************************************************************** SQL ID: bfqfztb6yprt9 Plan Hash: 1199891097 SELECT I.INVOICE_ID,I.VENDOR_ID,I.INVOICE_NUM,I.INVOICE_CURRENCY_CODE, I.PAYMENT_CURRENCY_CODE,I.PAYMENT_CROSS_RATE,I.VENDOR_SITE_ID,I.AMOUNT_PAID, I.INVOICE_TYPE_LOOKUP_CODE,I.ACCTS_PAY_CODE_COMBINATION_ID,I.INVOICE_DATE, I.EXCHANGE_RATE,I.CANCELLED_DATE,I.ORG_ID,I.GL_DATE,I.PAYMENT_STATUS_FLAG, I.TERMS_ID FROM AP_INVOICES I WHERE I.INVOICE_ID = :b1 AND NVL(:b2,I.VENDOR_ID) = I.VENDOR_ID AND NVL(:b3,I.INVOICE_TYPE_LOOKUP_CODE) = I.INVOICE_TYPE_LOOKUP_CODE AND (I.CANCELLED_DATE IS NULL OR (I.CANCELLED_DATE IS NOT NULL AND I.CANCELLED_DATE > :b4 )) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 445765 30.24 30.17 0 0 0 0 Fetch 891530 39.42 40.43 4 1783110 0 445765 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1337296 69.66 70.60 4 1783110 0 445765 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=4 pr=0 pw=0 time=72 us cost=3 size=88 card=1) 1 1 1 INDEX UNIQUE SCAN AP_INVOICES_U1 (cr=3 pr=0 pw=0 time=34 us cost=2 size=0 card=1)(object id 27998) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 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)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1783061 0.00 1.22 SQL*Net message from client 1783061 0.54 109.40 db file sequential read 4 0.03 0.07 latch: cache buffers chains 1 0.00 0.00 ******************************************************************************** SQL ID: 60v25skgb0adu Plan Hash: 3957376110 SELECT /*+ INDEX ( xxap_invoice_aging_all XXAP_INVOICE_AGING_ALL_N1) */SUM(DECODE(SEGMENT1,:b1,1,0)),SUM(DECODE(SEGMENT1,:b1,0,SUM_DIST_AMOUNT)) FROM XXAP_INVOICE_AGING_ALL WHERE INVOICE_ID = :b3 AND LINE_TYPE_LOOKUP_CODE = :b4 AND REQUEST_ID = :b5 AND ORG_ID = :b6 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 529507 23.47 22.88 0 0 0 0 Fetch 529507 30.39 47.28 2098 1720229 0 529507 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1059015 53.86 70.17 2098 1720229 0 529507 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=4 pr=0 pw=0 time=83 us) 0 0 0 TABLE ACCESS BY INDEX ROWID XXAP_INVOICE_AGING_ALL (cr=4 pr=0 pw=0 time=70 us cost=0 size=188 card=1) 0 0 0 INDEX RANGE SCAN XXAP_INVOICE_AGING_N3 (cr=4 pr=0 pw=0 time=69 us cost=0 size=0 card=1)(object id 10007439) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 SORT (AGGREGATE) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'XXAP_INVOICE_AGING_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_INVOICE_AGING_N3' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1588522 0.00 1.08 SQL*Net message from client 1588522 0.01 97.21 db file sequential read 2098 0.10 17.06 latch: shared pool 1 0.00 0.00 ******************************************************************************** SQL ID: b8h1s8rdzuyc9 Plan Hash: 251242241 SELECT T.DESCRIPTION FROM FND_FLEX_VALUES_TL T,FND_FLEX_VALUES B WHERE B.FLEX_VALUE_ID = T.FLEX_VALUE_ID AND T.LANGUAGE = USERENV('LANG') AND B.FLEX_VALUE = :b1 AND B.FLEX_VALUE_SET_ID = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 514799 16.00 15.98 0 0 0 0 Fetch 514799 43.94 43.80 0 4118344 0 514793 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1029599 59.94 59.79 0 4118344 0 514793 Misses in library cache during parse: 1 Misses in library cache during execute: 2 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=28 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=18 us cost=6 size=100 card=2) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_FLEX_VALUES (cr=0 pr=0 pw=0 time=17 us cost=4 size=22 card=1) 0 0 0 INDEX RANGE SCAN FND_FLEX_VALUES_N1 (cr=0 pr=0 pw=0 time=11 us cost=3 size=0 card=1)(object id 3053899) 0 0 0 INDEX UNIQUE SCAN FND_FLEX_VALUES_TL_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 33908) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_FLEX_VALUES_TL (cr=0 pr=0 pw=0 time=0 us cost=2 size=56 card=2) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_FLEX_VALUES' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_FLEX_VALUES_N1' (INDEX) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_FLEX_VALUES_TL_U1' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_FLEX_VALUES_TL' (TABLE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1544398 0.00 1.16 SQL*Net message from client 1544398 0.01 86.39 ******************************************************************************** SQL ID: a6uwtmm61tu2s Plan Hash: 4044759688 SELECT NVL(SUM(NVL(NVL((AID.AMOUNT * ROUND(:b1,5) ),AID.AMOUNT),0)),0) FROM AP_INVOICE_DISTRIBUTIONS AID WHERE AID.INVOICE_ID = :b2 AND TRUNC(AID.ACCOUNTING_DATE) <= :b3 AND NVL(AID.BASE_AMOUNT,AID.AMOUNT) != 0 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 12722 0.43 0.54 0 0 0 0 Fetch 12722 2.54 44.61 2552 64079 0 12722 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 25445 2.98 45.16 2552 64079 0 12722 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=5 pr=0 pw=0 time=189 us) 1 1 1 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=5 pr=0 pw=0 time=161 us cost=5 size=25 card=1) 1 1 1 INDEX RANGE SCAN XXAP_AP_INVOICE_DISTRI_X2 (cr=4 pr=0 pw=0 time=114 us cost=4 size=0 card=1)(object id 2527394) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 SORT (AGGREGATE) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_AP_INVOICE_DISTRI_X2' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 38167 0.00 0.03 SQL*Net message from client 38167 0.00 3.16 db file sequential read 2552 0.14 42.27 ******************************************************************************** SQL ID: 6tttxsjcdy06w Plan Hash: 4044759688 SELECT NVL(SUM(NVL(NVL((AID.AMOUNT * ROUND(:b1,5) ),AID.AMOUNT),0)),0) FROM AP_INVOICE_DISTRIBUTIONS AID WHERE AID.INVOICE_ID = :b2 AND TRUNC(AID.ACCOUNTING_DATE) <= :b3 AND AID.LINE_TYPE_LOOKUP_CODE IN ( 'ITEM','FREIGHT','MISCELLANEOUS','TAX','AWT' ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1912 0.07 0.08 0 0 0 0 Fetch 1912 0.68 14.41 772 9625 0 1912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3825 0.76 14.50 772 9625 0 1912 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=7 pr=0 pw=0 time=224 us) 12 12 12 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=7 pr=0 pw=0 time=238 us cost=5 size=28 card=1) 12 12 12 INDEX RANGE SCAN XXAP_AP_INVOICE_DISTRI_X2 (cr=4 pr=0 pw=0 time=143 us cost=4 size=0 card=1)(object id 2527394) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 SORT (AGGREGATE) 12 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 12 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_AP_INVOICE_DISTRI_X2' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5737 0.00 0.00 SQL*Net message from client 5737 0.00 0.44 db file sequential read 772 0.12 13.96 ******************************************************************************** SQL ID: 7ngv5grx7xwaa Plan Hash: 0 INSERT INTO XXAP_INVOICE_AGING_ALL ( INVOICE_ID,VENDOR_ID,INVOICE_NUM, INVOICE_CURRENCY_CODE,PAYMENT_CURRENCY_CODE,PAYMENT_CROSS_RATE, VENDOR_SITE_ID,AMOUNT_PAID,INVOICE_DATE,INVOICE_TYPE_LOOKUP_CODE, ACCTS_PAY_CODE_COMBINATION_ID,EXCHANGE_RATE,CANCELLED_DATE,ORG_ID,GL_DATE, LINE_TYPE_LOOKUP_CODE,SEGMENT1,SEGMENT_DESCRIPTION,SEGMENT_GROUP, GROUP_DESCRIPTION,SUM_DIST_AMOUNT,PAYMENT_STATUS_FLAG,DISTRIBUTION_SPLIT, TERMS_ID,DUE_DATE,REQUEST_ID,CREATED_BY,CREATION_DATE ) VALUES ( :b1,:b2,:b3,:b4,:b5,:b6,:b7,:b8,:b9,:b10,:b11,:b12,:b13,:b14,:b15,:b16, :b17,:b18,:b19,:b20,:b21,:b22,:b23,:b24,:b25,:b26,:b27,SYSDATE ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 14708 6.13 12.94 1020 3281 182357 14708 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14709 6.13 12.95 1020 3281 182357 14708 Misses in library cache during parse: 1 Misses in library cache during execute: 3 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=1 pw=0 time=943 us) Rows Execution Plan ------- --------------------------------------------------- 0 INSERT STATEMENT MODE: CHOOSE 0 LOAD TABLE CONVENTIONAL OF 'XXAP_INVOICE_AGING_ALL' Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 29417 0.00 0.02 SQL*Net message from client 29417 0.01 1.54 db file sequential read 1020 0.15 6.51 Disk file operations I/O 1 0.00 0.00 buffer busy waits 1 0.00 0.00 ******************************************************************************** SQL ID: 374x48vwuv0j0 Plan Hash: 1299010522 SELECT DISPLAYED_FIELD FROM PO_LOOKUP_CODES A,PO_VENDORS B WHERE NVL(A.INACTIVE_DATE,SYSDATE + 1 ) > SYSDATE AND A.LOOKUP_TYPE = 'VENDOR TYPE' AND UPPER(A.LOOKUP_CODE) = UPPER(B.VENDOR_TYPE_LOOKUP_CODE) AND B.VENDOR_ID = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 14708 0.81 0.89 0 0 0 0 Fetch 14708 7.91 10.62 248 117664 0 14708 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 29417 8.72 11.52 248 117664 0 14708 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=8 pr=3 pw=0 time=38446 us cost=5 size=74 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID PO_VENDORS (cr=3 pr=0 pw=0 time=76 us cost=2 size=13 card=1) 1 1 1 INDEX UNIQUE SCAN PO_VENDORS_U1 (cr=2 pr=0 pw=0 time=52 us cost=1 size=0 card=1)(object id 45068) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=5 pr=3 pw=0 time=38361 us cost=3 size=61 card=1) 1 1 1 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (cr=4 pr=2 pw=0 time=19199 us cost=2 size=0 card=1)(object id 32878) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 NESTED LOOPS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'PO_VENDORS' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'PO_VENDORS_U1' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) 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 ---------- ------------ SQL*Net message to client 29417 0.00 0.02 SQL*Net message from client 29417 0.00 1.70 db file sequential read 248 0.07 3.05 Disk file operations I/O 1 0.00 0.00 library cache: mutex X 1 0.00 0.00 latch: cache buffers chains 1 0.00 0.00 ******************************************************************************** SQL ID: 41yx8u108kc8v Plan Hash: 3580082832 SELECT NVL(ABS(SUM(AIDV.AMOUNT * NVL(:b1,1) )),0) FROM AP_INVOICE_DISTRIBUTIONS AIDV,AP_INVOICE_DISTRIBUTIONS AID WHERE AIDV.PREPAY_DISTRIBUTION_ID = AID.INVOICE_DISTRIBUTION_ID AND AIDV.INVOICE_ID = :b2 AND AIDV.LINE_TYPE_LOOKUP_CODE = 'PREPAY' AND TRUNC(AIDV.ACCOUNTING_DATE) <= :b3 AND :b4 IS NULL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1912 0.10 0.10 0 0 0 0 Fetch 1912 0.34 10.93 568 9190 0 1912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3825 0.45 11.03 568 9190 0 1912 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=4 pr=0 pw=0 time=129 us) 0 0 0 FILTER (cr=4 pr=0 pw=0 time=114 us) 0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=112 us) 0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=106 us cost=7 size=40 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=4 pr=0 pw=0 time=105 us cost=5 size=30 card=1) 0 0 0 INDEX RANGE SCAN XXAP_AP_INVOICE_DISTRI_X2 (cr=4 pr=0 pw=0 time=98 us cost=4 size=0 card=1)(object id 2527394) 0 0 0 INDEX UNIQUE SCAN AP_INVOICE_DISTRIBUTIONS_U2 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 28163) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=0 pr=0 pw=0 time=0 us cost=2 size=10 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 SORT (AGGREGATE) 0 FILTER 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_AP_INVOICE_DISTRI_X2' (INDEX) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_INVOICE_DISTRIBUTIONS_U2' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3825 0.00 0.00 SQL*Net message from client 3825 0.00 0.65 db file sequential read 568 0.08 10.64 ******************************************************************************** SELECT /*+ INDEX ( i XXAP_INVOICE_AGING_N2 ) */ i.line_type_lookup_code clase, i.segment_group grupo, i.segment1 division, i.invoice_type_lookup_code, i.amount_paid*NVL(i.exchange_rate,1) amount_paid, v.vendor_name C_VENDOR_NAME, DECODE(UPPER(:P_SORT_OPTION), 'VENDOR NAME', DECODE(:C_VENDOR_NAME_SELECT, '%',UPPER(v.vendor_name),v.vendor_name), i.invoice_type_lookup_code) C_PRIMARY_BRK, DECODE(UPPER(:P_SORT_OPTION), 'VENDOR NAME', DECODE(:C_VENDOR_NAME_SELECT,'%', DECODE(:SORT_BY_ALTERNATE,'Y', UPPER(v.vendor_name_alt),UPPER(v.vendor_name)), DECODE(:SORT_BY_ALTERNATE, 'Y', v.vendor_name_alt, v.vendor_name)), i.invoice_type_lookup_code) C_PRIMARY_BRK_REAL, v.vendor_name C_SHORT_VENDOR_NAME, v.vendor_id C_VENDOR_ID, i.vendor_site_id C_CONTACT_SITE_ID, vs.vendor_site_code C_VENDOR_SITE_CODE, DECODE(:SORT_BY_ALTERNATE, 'Y', vs.vendor_site_code_alt, vs.vendor_site_code) C_VENDOR_SITE_CODE_BRK, NVL(vs.state,' ') C_VENDOR_STATE, NVL(SUBSTR(vs.city,1,15),' ') C_VENDOR_CITY, i.vendor_site_id C_ADDRESS_ID, NVL(SUBSTR(i.invoice_type_lookup_code,1,20), ' ') C_INVOICE_TYPE, i.invoice_id C_PAYMENT_SCHED_ID, i.accts_pay_code_combination_id C_VENDOR_TRX_ID, i.invoice_num C_INVOICE_NUMBER, i.invoice_num C_INVOICE_NUM_SHORT, TO_CHAR(i.gl_date,'DD-MON-RR') C_INVOICE_GL_DATE, DECODE(i.invoice_currency_code, :C_BASE_CURRENCY_CODE, ' ', DECODE(i.exchange_rate, NULL,'*', ' ')) C_DATA_CONVERTED, ROUND(NVL(i.exchange_rate, 1),5) C_EXCHANGE_RATE, DECODE(:C_VENDOR_NAME_SELECT, '%',DECODE(:SORT_BY_ALTERNATE, 'Y', UPPER(v.vendor_name_alt), UPPER(v.vendor_name)), DECODE(:SORT_BY_ALTERNATE, 'Y', v.vendor_name_alt, v.vendor_name)) C_VENDOR_NAME_BRK, i.sum_dist_amount TOTAL_ITEM, i.cancelled_date , i.invoice_date, i.segment_description, i.invoice_currency_code, i.payment_status_flag, i.distribution_split, i.terms_id, i.group_description desc_group, i.gl_date, NVL(i.exchange_rate, 1) INV_EXCHANGE_RATE, i.due_date FROM xxap_invoice_aging_all i, po_vendors v, po_vendor_sites vs WHERE i.request_id = : cp_concurrent_id AND i.org_id = : cp_org_id AND v.vendor_id = i.vendor_id AND vs.vendor_id = v.vendor_id AND vs.vendor_site_id = i.vendor_site_id AND vs.org_id = : cp_org_id AND i.sum_dist_amount <> 0 ORDER BY 2 ASC,34 ASC,3 ASC,8 ASC,25 ASC,10 ASC,13 ASC , i.segment_group , i.segment1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 7354 1.34 10.59 1832 57031 10 14708 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7356 1.35 10.60 1832 57031 10 14708 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 14708 14708 14708 SORT ORDER BY (cr=57031 pr=1832 pw=801 time=10383090 us cost=4 size=840 card=1) 14708 14708 14708 NESTED LOOPS (cr=57031 pr=1031 pw=0 time=2808283 us) 14708 14708 14708 NESTED LOOPS (cr=44832 pr=668 pw=0 time=770167 us cost=3 size=840 card=1) 14708 14708 14708 NESTED LOOPS (cr=30256 pr=542 pw=0 time=608176 us cost=2 size=795 card=1) 14708 14708 14708 TABLE ACCESS BY INDEX ROWID XXAP_INVOICE_AGING_ALL (cr=990 pr=101 pw=0 time=223206 us cost=1 size=740 card=1) 14708 14708 14708 INDEX RANGE SCAN XXAP_INVOICE_AGING_N2 (cr=408 pr=101 pw=0 time=186318 us cost=1 size=0 card=1)(object id 10007438) 14708 14708 14708 TABLE ACCESS BY INDEX ROWID PO_VENDORS (cr=29266 pr=441 pw=0 time=4841241 us cost=1 size=55 card=1) 14708 14708 14708 INDEX UNIQUE SCAN PO_VENDORS_U1 (cr=14558 pr=107 pw=0 time=859426 us cost=0 size=0 card=1)(object id 45068) 14708 14708 14708 INDEX UNIQUE SCAN PO_VENDOR_SITES_U1 (cr=14576 pr=126 pw=0 time=908521 us cost=0 size=0 card=1)(object id 3032265) 14708 14708 14708 TABLE ACCESS BY INDEX ROWID PO_VENDOR_SITES_ALL (cr=12199 pr=363 pw=0 time=3730867 us cost=1 size=45 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 14708 SORT (ORDER BY) 14708 NESTED LOOPS 14708 NESTED LOOPS 14708 NESTED LOOPS 14708 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'XXAP_INVOICE_AGING_ALL' (TABLE) 14708 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_INVOICE_AGING_N2' (INDEX) 14708 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'PO_VENDORS' (TABLE) 14708 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'PO_VENDORS_U1' (INDEX (UNIQUE)) 14708 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'PO_VENDOR_SITES_U1' (INDEX (UNIQUE)) 14708 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'PO_VENDOR_SITES_ALL' (TABLE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 7354 0.00 0.00 SQL*Net more data to client 1 0.00 0.00 db file sequential read 1031 0.13 9.19 Disk file operations I/O 4 0.00 0.00 direct path write temp 32 0.02 0.11 direct path read temp 38 0.00 0.07 SQL*Net message from client 7354 0.00 1.39 ******************************************************************************** SQL ID: 01ddaurfz70hy Plan Hash: 2581202622 SELECT DUE_PERCENT,DUE_DAYS FROM AP_TERMS_LINES WHERE TERM_ID = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 7 0.00 0.00 0 0 0 0 Execute 102956 2.95 2.87 0 0 0 0 Fetch 205912 5.52 5.62 4 308868 0 102956 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 308875 8.47 8.49 4 308868 0 102956 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 7 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID AP_TERMS_LINES (cr=3 pr=0 pw=0 time=9540 us cost=2 size=12 card=1) 1 1 1 INDEX RANGE SCAN AP_TERMS_LINES_U1 (cr=2 pr=0 pw=0 time=6182 us cost=1 size=0 card=1)(object id 28122) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_TERMS_LINES' (TABLE) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_TERMS_LINES_U1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 411831 0.00 0.25 SQL*Net message from client 411831 0.01 67.27 db file sequential read 4 0.04 0.08 ******************************************************************************** SQL ID: 8ggw94h7mvxd7 Plan Hash: 0 COMMIT call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 44131 0.57 0.59 0 0 0 0 Execute 44131 7.13 7.00 0 0 29421 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 88262 7.70 7.59 0 0 29421 0 Misses in library cache during parse: 0 Parsing user id: 173 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 88256 0.00 0.07 SQL*Net message from client 88256 0.01 4.94 log file sync 29419 0.02 34.67 ******************************************************************************** SQL ID: 5rg2kyfdp6mwf Plan Hash: 2710583454 DELETE FROM XXAP_INVOICE_AGING_ALL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 1.10 7.11 2336 1435 25743 14708 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 1.11 7.12 2336 1435 25743 14708 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE XXAP_INVOICE_AGING_ALL (cr=1435 pr=2336 pw=0 time=7119197 us) 14708 14708 14708 INDEX FULL SCAN XXAP_INVOICE_AGING_N1 (cr=978 pr=978 pw=0 time=8652273 us cost=0 size=175 card=1)(object id 10007425) Rows Execution Plan ------- --------------------------------------------------- 0 DELETE STATEMENT MODE: CHOOSE 0 DELETE OF 'XXAP_INVOICE_AGING_ALL' 14708 INDEX MODE: ANALYZED (FULL SCAN) OF 'XXAP_INVOICE_AGING_N1' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 3 0.00 0.00 Disk file operations I/O 4 0.00 0.00 db file sequential read 2322 0.12 5.81 undo segment extension 3 0.02 0.03 log buffer space 1 0.01 0.01 db file parallel read 2 0.17 0.27 ******************************************************************************** SQL ID: byv8zw542tf8h Plan Hash: 1546270724 SELECT SYSDATE FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 102957 2.32 2.06 0 0 0 0 Fetch 102957 2.84 2.90 0 0 0 102957 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 205915 5.16 4.97 0 0 0 102957 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=3 us cost=2 size=0 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 FAST DUAL Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 205915 0.00 0.13 SQL*Net message from client 205915 0.01 10.62 ******************************************************************************** SQL ID: 5qhr2vzs5ygm8 Plan Hash: 4126334232 analyze table XXAP.XXAP_INVOICE_AGING_ALL compute statistics call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.52 4.95 3796 9111 6 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.52 4.95 3796 9111 6 0 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1156 0.05 1.81 db file scattered read 337 0.05 2.77 ******************************************************************************** SQL ID: 0gwwp9k5k9jcm Plan Hash: 982563878 UPDATE XXAP_INVOICE_AGING_ALL SET SUM_DIST_AMOUNT=(SUM_DIST_AMOUNT + :b1 ), DISTRIBUTION_SPLIT=:b2,LAST_UPDATE_DATE=SYSDATE,LAST_UPDATED_BY=:b3 WHERE INVOICE_ID = :b4 AND LINE_TYPE_LOOKUP_CODE = :b5 AND SEGMENT1 = :b6 AND REQUEST_ID = :b7 AND ORG_ID = :b8 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 14708 3.85 3.96 14 45067 45008 14708 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14709 3.85 3.96 14 45067 45008 14708 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE XXAP_INVOICE_AGING_ALL (cr=4 pr=0 pw=0 time=339 us) 1 1 1 INDEX RANGE SCAN XXAP_INVOICE_AGING_N3 (cr=4 pr=0 pw=0 time=135 us cost=1 size=223 card=1)(object id 10007439) Rows Execution Plan ------- --------------------------------------------------- 0 UPDATE STATEMENT MODE: CHOOSE 0 UPDATE OF 'XXAP_INVOICE_AGING_ALL' 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_INVOICE_AGING_N3' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 29417 0.00 0.02 SQL*Net message from client 29417 0.00 1.42 db file sequential read 14 0.03 0.22 log file switch (private strand flush incomplete) 1 0.01 0.01 ******************************************************************************** SQL ID: gpd0vjctb1ysr Plan Hash: 4154489579 SELECT 1 FROM AP_INVOICE_PAYMENTS WHERE INVOICE_ID = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 14708 0.54 0.50 0 0 0 0 Fetch 14708 0.81 2.50 112 46047 0 1763 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 29417 1.35 3.02 112 46047 0 1763 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_PAYMENTS_ALL (cr=3 pr=0 pw=0 time=115 us cost=4 size=10 card=1) 0 0 0 INDEX RANGE SCAN AP_INVOICE_PAYMENTS_N1 (cr=3 pr=0 pw=0 time=114 us cost=3 size=0 card=1)(object id 27688) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_PAYMENTS_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_PAYMENTS_N1' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 29417 0.00 0.01 SQL*Net message from client 29417 0.00 1.69 db file sequential read 112 0.07 1.79 ******************************************************************************** SQL ID: 7h8wa1n2hwwft Plan Hash: 3138356118 SELECT RATE FROM XXAP_INV_CURRENCY_AGING_TMP WHERE INVOICE_CURRENCY_CODE = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 27312 0.76 0.87 0 0 0 0 Fetch 27312 1.09 1.09 1 54626 0 27312 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 54625 1.85 1.97 1 54626 0 27312 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID XXAP_INV_CURRENCY_AGING_TMP (cr=2 pr=1 pw=0 time=9801 us) 1 1 1 INDEX UNIQUE SCAN XXAP_INV_CURRENCY_AGING_TMP_U1 (cr=1 pr=0 pw=0 time=33 us)(object id 4007867) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 TABLE ACCESS (BY INDEX ROWID) OF 'XXAP_INV_CURRENCY_AGING_TMP' (TABLE (TEMP)) 1 INDEX (UNIQUE SCAN) OF 'XXAP_INV_CURRENCY_AGING_TMP_U1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 54625 0.00 0.03 SQL*Net message from client 54625 0.00 6.89 db file sequential read 1 0.00 0.00 ******************************************************************************** SQL ID: 0xmxjuz20nnwg Plan Hash: 3061313427 UPDATE XXAP_INVOICE_AGING_ALL SET DISTRIBUTION_SPLIT=:b1,LAST_UPDATE_DATE= SYSDATE,LAST_UPDATED_BY=:b2 WHERE INVOICE_ID = :b3 AND LINE_TYPE_LOOKUP_CODE = :b4 AND SEGMENT1 != :b5 AND SUM_DIST_AMOUNT != 0 AND REQUEST_ID = :b6 AND ORG_ID = :b7 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 14708 1.51 1.52 0 44877 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14709 1.51 1.52 0 44877 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE XXAP_INVOICE_AGING_ALL (cr=4 pr=0 pw=0 time=118 us) 0 0 0 TABLE ACCESS BY INDEX ROWID XXAP_INVOICE_AGING_ALL (cr=4 pr=0 pw=0 time=108 us cost=0 size=223 card=1) 0 0 0 INDEX RANGE SCAN XXAP_INVOICE_AGING_N3 (cr=4 pr=0 pw=0 time=104 us cost=0 size=0 card=1)(object id 10007439) Rows Execution Plan ------- --------------------------------------------------- 0 UPDATE STATEMENT MODE: CHOOSE 0 UPDATE OF 'XXAP_INVOICE_AGING_ALL' 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'XXAP_INVOICE_AGING_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XXAP_INVOICE_AGING_N3' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 29417 0.00 0.02 SQL*Net message from client 29417 0.00 1.38 ******************************************************************************** SQL ID: 6ppa18swrqbny Plan Hash: 468265191 SELECT SUBSTR(FIRST_NAME,1,1),LAST_NAME,PHONE FROM PO_VENDOR_CONTACTS WHERE VENDOR_SITE_ID = :b1 AND ROWNUM = 1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 0 0 0 Execute 14708 0.44 0.36 0 0 0 0 Fetch 14708 0.19 1.13 101 29601 0 185 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 29417 0.64 1.50 101 29601 0 185 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 COUNT STOPKEY (cr=2 pr=2 pw=0 time=56932 us) 0 0 0 TABLE ACCESS BY INDEX ROWID PO_VENDOR_CONTACTS (cr=2 pr=2 pw=0 time=56921 us cost=2 size=29 card=1) 0 0 0 INDEX RANGE SCAN PO_VENDOR_CONTACTS_N1 (cr=2 pr=2 pw=0 time=56918 us cost=1 size=0 card=2)(object id 45089) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 COUNT (STOPKEY) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'PO_VENDOR_CONTACTS' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'PO_VENDOR_CONTACTS_N1' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 29417 0.00 0.01 SQL*Net message from client 29417 0.00 2.59 db file sequential read 101 0.05 0.91 ******************************************************************************** SQL ID: fwurypbty48s2 Plan Hash: 693690358 SELECT B.NAME FROM AP_TERMS B WHERE :b1 = B.TERM_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 14708 0.43 0.49 0 0 0 0 Fetch 14708 0.76 0.83 10 44124 0 14708 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 29417 1.19 1.33 10 44124 0 14708 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID AP_TERMS_TL (cr=3 pr=3 pw=0 time=44134 us cost=2 size=23 card=1) 1 1 1 INDEX UNIQUE SCAN AP_TERMS_TL_U1 (cr=2 pr=2 pw=0 time=18972 us cost=1 size=0 card=1)(object id 28098) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_TERMS_TL' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_TERMS_TL_U1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 29417 0.00 0.01 SQL*Net message from client 29417 10.60 15.41 db file sequential read 10 0.02 0.09 ******************************************************************************** SQL ID: 753pqw234b1w4 Plan Hash: 667173197 SELECT COUNT(1) FROM XXAP_INV_CURRENCY_AGING_TMP WHERE INVOICE_CURRENCY_CODE = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6828 0.36 0.33 0 0 0 0 Fetch 6828 0.26 0.31 0 6830 0 6828 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13657 0.62 0.65 0 6830 0 6828 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) 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=23 us) 0 0 0 INDEX UNIQUE SCAN XXAP_INV_CURRENCY_AGING_TMP_U1 (cr=0 pr=0 pw=0 time=8 us)(object id 4007867) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 SORT (AGGREGATE) 0 INDEX (UNIQUE SCAN) OF 'XXAP_INV_CURRENCY_AGING_TMP_U1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 13657 0.00 0.00 SQL*Net message from client 13657 0.00 1.56 ******************************************************************************** SQL ID: g9bkzjb3tb061 Plan Hash: 126076364 SELECT NVL(SUM(DECODE(:b1,:b2,NVL(AIP.AMOUNT,0),NVL(AIP.AMOUNT,0) * NVL(:b3,1) )),0) FROM AP_INVOICE_PAYMENTS AIP WHERE AIP.ACCOUNTING_DATE <= :b4 AND AIP.INVOICE_ID = :b5 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1912 0.24 0.23 0 0 0 0 Fetch 1912 0.15 0.32 11 7787 0 1912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3825 0.39 0.56 11 7787 0 1912 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=4 pr=0 pw=0 time=82 us) 0 0 0 TABLE ACCESS BY INDEX ROWID AP_INVOICE_PAYMENTS_ALL (cr=4 pr=0 pw=0 time=75 us cost=4 size=23 card=1) 1 1 1 INDEX RANGE SCAN AP_INVOICE_PAYMENTS_N1 (cr=3 pr=0 pw=0 time=55 us cost=3 size=0 card=1)(object id 27688) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 SORT (AGGREGATE) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_PAYMENTS_ALL' (TABLE) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_PAYMENTS_N1' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3825 0.00 0.00 SQL*Net message from client 3825 0.00 0.23 db file sequential read 11 0.03 0.17 ******************************************************************************** SQL ID: gzsdz4t84tgq2 Plan Hash: 4240876912 SELECT ROUND(DECODE(R.EOP_RATE,0,0,(1 / R.EOP_RATE )),5) FROM GL_PERIOD_STATUSES GP,FND_APPLICATION FA,GL_TRANSLATION_RATES R WHERE GP.SET_OF_BOOKS_ID = :b1 AND GP.APPLICATION_ID = FA.APPLICATION_ID AND APPLICATION_SHORT_NAME = 'SQLGL' AND R.SET_OF_BOOKS_ID = GP.SET_OF_BOOKS_ID AND R.PERIOD_NAME = GP.PERIOD_NAME AND R.TO_CURRENCY_CODE = :b2 AND GP.END_DATE = (SELECT MAX(GP.END_DATE) FROM GL_PERIOD_STATUSES GP,FND_APPLICATION FA,GL_TRANSLATION_RATES R WHERE GP.SET_OF_BOOKS_ID = :b1 AND GP.APPLICATION_ID = FA.APPLICATION_ID AND APPLICATION_SHORT_NAME = 'SQLGL' AND R.SET_OF_BOOKS_ID = GP.SET_OF_BOOKS_ID AND R.PERIOD_NAME = GP.PERIOD_NAME AND R.TO_CURRENCY_CODE = :b2 AND GP.END_DATE <= :b5 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.01 0.00 0 0 0 0 Fetch 3 0.01 0.33 15 38 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.02 0.35 15 38 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=17 pr=7 pw=0 time=170603 us) 1 1 1 NESTED LOOPS (cr=8 pr=6 pw=0 time=155493 us cost=35 size=66 card=1) 1 1 1 NESTED LOOPS (cr=5 pr=3 pw=0 time=84332 us cost=18 size=624 card=16) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_APPLICATION (cr=2 pr=0 pw=0 time=67 us cost=1 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN FND_APPLICATION_U3 (cr=1 pr=0 pw=0 time=36 us cost=0 size=0 card=1)(object id 32806) 1 1 1 TABLE ACCESS BY INDEX ROWID GL_TRANSLATION_RATES (cr=3 pr=3 pw=0 time=84258 us cost=17 size=464 card=16) 1 1 1 INDEX RANGE SCAN GL_TRANSLATION_RATES_U1 (cr=2 pr=2 pw=0 time=60488 us cost=1 size=0 card=16)(object id 34903) 1 1 1 INDEX UNIQUE SCAN GL_PERIOD_STATUSES_U1 (cr=3 pr=3 pw=0 time=71151 us cost=1 size=0 card=1)(object id 34513) 1 1 1 TABLE ACCESS BY INDEX ROWID GL_PERIOD_STATUSES (cr=9 pr=1 pw=0 time=15090 us cost=2 size=27 card=1) 1 1 1 SORT AGGREGATE (cr=8 pr=0 pw=0 time=234 us) 1 1 1 NESTED LOOPS (cr=8 pr=0 pw=0 time=178 us) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=161 us cost=19 size=114 card=2) 1 1 1 NESTED LOOPS (cr=4 pr=0 pw=0 time=129 us cost=2 size=480 card=16) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_APPLICATION (cr=2 pr=0 pw=0 time=72 us cost=1 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN FND_APPLICATION_U3 (cr=1 pr=0 pw=0 time=48 us cost=0 size=0 card=1)(object id 32806) 1 1 1 INDEX RANGE SCAN GL_TRANSLATION_RATES_U1 (cr=2 pr=0 pw=0 time=50 us cost=1 size=320 card=16)(object id 34903) 1 1 1 INDEX UNIQUE SCAN GL_PERIOD_STATUSES_U1 (cr=3 pr=0 pw=0 time=29 us cost=1 size=0 card=1)(object id 34513) 1 1 1 TABLE ACCESS BY INDEX ROWID GL_PERIOD_STATUSES (cr=1 pr=0 pw=0 time=8 us cost=2 size=27 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 NESTED LOOPS 1 NESTED LOOPS 1 NESTED LOOPS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_APPLICATION' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_APPLICATION_U3' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_TRANSLATION_RATES' (TABLE) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'GL_TRANSLATION_RATES_U1' (INDEX (UNIQUE)) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_PERIOD_STATUSES_U1' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_PERIOD_STATUSES' (TABLE) 1 SORT (AGGREGATE) 1 NESTED LOOPS 1 NESTED LOOPS 1 NESTED LOOPS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_APPLICATION' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_APPLICATION_U3' (INDEX (UNIQUE)) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'GL_TRANSLATION_RATES_U1' (INDEX (UNIQUE)) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_PERIOD_STATUSES_U1' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_PERIOD_STATUSES' (TABLE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 7 0.00 0.00 SQL*Net message from client 7 0.00 0.00 Disk file operations I/O 2 0.00 0.00 db file sequential read 15 0.04 0.33 ******************************************************************************** SQL ID: 9tgj4g8y4rwy8 Plan Hash: 3632979230 select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts, NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0), NVL(scanhint,0),NVL(bitmapranges,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 13 0.00 0.00 0 0 0 0 Fetch 13 0.00 0.35 18 52 0 13 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 27 0.00 0.35 18 52 0 13 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS CLUSTER SEG$ (cr=4 pr=2 pw=0 time=34976 us cost=3 size=67 card=1) 1 1 1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=3 pr=1 pw=0 time=13301 us cost=2 size=0 card=1)(object id 9) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 18 0.04 0.34 ******************************************************************************** SQL ID: cmdgamn5p82p2 Plan Hash: 2613659903 SELECT /*+ INDEX ( gp GL_PERIODS_U2) */GP.START_DATE,GP.END_DATE FROM GL_PERIODS GP WHERE GP.PERIOD_SET_NAME = :b1 AND ((GP.END_DATE <= TRUNC(:b2) ) OR (TRUNC(:b2) BETWEEN GP.START_DATE AND GP.END_DATE )) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 331 0.03 0.28 11 667 0 330 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 333 0.04 0.28 11 667 0 330 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 330 330 330 TABLE ACCESS BY INDEX ROWID GL_PERIODS (cr=667 pr=11 pw=0 time=143700 us cost=18 size=330 card=11) 388 388 388 INDEX RANGE SCAN GL_PERIODS_U2 (cr=333 pr=4 pw=0 time=130916 us cost=3 size=0 card=210)(object id 34453) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 330 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_PERIODS' (TABLE) 388 INDEX MODE: ANALYZED (RANGE SCAN) OF 'GL_PERIODS_U2' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 334 0.00 0.00 SQL*Net message from client 334 1.75 1.80 Disk file operations I/O 3 0.00 0.00 db file sequential read 11 0.07 0.25 SQL*Net more data from client 1 0.00 0.00 ******************************************************************************** SQL ID: 96g93hntrzjtr Plan Hash: 841937906 select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 32 0.00 0.00 0 0 0 0 Fetch 32 0.00 0.26 11 128 0 32 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 65 0.00 0.26 11 128 0 32 Misses in library cache during parse: 0 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 11 0.05 0.25 ******************************************************************************** SQL ID: 6q42j0018w7t8 Plan Hash: 0 insert into sys.wri$_optstat_ind_history(obj#,rowcnt,leafcnt,distkey, lblkkey, dblkkey,clufac,blevel,analyzetime,samplesize,guessq,cachedblk, cachehit, logicalread,savtime,flags) values (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.22 11 3 31 3 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.22 11 3 31 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=4 pw=0 time=73946 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 2 0.00 0.00 db file sequential read 11 0.05 0.21 ******************************************************************************** SQL ID: 7ng34ruy5awxq Plan Hash: 3984801583 select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property, i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey, i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#, nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256), i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null, null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer,1))) deferrable#,min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 15 0.02 0.16 12 52 0 10 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21 0.02 0.16 12 52 0 10 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 5 5 5 SORT ORDER BY (cr=11 pr=4 pw=0 time=72702 us cost=10 size=386 card=2) 5 5 5 HASH JOIN OUTER (cr=11 pr=4 pw=0 time=72461 us cost=9 size=386 card=2) 5 5 5 NESTED LOOPS OUTER (cr=7 pr=2 pw=0 time=2639 us cost=4 size=300 card=2) 5 5 5 TABLE ACCESS CLUSTER IND$ (cr=6 pr=2 pw=0 time=2603 us cost=4 size=196 card=2) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=186 us cost=2 size=0 card=1)(object id 3) 0 0 0 TABLE ACCESS BY INDEX ROWID IND_STATS$ (cr=1 pr=0 pw=0 time=22 us cost=0 size=52 card=1) 0 0 0 INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=1 pr=0 pw=0 time=16 us cost=0 size=0 card=1)(object id 9228134) 0 0 0 VIEW (cr=4 pr=2 pw=0 time=70471 us cost=4 size=43 card=1) 0 0 0 SORT GROUP BY (cr=4 pr=2 pw=0 time=70468 us cost=4 size=16 card=1) 0 0 0 TABLE ACCESS CLUSTER CDEF$ (cr=4 pr=2 pw=0 time=70422 us cost=3 size=16 card=1) 1 1 1 INDEX UNIQUE SCAN I_COBJ# (cr=3 pr=1 pw=0 time=54631 us cost=2 size=0 card=1)(object id 27) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 12 0.05 0.15 ******************************************************************************** SQL ID: grwydz59pu6mc Plan Hash: 1028580536 select text from view$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 56 0.00 0.00 0 0 0 0 Execute 56 0.01 0.00 0 0 0 0 Fetch 56 0.00 0.12 10 112 0 56 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 168 0.01 0.12 10 112 0 56 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=9948 us cost=1 size=15 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 10 0.02 0.12 ******************************************************************************** SQL ID: 5n1fs4m2n2y0r Plan Hash: 992489688 select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 27 0.00 0.08 5 64 0 17 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 38 0.00 0.08 5 64 0 17 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID ICOL$ (cr=5 pr=1 pw=0 time=18983 us cost=4 size=58 card=2) 1 1 1 INDEX RANGE SCAN I_ICOL1 (cr=4 pr=1 pw=0 time=18924 us cost=3 size=0 card=2)(object id 37) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 5 0.02 0.08 ******************************************************************************** SQL ID: gx4mv66pvj3xz Plan Hash: 3886069984 select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0), rowid,cols,nvl(defer,0),mtime,nvl(spare1,0),spare2,spare3 from cdef$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 37 0.00 0.08 2 56 0 31 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 44 0.00 0.08 2 56 0 31 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.04 0.08 ******************************************************************************** SQL ID: 3d40u5r2jfcsd Plan Hash: 3821994137 update ind$ set ts#=:2,file#=:3,block#=:4,intcols=:5,type#=:6,flags=:7, property=:8,pctfree$=:9,initrans=:10,maxtrans=:11,blevel=:12,leafcnt=:13, distkey=:14,lblkkey=:15,dblkkey=:16,clufac=:17,cols=:18,analyzetime=:19, samplesize=:20,dataobj#=:21,degree=decode(:22,1,null,:22),instances= decode(:23,1,null,:23),rowcnt=:24,pctthres$=:31*256+:25, indmethod#=:26, trunccnt=:27,spare4=:29,spare2=:30,spare6=:32where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.07 3 9 3 3 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.07 3 9 3 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE IND$ (cr=3 pr=3 pw=0 time=71290 us) 1 1 1 INDEX UNIQUE SCAN I_IND1 (cr=3 pr=3 pw=0 time=71035 us cost=2 size=98 card=1)(object id 36) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.04 0.07 ******************************************************************************** SQL ID: fmfdkztk8vx23 Plan Hash: 3675718404 SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.06 5 8 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.06 5 8 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 COUNT STOPKEY (cr=4 pr=3 pw=0 time=58304 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_NEW_MESSAGES (cr=4 pr=3 pw=0 time=58289 us cost=3 size=36 card=1) 1 1 1 INDEX UNIQUE SCAN FND_NEW_MESSAGES_PK (cr=3 pr=2 pw=0 time=40857 us cost=2 size=0 card=1)(object id 33198) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 COUNT (STOPKEY) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_NEW_MESSAGES' (TABLE) 1 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 5 0.02 0.06 SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.01 0.01 ******************************************************************************** SQL ID: 7tt3tfgb57599 Plan Hash: 3187663039 delete /*+ index(mm) */ from sys.mon_mods_all$ mm where obj# = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.06 3 2 4 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.06 3 2 4 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE MON_MODS_ALL$ (cr=2 pr=3 pw=0 time=61714 us) 1 1 1 INDEX UNIQUE SCAN I_MON_MODS_ALL$_OBJ (cr=2 pr=2 pw=0 time=52999 us cost=1 size=6 card=1)(object id 9228317) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.03 0.06 ******************************************************************************** SQL ID: 3pz428zn2vkdw Plan Hash: 2516109271 SELECT /*+ index_asc ( fifs fnd_id_flex_segments_u2) */FIFS.FLEX_VALUE_SET_ID FROM FND_ID_FLEX_SEGMENTS FIFS WHERE FIFS.SEGMENT_NAME = 'XXGL_BUSINESS_UNIT' AND FIFS.ID_FLEX_CODE = 'GL#' GROUP BY FIFS.FLEX_VALUE_SET_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.05 5 8 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.05 5 8 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 HASH GROUP BY (cr=8 pr=5 pw=0 time=51879 us cost=10 size=29 card=1) 5 5 5 TABLE ACCESS BY INDEX ROWID FND_ID_FLEX_SEGMENTS (cr=8 pr=5 pw=0 time=74074 us cost=9 size=29 card=1) 5 5 5 INDEX SKIP SCAN FND_ID_FLEX_SEGMENTS_U2 (cr=5 pr=3 pw=0 time=101 us cost=8 size=0 card=1)(object id 33728) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 HASH (GROUP BY) 5 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_ID_FLEX_SEGMENTS' (TABLE) 5 INDEX MODE: ANALYZED (SKIP SCAN) OF 'FND_ID_FLEX_SEGMENTS_U2' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 3 0.00 0.00 Disk file operations I/O 2 0.00 0.00 db file sequential read 5 0.01 0.04 ******************************************************************************** SQL ID: 9gkq7rruycsjp Plan Hash: 2930975892 select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags, mod(spare3, 256) interval_dty, rowid, defmaxsize from partobj$ where obj# = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.05 2 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.05 2 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID PARTOBJ$ (cr=2 pr=2 pw=0 time=51053 us cost=2 size=52 card=1) 0 0 0 INDEX UNIQUE SCAN I_PARTOBJ$ (cr=2 pr=2 pw=0 time=51048 us cost=1 size=0 card=1)(object id 200) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.03 0.05 ******************************************************************************** SQL ID: 2s4dgaaj628r0 Plan Hash: 417715393 SELECT /*+ INDEX_ASC ( p AP_SYSTEM_PARAMETERS_U1) */P.BASE_CURRENCY_CODE, P.SORT_BY_ALTERNATE_FIELD,C.PRECISION,NVL(C.MINIMUM_ACCOUNTABLE_UNIT,0), C.DESCRIPTION FROM AP_SYSTEM_PARAMETERS P,FND_CURRENCIES C WHERE P.BASE_CURRENCY_CODE = C.CURRENCY_CODE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.05 2 6 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.01 0.05 2 10 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) 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=257 us) 1 1 1 NESTED LOOPS (cr=3 pr=0 pw=0 time=233 us cost=3 size=69 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID AP_SYSTEM_PARAMETERS_ALL (cr=2 pr=0 pw=0 time=213 us cost=2 size=10 card=1) 1 1 1 INDEX FULL SCAN AP_SYSTEM_PARAMETERS_U1 (cr=1 pr=0 pw=0 time=187 us cost=1 size=0 card=1)(object id 3022567) 1 1 1 INDEX UNIQUE SCAN FND_CURRENCIES_U1 (cr=1 pr=0 pw=0 time=17 us cost=0 size=0 card=1)(object id 32944) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CURRENCIES (cr=1 pr=0 pw=0 time=17 us cost=1 size=59 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 NESTED LOOPS 1 NESTED LOOPS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SYSTEM_PARAMETERS_ALL' (TABLE) 1 INDEX MODE: ANALYZED (FULL SCAN) OF 'AP_SYSTEM_PARAMETERS_U1' (INDEX (UNIQUE)) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_CURRENCIES_U1' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_CURRENCIES' (TABLE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 3 0.00 0.00 ******************************************************************************** SQL ID: 53saa2zkr6wc3 Plan Hash: 2631433895 select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 31 0.00 0.00 0 0 0 0 Fetch 62 0.00 0.04 5 160 0 31 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 94 0.00 0.04 5 160 0 31 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 5 0.02 0.04 ******************************************************************************** SQL ID: bd4bznqbq73hk Plan Hash: 4271409967 select bo#, intcol# from icoldep$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 2 0.00 0.04 2 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.04 2 4 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID ICOLDEP$ (cr=4 pr=2 pw=0 time=44920 us cost=2 size=75 card=5) 1 1 1 INDEX RANGE SCAN I_ICOLDEP$_OBJ (cr=3 pr=2 pw=0 time=44894 us cost=1 size=0 card=5)(object id 300) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.04 0.04 ******************************************************************************** SQL ID: 6rdakqkhmzg0b Plan Hash: 1621631211 SELECT MIN(DAYS_START),MAX(DAYS_TO) FROM AP_AGING_PERIOD_LINES AAPL,AP_AGING_PERIODS AAP WHERE AAPL.AGING_PERIOD_ID = AAP.AGING_PERIOD_ID AND UPPER(AAP.PERIOD_NAME) = UPPER(:b1) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.03 2 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.04 2 7 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=7 pr=2 pw=0 time=36746 us) 4 4 4 NESTED LOOPS (cr=7 pr=2 pw=0 time=36671 us) 4 4 4 NESTED LOOPS (cr=6 pr=1 pw=0 time=21625 us cost=5 size=34 card=1) 1 1 1 TABLE ACCESS FULL AP_AGING_PERIODS (cr=5 pr=0 pw=0 time=147 us cost=4 size=21 card=1) 4 4 4 INDEX RANGE SCAN AP_AGING_PERIOD_LINES_N1 (cr=1 pr=1 pw=0 time=21534 us cost=0 size=0 card=5)(object id 27755) 4 4 4 TABLE ACCESS BY INDEX ROWID AP_AGING_PERIOD_LINES (cr=1 pr=1 pw=0 time=15026 us cost=1 size=65 card=5) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 SORT (AGGREGATE) 4 NESTED LOOPS 4 NESTED LOOPS 1 TABLE ACCESS MODE: ANALYZED (FULL) OF 'AP_AGING_PERIODS' (TABLE) 4 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_AGING_PERIOD_LINES_N1' (INDEX) 4 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_AGING_PERIOD_LINES' (TABLE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 3 0.00 0.00 Disk file operations I/O 2 0.00 0.00 db file sequential read 2 0.02 0.03 ******************************************************************************** SQL ID: 14743yy2dr5a6 Plan Hash: 61561909 SELECT MEANING FROM FND_LOOKUP_VALUES_VL WHERE (NVL('',TERRITORY_CODE) = TERRITORY_CODE OR TERRITORY_CODE IS NULL ) AND LOOKUP_TYPE = 'EMR AP PARENT FLEX VALUE LAM' AND (LOOKUP_TYPE LIKE 'EMR AP PARENT FLEX VALUE LAM' ) AND (VIEW_APPLICATION_ID = 3 ) AND (SECURITY_GROUP_ID = 0 ) AND NVL(ENABLED_FLAG,'Y') = 'Y' AND LOOKUP_CODE = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.02 2 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.03 2 6 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=3 pr=1 pw=0 time=14558 us cost=3 size=63 card=1) 0 0 0 INDEX UNIQUE SCAN FND_LOOKUP_VALUES_U1 (cr=3 pr=1 pw=0 time=14552 us cost=2 size=0 card=1)(object id 32878) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_LOOKUP_VALUES' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_LOOKUP_VALUES_U1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6 0.00 0.00 SQL*Net message from client 6 0.00 0.00 db file sequential read 2 0.01 0.02 ******************************************************************************** SQL ID: gtfzbk4ajr15q Plan Hash: 3077000726 select count(*) from association$ a, coltype$ c, obj$ o where c.obj#= :1 AND c.toid = o.oid$ and o.obj# = a.obj# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.02 2 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.03 2 2 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=2 pr=2 pw=0 time=29531 us) 0 0 0 HASH JOIN (cr=2 pr=2 pw=0 time=29513 us cost=13 size=37 card=1) 0 0 0 NESTED LOOPS (cr=2 pr=2 pw=0 time=29172 us) 0 0 0 NESTED LOOPS (cr=2 pr=2 pw=0 time=29165 us cost=11 size=124 card=4) 0 0 0 TABLE ACCESS BY INDEX ROWID COLTYPE$ (cr=2 pr=2 pw=0 time=29161 us cost=3 size=92 card=4) 0 0 0 INDEX RANGE SCAN I_COLTYPE1 (cr=2 pr=2 pw=0 time=29146 us cost=2 size=0 card=4)(object id 242) 0 0 0 INDEX RANGE SCAN I_OBJ3 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 26619163) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=2 size=8 card=1) 0 0 0 INDEX FULL SCAN ASSOC1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=84 card=14)(object id 312) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.01 0.02 ******************************************************************************** SQL ID: 9g289tmwvw8zp Plan Hash: 4190035858 SELECT LY.MEANING,LN.MEANING,LA.DISPLAYED_FIELD FROM FND_LOOKUPS LY,FND_LOOKUPS LN,AP_LOOKUP_CODES LA WHERE LY.LOOKUP_TYPE = 'YES_NO' AND LY.LOOKUP_CODE = 'Y' AND LN.LOOKUP_TYPE = 'YES_NO' AND LN.LOOKUP_CODE = 'N' AND LA.LOOKUP_TYPE = 'NLS REPORT PARAMETER' AND LA.LOOKUP_CODE = 'ALL' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.02 2 24 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.03 2 24 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 MERGE JOIN CARTESIAN (cr=24 pr=2 pw=0 time=21532 us cost=9 size=177 card=1) 1 1 1 NESTED LOOPS (cr=14 pr=2 pw=0 time=21327 us cost=6 size=118 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=4 pr=2 pw=0 time=20974 us cost=3 size=59 card=1) 1 1 1 INDEX UNIQUE SCAN FND_LOOKUP_VALUES_U1 (cr=3 pr=1 pw=0 time=20004 us cost=2 size=0 card=1)(object id 32878) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=10 pr=0 pw=0 time=346 us cost=3 size=59 card=1) 11 11 11 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=3 pr=0 pw=0 time=72 us cost=2 size=0 card=1)(object id 14622584) 1 1 1 BUFFER SORT (cr=10 pr=0 pw=0 time=200 us cost=6 size=59 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=10 pr=0 pw=0 time=166 us cost=3 size=59 card=1) 11 11 11 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=3 pr=0 pw=0 time=14 us cost=2 size=0 card=1)(object id 14622584) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 MERGE JOIN (CARTESIAN) 1 NESTED LOOPS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_LOOKUP_VALUES' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_LOOKUP_VALUES_U1' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_LOOKUP_VALUES' (TABLE) 11 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_LOOKUP_VALUES_X99' (INDEX) 1 BUFFER (SORT) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_LOOKUP_VALUES' (TABLE) 11 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_LOOKUP_VALUES_X99' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 3 0.06 0.06 Disk file operations I/O 2 0.00 0.00 db file sequential read 2 0.01 0.02 ******************************************************************************** SQL ID: gsfnqdfcvy33q Plan Hash: 3734090372 delete from superobj$ where subobj# = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.02 1 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.02 1 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE SUPEROBJ$ (cr=1 pr=1 pw=0 time=28671 us) 0 0 0 INDEX UNIQUE SCAN I_SUPEROBJ1 (cr=1 pr=1 pw=0 time=28664 us cost=0 size=26 card=1)(object id 765426) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.02 0.02 ******************************************************************************** SQL ID: a9u0s3g93f47z Plan Hash: 2094022552 select decode(u.type#, 2, u.ext_username, u.name), o.name, t.update$, t.insert$, t.delete$, t.enabled, decode(bitand(t.property, 8192), 8192, 1, 0), decode(bitand(t.property, 65536), 65536, 1, 0), decode(bitand(t.property, 131072), 131072, 1, 0), (select o.name from obj$ o where o.obj# = u.spare2 and o.type# =57) from sys.obj$ o, sys.user$ u, sys.trigger$ t, sys.obj$ bo where t.baseobject=bo.obj# and bo.name = :1 and bo.spare3 = :2 and bo.namespace = 1 and t.obj#=o.obj# and o.owner#=u.user# and o.type# = 12 and bitand(property,16)=0 and bitand(property,8)=0 order by o.obj# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.02 3 10 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.02 3 10 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=4 size=33 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=1)(object id 26619161) 0 0 0 SORT ORDER BY (cr=5 pr=3 pw=0 time=27123 us cost=11 size=215 card=1) 0 0 0 NESTED LOOPS (cr=5 pr=3 pw=0 time=27080 us cost=10 size=215 card=1) 0 0 0 NESTED LOOPS (cr=5 pr=3 pw=0 time=27077 us cost=9 size=101 card=1) 0 0 0 NESTED LOOPS (cr=5 pr=3 pw=0 time=27072 us cost=6 size=64 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ5 (cr=3 pr=2 pw=0 time=26369 us cost=3 size=36 card=1)(object id 26619165) 0 0 0 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=1 pw=0 time=693 us cost=3 size=56 card=2) 0 0 0 INDEX RANGE SCAN I_TRIGGER1 (cr=2 pr=1 pw=0 time=678 us cost=1 size=0 card=2)(object id 119) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=3 size=37 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 26619161) 0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=114 card=1) 0 0 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 11) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.01 0.02 ******************************************************************************** SQL ID: 524kt723snfa2 Plan Hash: 0 INSERT INTO XXAP_INV_CURRENCY_AGING_TMP ( INVOICE_CURRENCY_CODE,RATE ) VALUES ( :b1,:b2 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.02 2 3 28 3 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.02 2 3 28 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=0 pw=0 time=1059 us) Rows Execution Plan ------- --------------------------------------------------- 0 INSERT STATEMENT MODE: CHOOSE 0 LOAD TABLE CONVENTIONAL OF 'XXAP_INV_CURRENCY_AGING_TMP' Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 7 0.00 0.00 SQL*Net message from client 7 0.00 0.00 Disk file operations I/O 1 0.00 0.00 db file sequential read 2 0.02 0.02 ******************************************************************************** SQL ID: cpr1yyzpfkw2a Plan Hash: 4155685193 delete /*+ index(m) */ from sys.mon_mods$ m where obj# = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.01 2 2 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.01 2 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE MON_MODS$ (cr=2 pr=2 pw=0 time=16848 us) 0 0 0 INDEX UNIQUE SCAN I_MON_MODS$_OBJ (cr=2 pr=2 pw=0 time=16843 us cost=1 size=6 card=1)(object id 369) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.01 0.01 ******************************************************************************** SQL ID: 3rwmntrn04p4f Plan Hash: 0 begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :org_id); fnd_profile.put('MFG_ORGANIZATION_ID', :mfg_org_id); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :coa); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); end; 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: CHOOSE Parsing user id: 173 (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: 3nkd3g3ju5ph1 Plan Hash: 853875749 select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.01 1 40 0 10 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21 0.00 0.01 1 40 0 10 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=1 pw=0 time=15302 us cost=4 size=86 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=1 pw=0 time=15272 us cost=3 size=0 card=1)(object id 26619162) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.01 0.01 ******************************************************************************** SQL ID: f711myt0q6cma Plan Hash: 0 insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid, userhost,terminal,action#,returncode, logoff$lread,logoff$pread, logoff$lwrite,logoff$dead, logoff$time,comment$text,spare1,clientid, sessioncpu,proxy$sid,user$guid, instance#,process#,auditid,dbid) values (:1,:2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date),:13,:14,:15,:16,:17, :18, :19,:20,:21,:22) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.01 1 1 10 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.01 1 1 10 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=1 pw=0 time=13451 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.01 0.01 ******************************************************************************** SQL ID: 4g2612tvbn0j8 Plan Hash: 0 begin FND_TRACE.START_TRACE; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.02 0.01 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.02 0.01 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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: 2q93zsrvbdw48 Plan Hash: 3286988581 select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 2 5 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 2 5 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 ******************************************************************************** SQL ID: 6aq34nj2zb2n7 Plan Hash: 3286988581 select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 1 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 1 3 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.00 0.00 ******************************************************************************** SQL ID: 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 12 0.01 0.00 0 0 0 12 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.01 0.00 0 0 0 12 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 12 0.00 0.00 SQL*Net message from client 12 0.00 0.00 ******************************************************************************** SQL ID: 330q95smuwnv9 Plan Hash: 2665782932 update hist_head$ set bucket_cnt=:3, row_cnt=:4, cache_cnt=:5,null_cnt=:6, timestamp#=:7, sample_size=:8, minimum=:9, maximum=:10,distcnt=:11, lowval= :12, hival=:13, density=:14, spare1=:15, spare2=:16, avgcln=:17, col#=:18 where obj#=:1 and intcol#=:2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 32 0.01 0.00 0 96 55 32 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 33 0.01 0.00 0 96 55 32 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE HIST_HEAD$ (cr=3 pr=0 pw=0 time=218 us) 1 1 1 INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=3 pr=0 pw=0 time=29 us cost=3 size=54 card=1)(object id 194) ******************************************************************************** SQL ID: 5vbbcp6pd58b8 Plan Hash: 0 begin Fnd_Concurrent.Init_Request; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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: 0a7jsgsmd9tyx Plan Hash: 2147880746 SELECT SESS.MODULE, SESS.PROGRAM, SESS.ACTION, SESS.CLIENT_INFO, SESS.MACHINE, SESS.TERMINAL, SESS.USERNAME, SESS.OSUSER, SESS.LOGON_TIME, S_IO.PHYSICAL_READS, S_IO.BLOCK_GETS, S_IO.CONSISTENT_GETS, S_IO.CONSISTENT_CHANGES, SESS.PROCESS, PROC.SPID, PROC.PID, SESS.SID FROM V$SESSION SESS, V$SESS_IO S_IO, V$PROCESS PROC WHERE SESS.AUDSID = :B1 AND SESS.STATUS = 'ACTIVE' AND S_IO.SID = SESS.SID AND SESS.PADDR = PROC.ADDR call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 1620 (HOTSOS) (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=6067 us cost=1 size=129 card=1) 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=6053 us cost=1 size=125 card=1) 1 1 1 HASH JOIN (cr=0 pr=0 pw=0 time=6027 us cost=1 size=100 card=1) 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=3697 us cost=0 size=77 card=1) 324 324 324 FIXED TABLE FULL X$KSLWT (cr=0 pr=0 pw=0 time=1957 us cost=0 size=2488 card=311) 1 1 1 FIXED TABLE FIXED INDEX X$KSUSE (ind:1) (cr=0 pr=0 pw=0 time=2002 us cost=0 size=69 card=1) 334 334 334 FIXED TABLE FULL X$KSUPR (cr=0 pr=0 pw=0 time=678 us cost=1 size=7866 card=342) 1 1 1 FIXED TABLE FIXED INDEX X$KSUSIO (ind:1) (cr=0 pr=0 pw=0 time=18 us cost=0 size=25 card=1) 1 1 1 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=7 us cost=0 size=4 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 NESTED LOOPS 1 NESTED LOOPS 1 HASH JOIN 1 NESTED LOOPS 324 FIXED TABLE (FULL) OF 'X$KSLWT' (TABLE (FIXED)) 1 FIXED TABLE (FIXED INDEX) OF 'X$KSUSE (ind:1)' (TABLE (FIXED)) 334 FIXED TABLE (FULL) OF 'X$KSUPR' (TABLE (FIXED)) 1 FIXED TABLE (FIXED INDEX) OF 'X$KSUSIO (ind:1)' (TABLE (FIXED)) 1 FIXED TABLE (FIXED INDEX) OF 'X$KSLED (ind:2)' (TABLE (FIXED)) ******************************************************************************** SQL ID: gyxv37z6aqyqp Plan Hash: 2285488774 SELECT P.PID, P.SPID, AUDSID, PROCESS, SUBSTR(USERENV('LANGUAGE'), INSTR( USERENV('LANGUAGE'), '.') + 1) FROM V$SESSION S, V$PROCESS P WHERE P.ADDR = S.PADDR AND S.AUDSID = USERENV('SESSIONID') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.01 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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=0 pr=0 pw=0 time=5718 us cost=1 size=116 card=2) 1 1 1 HASH JOIN (cr=0 pr=0 pw=0 time=5709 us cost=1 size=108 card=2) 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=2460 us cost=0 size=62 card=2) 328 328 328 FIXED TABLE FULL X$KSLWT (cr=0 pr=0 pw=0 time=887 us cost=0 size=2488 card=311) 1 1 1 FIXED TABLE FIXED INDEX X$KSUSE (ind:1) (cr=0 pr=0 pw=0 time=1130 us cost=0 size=23 card=1) 333 333 333 FIXED TABLE FULL X$KSUPR (cr=0 pr=0 pw=0 time=452 us cost=1 size=7866 card=342) 1 1 1 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=5 us cost=0 size=4 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 NESTED LOOPS 1 HASH JOIN 1 NESTED LOOPS 328 FIXED TABLE (FULL) OF 'X$KSLWT' (TABLE (FIXED)) 1 FIXED TABLE (FIXED INDEX) OF 'X$KSUSE (ind:1)' (TABLE (FIXED)) 333 FIXED TABLE (FULL) OF 'X$KSUPR' (TABLE (FIXED)) 1 FIXED TABLE (FIXED INDEX) OF 'X$KSLED (ind:2)' (TABLE (FIXED)) ******************************************************************************** SQL ID: fqgawy8zjbdxp Plan Hash: 61561909 SELECT DISPLAYED_FIELD FROM AP_LOOKUP_CODES WHERE LOOKUP_TYPE = 'AGING_SORT_OPTION' AND LOOKUP_CODE = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (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_LOOKUP_VALUES (cr=4 pr=0 pw=0 time=79 us cost=3 size=59 card=1) 1 1 1 INDEX UNIQUE SCAN FND_LOOKUP_VALUES_U1 (cr=3 pr=0 pw=0 time=66 us cost=2 size=0 card=1)(object id 32878) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_LOOKUP_VALUES' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_LOOKUP_VALUES_U1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 3 0.00 0.00 ******************************************************************************** SQL ID: gjmybfcfwywhn Plan Hash: 1735433180 SELECT FCP.CONCURRENT_PROGRAM_ID FROM FND_CONCURRENT_PROGRAMS FCP WHERE FCP.CONCURRENT_PROGRAM_NAME = 'CSTPGLXF' AND FCP.CONCURRENT_PROGRAM_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 59 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 59 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=59 pr=0 pw=0 time=2104 us cost=73 size=20 card=1) 1 1 1 INDEX SKIP SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=58 pr=0 pw=0 time=2085 us cost=72 size=0 card=1)(object id 33183) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_CONCURRENT_PROGRAMS' (TABLE) 1 INDEX MODE: ANALYZED (SKIP SCAN) OF 'FND_CONCURRENT_PROGRAMS_U1' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: bcv9qynmu1nv9 Plan Hash: 1546270724 select sys.dbms_standard.dictionary_obj_type from dual call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 0 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 0 0 2 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 26 (MDSYS) (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=9 us cost=2 size=0 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 FAST DUAL ******************************************************************************** SQL ID: 3axxxnjp5jjwj Plan Hash: 924258442 delete from ind_stats$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.01 0.00 0 0 0 0 Execute 3 0.00 0.00 0 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.01 0.00 0 3 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE IND_STATS$ (cr=1 pr=0 pw=0 time=17 us) 0 0 0 INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=1 pr=0 pw=0 time=14 us cost=0 size=13 card=1)(object id 9228134) ******************************************************************************** SQL ID: 0s9jg1j7mykf2 Plan Hash: 3134095148 DELETE FROM FND_DEBUG_RULE_OPTIONS WHERE DEBUG_RULE_ID IN (SELECT DEBUG_RULE_ID FROM FND_DEBUG_RULES WHERE (START_TIME IS NOT NULL AND END_TIME < SYSDATE) OR (REPEATION_COUNTER = 0) ) 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 5 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 5 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE FND_DEBUG_RULE_OPTIONS (cr=5 pr=0 pw=0 time=3979 us) 0 0 0 HASH JOIN SEMI (cr=5 pr=0 pw=0 time=3967 us cost=6 size=23 card=1) 8 8 8 INDEX FULL SCAN FND_DEBUG_RULE_OPTIONS_U1 (cr=1 pr=0 pw=0 time=22 us cost=1 size=112 card=8)(object id 2321837) 0 0 0 TABLE ACCESS FULL FND_DEBUG_RULES (cr=4 pr=0 pw=0 time=97 us cost=4 size=9 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 DELETE STATEMENT MODE: CHOOSE 0 DELETE OF 'FND_DEBUG_RULE_OPTIONS' 0 HASH JOIN (SEMI) 8 INDEX MODE: ANALYZED (FULL SCAN) OF 'FND_DEBUG_RULE_OPTIONS_U1' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (FULL) OF 'FND_DEBUG_RULES' (TABLE) ******************************************************************************** SQL ID: 23g30jrj7u5xu Plan Hash: 1503372805 SELECT LINES.DAYS_START,LINES.DAYS_TO,LINES.PERIOD_SEQUENCE_NUM, REPORT_HEADING1,REPORT_HEADING2 FROM AP_AGING_PERIOD_LINES LINES,AP_AGING_PERIODS PERIODS WHERE LINES.AGING_PERIOD_ID = PERIODS.AGING_PERIOD_ID AND UPPER(PERIODS.PERIOD_NAME) = UPPER(:b1) ORDER BY LINES.PERIOD_SEQUENCE_NUM call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.00 0 7 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.01 0.00 0 7 0 4 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 4 4 4 SORT ORDER BY (cr=7 pr=0 pw=0 time=160 us cost=6 size=54 card=1) 4 4 4 NESTED LOOPS (cr=7 pr=0 pw=0 time=106 us) 4 4 4 NESTED LOOPS (cr=6 pr=0 pw=0 time=87 us cost=5 size=54 card=1) 1 1 1 TABLE ACCESS FULL AP_AGING_PERIODS (cr=5 pr=0 pw=0 time=82 us cost=4 size=21 card=1) 4 4 4 INDEX RANGE SCAN AP_AGING_PERIOD_LINES_N1 (cr=1 pr=0 pw=0 time=18 us cost=0 size=0 card=5)(object id 27755) 4 4 4 TABLE ACCESS BY INDEX ROWID AP_AGING_PERIOD_LINES (cr=1 pr=0 pw=0 time=14 us cost=1 size=165 card=5) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 4 SORT (ORDER BY) 4 NESTED LOOPS 4 NESTED LOOPS 1 TABLE ACCESS MODE: ANALYZED (FULL) OF 'AP_AGING_PERIODS' (TABLE) 4 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_AGING_PERIOD_LINES_N1' (INDEX) 4 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_AGING_PERIOD_LINES' (TABLE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 8 0.00 0.00 SQL*Net message from client 8 0.00 0.00 ******************************************************************************** SQL ID: 9nxs1sq5jyyf1 Plan Hash: 3494361834 select count(i.obj#) from ind$ i where i.bo#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 5 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 5 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=5 pr=0 pw=0 time=158 us) 3 3 3 TABLE ACCESS CLUSTER IND$ (cr=5 pr=0 pw=0 time=119 us cost=4 size=12 card=2) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=69 us cost=2 size=0 card=1)(object id 3) ******************************************************************************** SQL ID: 7dwyqv9sawkyb Plan Hash: 1546270724 select sys.dbms_standard.login_user from dual call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 26 (MDSYS) (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=3 us cost=2 size=0 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 FAST DUAL ******************************************************************************** SQL ID: 342tz7tx4yumv Plan Hash: 0 begin HR_SIGNON.INITIALIZE_HR_SECURITY; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) ******************************************************************************** BEGIN hotsos_utilities.db_coll_trigger; END hot_logoff_trg; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 1620 (HOTSOS) (recursive depth: 1) ******************************************************************************** SQL ID: b5cr4hhndmbuf Plan Hash: 2583366266 update tab$ set ts#=:2,file#=:3,block#=:4,bobj#=decode(:5,0,null,:5),tab#= decode(:6,0,null,:6),intcols=:7,kernelcols=:8,clucols=decode(:9,0,null,:9), audit$=:10,flags=:11,pctfree$=:12,pctused$=:13,initrans=:14,maxtrans=:15, rowcnt=:16,blkcnt=:17,empcnt=:18,avgspc=:19,chncnt=:20,avgrln=:21, analyzetime=:22,samplesize=:23,cols=:24,property=:25,degree=decode(:26,1, null,:26),instances=decode(:27,1,null,:27),dataobj#=:28,avgspc_flb=:29, flbcnt=:30,trigflag=:31,spare1=:32,spare2=decode(:33,0,null,:33),spare4=:34, spare6=:35 where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 5 2 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 5 2 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE TAB$ (cr=5 pr=0 pw=0 time=401 us) 1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=5 pr=0 pw=0 time=75 us cost=4 size=140 card=1) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=36 us cost=2 size=0 card=1)(object id 3) ******************************************************************************** SQL ID: 0a7q9v9nd2qc1 Plan Hash: 3712735545 select count(*) from association$ where obj# = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 1 1 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 1 1 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=857 us) 0 0 0 INDEX RANGE SCAN ASSOC1 (cr=1 pr=1 pw=0 time=835 us cost=1 size=6 card=1)(object id 312) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.00 0.00 ******************************************************************************** SQL ID: 83taa7kaw59c1 Plan Hash: 2783779297 select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2, nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182, scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$, rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2, nvl(spare3,0) from col$ where obj#=:1 order by intcol# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 120 0.00 0.00 0 27 0 115 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 126 0.00 0.00 0 27 0 115 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 47 47 47 SORT ORDER BY (cr=6 pr=0 pw=0 time=376 us cost=5 size=2924 card=43) 47 47 47 TABLE ACCESS CLUSTER COL$ (cr=6 pr=0 pw=0 time=193 us cost=4 size=2924 card=43) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=77 us cost=2 size=0 card=1)(object id 3) ******************************************************************************** SQL ID: dy20tb1s56ahh Plan Hash: 0 begin fnd_conc_stat.collect; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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 ******************************************************************************** declare TYPE attrs_cur IS REF CURSOR; m_cur attrs_cur; m_event varchar2(512); m_user varchar2(512); m_owner varchar2(512); m_user1 varchar2(512); m_type varchar2(512); m_stmt varchar2(512); m_name varchar2(5120); m_column varchar2(5120); m_cnt NUMBER; m_stmt1 varchar2(512); m_var varchar2(512); m_o_stmt VARCHAR2(5120); PRAGMA AUTONOMOUS_TRANSACTION; begin m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual'; execute immediate m_stmt into m_type; if(not (m_type='TABLE' or m_type='TRIGGER' or m_type='USER' or m_type='TABLESPACE')) then return; end if; m_stmt:='select sys.dbms_standard.sysevent from dual'; execute immediate m_stmt into m_event; m_stmt:='select SYS_CONTEXT(''USERENV'',''SESSION_USER'') from dual'; execute immediate m_stmt into m_user; m_stmt:='select SYS_CONTEXT(''USERENV'',''CURRENT_USER'') from dual'; execute immediate m_stmt into m_user1; m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual'; execute immediate m_stmt into m_owner; m_stmt:='select sys.dbms_standard.dictionary_obj_name from dual'; execute immediate m_stmt into m_name; m_stmt:='select sdo_geor_def.getSqlText from dual'; execute immediate m_stmt into m_o_stmt; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='ALTER') then m_stmt:='select column_name from dba_tab_columns where owner=:1 and table_name=:2'; open m_cur for m_stmt using m_owner,m_name; loop fetch m_cur into m_column; exit when m_cur%NOTFOUND; m_stmt:='select sdo_geor_def.isDropColumn(:1) from dual'; execute immediate m_stmt into m_stmt1 using SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_column); if (trim(m_stmt1)='TRUE') then m_stmt:='begin sdo_geor_def.doAlterDropColumn(:1,:2,:3); end;'; execute immediate m_stmt using SYS.DBMS_ASSERT.SCHEMA_NAME(m_owner),SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_name),SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_column); end if; end loop; end if; if ((m_event='DROP' and m_type='USER') or (m_event='DROP' and m_type='TABLESPACE')) then m_stmt:='insert into sdo_geor_ddl__table$$ values (1)'; EXECUTE IMMEDIATE m_stmt; commit; end if; if (m_event='DROP' and m_type='TABLE') then m_stmt:='select count(*) from sdo_geor_sysdata_table where sdo_owner=:1 and RDT_TABLE_NAME=:2'; EXECUTE IMMEDIATE m_stmt into m_cnt using m_owner,m_name; if(m_cnt!=0) then m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if((m_cnt=0)and (m_user!='SYS' and m_user!='SYSTEM' and m_user!='MDSYS'and m_owner!='MDSYS' and m_owner!='SYS')) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''The referenced raster data table(RDT) cannot be dropped.'')'; execute immediate m_stmt; end if; end if; m_stmt:='insert into sdo_geor_ddl__table$$ values (2)'; EXECUTE IMMEDIATE m_stmt; commit; end if; if(m_user='SYS' or m_user='SYSTEM' or m_user='MDSYS' or m_owner='MDSYS' or m_owner='SYS') then return; end if; if (m_event='RENAME' and m_type='TABLE') then m_stmt:='select count(*) from sdo_geor_sysdata_table where sdo_owner=:1 and RDT_TABLE_NAME=:2'; EXECUTE IMMEDIATE m_stmt into m_cnt using m_owner,m_name; if(m_cnt!=0) then m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''The referenced raster data table(RDT) cannot be renamed directly.'')'; execute immediate m_stmt; end if; end if; end if; if (m_type='TRIGGER' and m_event='DROP') then m_stmt:='select REGEXP_SUBSTR(:1,''GRDMLTR_.+'',1,1,''i'') from dual'; EXECUTE IMMEDIATE m_stmt into m_var using m_name; if(m_var is null) then return; end if; m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster DML triggers cannot be dropped.'')'; execute immediate m_stmt; end if; end if; if (m_type='TRIGGER' and m_event='ALTER') then m_o_stmt:=upper(trim(m_o_stmt)); if(instr(m_o_stmt,' COMPILE ')>0 or instr(m_o_stmt,' ENABLE ')>0 or substr(m_o_stmt,length(m_o_stmt)-8,8)=' COMPILE' or substr(m_o_stmt,length(m_o_stmt)-7,7)=' ENABLE' ) then return; end if; m_stmt:='select REGEXP_SUBSTR(:1,''GRDMLTR_.+'',1,1,''i'') from dual'; EXECUTE IMMEDIATE m_stmt into m_var using m_name; if(m_var is null) then return; end if; m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster DML triggers cannot be altered.'')'; execute immediate m_stmt; end if; end if; if (m_type='TRIGGER' and m_event='CREATE') then m_stmt:='select REGEXP_SUBSTR(:1,''GRDMLTR_.+'',1,1,''i'') from dual'; EXECUTE IMMEDIATE m_stmt into m_var using m_name; if(m_var is null) then return; end if; m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster reserved names cannot be used to create regular triggers.'')'; execute immediate m_stmt; end if; end if; Exception when others then if(sqlcode=-13391) then m_stmt:=sqlerrm; m_stmt:=substr(m_stmt,11); m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391,'''||m_stmt||''')'; execute immediate m_stmt; end if; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 26 (MDSYS) (recursive depth: 2) ******************************************************************************** SQL ID: 3kywng531fcxu Plan Hash: 77896438 delete from tab_stats$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 2 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE TAB_STATS$ (cr=2 pr=0 pw=0 time=83 us) 0 0 0 INDEX UNIQUE SCAN I_TAB_STATS$_OBJ# (cr=2 pr=0 pw=0 time=78 us cost=1 size=7 card=1)(object id 9228132) ******************************************************************************** SQL ID: bsa0wjtftg3uw Plan Hash: 690176192 select file# from file$ where ts#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.00 0 20 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.00 0.00 0 20 0 8 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 4 4 4 TABLE ACCESS BY INDEX ROWID FILE$ (cr=10 pr=0 pw=0 time=50 us cost=3 size=16 card=2) 4 4 4 INDEX RANGE SCAN I_FILE2 (cr=6 pr=0 pw=0 time=46 us cost=2 size=0 card=1)(object id 39) ******************************************************************************** SQL ID: 6mmagtdr9pd83 Plan Hash: 0 begin MO_GLOBAL.INIT; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) ******************************************************************************** SQL ID: 371q0pr7ykkr2 Plan Hash: 304613454 select CURRENCY_CODE, CURRENCY_FLAG, nvl(PRECISION,-1), SYMBOL, nvl(EXTENDED_PRECISION,-1), TO_CHAR(MINIMUM_ACCOUNTABLE_UNIT) FROM FND_CURRENCIES 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 16 0 249 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 16 0 249 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 249 249 249 TABLE ACCESS FULL FND_CURRENCIES (cr=16 pr=0 pw=0 time=208 us cost=8 size=6972 card=249) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 249 TABLE ACCESS MODE: ANALYZED (FULL) OF 'FND_CURRENCIES' (TABLE) 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 more data to client 4 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: bcg7084jc4um6 Plan Hash: 1546270724 select sdo_geor_def.getSqlText from dual call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 26 (MDSYS) (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=1 us cost=2 size=0 card=1) error during execute of EXPLAIN PLAN statement ORA-00904: "SDO_GEOR_DEF"."GETSQLTEXT": invalid identifier parse error offset: 79 ******************************************************************************** SQL ID: 8w57t3xaxs89k Plan Hash: 3712617803 SELECT NAME, VERSION FROM FND_CACHE_VERSIONS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 14 0.00 0.00 0 0 0 0 Fetch 14 0.00 0.00 0 14 0 112 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 29 0.00 0.00 0 14 0 112 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 INDEX MODE: ANALYZED (FULL SCAN) OF 'FND_CACHE_VERSIONS_PK1' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: ar9nmtmd28460 Plan Hash: 1546270724 select sys.dbms_standard.dictionary_obj_owner from dual call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 0 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 0 0 2 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 26 (MDSYS) (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 FAST DUAL ******************************************************************************** SQL ID: 7qs7fx89194u1 Plan Hash: 1990737700 SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 45 0.00 0.00 0 0 0 0 Fetch 45 0.00 0.00 0 136 0 10 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 92 0.00 0.00 0 136 0 10 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_PROFILE_OPTION_VALUES_X99' (INDEX) ******************************************************************************** SQL ID: 12kw3xcxv1qpg Plan Hash: 1546270724 select sys.dbms_standard.sysevent from dual call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.01 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 0 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.01 0.00 0 0 0 2 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 26 (MDSYS) (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=2 us cost=2 size=0 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 FAST DUAL ******************************************************************************** SQL ID: 9gdxsmyzbrdkr Plan Hash: 1883182706 SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG, APP_ENABLED_FLAG, RESP_ENABLED_FLAG, USER_ENABLED_FLAG, ORG_ENABLED_FLAG, SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 33 0.01 0.00 0 0 0 0 Fetch 33 0.00 0.00 0 66 0 26 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 68 0.01 0.00 0 66 0 26 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_PROFILE_OPTIONS_X99' (INDEX) ******************************************************************************** SQL ID: 87gaftwrm2h68 Plan Hash: 2863542513 select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname from obj$ o where o.obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.00 0 40 0 10 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21 0.00 0.00 0 40 0 10 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=0 pw=0 time=120 us cost=4 size=42 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=3 pr=0 pw=0 time=89 us cost=3 size=0 card=1)(object id 26619161) ******************************************************************************** SQL ID: 9xcgzczskvc67 Plan Hash: 0 begin FND_CONCURRENT.SET_PREFERRED_RBS; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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: 4a3ccstvk0ssw Plan Hash: 1546270724 select sys.dbms_standard.dictionary_obj_name from dual call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.01 0.00 0 0 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.01 0.00 0 0 0 2 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 26 (MDSYS) (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 FAST DUAL ******************************************************************************** SQL ID: ac9sfg3m1qc63 Plan Hash: 61561909 SELECT DISPLAYED_FIELD FROM AP_LOOKUP_CODES WHERE LOOKUP_TYPE = 'NLS REPORT PARAMETER' AND LOOKUP_CODE = 'ALL' 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 Optimizer mode: CHOOSE Parsing user id: 173 (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_LOOKUP_VALUES (cr=4 pr=0 pw=0 time=44 us cost=3 size=59 card=1) 1 1 1 INDEX UNIQUE SCAN FND_LOOKUP_VALUES_U1 (cr=3 pr=0 pw=0 time=31 us cost=2 size=0 card=1)(object id 32878) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_LOOKUP_VALUES' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_LOOKUP_VALUES_U1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 3 0.00 0.00 ******************************************************************************** SQL ID: 4y5yauuh46279 Plan Hash: 3166716468 SELECT P.PERIOD_SET_NAME,P.NAME,P.CHART_OF_ACCOUNTS_ID FROM GL_SETS_OF_BOOKS P WHERE P.SET_OF_BOOKS_ID = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID GL_SETS_OF_BOOKS (cr=2 pr=0 pw=0 time=75 us cost=1 size=45 card=1) 1 1 1 INDEX UNIQUE SCAN GL_SETS_OF_BOOKS_U2 (cr=1 pr=0 pw=0 time=55 us cost=0 size=0 card=1)(object id 34341) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_SETS_OF_BOOKS' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_SETS_OF_BOOKS_U2' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 3 0.00 0.00 ******************************************************************************** SQL ID: 3w4qs0tbpmxr6 Plan Hash: 3924106966 select con#,obj#,rcon#,enabled,nvl(defer,0),spare2,spare3 from cdef$ where robj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 1 12 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13 0.00 0.00 1 12 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.00 0.00 ******************************************************************************** SQL ID: bpv5n2m9dhcc4 Plan Hash: 1884197401 UPDATE FND_CONCURRENT_REQUESTS SET ORACLE_SESSION_ID = :B4 , ORACLE_PROCESS_ID = :B3 , OS_PROCESS_ID = :B2 , NLS_CODESET = :B1 WHERE REQUEST_ID = FND_GLOBAL.CONC_REQUEST_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 4 4 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 4 4 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE FND_CONCURRENT_REQUESTS (cr=63 pr=0 pw=0 time=5532 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=235 us cost=3 size=53 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=177 us cost=2 size=0 card=1)(object id 34547) Rows Execution Plan ------- --------------------------------------------------- 0 UPDATE STATEMENT MODE: CHOOSE 0 UPDATE OF 'FND_CONCURRENT_REQUESTS' 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)) ******************************************************************************** declare TYPE attrs_cur IS REF CURSOR; m_cur attrs_cur; m_event varchar2(512); m_user varchar2(512); m_owner varchar2(512); m_user1 varchar2(512); m_type varchar2(512); m_name varchar2(5120); m_column varchar2(5120); m_cnt NUMBER; m_stmt varchar2(512); m_ret varchar2(3000); m_ret1 varchar2(512); m_o_stmt VARCHAR2(5120); begin m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual'; execute immediate m_stmt into m_type; if(not (m_type='TABLE' or m_type='TRIGGER' or m_type='USER' or m_type='TABLESPACE')) then return; end if; m_stmt:='select sys.dbms_standard.sysevent from dual'; execute immediate m_stmt into m_event; m_stmt:='select SYS_CONTEXT(''USERENV'',''SESSION_USER'') from dual'; execute immediate m_stmt into m_user; m_stmt:='select sys.dbms_standard.login_user from dual'; execute immediate m_stmt into m_user1; m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual'; execute immediate m_stmt into m_owner; m_stmt:='select sys.dbms_standard.dictionary_obj_name from dual'; execute immediate m_stmt into m_name; if((instr(upper(m_name),'MDRT_')>0) and m_event='DROP') then return; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='CREATE') then m_stmt:='select sdo_geor_def.listAllGeoRasterFieldsStr(:1,:2) from dual'; execute immediate m_stmt into m_ret using SYS.DBMS_ASSERT.SCHEMA_NAME(m_owner),SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_name); m_ret:=trim(m_ret); while (length(m_ret)!=0) loop if (instr(m_ret,' $$__## ')!=0) then m_ret1:=trim(substr(m_ret,1,instr(m_ret,' $$__## ')-1)); m_ret:=trim(substr(m_ret,instr(m_ret,' $$__## ')+8)); else m_ret1:=trim(m_ret); m_ret:=''; end if; m_stmt:='begin SDO_GEOR_UTL.createDMLTrigger(:1,:2); end;'; execute immediate m_stmt using m_owner||'.'||m_name,SYS.DBMS_ASSERT.QUALIFIED_SQL_NAME(m_ret1); end loop; return; end if; if (m_name!='MDSYS' and m_type='USER' and m_event='DROP') then m_stmt:='call sdo_geor_def.doDropUserAndTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='DROP') then m_stmt:='call sdo_geor_def.doDropUserAndTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='TRUNCATE') then m_stmt:='call sdo_geor_def.doTruncateTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='ALTER') then m_stmt:='call sdo_geor_def.doAlterRenameTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='RENAME') then m_stmt:='call sdo_geor_def.doRenameTable()'; execute immediate m_stmt; end if; if (m_event='DROP' and m_type='TABLE') then m_stmt:='delete from sdo_geor_ddl__table$$ where id=2'; EXECUTE IMMEDIATE m_stmt; end if; if ((m_type='USER' and m_event='DROP') or (m_type='TABLESPACE' and m_event='DROP')) then m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; end if; Exception when others then if(sqlcode=-13391) then m_stmt:=sqlerrm; m_stmt:=substr(m_stmt,11); m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391,'''||m_stmt||''')'; execute immediate m_stmt; end if; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 26 (MDSYS) (recursive depth: 2) ******************************************************************************** SQL ID: 5hajs402v7dqg Plan Hash: 3440761486 select i.obj# from ind$ i where i.bo#=:1 order by i.obj# desc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 5 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 5 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 3 3 3 SORT ORDER BY (cr=5 pr=0 pw=0 time=60 us cost=5 size=24 card=2) 3 3 3 TABLE ACCESS CLUSTER IND$ (cr=5 pr=0 pw=0 time=21 us cost=4 size=24 card=2) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=13 us cost=2 size=0 card=1)(object id 3) ******************************************************************************** SQL ID: fwc7tq5qthy1u Plan Hash: 0 begin JG_CONTEXT.INITIALIZE; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) ******************************************************************************** SQL ID: 55dc767ajydh3 Plan Hash: 2802907561 SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 20 0.00 0.00 0 0 0 0 Fetch 20 0.00 0.00 0 66 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 42 0.00 0.00 0 66 0 6 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_PROFILE_OPTION_VALUES' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_PROFILE_OPTION_VALUES_U1' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: 5hw78v66jn9mc Plan Hash: 2843490295 SELECT DISTINCT PRODUCT_DEPENDENCY, LEVEL FROM FND_PRODUCT_INIT_DEPENDENCY P1 WHERE LEVEL = (SELECT MAX(LEVEL) FROM FND_PRODUCT_INIT_DEPENDENCY P2 WHERE P2.PRODUCT_DEPENDENCY = P1.PRODUCT_DEPENDENCY CONNECT BY PRIOR P2.PRODUCT_DEPENDENCY = P2.APPLICATION_SHORT_NAME START WITH P2.APPLICATION_SHORT_NAME = UPPER(:B1 ) ) CONNECT BY PRIOR PRODUCT_DEPENDENCY = APPLICATION_SHORT_NAME START WITH APPLICATION_SHORT_NAME = UPPER(:B1 ) ORDER BY LEVEL DESC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 2 2 2 SORT UNIQUE (cr=3 pr=0 pw=0 time=1009 us cost=2 size=704 card=8) 2 2 2 FILTER (cr=3 pr=0 pw=0 time=987 us) 3 3 3 CONNECT BY NO FILTERING WITH SW (UNIQUE) (cr=1 pr=0 pw=0 time=344 us) 283 283 283 INDEX FULL SCAN FND_PRODUCT_INIT_DEPENDENCY_U1 (cr=1 pr=0 pw=0 time=26 us cost=1 size=2264 card=283)(object id 108134) 2 2 2 SORT AGGREGATE (cr=2 pr=0 pw=0 time=606 us) 3 3 3 FILTER (cr=2 pr=0 pw=0 time=575 us) 6 6 6 CONNECT BY NO FILTERING WITH START-WITH (cr=2 pr=0 pw=0 time=568 us) 566 566 566 INDEX FULL SCAN FND_PRODUCT_INIT_DEPENDENCY_U1 (cr=2 pr=0 pw=0 time=112 us cost=1 size=2264 card=283)(object id 108134) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 2 SORT (UNIQUE) 2 FILTER 3 CONNECT BY (NO FILTERING WITH SW (UNIQUE)) 283 INDEX MODE: ANALYZED (FULL SCAN) OF 'FND_PRODUCT_INIT_DEPENDENCY_U1' (INDEX (UNIQUE)) 2 SORT (AGGREGATE) 3 FILTER 6 CONNECT BY (NO FILTERING WITH START-WITH) 566 INDEX MODE: ANALYZED (FULL SCAN) OF 'FND_PRODUCT_INIT_DEPENDENCY_U1' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: 47r1y8yn34jmj Plan Hash: 3213098354 select default$ from col$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.00 1 10 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 15 0.00 0.00 1 10 0 5 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID COL$ (cr=1 pr=0 pw=0 time=232 us cost=1 size=15 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.00 0.00 ******************************************************************************** SQL ID: dbmdavb6ydwb4 Plan Hash: 0 ALTER SESSION SET SQL_TRACE=FALSE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 3 0.00 0.00 ******************************************************************************** SQL ID: 4kvc1pjyh5n7x Plan Hash: 0 ALTER SESSION SET SQL_TRACE=TRUE 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: CHOOSE Parsing user id: 173 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 3 0.00 0.00 ******************************************************************************** SQL ID: cbv5buwyg0qck Plan Hash: 0 INSERT INTO HOT_SESSION (SESSIONID, MODULE, PROGRAM, ACTION, CLIENT_INFO, MACHINE, TERMINAL, USERNAME, OSUSER, LOGON_TIME, SESSION_DT, PREADS, BLK_GETS, CONS_GETS, CONS_CHGS, PROCESS, SPID, PID, SID, INST_ID) VALUES (:B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , SYSDATE, :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 1 10 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 10 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 1620 (HOTSOS) (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=0 pw=0 time=647 us) error during execute of EXPLAIN PLAN statement ORA-00942: table or view does not exist parse error offset: 84 ******************************************************************************** SQL ID: azdfzhq64vdkr Plan Hash: 1546270724 SELECT 'TRACE_USER_DETAILS: TIMESTAMP=16-DEC-13:10:56:50: USER_NAME= NISHANT_RANJAN: CONC_REQUEST_ID=268735174: OLTP_OPT_MODE= : CONC_OPT_MODE= : CONC_PROG_EXE=XXAP_AGING_REEXP_LAM: CONC_PROG_NAME=EMR AP Aging de Facturas reexpresadas LAM: RESPONSIBILITY=EMR AP Setup with Inquiry BR: APPL_NAME=JL' FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 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: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 FAST DUAL (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 FAST DUAL ******************************************************************************** SQL ID: d7y4tdacc7f3j Plan Hash: 1546270724 select SYS_CONTEXT('USERENV','SESSION_USER') from dual call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 0 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 0 0 2 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 26 (MDSYS) (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=1 us cost=2 size=0 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 FAST DUAL ******************************************************************************** SQL ID: 721d7993vjur9 Plan Hash: 1546270724 select SYS_CONTEXT('USERENV','CURRENT_USER') from dual call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 26 (MDSYS) (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 FAST DUAL ******************************************************************************** SQL ID: 14ys3d7nmvxbv Plan Hash: 0 ALTER SESSION SET SQL_TRACE = TRUE 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: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) ******************************************************************************** SQL ID: 2syvqzbxp4k9z Plan Hash: 2485131612 select u.name, o.name, a.interface_version#, o.obj# from association$ a, user$ u, obj$ o where a.obj# = :1 and a.property = :2 and a.statstype# = o.obj# and u.user# = o.owner# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 6 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=98 us cost=6 size=69 card=1) 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=93 us cost=5 size=50 card=1) 0 0 0 TABLE ACCESS FULL ASSOCIATION$ (cr=2 pr=0 pw=0 time=91 us cost=2 size=17 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=3 size=33 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 26619161) 0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=19 card=1) 0 0 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 11) ******************************************************************************** SQL ID: 4z2at9d1natrv Plan Hash: 3053170185 SELECT INSTANCE_NUMBER FROM V$INSTANCE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 1620 (HOTSOS) (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=62 us) 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=33 us) 1 1 1 FIXED TABLE FULL X$QUIESCE (cr=0 pr=0 pw=0 time=15 us) 1 1 1 FIXED TABLE FULL X$KVIT (cr=0 pr=0 pw=0 time=15 us) 1 1 1 FIXED TABLE FULL X$KSUXSINST (cr=0 pr=0 pw=0 time=22 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 NESTED LOOPS 1 NESTED LOOPS 1 FIXED TABLE (FULL) OF 'X$QUIESCE' (TABLE (FIXED)) 1 FIXED TABLE (FULL) OF 'X$KVIT' (TABLE (FIXED)) 1 FIXED TABLE (FULL) OF 'X$KSUXSINST' (TABLE (FIXED)) ******************************************************************************** SQL ID: d17m78gkh6p93 Plan Hash: 2775352469 SELECT Q.RESOURCE_CONSUMER_GROUP FROM FND_CONCURRENT_REQUESTS R, FND_CONCURRENT_PROCESSES P, FND_CONCURRENT_QUEUES Q WHERE R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID AND R.CONTROLLING_MANAGER = P.CONCURRENT_PROCESS_ID AND Q.CONCURRENT_QUEUE_ID= P.CONCURRENT_QUEUE_ID AND Q.APPLICATION_ID = P.QUEUE_APPLICATION_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 10 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 10 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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=10 pr=0 pw=0 time=221 us cost=5 size=50 card=1) 1 1 1 NESTED LOOPS (cr=8 pr=0 pw=0 time=118 us cost=4 size=26 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=73 us cost=3 size=13 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=57 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROCESSES (cr=4 pr=0 pw=0 time=41 us cost=1 size=82602 card=6354) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROCESSES_U1 (cr=2 pr=0 pw=0 time=13 us cost=0 size=0 card=1)(object id 33070) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_QUEUES (cr=2 pr=0 pw=0 time=98 us cost=1 size=1656 card=69) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_QUEUES_U1 (cr=1 pr=0 pw=0 time=15 us cost=0 size=0 card=1)(object id 33259) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 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_PROCESSES' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_CONCURRENT_PROCESSES_U1' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_CONCURRENT_QUEUES' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_CONCURRENT_QUEUES_U1' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: 4muh1y3arxuck Plan Hash: 3674145885 SELECT NAME FROM HR_OPERATING_UNITS WHERE ORGANIZATION_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 8 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 8 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 MERGE JOIN CARTESIAN (cr=8 pr=0 pw=0 time=220 us cost=5 size=72 card=1) 1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=94 us cost=3 size=43 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID HR_ALL_ORGANIZATION_UNITS_TL (cr=3 pr=0 pw=0 time=48 us cost=2 size=26 card=1) 1 1 1 INDEX UNIQUE SCAN HR_ALL_ORGANIZATION_UNTS_TL_PK (cr=2 pr=0 pw=0 time=33 us cost=1 size=0 card=1)(object id 44637) 1 1 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (cr=2 pr=0 pw=0 time=43 us cost=1 size=17 card=1)(object id 3031442) 1 1 1 BUFFER SORT (cr=3 pr=0 pw=0 time=118 us cost=4 size=29 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=3 pr=0 pw=0 time=73 us cost=2 size=29 card=1) 1 1 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_X99 (cr=2 pr=0 pw=0 time=47 us cost=1 size=0 card=1)(object id 14622722) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 MERGE JOIN (CARTESIAN) 1 NESTED LOOPS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ALL_ORGANIZATION_UNITS_TL' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HR_ALL_ORGANIZATION_UNTS_TL_PK' (INDEX (UNIQUE)) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HR_ORGANIZATION_INFORMATIO_FK2' (INDEX) 1 BUFFER (SORT) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ORGANIZATION_INFORMATION' (TABLE) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HR_ORGANIZATION_INFORMATIO_X99' (INDEX) ******************************************************************************** SQL ID: a4gss3ajbyfzr Plan Hash: 515703603 SELECT R.RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL R WHERE R.RESPONSIBILITY_ID = :B2 AND R.APPLICATION_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 10 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 10 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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=5 pr=0 pw=0 time=111 us cost=3 size=52 card=1) 1 1 1 INDEX UNIQUE SCAN FND_RESPONSIBILITY_U1 (cr=2 pr=0 pw=0 time=32 us cost=1 size=9 card=1)(object id 33329) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY_TL (cr=3 pr=0 pw=0 time=76 us cost=2 size=43 card=1) 1 1 1 INDEX RANGE SCAN FND_RESPONSIBILITY_TL_N99 (cr=2 pr=0 pw=0 time=52 us cost=1 size=0 card=1)(object id 23137188) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 NESTED LOOPS 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_RESPONSIBILITY_U1' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_RESPONSIBILITY_TL' (TABLE) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_RESPONSIBILITY_TL_N99' (INDEX) ******************************************************************************** SQL ID: 3r3j4ftjs9mu8 Plan Hash: 4001234684 SELECT PLSQL_LOG, PLSQL_OUT, PLSQL_DIR FROM FND_CONCURRENT_PROCESSES P, FND_CONCURRENT_REQUESTS R WHERE P.CONCURRENT_PROCESS_ID = R.CONTROLLING_MANAGER AND R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_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 8 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 8 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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=8 pr=0 pw=0 time=174 us cost=4 size=81 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=54 us cost=3 size=13 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=43 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROCESSES (cr=4 pr=0 pw=0 time=117 us cost=1 size=432072 card=6354) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROCESSES_U1 (cr=2 pr=0 pw=0 time=32 us cost=0 size=0 card=1)(object id 33070) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 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_PROCESSES' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_CONCURRENT_PROCESSES_U1' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: 19w2h52d7ggr7 Plan Hash: 3498285708 SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER IN ( 'NLS_LANGUAGE', 'NLS_DATE_LANGUAGE', 'NLS_SORT', 'NLS_TERRITORY', 'NLS_DATE_FORMAT', 'NLS_NUMERIC_CHARACTERS', 'NLS_CHARACTERSET' ) 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 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 7 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 7 7 7 FIXED TABLE FULL X$NLS_PARAMETERS (cr=0 pr=0 pw=0 time=59 us cost=0 size=217 card=7) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 7 FIXED TABLE (FULL) OF 'X$NLS_PARAMETERS' (TABLE (FIXED)) ******************************************************************************** SQL ID: bkaaqaa5aj3gf Plan Hash: 2797573680 SELECT MESSAGE_TEXT, MESSAGE_NUMBER, TYPE, FND_LOG_SEVERITY, CATEGORY, SEVERITY FROM FND_NEW_MESSAGES M, FND_APPLICATION A WHERE :B3 = M.MESSAGE_NAME AND :B2 = M.LANGUAGE_CODE AND :B1 = A.APPLICATION_SHORT_NAME AND M.APPLICATION_ID = A.APPLICATION_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 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: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=104 us cost=3 size=138 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_APPLICATION (cr=2 pr=0 pw=0 time=29 us cost=1 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN FND_APPLICATION_U3 (cr=1 pr=0 pw=0 time=18 us cost=0 size=0 card=1)(object id 32806) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_NEW_MESSAGES (cr=4 pr=0 pw=0 time=70 us cost=2 size=128 card=1) 1 1 1 INDEX UNIQUE SCAN FND_NEW_MESSAGES_PK (cr=3 pr=0 pw=0 time=36 us cost=1 size=0 card=1)(object id 33198) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 NESTED LOOPS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_APPLICATION' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_APPLICATION_U3' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_NEW_MESSAGES' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_NEW_MESSAGES_PK' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: 2xyb5d6xg9srh Plan Hash: 1783251294 select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj# = :1 and a.property = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 6 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS FULL ASSOCIATION$ (cr=2 pr=0 pw=0 time=23 us cost=2 size=13 card=1) ******************************************************************************** SQL ID: 6x6vgq62dq86h Plan Hash: 2585102522 SELECT INIT_FUNCTION_NAME FROM FND_PRODUCT_INITIALIZATION WHERE APPLICATION_SHORT_NAME = :B1 AND EXISTS (SELECT 1 FROM FND_PRODUCT_INIT_CONDITION C WHERE C.APPLICATION_SHORT_NAME = :B1 AND C.RE_INIT_CONDITION IN (:B7 , :B6 , :B5 , :B4 , :B3 , :B2 )) 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 3 0 0 Fetch 3 0.00 0.00 0 3 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 6 0 3 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FILTER (cr=2 pr=0 pw=0 time=54 us) 1 1 1 INDEX RANGE SCAN FND_PRODUCT_INITIALIZATION_U1 (cr=1 pr=0 pw=0 time=21 us cost=1 size=24 card=1)(object id 108129) 1 1 1 INDEX RANGE SCAN FND_PRODUCT_INIT_CONDITION_U1 (cr=1 pr=0 pw=0 time=28 us cost=1 size=54 card=6)(object id 108132) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 FILTER 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_PRODUCT_INITIALIZATION_U1' (INDEX (UNIQUE)) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_PRODUCT_INIT_CONDITION_U1' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: 9twz82vgfbpsa Plan Hash: 4254020431 SELECT NVL(MULTI_ORG_FLAG, 'N') FROM FND_PRODUCT_GROUPS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS FULL FND_PRODUCT_GROUPS (cr=4 pr=0 pw=0 time=106 us cost=4 size=2 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 TABLE ACCESS MODE: ANALYZED (FULL) OF 'FND_PRODUCT_GROUPS' (TABLE) ******************************************************************************** SQL ID: 19d9ju4hz45dr Plan Hash: 1934133821 SELECT P.ROLLBACK_SEGMENT FROM FND_CONCURRENT_PROGRAMS P, FND_CONCURRENT_REQUESTS R WHERE R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_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 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 7 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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=7 pr=0 pw=0 time=130 us cost=4 size=29 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=104 us cost=3 size=17 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=78 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=23 us cost=1 size=177468 card=14789) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=15 us cost=0 size=0 card=1)(object id 33183) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 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)) ******************************************************************************** SQL ID: gryz5jc5wzzh4 Plan Hash: 3586361124 SELECT LEGISLATION_CODE FROM PER_BUSINESS_GROUPS_PERF WHERE BUSINESS_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 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 6 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 MERGE JOIN CARTESIAN (cr=6 pr=0 pw=0 time=105 us cost=4 size=48 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=3 pr=0 pw=0 time=41 us cost=2 size=29 card=1) 1 1 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_X99 (cr=2 pr=0 pw=0 time=29 us cost=1 size=0 card=1)(object id 14622722) 1 1 1 BUFFER SORT (cr=3 pr=0 pw=0 time=57 us cost=2 size=19 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=3 pr=0 pw=0 time=36 us cost=2 size=19 card=1) 1 1 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (cr=2 pr=0 pw=0 time=26 us cost=1 size=0 card=1)(object id 3031442) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 MERGE JOIN (CARTESIAN) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ORGANIZATION_INFORMATION' (TABLE) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HR_ORGANIZATION_INFORMATIO_X99' (INDEX) 1 BUFFER (SORT) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ORGANIZATION_INFORMATION' (TABLE) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HR_ORGANIZATION_INFORMATIO_FK2' (INDEX) ******************************************************************************** SQL ID: ffuf485g4tj0s Plan Hash: 1396620114 select count(*) from resource_consumer_group$ where name = :1 and internal_use = 1 and status = 'ACTIVE' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=2 pr=0 pw=0 time=90 us) 0 0 0 TABLE ACCESS FULL RESOURCE_CONSUMER_GROUP$ (cr=2 pr=0 pw=0 time=75 us cost=2 size=27 card=1) ******************************************************************************** SQL ID: 0p5cpqqwhdyr7 Plan Hash: 134341859 SELECT SUBSTR(REPLACE(USER_CONCURRENT_PROGRAM_NAME,'''',' '),1,240), SUBSTR(CONCURRENT_PROGRAM_NAME,1,30) FROM FND_CONCURRENT_PROGRAMS_VL WHERE CONCURRENT_PROGRAM_ID = :B1 AND APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 7 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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=7 pr=0 pw=0 time=102 us cost=4 size=77 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=55 us cost=2 size=25 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=49 us cost=1 size=0 card=1)(object id 33183) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS_TL (cr=4 pr=0 pw=0 time=41 us cost=2 size=52 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_TL_U1 (cr=3 pr=0 pw=0 time=31 us cost=1 size=0 card=1)(object id 33634) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 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)) ******************************************************************************** SQL ID: 18vgyatw1kbvw Plan Hash: 1934133821 SELECT P.OPTIMIZER_MODE, P.CONCURRENT_PROGRAM_NAME, UPPER(P.ENABLE_TRACE), UPPER(R.ENABLE_TRACE), DECODE(UPPER(P.ENABLE_TIME_STATISTICS),'Y','TRUE', NULL), EXECUTION_METHOD_CODE FROM FND_CONCURRENT_PROGRAMS P, FND_CONCURRENT_REQUESTS R WHERE P.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID AND P.APPLICATION_ID = R.PROGRAM_APPLICATION_ID AND R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 7 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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=7 pr=0 pw=0 time=101 us cost=4 size=67 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=82 us cost=3 size=19 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=61 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=12 us cost=1 size=709872 card=14789) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=6 us cost=0 size=0 card=1)(object id 33183) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 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)) ******************************************************************************** SQL ID: b1smtsrm4hrk9 Plan Hash: 1546270724 SELECT SYS_CONTEXT ('USERENV', 'SESSIONID') FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 1620 (HOTSOS) (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=9 us cost=2 size=0 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 FAST DUAL ******************************************************************************** SQL ID: 2tbcm3zxyxc45 Plan Hash: 3368168323 SELECT NVL(MOI.STATUS,'N') FROM FND_MO_PRODUCT_INIT MOI, FND_APPLICATION APP WHERE APP.APPLICATION_ID = :B1 AND APP.APPLICATION_SHORT_NAME = MOI.APPLICATION_SHORT_NAME call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=56 us cost=2 size=16 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_APPLICATION (cr=2 pr=0 pw=0 time=35 us cost=1 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN FND_APPLICATION_U1 (cr=1 pr=0 pw=0 time=17 us cost=0 size=0 card=1)(object id 32802) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_MO_PRODUCT_INIT (cr=1 pr=0 pw=0 time=16 us cost=1 size=120 card=20) 0 0 0 INDEX UNIQUE SCAN FND_MO_PRODUCT_INIT_U1 (cr=1 pr=0 pw=0 time=13 us cost=0 size=0 card=1)(object id 302508) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 NESTED LOOPS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_APPLICATION' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_APPLICATION_U1' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_MO_PRODUCT_INIT' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_MO_PRODUCT_INIT_U1' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: 1d3vut2wf2mhv Plan Hash: 173711545 SELECT ENABLE_ROUTINE, DISABLE_ROUTINE, DRO.DEBUG_OPTION_NAME, DRO.DEBUG_OPTION_VALUE, DR.DEBUG_RULE_ID, REPEATION_COUNTER, START_TIME, END_TIME, USER_ID, RESPONSIBILITY_ID, RESP_APPL_ID, COMPONENT_TYPE, COMPONENT_NAME, COMPONENT_ID, COMPONENT_APPL_ID, TRACE_FILE_ROUTINE, TRACE_FILE_NODE, COMMENTS, NVL(REQUEST_ID,0) REQID FROM FND_DEBUG_OPTIONS DO, FND_DEBUG_RULES DR, FND_DEBUG_OPTION_VALUES DOV, FND_DEBUG_RULE_OPTIONS DRO WHERE ( DR.USER_ID = :B8 OR (DR.RESPONSIBILITY_ID = :B7 AND DR.RESP_APPL_ID = :B6 ) OR (DR.USER_ID IS NULL AND DR.RESPONSIBILITY_ID IS NULL) ) AND (( SYSDATE >= DR.START_TIME AND SYSDATE <= DR.END_TIME) OR DR.REPEATION_COUNTER > 0 ) AND ( DR.COMPONENT_NAME = :B5 OR (DR.COMPONENT_ID = :B4 AND DR.COMPONENT_APPL_ID = :B3 ) ) AND DR.COMPONENT_TYPE = :B2 AND DRO.DEBUG_OPTION_NAME = DOV.DEBUG_OPTION_NAME AND DRO.DEBUG_OPTION_VALUE = DOV.DEBUG_OPTION_VALUE AND DRO.DEBUG_OPTION_NAME = DO.DEBUG_OPTION_NAME AND DO.TYPE = 'D' AND DO.ENABLED_FLAG = 'Y' AND ((DR.REQUEST_ID IS NOT NULL AND :B1 = DR.REQUEST_ID) OR (DR.REQUEST_ID IS NULL) ) AND DR.DEBUG_RULE_ID = DRO.DEBUG_RULE_ID AND DR.DEBUG_RULE_ID=(SELECT MIN(DEBUG_RULE_ID) FROM FND_DEBUG_RULES IDR WHERE (IDR.USER_ID = :B8 OR (IDR.RESPONSIBILITY_ID = :B7 AND IDR.RESP_APPL_ID = :B6 ) OR (IDR.USER_ID IS NULL AND IDR.RESPONSIBILITY_ID IS NULL) ) AND (( SYSDATE >= IDR.START_TIME AND SYSDATE <= IDR.END_TIME) OR IDR.REPEATION_COUNTER > 0 ) AND ( IDR.COMPONENT_NAME = :B5 OR (IDR.COMPONENT_ID = :B4 AND IDR.COMPONENT_APPL_ID = :B3 ) ) AND IDR.COMPONENT_TYPE = :B2 AND ((IDR.REQUEST_ID IS NOT NULL AND :B1 = IDR.REQUEST_ID) OR (IDR.REQUEST_ID IS NULL) ) ) ORDER BY REQID DESC, DR.CREATION_DATE, DR.DEBUG_RULE_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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 SORT ORDER BY (cr=1 pr=0 pw=0 time=71 us cost=9 size=219 card=1) 0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=39 us) 0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=37 us cost=6 size=219 card=1) 0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=35 us cost=5 size=115 card=1) 0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=34 us cost=4 size=101 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_DEBUG_RULES (cr=1 pr=0 pw=0 time=31 us cost=2 size=76 card=1) 0 0 0 INDEX RANGE SCAN FND_DEBUG_RULES_N3 (cr=1 pr=0 pw=0 time=25 us cost=1 size=0 card=1)(object id 2250898) 0 0 0 SORT AGGREGATE (cr=0 pr=0 pw=0 time=0 us) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_DEBUG_RULES (cr=0 pr=0 pw=0 time=0 us cost=2 size=76 card=1) 0 0 0 INDEX RANGE SCAN FND_DEBUG_RULES_N3 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 2250898) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_DEBUG_RULE_OPTIONS (cr=0 pr=0 pw=0 time=0 us cost=2 size=25 card=1) 0 0 0 INDEX RANGE SCAN FND_DEBUG_RULE_OPTIONS_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 2321837) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_DEBUG_OPTIONS (cr=0 pr=0 pw=0 time=0 us cost=1 size=14 card=1) 0 0 0 INDEX UNIQUE SCAN FND_DEBUG_OPTIONS_U1 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 2250886) 0 0 0 INDEX UNIQUE SCAN FND_DEBUG_OPTION_VALUES_U1 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 2250890) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_DEBUG_OPTION_VALUES (cr=0 pr=0 pw=0 time=0 us cost=1 size=104 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 SORT (ORDER BY) 0 NESTED LOOPS 0 NESTED LOOPS 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_DEBUG_RULES' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_DEBUG_RULES_N3' (INDEX) 0 SORT (AGGREGATE) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_DEBUG_RULES' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_DEBUG_RULES_N3' (INDEX) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_DEBUG_RULE_OPTIONS' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_DEBUG_RULE_OPTIONS_U1' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_DEBUG_OPTIONS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_DEBUG_OPTIONS_U1' (INDEX (UNIQUE)) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_DEBUG_OPTION_VALUES_U1' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_DEBUG_OPTION_VALUES' (TABLE) ******************************************************************************** SQL ID: aw7fu9a9bdyus Plan Hash: 510263741 SELECT * FROM PER_SECURITY_PROFILES WHERE SECURITY_PROFILE_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 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.01 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID PER_SECURITY_PROFILES (cr=2 pr=0 pw=0 time=36 us cost=1 size=109 card=1) 1 1 1 INDEX UNIQUE SCAN PER_SECURITY_PROFILES_PK (cr=1 pr=0 pw=0 time=17 us cost=0 size=0 card=1)(object id 44492) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'PER_SECURITY_PROFILES' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'PER_SECURITY_PROFILES_PK' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: gy26a7tjan9jk Plan Hash: 1934133821 SELECT P.RESOURCE_CONSUMER_GROUP FROM FND_CONCURRENT_PROGRAMS P, FND_CONCURRENT_REQUESTS R WHERE R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID AND R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 7 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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=7 pr=0 pw=0 time=73 us cost=4 size=44 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=54 us cost=3 size=17 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=43 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=16 us cost=1 size=399303 card=14789) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=9 us cost=0 size=0 card=1)(object id 33183) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 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)) ******************************************************************************** SQL ID: 98j69vs3ymzjv Plan Hash: 1846972739 SELECT DECODE(:B2 , 'UTF8', FL.UTF8_DATE_LANGUAGE, 'AL32UTF8', FL.UTF8_DATE_LANGUAGE, FL.LOCAL_DATE_LANGUAGE ) DATA_RTN FROM FND_LANGUAGES FL WHERE FL.NLS_LANGUAGE = :B1 AND FL.INSTALLED_FLAG <>'D' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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_LANGUAGES (cr=2 pr=0 pw=0 time=57 us cost=1 size=38 card=1) 1 1 1 INDEX UNIQUE SCAN FND_LANGUAGES_U5 (cr=1 pr=0 pw=0 time=25 us cost=0 size=0 card=1)(object id 33042) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_LANGUAGES' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_LANGUAGES_U5' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: 4hbsrc9yfbsxh Plan Hash: 1394898670 DELETE FROM MO_GLOB_ORG_ACCESS_TMP call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE MO_GLOB_ORG_ACCESS_TMP (cr=0 pr=0 pw=0 time=9 us) 0 0 0 TABLE ACCESS FULL MO_GLOB_ORG_ACCESS_TMP (cr=0 pr=0 pw=0 time=3 us) Rows Execution Plan ------- --------------------------------------------------- 0 DELETE STATEMENT MODE: CHOOSE 0 DELETE OF 'MO_GLOB_ORG_ACCESS_TMP' 0 TABLE ACCESS (FULL) OF 'MO_GLOB_ORG_ACCESS_TMP' (TABLE (TEMP)) ******************************************************************************** SQL ID: at3qkkaxrbrn5 Plan Hash: 3162025953 DELETE FROM FND_DEBUG_RULES WHERE (START_TIME IS NOT NULL AND END_TIME < SYSDATE) OR (REPEATION_COUNTER = 0) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 4 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 4 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE FND_DEBUG_RULES (cr=4 pr=0 pw=0 time=35 us) 0 0 0 TABLE ACCESS FULL FND_DEBUG_RULES (cr=4 pr=0 pw=0 time=34 us cost=4 size=43 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 DELETE STATEMENT MODE: CHOOSE 0 DELETE OF 'FND_DEBUG_RULES' 0 TABLE ACCESS MODE: ANALYZED (FULL) OF 'FND_DEBUG_RULES' (TABLE) ******************************************************************************** SQL ID: 1c1u6gc725u2a Plan Hash: 2325295079 SELECT U.USER_NAME, NVL(U.EMPLOYEE_ID, :B2 ) EMPLOYEE_ID, NVL(U.CUSTOMER_ID, :B2 ) CUSTOMER_ID, NVL(U.SUPPLIER_ID, :B2 ) SUPPLIER_ID, NVL(U.PERSON_PARTY_ID, :B2 ) PERSON_PARTY_ID FROM FND_USER U WHERE U.USER_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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_USER (cr=3 pr=0 pw=0 time=35 us cost=2 size=35 card=1) 1 1 1 INDEX UNIQUE SCAN FND_USER_U1 (cr=2 pr=0 pw=0 time=21 us cost=1 size=0 card=1)(object id 33427) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_USER' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_USER_U1' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: g0621q4gsac3f Plan Hash: 1546270724 SELECT TO_CHAR(SYSDATE,'DD-MON-YY:HH24:MI:SS') FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=1 us cost=2 size=0 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 FAST DUAL ******************************************************************************** SQL ID: at2h5x34yj2c4 Plan Hash: 1546270724 SELECT NLS_CHARSET_ID(:B1 ) FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=2 us cost=2 size=0 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 FAST DUAL ******************************************************************************** SQL ID: 5as61q63aqmts Plan Hash: 3838274141 SELECT A.APPLICATION_SHORT_NAME FROM FND_APPLICATION A WHERE A.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 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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_APPLICATION (cr=2 pr=0 pw=0 time=24 us cost=1 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN FND_APPLICATION_U1 (cr=1 pr=0 pw=0 time=11 us cost=0 size=0 card=1)(object id 32802) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_APPLICATION' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_APPLICATION_U1' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: bvyqm6268u2as Plan Hash: 2335689044 SELECT NODE_NAME FROM FND_NODES WHERE NODE_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 1 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (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 FND_NODES (cr=1 pr=0 pw=0 time=13 us cost=2 size=21 card=1) 0 0 0 INDEX RANGE SCAN FND_NODES_N1 (cr=1 pr=0 pw=0 time=11 us cost=1 size=0 card=1)(object id 9256161) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_NODES' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_NODES_N1' (INDEX) ******************************************************************************** SQL ID: 595qpkr7b4a4t Plan Hash: 1546270724 SELECT NLS_CHARSET_NAME(:B1 ) FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=1 us cost=2 size=0 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 FAST DUAL ******************************************************************************** SQL ID: 1ad1ww0b5p4ky Plan Hash: 1546270724 SELECT DECODE(:B1 , 'P', 'REPORTS', 'I', 'PLSQL_CP', 'J', 'JAVA_STORED_CP', 'K', 'JAVA_CP', 'Q', 'SQLPLUS_CP', 'E', 'PERL_CP', 'S', 'SUBROUTINE_CP', 'A', 'SPAWNED_CP', 'H', 'HOST_CP', 'L', 'LOADER_CP', 'NOT_SUPPORTED') FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 FAST DUAL ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 44183 0.69 0.76 2 6 0 0 Execute 3718851 173.32 183.94 3372 94663 282557 44144 Fetch 4716488 451.85 3631.26 269251 20560462 10 4078526 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8479522 625.86 3815.98 272625 20655131 282567 4122670 Misses in library cache during parse: 40 Misses in library cache during execute: 34 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 12042872 0.00 8.91 SQL*Net message from client 12042872 10.60 781.40 db file sequential read 271808 0.31 3214.19 Disk file operations I/O 36 0.00 0.00 undo segment extension 3 0.02 0.03 log buffer space 1 0.01 0.01 db file parallel read 2 0.17 0.27 log file sync 29422 0.02 34.67 SQL*Net more data from client 2 0.00 0.00 latch: cache buffers chains 11 0.00 0.00 latch: shared pool 1 0.00 0.00 buffer busy waits 1 0.00 0.00 log file switch (private strand flush incomplete) 1 0.01 0.01 SQL*Net more data to client 5 0.00 0.00 direct path write temp 32 0.02 0.11 direct path read temp 38 0.00 0.07 library cache: mutex X 1 0.00 0.00 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 166 0.04 0.04 0 0 0 0 Execute 427 0.60 5.42 3817 9252 125 49 Fetch 584 0.04 1.33 79 1265 0 551 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1177 0.68 6.80 3896 10517 125 600 Misses in library cache during parse: 29 Misses in library cache during execute: 17 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1256 0.05 3.50 Disk file operations I/O 2 0.00 0.00 db file scattered read 337 0.05 2.77 133 user SQL statements in session. 54 internal SQL statements in session. 187 SQL statements in session. 85 statements EXPLAINed in this session. ******************************************************************************** Trace file: betsyu1_ora_7522_APPS.trc Trace file compatibility: 11.1.0.7 Sort options: prsela exeela fchela 1 session in tracefile. 133 user SQL statements in trace file. 54 internal SQL statements in trace file. 187 SQL statements in trace file. 139 unique SQL statements in trace file. 85 SQL statements EXPLAINed using schema: APPS.prof$plan_table Default table was used. Table was created. Table was dropped. 32971092 lines in trace file. 5666 elapsed seconds in trace file.