Skip to content

Instantly share code, notes, and snippets.

@aryangoti

aryangoti/gist:f50de232c925100e158b8f834171d27e

Created February 23, 2022 03:51
Show Gist options
  • Save aryangoti/f50de232c925100e158b8f834171d27e to your computer and use it in GitHub Desktop.
Save aryangoti/f50de232c925100e158b8f834171d27e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Plan hash value: 156063049
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | TQ |IN-OUT| PQ Distrib |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 191 (100)| | | | | | |
|* 1 | FILTER | | | | | | | | | | |
| 2 | PX COORDINATOR | | | | | | | | | | |
| 3 | PX SEND QC (RANDOM) | :TQ10003 | 1 | 632 | 191 (2)| 00:00:01 | | | Q1,03 | P->S | QC (RAND) |
|* 4 | HASH JOIN BUFFERED | | 1 | 632 | 191 (2)| 00:00:01 | | | Q1,03 | PCWP | |
| 5 | BUFFER SORT | | | | | | | | Q1,03 | PCWC | |
| 6 | PX RECEIVE | | 1 | 566 | 131 (1)| 00:00:01 | | | Q1,03 | PCWP | |
| 7 | PX SEND HYBRID HASH | :TQ10000 | 1 | 566 | 131 (1)| 00:00:01 | | | | S->P | HYBRID HASH|
| 8 | STATISTICS COLLECTOR | | | | | | | | | | |
|* 9 | HASH JOIN | | 1 | 566 | 131 (1)| 00:00:01 | | | | | |
| 10 | NESTED LOOPS | | 1 | 542 | 130 (1)| 00:00:01 | | | | | |
|* 11 | FILTER | | | | | | | | | | |
| 12 | NESTED LOOPS OUTER | | 1 | 521 | 128 (1)| 00:00:01 | | | | | |
| 13 | NESTED LOOPS | | 1 | 473 | 127 (1)| 00:00:01 | | | | | |
|* 14 | HASH JOIN | | 1 | 451 | 126 (1)| 00:00:01 | | | | | |
|* 15 | HASH JOIN OUTER | | 1 | 437 | 124 (1)| 00:00:01 | | | | | |
|* 16 | HASH JOIN OUTER | | 1 | 421 | 123 (1)| 00:00:01 | | | | | |
|* 17 | HASH JOIN OUTER | | 1 | 412 | 118 (1)| 00:00:01 | | | | | |
|* 18 | HASH JOIN OUTER | | 1 | 402 | 116 (1)| 00:00:01 | | | | | |
| 19 | NESTED LOOPS | | 1 | 374 | 115 (1)| 00:00:01 | | | | | |
|* 20 | HASH JOIN | | 1 | 318 | 114 (1)| 00:00:01 | | | | | |
| 21 | NESTED LOOPS OUTER | | 1 | 294 | 113 (1)| 00:00:01 | | | | | |
|* 22 | HASH JOIN | | 1 | 289 | 112 (1)| 00:00:01 | | | | | |
| 23 | NESTED LOOPS | | 1 | 243 | 109 (1)| 00:00:01 | | | | | |
|* 24 | HASH JOIN | | 1 | 239 | 108 (1)| 00:00:01 | | | | | |
|* 25 | HASH JOIN | | 1 | 231 | 107 (1)| 00:00:01 | | | | | |
| 26 | VIEW | USER_CONSTRAINTS | 2 | 412 | 105 (1)| 00:00:01 | | | | | |
| 27 | UNION-ALL | | | | | | | | | | |
| 28 | PARTITION LIST ALL | | 1 | 285 | 1 (100)| 00:00:01 | 1 | 2 | | | |
|* 29 | FIXED TABLE FULL | X$COMVW$ | 1 | 285 | 1 (100)| 00:00:01 | | | | | |
|* 30 | FILTER | | | | | | | | | | |
|* 31 | HASH JOIN | | 1 | 318 | 105 (1)| 00:00:01 | | | | | |
|* 32 | HASH JOIN OUTER | | 1 | 294 | 104 (1)| 00:00:01 | | | | | |
|* 33 | HASH JOIN OUTER | | 1 | 290 | 103 (1)| 00:00:01 | | | | | |
|* 34 | HASH JOIN OUTER | | 1 | 274 | 102 (1)| 00:00:01 | | | | | |
| 35 | NESTED LOOPS OUTER | | 1 | 266 | 101 (1)| 00:00:01 | | | | | |
| 36 | NESTED LOOPS OUTER | | 1 | 241 | 100 (1)| 00:00:01 | | | | | |
| 37 | NESTED LOOPS | | 1 | 236 | 99 (2)| 00:00:01 | | | | | |
|* 38 | HASH JOIN | | 1 | 190 | 97 (2)| 00:00:01 | | | | | |
|* 39 | HASH JOIN | | 2 | 92 | 95 (2)| 00:00:01 | | | | | |
|* 40 | TABLE ACCESS FULL | CDEF$ | 2 | 42 | 93 (2)| 00:00:01 | | | | | |
| 41 | TABLE ACCESS FULL | CON$ | 1 | 25 | 1 (0)| 00:00:01 | | | | | |
|* 42 | TABLE ACCESS FULL | USER$ | 1 | 144 | 1 (0)| 00:00:01 | | | | | |
|* 43 | WID BATCHED TABLE ACCESS BY INDEX RO | OBJ$ | 1 | 46 | 2 (0)| 00:00:01 | | | | | |
|* 44 | INDEX RANGE SCAN | I_OBJ1 | 1 | | 1 (0)| 00:00:01 | | | | | |
| 45 | VIEW PUSHED PREDICATE | _CURRENT_EDITION_OBJ | 1 | 5 | 1 (0)| 00:00:01 | | | | | |
|* 46 | FILTER | | | | | | | | | | |
| 47 | NESTED LOOPS | | 1 | 45 | 4 (0)| 00:00:01 | | | | | |
| 48 | ROWID BATCHED TABLE ACCESS BY INDEX | OBJ$ | 1 | 21 | 3 (0)| 00:00:01 | | | | | |
|* 49 | INDEX RANGE SCAN | I_OBJ1 | 1 | | 2 (0)| 00:00:01 | | | | | |
|* 50 | INDEX RANGE SCAN | I_USER2 | 1 | 24 | 1 (0)| 00:00:01 | | | | | |
|* 51 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 6 | 2 (0)| 00:00:01 | | | | | |
| 52 | NESTED LOOPS | | 1 | 29 | 3 (0)| 00:00:01 | | | | | |
|* 53 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | | | | |
|* 54 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | 2 (0)| 00:00:01 | | | | | |
|* 55 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 6 | 2 (0)| 00:00:01 | | | | | |
| 56 | D TABLE ACCESS BY INDEX ROWI | CON$ | 1 | 25 | 1 (0)| 00:00:01 | | | | | |
|* 57 | INDEX UNIQUE SCAN | I_CON2 | 1 | | 0 (0)| | | | | | |
| 58 | INDEX FAST FULL SCAN | I_OBJ1 | 1 | 8 | 1 (0)| 00:00:01 | | | | | |
| 59 | INDEX FULL SCAN | I_USER2 | 1 | 16 | 1 (0)| 00:00:01 | | | | | |
| 60 | INDEX FULL SCAN | I_USER2 | 1 | 4 | 1 (0)| 00:00:01 | | | | | |
| 61 | INDEX FULL SCAN | I_USER2 | 1 | 24 | 1 (0)| 00:00:01 | | | | | |
|* 62 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 6 | 2 (0)| 00:00:01 | | | | | |
| 63 | NESTED LOOPS | | 1 | 29 | 3 (0)| 00:00:01 | | | | | |
|* 64 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | | | | |
|* 65 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | 2 (0)| 00:00:01 | | | | | |
|* 66 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 6 | 2 (0)| 00:00:01 | | | | | |
|* 67 | TABLE ACCESS FULL | CON$ | 1 | 25 | 1 (0)| 00:00:01 | | | | | |
|* 68 | TABLE ACCESS FULL | CDEF$ | 1 | 8 | 1 (0)| 00:00:01 | | | | | |
|* 69 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | 1 (0)| 00:00:01 | | | | | |
|* 70 | TABLE ACCESS FULL | OBJ$ | 1 | 46 | 3 (0)| 00:00:01 | | | | | |
| 71 | TABLE ACCESS CLUSTER | TAB$ | 1 | 5 | 1 (0)| 00:00:01 | | | | | |
|* 72 | INDEX UNIQUE SCAN | I_OBJ# | 1 | | 0 (0)| | | | | | |
| 73 | INDEX FULL SCAN | I_USER2 | 1 | 24 | 1 (0)| 00:00:01 | | | | | |
|* 74 | TABLE ACCESS CLUSTER | COL$ | 1 | 56 | 1 (0)| 00:00:01 | | | | | |
|* 75 | INDEX UNIQUE SCAN | I_OBJ# | 1 | | 0 (0)| | | | | | |
| 76 | TABLE ACCESS BY INDEX ROWID BATCHED | COLTYPE$ | 1 | 28 | 1 (0)| 00:00:01 | | | | | |
| 77 | INDEX FULL SCAN | I_COLTYPE2 | 2674 | | 9 (0)| 00:00:01 | | | | | |
| 78 | INDEX FAST FULL SCAN | I_HH_OBJ#_INTCOL# | 1 | 10 | 2 (0)| 00:00:01 | | | | | |
|* 79 | TABLE ACCESS FULL | OBJ$ | 1 | 9 | 5 (0)| 00:00:01 | | | | | |
| 80 | INDEX FULL SCAN | I_USER2 | 1 | 16 | 1 (0)| 00:00:01 | | | | | |
| 81 | TABLE ACCESS FULL | CCOL$ | 1 | 14 | 2 (0)| 00:00:01 | | | | | |
| 82 | TABLE ACCESS BY INDEX ROWID | COL$ | 1 | 22 | 1 (0)| 00:00:01 | | | | | |
|* 83 | INDEX UNIQUE SCAN | I_COL3 | 1 | | 0 (0)| | | | | | |
|* 84 | TABLE ACCESS CLUSTER | ATTRCOL$ | 1 | 48 | 1 (0)| 00:00:01 | | | | | |
| 85 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 1 | 21 | 2 (0)| 00:00:01 | | | | | |
|* 86 | INDEX RANGE SCAN | I_OBJ1 | 1 | | 1 (0)| 00:00:01 | | | | | |
| 87 | INDEX FULL SCAN | I_USER2 | 1 | 24 | 1 (0)| 00:00:01 | | | | | |
| 88 | PX RECEIVE | | 2 | 132 | 60 (4)| 00:00:01 | | | Q1,03 | PCWP | |
| 89 | PX SEND HYBRID HASH | :TQ10002 | 2 | 132 | 60 (4)| 00:00:01 | | | Q1,02 | P->P | HYBRID HASH|
| 90 | VIEW | VW_NSO_1 | 2 | 132 | 60 (4)| 00:00:01 | | | Q1,02 | PCWP | |
| 91 | HASH UNIQUE | | 2 | 268 | 60 (4)| 00:00:01 | | | Q1,02 | PCWP | |
| 92 | PX RECEIVE | | 2 | 268 | 60 (4)| 00:00:01 | | | Q1,02 | PCWP | |
| 93 | PX SEND HASH | :TQ10001 | 2 | 268 | 60 (4)| 00:00:01 | | | Q1,01 | P->P | HASH |
| 94 | HASH UNIQUE | | 2 | 268 | 60 (4)| 00:00:01 | | | Q1,01 | PCWP | |
| 95 | VIEW | USER_CONSTRAINTS | 2 | 268 | 59 (2)| 00:00:01 | | | Q1,01 | PCWP | |
| 96 | UNION-ALL | | | | | | | | Q1,01 | PCWP | |
| 97 | PX PARTITION LIST ALL | | 1 | 213 | 1 (100)| 00:00:01 | 1 | 2 | Q1,01 | PCWC | |
|* 98 | FIXED TABLE FULL | X$COMVW$ | 1 | 213 | 1 (100)| 00:00:01 | | | Q1,01 | PCWP | |
| 99 | PX SELECTOR | | | | | | | | Q1,01 | PCWP | |
|*100 | FILTER | | | | | | | | Q1,01 | PCWP | |
| 101 | NESTED LOOPS | | 1 | 302 | 58 (0)| 00:00:01 | | | Q1,01 | PCWP | |
| 102 | NESTED LOOPS OUTER | | 1 | 278 | 57 (0)| 00:00:01 | | | Q1,01 | PCWP | |
| 103 | NESTED LOOPS OUTER | | 1 | 274 | 56 (0)| 00:00:01 | | | Q1,01 | PCWP | |
| 104 | NESTED LOOPS OUTER | | 1 | 266 | 55 (0)| 00:00:01 | | | Q1,01 | PCWP | |
| 105 | NESTED LOOPS | | 1 | 261 | 54 (0)| 00:00:01 | | | Q1,01 | PCWP | |
| 106 | NESTED LOOPS OUTER | | 1 | 117 | 53 (0)| 00:00:01 | | | Q1,01 | PCWP | |
| 107 | NESTED LOOPS | | 1 | 101 | 52 (0)| 00:00:01 | | | Q1,01 | PCWP | |
| 108 | NESTED LOOPS OUTER | | 1 | 76 | 51 (0)| 00:00:01 | | | Q1,01 | PCWP | |
| 109 | NESTED LOOPS | | 1 | 67 | 50 (0)| 00:00:01 | | | Q1,01 | PCWP | |
| 110 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 1 | 46 | 49 (0)| 00:00:01 | | | Q1,01 | PCWP | |
|*111 | INDEX SKIP SCAN | I_OBJ5 | 1 | | 48 (0)| 00:00:01 | | | Q1,01 | PCWP | |
|*112 | TABLE ACCESS CLUSTER | CDEF$ | 1 | 21 | 1 (0)| 00:00:01 | | | Q1,01 | PCWP | |
|*113 | INDEX UNIQUE SCAN | I_COBJ# | 1 | | 0 (0)| | | | Q1,01 | PCWP | |
| 114 | TABLE ACCESS BY INDEX ROWID | CON$ | 1 | 9 | 1 (0)| 00:00:01 | | | Q1,01 | PCWP | |
|*115 | INDEX UNIQUE SCAN | I_CON2 | 1 | | 0 (0)| | | | Q1,01 | PCWP | |
| 116 | TABLE ACCESS BY INDEX ROWID | CON$ | 1 | 25 | 1 (0)| 00:00:01 | | | Q1,01 | PCWP | |
|*117 | INDEX UNIQUE SCAN | I_CON2 | 1 | | 0 (0)| | | | Q1,01 | PCWP | |
|*118 | INDEX RANGE SCAN | I_USER2 | 1 | 16 | 1 (0)| 00:00:01 | | | Q1,01 | PCWP | |
|*119 | TABLE ACCESS CLUSTER | USER$ | 1 | 144 | 1 (0)| 00:00:01 | | | Q1,01 | PCWP | |
|*120 | INDEX UNIQUE SCAN | I_USER# | 1 | | 0 (0)| | | | Q1,01 | PCWP | |
| 121 | VIEW PUSHED PREDICATE | _CURRENT_EDITION_OBJ | 1 | 5 | 1 (0)| 00:00:01 | | | Q1,01 | PCWP | |
|*122 | FILTER | | | | | | | | Q1,01 | PCWP | |
| 123 | NESTED LOOPS | | 1 | 45 | 4 (0)| 00:00:01 | | | Q1,01 | PCWP | |
| 124 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 1 | 21 | 3 (0)| 00:00:01 | | | Q1,01 | PCWP | |
|*125 | INDEX RANGE SCAN | I_OBJ1 | 1 | | 2 (0)| 00:00:01 | | | Q1,01 | PCWP | |
|*126 | INDEX RANGE SCAN | I_USER2 | 1 | 24 | 1 (0)| 00:00:01 | | | Q1,01 | PCWP | |
|*127 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 6 | 2 (0)| 00:00:01 | | | | | |
| 128 | NESTED LOOPS | | 1 | 29 | 3 (0)| 00:00:01 | | | | | |
|*129 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | | | | |
|*130 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | 2 (0)| 00:00:01 | | | | | |
|*131 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 6 | 2 (0)| 00:00:01 | | | | | |
|*132 | INDEX RANGE SCAN | I_OBJ1 | 1 | 8 | 1 (0)| 00:00:01 | | | Q1,01 | PCWP | |
|*133 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | 1 (0)| 00:00:01 | | | Q1,01 | PCWP | |
|*134 | INDEX RANGE SCAN | I_USER2 | 1 | 24 | 1 (0)| 00:00:01 | | | Q1,01 | PCWP | |
|*135 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 6 | 2 (0)| 00:00:01 | | | | | |
| 136 | NESTED LOOPS | | 1 | 29 | 3 (0)| 00:00:01 | | | | | |
|*137 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | | | | |
|*138 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | 2 (0)| 00:00:01 | | | | | |
|*139 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 6 | 2 (0)| 00:00:01 | | | | | |
|*140 | TABLE ACCESS CLUSTER | TAB$ | 1 | 13 | 2 (0)| 00:00:01 | | | | | |
|*141 | INDEX UNIQUE SCAN | I_OBJ# | 1 | | 1 (0)| 00:00:01 | | | | | |
|*142 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 6 | 2 (0)| 00:00:01 | | | | | |
| 143 | NESTED LOOPS | | 1 | 29 | 3 (0)| 00:00:01 | | | | | |
|*144 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | | | | |
|*145 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | 2 (0)| 00:00:01 | | | | | |
|*146 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 6 | 2 (0)| 00:00:01 | | | | | |
|*147 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 6 | 2 (0)| 00:00:01 | | | | | |
| 148 | NESTED LOOPS | | 1 | 29 | 3 (0)| 00:00:01 | | | | | |
|*149 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | | | | |
|*150 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | 2 (0)| 00:00:01 | | | | | |
|*151 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 6 | 2 (0)| 00:00:01 | | | | | |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter((("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))))
4 - access("UC"."R_CONSTRAINT_NAME"="CONSTRAINT_NAME")
9 - access("O"."OWNER#"="U"."USER#")
11 - filter("C"."NAME"=DECODE("AC"."NAME",NULL,"COL"."NAME","AC"."NAME"))
14 - access("CD"."CON#"="CC"."CON#")
15 - access("OT"."OWNER#"="USER#")
16 - access("AC"."TOID"="OT"."OID$")
17 - access("C"."OBJ#"="H"."OBJ#" AND "C"."INTCOL#"="H"."INTCOL#")
18 - access("C"."OBJ#"="AC"."OBJ#" AND "C"."INTCOL#"="AC"."INTCOL#")
20 - access("O"."OWNER#"="U"."USER#")
22 - access("UC"."TABLE_NAME"="O"."NAME")
24 - access("C"."CON#"="CD"."CON#")
25 - access("UC"."CONSTRAINT_NAME"="C"."NAME")
29 - filter(("INT$INT$DBA_CONSTRAINTS"."OBJECT_TYPE#"=4 AND "CONSTRAINT_TYPE"='R' AND "STATUS"='ENABLED' AND "TABLE_NAME"<>:B1 AND
"INT$INT$DBA_CONSTRAINTS"."OWNER"=SYS_CONTEXT('USERENV','CURRENT_USER')))
30 - 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)))
31 - access("O"."OWNER#"="U"."USER#")
32 - access("OI"."OWNER#"="UI"."USER#")
33 - access("RC"."OWNER#"="USER#")
34 - access("C"."ENABLED"="OI"."OBJ#")
38 - access("OC"."OWNER#"="USER#")
39 - access("OC"."CON#"="C"."CON#")
40 - 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','?')='R' AND
DECODE("C"."TYPE#",5,'ENABLED',DECODE(TO_CHAR("C"."ENABLED"),NULL,'DISABLED','ENABLED'))='ENABLED' AND ("C"."TYPE#"<14 OR "C"."TYPE#">17) AND "C"."TYPE#"<>12 AND
"C"."TYPE#"<>8))
42 - filter(DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME")=SYS_CONTEXT('USERENV','CURRENT_USER'))
43 - filter("O"."NAME"<>:B1)
44 - access("C"."OBJ#"="O"."OBJ#" AND "O"."TYPE#"=2)
filter("O"."TYPE#"=2)
46 - 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)))
49 - access("O"."OBJ#"="C"."ROBJ#")
50 - access("O"."OWNER#"="U"."USER#")
51 - filter(("TYPE#"=:B1 AND "UE"."USER#"=:B2))
53 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
filter(("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))
54 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
55 - filter(("UE"."TYPE#"=:B1 AND "UE"."USER#"=:B2))
57 - access("C"."RCON#"="RC"."CON#")
62 - filter(("TYPE#"=:B1 AND "UE"."USER#"=:B2))
64 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
filter(("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))
65 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
66 - filter(("UE"."TYPE#"=:B1 AND "UE"."USER#"=:B2))
67 - filter("C"."OWNER#"=USERENV('SCHEMAID'))
68 - filter((("CD"."TYPE#"<14 OR "CD"."TYPE#">17) AND "CD"."TYPE#"<>12))
69 - access("U"."USER#"=USERENV('SCHEMAID'))
70 - filter(("O"."SPARE3"=USERENV('SCHEMAID') AND BITAND("O"."FLAGS",128)=0 AND "O"."NAME"<>:B1))
72 - access("O"."OBJ#"="T"."OBJ#")
74 - filter(DECODE(BITAND("C"."PROPERTY",17179869184),17179869184,'YES',DECODE(BITAND("C"."PROPERTY",32),32,'NO','YES'))='YES')
75 - access("O"."OBJ#"="C"."OBJ#")
79 - filter("OT"."TYPE#"=13)
83 - access("CC"."OBJ#"="COL"."OBJ#" AND "CC"."INTCOL#"="COL"."INTCOL#")
84 - filter(("COL"."OBJ#"="AC"."OBJ#" AND "COL"."INTCOL#"="AC"."INTCOL#"))
86 - access("CC"."OBJ#"="O"."OBJ#")
98 - filter(("INT$INT$DBA_CONSTRAINTS"."OBJECT_TYPE#"=4 AND INTERNAL_FUNCTION("CONSTRAINT_TYPE") AND "TABLE_NAME"=:B1 AND
"INT$INT$DBA_CONSTRAINTS"."OWNER"=SYS_CONTEXT('USERENV','CURRENT_USER')))
100 - 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)))
111 - access("O"."NAME"=:B1 AND "O"."TYPE#"=2)
filter(("O"."NAME"=:B1 AND "O"."TYPE#"=2))
112 - 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','?')='P' OR
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','?')='U') AND ("C"."TYPE#"<14 OR "C"."TYPE#">17) AND "C"."TYPE#"<>12 AND
"C"."TYPE#"<>8))
113 - access("C"."OBJ#"="O"."OBJ#")
115 - access("C"."RCON#"="RC"."CON#")
117 - access("OC"."CON#"="C"."CON#")
118 - access("RC"."OWNER#"="USER#")
119 - filter(DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME")=SYS_CONTEXT('USERENV','CURRENT_USER'))
120 - access("OC"."OWNER#"="USER#")
122 - 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)))
125 - access("O"."OBJ#"="C"."ROBJ#")
126 - access("O"."OWNER#"="U"."USER#")
127 - filter(("TYPE#"=:B1 AND "UE"."USER#"=:B2))
129 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
filter(("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))
130 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
131 - filter(("UE"."TYPE#"=:B1 AND "UE"."USER#"=:B2))
132 - access("C"."ENABLED"="OI"."OBJ#")
133 - access("OI"."OWNER#"="UI"."USER#")
134 - access("O"."OWNER#"="U"."USER#")
135 - filter(("TYPE#"=:B1 AND "UE"."USER#"=:B2))
137 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
filter(("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))
138 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
139 - filter(("UE"."TYPE#"=:B1 AND "UE"."USER#"=:B2))
140 - filter((BITAND("T"."PROPERTY",8192)=8192 OR BITAND("T"."PROPERTY",512)=512))
141 - access("T"."OBJ#"=:B1)
142 - filter(("TYPE#"=:B1 AND "UE"."USER#"=:B2))
144 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
filter(("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))
145 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
146 - filter(("UE"."TYPE#"=:B1 AND "UE"."USER#"=:B2))
147 - filter(("TYPE#"=:B1 AND "UE"."USER#"=:B2))
149 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
filter(("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))
150 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
151 - filter(("UE"."TYPE#"=:B1 AND "UE"."USER#"=:B2))
Note
-----
- this is an adaptive plan
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment