Created
February 23, 2022 03:47
-
-
Save aryangoti/325f0c60e39fcceab38e980eea049508 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Plan hash value: 284967902 | |
--------------------------------------------------------------------------------------------------------------------------------- | |
| Id | Operation | Name | E-Rows | OMem | 1Mem | Used-Mem | | |
--------------------------------------------------------------------------------------------------------------------------------- | |
| 0 | SELECT STATEMENT | | | | | | | |
|* 1 | FILTER | | | | | | | |
|* 2 | HASH JOIN | | 1 | 803K| 803K| 447K (0)| | |
| 3 | NESTED LOOPS | | 1 | | | | | |
|* 4 | FILTER | | | | | | | |
| 5 | NESTED LOOPS OUTER | | 1 | | | | | |
| 6 | NESTED LOOPS | | 1 | | | | | |
|* 7 | HASH JOIN | | 1 | 822K| 822K| 1265K (0)| | |
|* 8 | HASH JOIN OUTER | | 1 | 826K| 826K| 567K (0)| | |
|* 9 | HASH JOIN OUTER | | 1 | 823K| 823K| 584K (0)| | |
|* 10 | HASH JOIN OUTER | | 1 | 818K| 818K| 1282K (0)| | |
|* 11 | HASH JOIN OUTER | | 1 | 820K| 820K| 1260K (0)| | |
| 12 | NESTED LOOPS | | 1 | | | | | |
|* 13 | HASH JOIN | | 1 | 857K| 857K| 416K (0)| | |
| 14 | NESTED LOOPS OUTER | | 1 | | | | | |
| 15 | NESTED LOOPS | | 1 | | | | | |
| 16 | NESTED LOOPS | | 1 | | | | | |
| 17 | NESTED LOOPS | | 1 | | | | | |
|* 18 | HASH JOIN | | 1 | 998K| 998K| 1262K (0)| | |
| 19 | VIEW | USER_CONSTRAINTS | 2 | | | | | |
| 20 | UNION-ALL | | | | | | | |
| 21 | PARTITION LIST ALL | | 1 | | | | | |
|* 22 | FIXED TABLE FULL | X$COMVW$ | 1 | | | | | |
|* 23 | FILTER | | | | | | | |
| 24 | NESTED LOOPS OUTER | | 1 | | | | | |
|* 25 | HASH JOIN | | 1 | 743K| 743K| 452K (0)| | |
|* 26 | HASH JOIN OUTER | | 1 | 750K| 750K| 416K (0)| | |
|* 27 | HASH JOIN OUTER | | 1 | 758K| 758K| 416K (0)| | |
| 28 | NESTED LOOPS OUTER | | 1 | | | | | |
| 29 | NESTED LOOPS OUTER | | 1 | | | | | |
| 30 | NESTED LOOPS | | 1 | | | | | |
|* 31 | HASH JOIN | | 1 | 1022K| 1022K| 1455K (0)| | |
|* 32 | HASH JOIN | | 2 | 1087K| 1087K| 1385K (0)| | |
|* 33 | TABLE ACCESS FULL | CDEF$ | 2 | | | | | |
| 34 | TABLE ACCESS FULL | CON$ | 1 | | | | | |
|* 35 | TABLE ACCESS FULL | USER$ | 1 | | | | | |
|* 36 | CHED TABLE ACCESS BY INDEX ROWID BAT | OBJ$ | 1 | | | | | |
|* 37 | INDEX RANGE SCAN | I_OBJ1 | 1 | | | | | |
| 38 | TABLE ACCESS BY INDEX ROWID | CON$ | 1 | | | | | |
|* 39 | INDEX UNIQUE SCAN | I_CON2 | 1 | | | | | |
|* 40 | INDEX RANGE SCAN | I_OBJ1 | 1 | | | | | |
| 41 | INDEX FULL SCAN | I_USER2 | 1 | | | | | |
| 42 | INDEX FULL SCAN | I_USER2 | 1 | | | | | |
| 43 | INDEX FULL SCAN | I_USER2 | 1 | | | | | |
| 44 | VIEW PUSHED PREDICATE | _CURRENT_EDITION_OBJ | 1 | | | | | |
|* 45 | FILTER | | | | | | | |
| 46 | NESTED LOOPS | | 1 | | | | | |
| 47 | D TABLE ACCESS BY INDEX ROWID BATCHE | OBJ$ | 1 | | | | | |
|* 48 | INDEX RANGE SCAN | I_OBJ1 | 1 | | | | | |
|* 49 | INDEX RANGE SCAN | I_USER2 | 1 | | | | | |
|* 50 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | | | | | |
| 51 | NESTED LOOPS | | 1 | | | | | |
|* 52 | INDEX SKIP SCAN | I_USER2 | 1 | | | | | |
|* 53 | INDEX RANGE SCAN | I_OBJ4 | 1 | | | | | |
|* 54 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | | | | | |
|* 55 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | | | | | |
| 56 | NESTED LOOPS | | 1 | | | | | |
|* 57 | INDEX SKIP SCAN | I_USER2 | 1 | | | | | |
|* 58 | INDEX RANGE SCAN | I_OBJ4 | 1 | | | | | |
|* 59 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | | | | | |
|* 60 | TABLE ACCESS FULL | CON$ | 1 | | | | | |
|* 61 | TABLE ACCESS BY INDEX ROWID | CDEF$ | 1 | | | | | |
|* 62 | INDEX UNIQUE SCAN | I_CDEF1 | 1 | | | | | |
|* 63 | INDEX RANGE SCAN | I_USER2 | 1 | | | | | |
|* 64 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 1 | | | | | |
|* 65 | INDEX RANGE SCAN | I_OBJ5 | 1 | | | | | |
| 66 | TABLE ACCESS CLUSTER | TAB$ | 1 | | | | | |
|* 67 | INDEX UNIQUE SCAN | I_OBJ# | 1 | | | | | |
| 68 | INDEX FULL SCAN | I_USER2 | 1 | | | | | |
|* 69 | TABLE ACCESS CLUSTER | COL$ | 1 | | | | | |
|* 70 | INDEX UNIQUE SCAN | I_OBJ# | 1 | | | | | |
| 71 | TABLE ACCESS BY INDEX ROWID BATCHED | COLTYPE$ | 1 | | | | | |
| 72 | INDEX FULL SCAN | I_COLTYPE2 | 2674 | | | | | |
| 73 | INDEX FAST FULL SCAN | I_HH_OBJ#_INTCOL# | 1 | | | | | |
|* 74 | TABLE ACCESS FULL | OBJ$ | 1 | | | | | |
| 75 | INDEX FULL SCAN | I_USER2 | 1 | | | | | |
| 76 | TABLE ACCESS FULL | CCOL$ | 1 | | | | | |
| 77 | TABLE ACCESS BY INDEX ROWID | COL$ | 1 | | | | | |
|* 78 | INDEX UNIQUE SCAN | I_COL3 | 1 | | | | | |
|* 79 | TABLE ACCESS CLUSTER | ATTRCOL$ | 1 | | | | | |
| 80 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 1 | | | | | |
|* 81 | INDEX RANGE SCAN | I_OBJ1 | 1 | | | | | |
| 82 | INDEX FULL SCAN | I_USER2 | 1 | | | | | |
| 83 | PX COORDINATOR | | | | | | | |
| 84 | PX SEND QC (RANDOM) | :TQ10000 | 2 | | | | | |
| 85 | VIEW | USER_CONSTRAINTS | 2 | | | | | |
| 86 | UNION-ALL | | | | | | | |
| 87 | PX PARTITION LIST ALL | | 1 | | | | | |
|* 88 | FIXED TABLE FULL | X$COMVW$ | 1 | | | | | |
| 89 | PX SELECTOR | | | | | | | |
|* 90 | FILTER | | | | | | | |
| 91 | NESTED LOOPS | | 1 | | | | | |
| 92 | NESTED LOOPS OUTER | | 1 | | | | | |
| 93 | NESTED LOOPS OUTER | | 1 | | | | | |
| 94 | NESTED LOOPS OUTER | | 1 | | | | | |
| 95 | NESTED LOOPS OUTER | | 1 | | | | | |
| 96 | NESTED LOOPS OUTER | | 1 | | | | | |
| 97 | NESTED LOOPS | | 1 | | | | | |
| 98 | NESTED LOOPS | | 1 | | | | | |
| 99 | NESTED LOOPS | | 1 | | | | | |
|*100 | TABLE ACCESS FULL | USER$ | 2 | | | | | |
| 101 | TABLE ACCESS BY INDEX ROWID | CON$ | 1 | | | | | |
|*102 | INDEX UNIQUE SCAN | I_CON1 | 1 | | | | | |
|*103 | TABLE ACCESS BY INDEX ROWID | CDEF$ | 1 | | | | | |
|*104 | INDEX UNIQUE SCAN | I_CDEF1 | 1 | | | | | |
|*105 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 1 | | | | | |
|*106 | INDEX RANGE SCAN | I_OBJ1 | 1 | | | | | |
| 107 | VIEW PUSHED PREDICATE | _CURRENT_EDITION_OBJ | 1 | | | | | |
|*108 | FILTER | | | | | | | |
| 109 | NESTED LOOPS | | 1 | | | | | |
| 110 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 1 | | | | | |
|*111 | INDEX RANGE SCAN | I_OBJ1 | 1 | | | | | |
|*112 | INDEX RANGE SCAN | I_USER2 | 1 | | | | | |
|*113 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | | | | | |
| 114 | NESTED LOOPS | | 1 | | | | | |
|*115 | INDEX SKIP SCAN | I_USER2 | 1 | | | | | |
|*116 | INDEX RANGE SCAN | I_OBJ4 | 1 | | | | | |
|*117 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | | | | | |
| 118 | TABLE ACCESS BY INDEX ROWID | CON$ | 1 | | | | | |
|*119 | INDEX UNIQUE SCAN | I_CON2 | 1 | | | | | |
|*120 | INDEX RANGE SCAN | I_OBJ1 | 1 | | | | | |
|*121 | INDEX RANGE SCAN | I_USER2 | 1 | | | | | |
|*122 | INDEX RANGE SCAN | I_USER2 | 1 | | | | | |
|*123 | INDEX RANGE SCAN | I_USER2 | 1 | | | | | |
|*124 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | | | | | |
| 125 | NESTED LOOPS | | 1 | | | | | |
|*126 | INDEX SKIP SCAN | I_USER2 | 1 | | | | | |
|*127 | INDEX RANGE SCAN | I_OBJ4 | 1 | | | | | |
|*128 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | | | | | |
|*129 | TABLE ACCESS CLUSTER | TAB$ | 1 | | | | | |
|*130 | INDEX UNIQUE SCAN | I_OBJ# | 1 | | | | | |
|*131 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | | | | | |
| 132 | NESTED LOOPS | | 1 | | | | | |
|*133 | INDEX SKIP SCAN | I_USER2 | 1 | | | | | |
|*134 | INDEX RANGE SCAN | I_OBJ4 | 1 | | | | | |
|*135 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | | | | | |
|*136 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | | | | | |
| 137 | NESTED LOOPS | | 1 | | | | | |
|*138 | INDEX SKIP SCAN | I_USER2 | 1 | | | | | |
|*139 | INDEX RANGE SCAN | I_OBJ4 | 1 | | | | | |
|*140 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | | | | | |
--------------------------------------------------------------------------------------------------------------------------------- | |
Predicate Information (identified by operation id): | |
--------------------------------------------------- | |
1 - filter(( IS NOT NULL AND ("O"."TYPE#"=3 OR "O"."TYPE#"=4 OR ("O"."TYPE#"=2 AND IS NULL)) AND (( IS NULL AND | |
"O"."TYPE#"<>88) OR BITAND("O"."FLAGS",1048576)=1048576 OR BITAND("U"."SPARE1",16)=0 OR | |
(((SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2) OR ("U"."TYPE#"=2 AND | |
"U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR IS NOT NULL) AND IS NOT NULL)) AND (( IS NULL | |
AND "O"."TYPE#"<>88) OR BITAND("O"."FLAGS",1048576)=1048576 OR BITAND("U"."SPARE1",16)=0 OR | |
(((SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2) OR ("U"."TYPE#"=2 AND | |
"U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR IS NOT NULL) AND IS NOT NULL)))) | |
2 - access("O"."OWNER#"="U"."USER#") | |
4 - filter("C"."NAME"=DECODE("AC"."NAME",NULL,"COL"."NAME","AC"."NAME")) | |
7 - access("CD"."CON#"="CC"."CON#") | |
8 - access("OT"."OWNER#"="USER#") | |
9 - access("AC"."TOID"="OT"."OID$") | |
10 - access("C"."OBJ#"="H"."OBJ#" AND "C"."INTCOL#"="H"."INTCOL#") | |
11 - access("C"."OBJ#"="AC"."OBJ#" AND "C"."INTCOL#"="AC"."INTCOL#") | |
13 - access("O"."OWNER#"="U"."USER#") | |
18 - access("UC"."CONSTRAINT_NAME"="C"."NAME") | |
22 - filter(("INT$INT$DBA_CONSTRAINTS"."OBJECT_TYPE#"=4 AND "CONSTRAINT_TYPE"=:SYS_B_0 AND "STATUS"=:SYS_B_1 AND | |
"TABLE_NAME"<>:SYS_B_5 AND "INT$INT$DBA_CONSTRAINTS"."OWNER"=SYS_CONTEXT('USERENV','CURRENT_USER'))) | |
23 - filter((( IS NULL AND "O"."TYPE#"<>88) OR BITAND("O"."FLAGS",1048576)=1048576 OR BITAND("U"."SPARE1",16)=0 OR | |
(((SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2) OR ("U"."TYPE#"=2 AND | |
"U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR IS NOT NULL) AND IS NOT NULL))) | |
25 - access("O"."OWNER#"="U"."USER#") | |
26 - access("OI"."OWNER#"="UI"."USER#") | |
27 - access("RC"."OWNER#"="USER#") | |
31 - access("OC"."OWNER#"="USER#") | |
32 - access("OC"."CON#"="C"."CON#") | |
33 - filter((DECODE("C"."TYPE#",1,'C',2,'P',3,'U',4,'R',5,'V',6,'O',7,'C',8,'H',9,'F',10,'F',11,'F',13,'F','?')=:SYS_B_ | |
0 AND DECODE("C"."TYPE#",5,'ENABLED',DECODE(TO_CHAR("C"."ENABLED"),NULL,'DISABLED','ENABLED'))=:SYS_B_1 AND | |
("C"."TYPE#"<14 OR "C"."TYPE#">17) AND "C"."TYPE#"<>12 AND "C"."TYPE#"<>8)) | |
35 - filter(DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME")=SYS_CONTEXT('USERENV','CURRENT_USER')) | |
36 - filter("O"."NAME"<>:SYS_B_5) | |
37 - access("C"."OBJ#"="O"."OBJ#" AND "O"."TYPE#"=2) | |
filter("O"."TYPE#"=2) | |
39 - access("C"."RCON#"="RC"."CON#") |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment