AS SYSDBA@SYS@CDBFINI21 >/
Enter value for sql_id: 569n2zsswkp8p
old 1: select * from table(dbms_xplan.display_awr('&sql_id'))
new 1: select * from table(dbms_xplan.display_awr('569n2zsswkp8p'))
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID 569n2zsswkp8p
--------------------
SELECT BA.BANK_ACCT_USE_ID, RC.CREATION_STATUS,
RC.CREATION_METHOD_CODE, RMA.START_DATE RMA_START_DATE, RMA.END_DATE
RMA_END_DATE, RM.START_DATE RM_START_DATE, RM.END_DATE RM_END_DATE,
BA.END_DATE BAU_END_DATE, RMA.ORG_ID RMA_ORG_ID FROM AR_RECEIPT_METHODS
RM, CE_BANK_ACCOUNTS CBA, CE_BANK_ACCT_USES BA,
AR_RECEIPT_METHOD_ACCOUNTS RMA , AR_RECEIPT_CLASSES RC WHERE
RM.RECEIPT_METHOD_ID = :B4 AND (:B3 BETWEEN RM.START_DATE AND
NVL(RM.END_DATE, :B3 )) AND ((RC.CREATION_METHOD_CODE = DECODE(:B2
,'BR_REMITTED','BR_REMIT', 'BR_FACTORED_WITH_RECOURSE','BR_REMIT',
'BR_FACTORED_WITHOUT_RECOURSE','BR_REMIT','@*%?&')) OR
(RC.CREATION_METHOD_CODE = 'MANUAL') OR (RC.CREATION_METHOD_CODE =
'AUTOMATIC' AND RC.CONFIRM_FLAG = DECODE(:B2 ,
'AUTORECAPI',RC.CONFIRM_FLAG,'N'))) AND CBA.ACCOUNT_CLASSIFICATION =
'INTERNAL' AND NVL(BA.END_DATE, :B3 +1) > :B3 AND :B3 BETWEEN
RMA.START_DATE AND NVL(RMA.END_DATE, :B3 ) AND CBA.CURRENCY_CODE =
DECODE(CBA.RECEIPT_MULTI_CURRENCY_FLAG, 'Y', CBA.CURRENCY_CODE, :B1 )
AND RC.RECEIPT_CLASS_ID = RM.RECEIPT_CLASS_ID AND RM.RECEIPT_METHOD_ID
= RMA.RECEIPT_METHOD_ID AND RMA.REMIT_BANK_ACCT_USE_ID =
BA.BANK_ACCT_USE_ID AND BA.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID AND
((NVL(:B2 ,'*&#$') <> 'MISC') OR (RM.RECEIPT_CLASS_ID NOT IN ( SELECT
ARC.RECEIPT_CLASS_ID FROM AR_RECEIPT_CLASSES ARC WHERE
ARC.NOTES_RECEIVABLE='Y' OR ARC.BILL_OF_EXCHANGE_FLAG='Y'))) ORDER BY
DECODE(RMA.PRIMARY_FLAG,'Y',1,'N',2,3), DECODE(CBA.CURRENCY_CODE,:B1
,1,2), CBA.BANK_BRANCH_ID, CBA.BANK_ACCOUNT_NAME, BA.BANK_ACCT_USE_ID
Plan hash value: 2526039324
---------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop |
---------------------------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 1184 (100)| | | |
| 1 | SORT ORDER BY | | 1 | 169 | 1184 (1)| 00:00:01 | | |
| 2 | FILTER | | | | | | | |
| 3 | NESTED LOOPS | | 1 | 169 | 1183 (1)| 00:00:01 | | |
| 4 | MERGE JOIN CARTESIAN | | 1 | 154 | 983 (1)| 00:00:01 | | |
| 5 | NESTED LOOPS | | 1 | 95 | 5 (0)| 00:00:01 | | |
| 6 | NESTED LOOPS | | 1 | 60 | 3 (0)| 00:00:01 | | |
| 7 | TABLE ACCESS BY INDEX ROWID | AR_RECEIPT_METHODS | 1 | 28 | 2 (0)| 00:00:01 | | |
| 8 | INDEX UNIQUE SCAN | AR_RECEIPT_METHODS_U1 | 1 | | 1 (0)| 00:00:01 | | |
| 9 | TABLE ACCESS BY INDEX ROWID | AR_RECEIPT_CLASSES | 1 | 32 | 1 (0)| 00:00:01 | | |
| 10 | INDEX UNIQUE SCAN | AR_RECEIPT_CLASSES_U1 | 1 | | 0 (0)| | | |
| 11 | TABLE ACCESS BY INDEX ROWID BATCHED | AR_RECEIPT_METHOD_ACCOUNTS_ALL | 1 | 35 | 2 (0)| 00:00:01 | | |
| 12 | INDEX RANGE SCAN | AR_RECEIPT_METHOD_ACCOUNTS_U1 | 1 | | 1 (0)| 00:00:01 | | |
| 13 | BUFFER SORT | | 44267 | 2550K| 981 (1)| 00:00:01 | | |
| 14 | TABLE ACCESS STORAGE FULL | CE_BANK_ACCOUNTS | 44267 | 2550K| 978 (1)| 00:00:01 | | |
| 15 | VIEW | CE_BANK_ACCT_USES | 1 | 15 | 200 (1)| 00:00:01 | | |
| 16 | UNION ALL PUSHED PREDICATE | | | | | | | |
| 17 | TABLE ACCESS BY INDEX ROWID BATCHED | CE_BANK_ACCT_USES_ALL | 1 | 65 | 2 (0)| 00:00:01 | | |
| 18 | INDEX RANGE SCAN | CE_BANK_ACCT_USES_N1 | 1 | | 1 (0)| 00:00:01 | | |
| 19 | SORT UNIQUE | | 1 | 1466 | 198 (2)| 00:00:01 | | |
| 20 | VIEW | VW_ORE_6631FAAA | 3 | 4398 | 197 (1)| 00:00:01 | | |
| 21 | UNION-ALL | | | | | | | |
| 22 | HASH JOIN | | 1 | 87 | 101 (1)| 00:00:01 | | |
| 23 | TABLE ACCESS BY INDEX ROWID BATCHED | CE_BANK_ACCT_USES_ALL | 1 | 65 | 2 (0)| 00:00:01 | | |
| 24 | INDEX RANGE SCAN | CE_BANK_ACCT_USES_N1 | 1 | | 1 (0)| 00:00:01 | | |
| 25 | VIEW | CE_SECURITY_PROFILES_V | 39 | 858 | 98 (0)| 00:00:01 | | |
| 26 | UNION-ALL | | | | | | | |
| 27 | SORT UNIQUE | | 39 | 10346 | 98 (0)| 00:00:01 | | |
| 28 | UNION-ALL | | | | | | | |
| 29 | FILTER | | | | | | | |
| 30 | HASH JOIN | | 1 | 2202 | 78 (0)| 00:00:01 | | |
| 31 | NESTED LOOPS | | 1 | 2184 | 72 (0)| 00:00:01 | | |
| 32 | NESTED LOOPS | | 3 | 2184 | 72 (0)| 00:00:01 | | |
| 33 | NESTED LOOPS | | 1 | 2143 | 68 (0)| 00:00:01 | | |
| 34 | NESTED LOOPS | | 2 | 4106 | 8 (0)| 00:00:01 | | |
| 35 | TABLE ACCESS BY INDEX ROWID | FND_OBJECTS | 1 | 51 | 2 (0)| 00:00:01 | | |
| 36 | INDEX UNIQUE SCAN | FND_OBJECTS_U2 | 1 | | 1 (0)| 00:00:01 | | |
| 37 | VIEW | VW_NSO_3 | 2 | 4004 | 6 (0)| 00:00:01 | | |
| 38 | UNION-ALL | | | | | | | |
| 39 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 | | |
| 40 | NESTED LOOPS | | 1 | 49 | 4 (0)| 00:00:01 | | |
| 41 | TABLE ACCESS BY INDEX ROWID | FND_USER | 1 | 14 | 2 (0)| 00:00:01 | | |
| 42 | INDEX UNIQUE SCAN | FND_USER_U2 | 1 | | 1 (0)| 00:00:01 | | |
| 43 | PARTITION RANGE SINGLE | | 1 | 35 | 2 (0)| 00:00:01 | 10 | 10 |
| 44 | TCHED TABLE ACCESS BY LOCAL INDEX ROWID BA | WF_LOCAL_ROLES | 1 | 35 | 2 (0)| 00:00:01 | 10 | 10 |
| 45 | INDEX RANGE SCAN | WF_LOCAL_ROLES_N1 | 1 | | 1 (0)| 00:00:01 | 10 | 10 |
| 46 | PARTITION RANGE ALL | | 1 | 90 | 30 (0)| 00:00:01 | 1 | 14 |
| 47 | D TABLE ACCESS BY LOCAL INDEX ROWID BATCHE | WF_LOCAL_USER_ROLES | 1 | 90 | 30 (0)| 00:00:01 | 1 | 14 |
| 48 | INDEX RANGE SCAN | WF_LOCAL_USER_ROLES_N4 | 5 | | 28 (0)| 00:00:01 | 1 | 14 |
| 49 | INDEX RANGE SCAN | FND_GRANTS_N8 | 3 | | 1 (0)| 00:00:01 | | |
| 50 | TABLE ACCESS BY INDEX ROWID | FND_GRANTS | 1 | 41 | 4 (0)| 00:00:01 | | |
| 51 | TABLE ACCESS STORAGE FULL | XLE_ENTITY_PROFILES | 324 | 5832 | 6 (0)| 00:00:01 | | |
| 52 | FILTER | | | | | | | |
| 53 | HASH JOIN | | 1 | 110 | 12 (0)| 00:00:01 | | |
| 54 | NESTED LOOPS | | 1 | 92 | 6 (0)| 00:00:01 | | |
| 55 | TABLE ACCESS BY INDEX ROWID | FND_OBJECTS | 1 | 51 | 2 (0)| 00:00:01 | | |
| 56 | INDEX UNIQUE SCAN | FND_OBJECTS_U2 | 1 | | 1 (0)| 00:00:01 | | |
| 57 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_GRANTS | 1 | 41 | 4 (0)| 00:00:01 | | |
| 58 | INDEX RANGE SCAN | FND_GRANTS_N8 | 3 | | 1 (0)| 00:00:01 | | |
| 59 | TABLE ACCESS STORAGE FULL | XLE_ENTITY_PROFILES | 324 | 5832 | 6 (0)| 00:00:01 | | |
| 60 | FILTER | | | | | | | |
| 61 | FILTER | | | | | | | |
| 62 | NESTED LOOPS OUTER | | 1 | 131 | 0 (0)| | | |
| 63 | NESTED LOOPS OUTER | | 1 | 123 | 0 (0)| | | |
| 64 | NESTED LOOPS | | 1 | 115 | 0 (0)| | | |
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 65 | NESTED LOOPS | | 1 | 97 | 0 (0)| | | |
| 66 | NESTED LOOPS | | 1 | 85 | 0 (0)| | | |
| 67 | NESTED LOOPS | | 1 | 49 | 0 (0)| | | |
| 68 | TABLE ACCESS BY INDEX ROWID | XTR_DEALER_CODES | 1 | 20 | 0 (0)| | | |
| 69 | INDEX UNIQUE SCAN | XTR_DEALER_CODES_U2 | 1 | | 0 (0)| | | |
| 70 | INDEX UNIQUE SCAN | XTR_PRO_PARAM_U1 | 1 | 29 | 0 (0)| | | |
| 71 | TABLE ACCESS BY INDEX ROWID BATCHED | XTR_PARTY_INFO | 1 | 36 | 0 (0)| | | |
| 72 | INDEX RANGE SCAN | XTR_PARTY_INFO_N1 | 1 | | 0 (0)| | | |
| 73 | INDEX RANGE SCAN | XTR_COMPANY_AUTHORITIES_N1 | 1 | 12 | 0 (0)| | | |
| 74 | TABLE ACCESS BY INDEX ROWID | XLE_ENTITY_PROFILES | 1 | 18 | 0 (0)| | | |
| 75 | INDEX UNIQUE SCAN | XLE_ENTITY_PROFILES_U1 | 1 | | 0 (0)| | | |
| 76 | TABLE ACCESS BY INDEX ROWID | GL_LEDGERS | 1 | 8 | 0 (0)| | | |
| 77 | INDEX UNIQUE SCAN | GL_LEDGERS_U2 | 1 | | 0 (0)| | | |
| 78 | TABLE ACCESS BY INDEX ROWID | GL_LEDGERS | 1 | 8 | 0 (0)| | | |
| 79 | INDEX UNIQUE SCAN | GL_LEDGERS_U2 | 1 | | 0 (0)| | | |
| 80 | TABLE ACCESS BY INDEX ROWID | XTR_COMPANY_AUTHORITIES | 1 | 15 | 0 (0)| | | |
| 81 | INDEX UNIQUE SCAN | XTR_COMPANY_AUTHORITIES_U1 | 1 | | 0 (0)| | | |
| 82 | FILTER | | | | | | | |
| 83 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 | | |
| 84 | HASH JOIN | | 35 | 2730 | 98 (0)| 00:00:01 | | |
| 85 | HASH JOIN | | 27 | 1377 | 79 (0)| 00:00:01 | | |
| 86 | HASH JOIN | | 25 | 850 | 54 (0)| 00:00:01 | | |
| 87 | INDEX FULL SCAN | HR_ORGANIZATION_UNITS_PK | 24 | 96 | 6 (0)| 00:00:01 | | |
| 88 | TABLE ACCESS BY INDEX ROWID BATCHED | HR_ORGANIZATION_INFORMATION | 1 | 30 | 2 (0)| 00:00:01 | | |
| 89 | INDEX RANGE SCAN | HR_ORGANIZATION_INFORMATIO_IX1 | 3 | | 1 (0)| 00:00:01 | | |
| 90 | TABLE ACCESS BY INDEX ROWID BATCHED | HR_ORGANIZATION_INFORMATION | 1 | 17 | 1 (0)| 00:00:01 | | |
| 91 | INDEX RANGE SCAN | HR_ORGANIZATION_INFORMATIO_FK1 | 1 | | 1 (0)| 00:00:01 | | |
| 92 | TABLE ACCESS STORAGE FULL | HR_ALL_ORGANIZATION_UNITS_TL | 2391 | 64557 | 19 (0)| 00:00:01 | | |
| 93 | HASH JOIN | | 1 | 87 | 92 (0)| 00:00:01 | | |
| 94 | TABLE ACCESS BY INDEX ROWID BATCHED | CE_BANK_ACCT_USES_ALL | 1 | 65 | 2 (0)| 00:00:01 | | |
| 95 | INDEX RANGE SCAN | CE_BANK_ACCT_USES_N1 | 1 | | 1 (0)| 00:00:01 | | |
| 96 | VIEW | CE_SECURITY_PROFILES_V | 5 | 110 | 90 (0)| 00:00:01 | | |
| 97 | UNION-ALL | | | | | | | |
| 98 | SORT UNIQUE | | 5 | 5042 | 90 (0)| 00:00:01 | | |
| 99 | UNION-ALL | | | | | | | |
| 100 | HASH JOIN | | 1 | 2202 | 78 (0)| 00:00:01 | | |
| 101 | NESTED LOOPS | | 1 | 2184 | 72 (0)| 00:00:01 | | |
| 102 | NESTED LOOPS | | 3 | 2184 | 72 (0)| 00:00:01 | | |
| 103 | NESTED LOOPS | | 1 | 2143 | 68 (0)| 00:00:01 | | |
| 104 | NESTED LOOPS | | 2 | 4106 | 8 (0)| 00:00:01 | | |
| 105 | TABLE ACCESS BY INDEX ROWID | FND_OBJECTS | 1 | 51 | 2 (0)| 00:00:01 | | |
| 106 | INDEX UNIQUE SCAN | FND_OBJECTS_U2 | 1 | | 1 (0)| 00:00:01 | | |
| 107 | VIEW | VW_NSO_2 | 2 | 4004 | 6 (0)| 00:00:01 | | |
| 108 | UNION-ALL | | | | | | | |
| 109 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 | | |
| 110 | NESTED LOOPS | | 1 | 49 | 4 (0)| 00:00:01 | | |
| 111 | TABLE ACCESS BY INDEX ROWID | FND_USER | 1 | 14 | 2 (0)| 00:00:01 | | |
| 112 | INDEX UNIQUE SCAN | FND_USER_U2 | 1 | | 1 (0)| 00:00:01 | | |
| 113 | PARTITION RANGE SINGLE | | 1 | 35 | 2 (0)| 00:00:01 | 10 | 10 |
| 114 | CHED TABLE ACCESS BY LOCAL INDEX ROWID BAT | WF_LOCAL_ROLES | 1 | 35 | 2 (0)| 00:00:01 | 10 | 10 |
| 115 | INDEX RANGE SCAN | WF_LOCAL_ROLES_N1 | 1 | | 1 (0)| 00:00:01 | 10 | 10 |
| 116 | PARTITION RANGE ALL | | 1 | 90 | 30 (0)| 00:00:01 | 1 | 14 |
| 117 | TABLE ACCESS BY LOCAL INDEX ROWID BATCHED | WF_LOCAL_USER_ROLES | 1 | 90 | 30 (0)| 00:00:01 | 1 | 14 |
| 118 | INDEX RANGE SCAN | WF_LOCAL_USER_ROLES_N4 | 5 | | 28 (0)| 00:00:01 | 1 | 14 |
| 119 | INDEX RANGE SCAN | FND_GRANTS_N8 | 3 | | 1 (0)| 00:00:01 | | |
| 120 | TABLE ACCESS BY INDEX ROWID | FND_GRANTS | 1 | 41 | 4 (0)| 00:00:01 | | |
| 121 | TABLE ACCESS STORAGE FULL | XLE_ENTITY_PROFILES | 324 | 5832 | 6 (0)| 00:00:01 | | |
| 122 | HASH JOIN | | 1 | 110 | 12 (0)| 00:00:01 | | |
| 123 | NESTED LOOPS | | 1 | 92 | 6 (0)| 00:00:01 | | |
| 124 | TABLE ACCESS BY INDEX ROWID | FND_OBJECTS | 1 | 51 | 2 (0)| 00:00:01 | | |
| 125 | INDEX UNIQUE SCAN | FND_OBJECTS_U2 | 1 | | 1 (0)| 00:00:01 | | |
| 126 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_GRANTS | 1 | 41 | 4 (0)| 00:00:01 | | |
| 127 | INDEX RANGE SCAN | FND_GRANTS_N8 | 3 | | 1 (0)| 00:00:01 | | |
| 128 | TABLE ACCESS STORAGE FULL | XLE_ENTITY_PROFILES | 324 | 5832 | 6 (0)| 00:00:01 | | |
| 129 | FILTER | | | | | | | |
| 130 | NESTED LOOPS OUTER | | 1 | 131 | 0 (0)| | | |
| 131 | NESTED LOOPS OUTER | | 1 | 123 | 0 (0)| | | |
| 132 | NESTED LOOPS | | 1 | 115 | 0 (0)| | | |
| 133 | NESTED LOOPS | | 1 | 97 | 0 (0)| | | |
| 134 | NESTED LOOPS | | 1 | 85 | 0 (0)| | | |
| 135 | NESTED LOOPS | | 1 | 49 | 0 (0)| | | |
| 136 | TABLE ACCESS BY INDEX ROWID | XTR_DEALER_CODES | 1 | 20 | 0 (0)| | | |
| 137 | INDEX UNIQUE SCAN | XTR_DEALER_CODES_U2 | 1 | | 0 (0)| | | |
| 138 | INDEX UNIQUE SCAN | XTR_PRO_PARAM_U1 | 1 | 29 | 0 (0)| | | |
| 139 | TABLE ACCESS BY INDEX ROWID BATCHED | XTR_PARTY_INFO | 1 | 36 | 0 (0)| | | |
| 140 | INDEX RANGE SCAN | XTR_PARTY_INFO_N1 | 1 | | 0 (0)| | | |
| 141 | INDEX RANGE SCAN | XTR_COMPANY_AUTHORITIES_N1 | 1 | 12 | 0 (0)| | | |
| 142 | TABLE ACCESS BY INDEX ROWID | XLE_ENTITY_PROFILES | 1 | 18 | 0 (0)| | | |
| 143 | INDEX UNIQUE SCAN | XLE_ENTITY_PROFILES_U1 | 1 | | 0 (0)| | | |
| 144 | TABLE ACCESS BY INDEX ROWID | GL_LEDGERS | 1 | 8 | 0 (0)| | | |
| 145 | INDEX UNIQUE SCAN | GL_LEDGERS_U2 | 1 | | 0 (0)| | | |
| 146 | TABLE ACCESS BY INDEX ROWID | GL_LEDGERS | 1 | 8 | 0 (0)| | | |
| 147 | INDEX UNIQUE SCAN | GL_LEDGERS_U2 | 1 | | 0 (0)| | | |
| 148 | TABLE ACCESS BY INDEX ROWID | XTR_COMPANY_AUTHORITIES | 1 | 15 | 0 (0)| | | |
| 149 | INDEX UNIQUE SCAN | XTR_COMPANY_AUTHORITIES_U1 | 1 | | 0 (0)| | | |
| 150 | FILTER | | | | | | | |
| 151 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 | | |
| 152 | FILTER | | | | | | | |
| 153 | HASH JOIN | | 35 | 2730 | 98 (0)| 00:00:01 | | |
| 154 | NESTED LOOPS | | 27 | 1377 | 79 (0)| 00:00:01 | | |
| 155 | NESTED LOOPS | | 25 | 850 | 54 (0)| 00:00:01 | | |
| 156 | INDEX FULL SCAN | HR_ORGANIZATION_UNITS_PK | 24 | 96 | 6 (0)| 00:00:01 | | |
| 157 | TABLE ACCESS BY INDEX ROWID BATCHED | HR_ORGANIZATION_INFORMATION | 1 | 30 | 2 (0)| 00:00:01 | | |
| 158 | INDEX RANGE SCAN | HR_ORGANIZATION_INFORMATIO_FK2 | 3 | | 1 (0)| 00:00:01 | | |
| 159 | INDEX RANGE SCAN | HR_ORGANIZATION_INFORMATIO_FK2 | 1 | 17 | 1 (0)| 00:00:01 | | |
| 160 | TABLE ACCESS STORAGE FULL | HR_ALL_ORGANIZATION_UNITS_TL | 2391 | 64557 | 19 (0)| 00:00:01 | | |
| 161 | HASH JOIN | | 1 | 87 | 4 (0)| 00:00:01 | | |
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 162 | TABLE ACCESS BY INDEX ROWID BATCHED | CE_BANK_ACCT_USES_ALL | 1 | 65 | 2 (0)| 00:00:01 | | |
| 163 | INDEX RANGE SCAN | CE_BANK_ACCT_USES_N1 | 1 | | 1 (0)| 00:00:01 | | |
| 164 | VIEW | CE_SECURITY_PROFILES_V | 5 | 110 | 2 (0)| 00:00:01 | | |
| 165 | UNION-ALL | | | | | | | |
| 166 | SORT UNIQUE | | 5 | 5042 | 2 (0)| 00:00:01 | | |
| 167 | UNION-ALL | | | | | | | |
| 168 | FILTER | | | | | | | |
| 169 | HASH JOIN | | 1 | 2202 | 78 (0)| 00:00:01 | | |
| 170 | NESTED LOOPS | | 1 | 2184 | 72 (0)| 00:00:01 | | |
| 171 | NESTED LOOPS | | 3 | 2184 | 72 (0)| 00:00:01 | | |
| 172 | NESTED LOOPS | | 1 | 2143 | 68 (0)| 00:00:01 | | |
| 173 | NESTED LOOPS | | 2 | 4106 | 8 (0)| 00:00:01 | | |
| 174 | TABLE ACCESS BY INDEX ROWID | FND_OBJECTS | 1 | 51 | 2 (0)| 00:00:01 | | |
| 175 | INDEX UNIQUE SCAN | FND_OBJECTS_U2 | 1 | | 1 (0)| 00:00:01 | | |
| 176 | VIEW | VW_NSO_1 | 2 | 4004 | 6 (0)| 00:00:01 | | |
| 177 | UNION-ALL | | | | | | | |
| 178 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 | | |
| 179 | NESTED LOOPS | | 1 | 49 | 4 (0)| 00:00:01 | | |
| 180 | TABLE ACCESS BY INDEX ROWID | FND_USER | 1 | 14 | 2 (0)| 00:00:01 | | |
| 181 | INDEX UNIQUE SCAN | FND_USER_U2 | 1 | | 1 (0)| 00:00:01 | | |
| 182 | PARTITION RANGE SINGLE | | 1 | 35 | 2 (0)| 00:00:01 | 10 | 10 |
| 183 | TCHED TABLE ACCESS BY LOCAL INDEX ROWID BA | WF_LOCAL_ROLES | 1 | 35 | 2 (0)| 00:00:01 | 10 | 10 |
| 184 | INDEX RANGE SCAN | WF_LOCAL_ROLES_N1 | 1 | | 1 (0)| 00:00:01 | 10 | 10 |
| 185 | PARTITION RANGE ALL | | 1 | 90 | 30 (0)| 00:00:01 | 1 | 14 |
| 186 | D TABLE ACCESS BY LOCAL INDEX ROWID BATCHE | WF_LOCAL_USER_ROLES | 1 | 90 | 30 (0)| 00:00:01 | 1 | 14 |
| 187 | INDEX RANGE SCAN | WF_LOCAL_USER_ROLES_N4 | 5 | | 28 (0)| 00:00:01 | 1 | 14 |
| 188 | INDEX RANGE SCAN | FND_GRANTS_N8 | 3 | | 1 (0)| 00:00:01 | | |
| 189 | TABLE ACCESS BY INDEX ROWID | FND_GRANTS | 1 | 41 | 4 (0)| 00:00:01 | | |
| 190 | TABLE ACCESS STORAGE FULL | XLE_ENTITY_PROFILES | 324 | 5832 | 6 (0)| 00:00:01 | | |
| 191 | FILTER | | | | | | | |
| 192 | HASH JOIN | | 1 | 110 | 12 (0)| 00:00:01 | | |
| 193 | NESTED LOOPS | | 1 | 92 | 6 (0)| 00:00:01 | | |
| 194 | TABLE ACCESS BY INDEX ROWID | FND_OBJECTS | 1 | 51 | 2 (0)| 00:00:01 | | |
| 195 | INDEX UNIQUE SCAN | FND_OBJECTS_U2 | 1 | | 1 (0)| 00:00:01 | | |
| 196 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_GRANTS | 1 | 41 | 4 (0)| 00:00:01 | | |
| 197 | INDEX RANGE SCAN | FND_GRANTS_N8 | 3 | | 1 (0)| 00:00:01 | | |
| 198 | TABLE ACCESS STORAGE FULL | XLE_ENTITY_PROFILES | 324 | 5832 | 6 (0)| 00:00:01 | | |
| 199 | FILTER | | | | | | | |
| 200 | FILTER | | | | | | | |
| 201 | NESTED LOOPS OUTER | | 1 | 131 | 0 (0)| | | |
| 202 | NESTED LOOPS OUTER | | 1 | 123 | 0 (0)| | | |
| 203 | NESTED LOOPS | | 1 | 115 | 0 (0)| | | |
| 204 | NESTED LOOPS | | 1 | 97 | 0 (0)| | | |
| 205 | NESTED LOOPS | | 1 | 85 | 0 (0)| | | |
| 206 | NESTED LOOPS | | 1 | 49 | 0 (0)| | | |
| 207 | TABLE ACCESS BY INDEX ROWID | XTR_DEALER_CODES | 1 | 20 | 0 (0)| | | |
| 208 | INDEX UNIQUE SCAN | XTR_DEALER_CODES_U2 | 1 | | 0 (0)| | | |
| 209 | INDEX UNIQUE SCAN | XTR_PRO_PARAM_U1 | 1 | 29 | 0 (0)| | | |
| 210 | TABLE ACCESS BY INDEX ROWID BATCHED | XTR_PARTY_INFO | 1 | 36 | 0 (0)| | | |
| 211 | INDEX RANGE SCAN | XTR_PARTY_INFO_N1 | 1 | | 0 (0)| | | |
| 212 | INDEX RANGE SCAN | XTR_COMPANY_AUTHORITIES_N1 | 1 | 12 | 0 (0)| | | |
| 213 | TABLE ACCESS BY INDEX ROWID | XLE_ENTITY_PROFILES | 1 | 18 | 0 (0)| | | |
| 214 | INDEX UNIQUE SCAN | XLE_ENTITY_PROFILES_U1 | 1 | | 0 (0)| | | |
| 215 | TABLE ACCESS BY INDEX ROWID | GL_LEDGERS | 1 | 8 | 0 (0)| | | |
| 216 | INDEX UNIQUE SCAN | GL_LEDGERS_U2 | 1 | | 0 (0)| | | |
| 217 | TABLE ACCESS BY INDEX ROWID | GL_LEDGERS | 1 | 8 | 0 (0)| | | |
| 218 | INDEX UNIQUE SCAN | GL_LEDGERS_U2 | 1 | | 0 (0)| | | |
| 219 | TABLE ACCESS BY INDEX ROWID | XTR_COMPANY_AUTHORITIES | 1 | 15 | 0 (0)| | | |
| 220 | INDEX UNIQUE SCAN | XTR_COMPANY_AUTHORITIES_U1 | 1 | | 0 (0)| | | |
| 221 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 | | |
| 222 | FILTER | | | | | | | |
| 223 | HASH JOIN | | 35 | 2730 | 98 (0)| 00:00:01 | | |
| 224 | NESTED LOOPS | | 27 | 1377 | 79 (0)| 00:00:01 | | |
| 225 | NESTED LOOPS | | 25 | 850 | 54 (0)| 00:00:01 | | |
| 226 | INDEX FULL SCAN | HR_ORGANIZATION_UNITS_PK | 24 | 96 | 6 (0)| 00:00:01 | | |
| 227 | TABLE ACCESS BY INDEX ROWID BATCHED | HR_ORGANIZATION_INFORMATION | 1 | 30 | 2 (0)| 00:00:01 | | |
| 228 | INDEX RANGE SCAN | HR_ORGANIZATION_INFORMATIO_FK2 | 3 | | 1 (0)| 00:00:01 | | |
| 229 | INDEX RANGE SCAN | HR_ORGANIZATION_INFORMATIO_FK2 | 1 | 17 | 1 (0)| 00:00:01 | | |
| 230 | TABLE ACCESS STORAGE FULL | HR_ALL_ORGANIZATION_UNITS_TL | 2391 | 64557 | 19 (0)| 00:00:01 | | |
| 231 | TABLE ACCESS BY INDEX ROWID | AR_RECEIPT_CLASSES | 1 | 17 | 1 (0)| 00:00:01 | | |
| 232 | INDEX UNIQUE SCAN | AR_RECEIPT_CLASSES_U1 | 1 | | 0 (0)| | | |
---------------------------------------------------------------------------------------------------------------------------------------------------------------
Note
-----
- this is an adaptive plan
271 rows selected.
AS SYSDBA@SYS@CDBFINI21 >spoof
SP2-0042: unknown command "spoof" - rest of line ignored.
AS SYSDBA@SYS@CDBFINI21 >spool off