SQL_ID f5dcdg4pyfxwy, child number 0 ------------------------------------- WITH ref_cons AS (Select c.owner, c.constraint_name, c.table_name, c.r_owner, c.r_constraint_name, cc.position, cc.column_name FROM sys.DBA_CONSTRAINTS c, sys.DBA_CONS_COLUMNS cc WHERE c.constraint_type = 'R' AND c.owner = cc.owner AND sys_context('USERENV', 'CURRENT_SCHEMA') in (c.r_owner, c.owner) AND c.constraint_name = cc.constraint_name), pk_cons AS (Select c.owner, c.constraint_name, c.table_name, cc.position, cc.column_name FROM sys.DBA_CONSTRAINTS c, sys.DBA_CONS_COLUMNS cc WHERE c.constraint_type IN ('P', 'U') AND c.owner = cc.owner AND c.owner = sys_context('USERENV', 'CURRENT_SCHEMA') AND c.constraint_name = cc.constraint_name) SELECT 'REF_I Plan hash value: 1416335830 ------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | 1789 (100)| | | 1 | SORT ORDER BY | | 1 | 1088 | 1789 (2)| 00:00:10 | |* 2 | FILTER | | | | | | | 3 | NESTED LOOPS OUTER | | 1 | 1088 | 1788 (2)| 00:00:10 | | 4 | NESTED LOOPS OUTER | | 1 | 1086 | 1784 (2)| 00:00:10 | | 5 | NESTED LOOPS | | 1 | 1084 | 1780 (2)| 00:00:10 | | 6 | NESTED LOOPS | | 1 | 1062 | 1779 (2)| 00:00:10 | | 7 | NESTED LOOPS OUTER | | 1 | 1048 | 1777 (2)| 00:00:10 | | 8 | NESTED LOOPS | | 1 | 1004 | 1776 (2)| 00:00:10 | | 9 | NESTED LOOPS | | 1 | 978 | 1774 (2)| 00:00:10 | | 10 | NESTED LOOPS | | 1 | 959 | 1771 (2)| 00:00:10 | | 11 | NESTED LOOPS | | 1 | 949 | 1769 (2)| 00:00:10 | | 12 | NESTED LOOPS | | 1 | 919 | 1767 (2)| 00:00:10 | | 13 | NESTED LOOPS | | 1 | 897 | 1766 (2)| 00:00:10 | | 14 | NESTED LOOPS OUTER | | 1 | 861 | 1763 (2)| 00:00:10 | | 15 | NESTED LOOPS OUTER | | 1 | 857 | 1762 (2)| 00:00:10 | | 16 | NESTED LOOPS OUTER | | 1 | 847 | 1760 (2)| 00:00:10 | | 17 | NESTED LOOPS OUTER | | 1 | 843 | 1759 (2)| 00:00:10 | | 18 | NESTED LOOPS | | 1 | 832 | 1757 (2)| 00:00:10 | | 19 | NESTED LOOPS | | 1 | 808 | 1755 (2)| 00:00:10 | | 20 | NESTED LOOPS | | 1 | 786 | 1754 (2)| 00:00:10 | | 21 | NESTED LOOPS OUTER | | 1 | 750 | 1751 (2)| 00:00:10 | | 22 | NESTED LOOPS OUTER | | 1 | 746 | 1750 (2)| 00:00:10 | | 23 | NESTED LOOPS | | 1 | 736 | 1748 (2)| 00:00:10 | | 24 | NESTED LOOPS | | 1 | 714 | 1747 (2)| 00:00:10 | | 25 | NESTED LOOPS OUTER | | 1 | 700 | 1745 (2)| 00:00:10 | | 26 | NESTED LOOPS | | 1 | 656 | 1744 (2)| 00:00:10 | | 27 | NESTED LOOPS | | 1 | 630 | 1742 (2)| 00:00:10 | | 28 | NESTED LOOPS | | 1 | 611 | 1739 (2)| 00:00:09 | | 29 | NESTED LOOPS | | 1 | 601 | 1737 (2)| 00:00:09 | | 30 | NESTED LOOPS | | 1 | 571 | 1735 (2)| 00:00:09 | | 31 | NESTED LOOPS | | 1 | 554 | 1734 (2)| 00:00:09 | | 32 | NESTED LOOPS OUTER | | 1 | 413 | 1733 (2)| 00:00:09 | | 33 | NESTED LOOPS | | 1 | 272 | 1732 (2)| 00:00:09 | |* 34 | HASH JOIN | | 1 | 242 | 1730 (2)| 00:00:09 | |* 35 | HASH JOIN | | 25 | 5450 | 576 (3)| 00:00:03 | | 36 | NESTED LOOPS | | 18 | 3384 | 241 (0)| 00:00:02 | | 37 | NESTED LOOPS | | 1787 | 3384 | 241 (0)| 00:00:02 | | 38 | NESTED LOOPS | | 1 | 158 | 7 (0)| 00:00:01 | | 39 | ROWID TABLE ACCESS BY INDEX | USER$ | 1 | 17 | 2 (0)| 00:00:01 | |* 40 | INDEX UNIQUE SCAN | I_USER1 | 1 | | 1 (0)| 00:00:01 | |* 41 | TABLE ACCESS FULL | USER$ | 1 | 141 | 5 (0)| 00:00:01 | |* 42 | INDEX RANGE SCAN | I_CON1 | 1787 | | 16 (0)| 00:00:01 | | 43 | OWID TABLE ACCESS BY INDEX R | CON$ | 1787 | 53610 | 234 (0)| 00:00:02 | | 44 | TABLE ACCESS FULL | CON$ | 303K| 8901K| 331 (3)| 00:00:02 | |* 45 | TABLE ACCESS FULL | CDEF$ | 519 | 12456 | 1154 (2)| 00:00:06 | | 46 | D TABLE ACCESS BY INDEX ROWI | CON$ | 1 | 30 | 2 (0)| 00:00:01 | |* 47 | INDEX UNIQUE SCAN | I_CON2 | 1 | | 1 (0)| 00:00:01 | | 48 | TABLE ACCESS CLUSTER | USER$ | 1 | 141 | 1 (0)| 00:00:01 | |* 49 | INDEX UNIQUE SCAN | I_USER# | 1 | | 0 (0)| | |* 50 | TABLE ACCESS CLUSTER | USER$ | 1 | 141 | 1 (0)| 00:00:01 | |* 51 | INDEX UNIQUE SCAN | I_USER# | 1 | | 0 (0)| | | 52 | TABLE ACCESS BY INDEX ROWID | USER$ | 1 | 17 | 1 (0)| 00:00:01 | |* 53 | INDEX UNIQUE SCAN | I_USER1 | 1 | | 0 (0)| | | 54 | TABLE ACCESS BY INDEX ROWID | CON$ | 1 | 30 | 2 (0)| 00:00:01 | |* 55 | INDEX UNIQUE SCAN | I_CON1 | 1 | | 1 (0)| 00:00:01 | |* 56 | TABLE ACCESS BY INDEX ROWID | CDEF$ | 1 | 10 | 2 (0)| 00:00:01 | |* 57 | INDEX UNIQUE SCAN | I_CDEF1 | 1 | | 1 (0)| 00:00:01 | |* 58 | TABLE ACCESS BY INDEX ROWID | CCOL$ | 1 | 19 | 3 (0)| 00:00:01 | |* 59 | INDEX RANGE SCAN | I_CCOL1 | 1 | | 2 (0)| 00:00:01 | | 60 | TABLE ACCESS BY INDEX ROWID | COL$ | 1 | 26 | 2 (0)| 00:00:01 | |* 61 | INDEX UNIQUE SCAN | I_COL3 | 1 | | 1 (0)| 00:00:01 | |* 62 | TABLE ACCESS CLUSTER | ATTRCOL$ | 1 | 44 | 1 (0)| 00:00:01 | |* 63 | INDEX RANGE SCAN | I_OBJ1 | 1 | 14 | 2 (0)| 00:00:01 | |* 64 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | 1 (0)| 00:00:01 | |* 65 | INDEX RANGE SCAN | I_OBJ1 | 1 | 10 | 2 (0)| 00:00:01 | |* 66 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | 1 (0)| 00:00:01 | | 67 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 1 | 36 | 3 (0)| 00:00:01 | |* 68 | INDEX RANGE SCAN | I_OBJ1 | 1 | | 2 (0)| 00:00:01 | |* 69 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | 1 (0)| 00:00:01 | |* 70 | TABLE ACCESS BY INDEX ROWID | CDEF$ | 1 | 24 | 2 (0)| 00:00:01 | |* 71 | INDEX UNIQUE SCAN | I_CDEF1 | 1 | | 1 (0)| 00:00:01 | | 72 | TABLE ACCESS BY INDEX ROWID | CON$ | 1 | 11 | 2 (0)| 00:00:01 | |* 73 | INDEX UNIQUE SCAN | I_CON2 | 1 | | 1 (0)| 00:00:01 | |* 74 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | 1 (0)| 00:00:01 | |* 75 | INDEX RANGE SCAN | I_OBJ1 | 1 | 10 | 2 (0)| 00:00:01 | |* 76 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | 1 (0)| 00:00:01 | | 77 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 1 | 36 | 3 (0)| 00:00:01 | |* 78 | INDEX RANGE SCAN | I_OBJ1 | 1 | | 2 (0)| 00:00:01 | |* 79 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | 1 (0)| 00:00:01 | | 80 | TABLE ACCESS BY INDEX ROWID | CON$ | 1 | 30 | 2 (0)| 00:00:01 | |* 81 | INDEX UNIQUE SCAN | I_CON1 | 1 | | 1 (0)| 00:00:01 | |* 82 | TABLE ACCESS BY INDEX ROWID | CDEF$ | 1 | 10 | 2 (0)| 00:00:01 | |* 83 | INDEX UNIQUE SCAN | I_CDEF1 | 1 | | 1 (0)| 00:00:01 | |* 84 | TABLE ACCESS BY INDEX ROWID | CCOL$ | 1 | 19 | 3 (0)| 00:00:01 | |* 85 | INDEX RANGE SCAN | I_CCOL1 | 1 | | 2 (0)| 00:00:01 | | 86 | TABLE ACCESS BY INDEX ROWID | COL$ | 1 | 26 | 2 (0)| 00:00:01 | |* 87 | INDEX UNIQUE SCAN | I_COL3 | 1 | | 1 (0)| 00:00:01 | |* 88 | TABLE ACCESS CLUSTER | ATTRCOL$ | 1 | 44 | 1 (0)| 00:00:01 | |* 89 | INDEX RANGE SCAN | I_OBJ1 | 1 | 14 | 2 (0)| 00:00:01 | |* 90 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | 1 (0)| 00:00:01 | | 91 | VIEW PUSHED PREDICATE | _CURRENT_EDITION_OBJ | 1 | 2 | 4 (0)| 00:00:01 | |* 92 | FILTER | | | | | | | 93 | NESTED LOOPS | | 1 | 36 | 4 (0)| 00:00:01 | |* 94 | INDEX RANGE SCAN | I_OBJ1 | 1 | 14 | 3 (0)| 00:00:01 | |* 95 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | 1 (0)| 00:00:01 | | 96 | NESTED LOOPS | | 1 | 32 | 4 (0)| 00:00:01 | |* 97 | INDEX RANGE SCAN | I_OBJ4 | 1 | 12 | 3 (0)| 00:00:01 | |* 98 | INDEX RANGE SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | 99 | VIEW PUSHED PREDICATE | _CURRENT_EDITION_OBJ | 1 | 2 | 4 (0)| 00:00:01 | |*100 | FILTER | | | | | | | 101 | NESTED LOOPS | | 1 | 36 | 4 (0)| 00:00:01 | |*102 | INDEX RANGE SCAN | I_OBJ1 | 1 | 14 | 3 (0)| 00:00:01 | |*103 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | 1 (0)| 00:00:01 | | 104 | NESTED LOOPS | | 1 | 32 | 4 (0)| 00:00:01 | |*105 | INDEX RANGE SCAN | I_OBJ4 | 1 | 12 | 3 (0)| 00:00:01 | |*106 | INDEX RANGE SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | 107 | NESTED LOOPS | | 1 | 32 | 4 (0)| 00:00:01 | |*108 | INDEX RANGE SCAN | I_OBJ4 | 1 | 12 | 3 (0)| 00:00:01 | |*109 | INDEX RANGE SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | 110 | NESTED LOOPS | | 1 | 32 | 4 (0)| 00:00:01 | |*111 | INDEX RANGE SCAN | I_OBJ4 | 1 | 12 | 3 (0)| 00:00:01 | |*112 | INDEX RANGE SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | 113 | NESTED LOOPS | | 1 | 32 | 4 (0)| 00:00:01 | |*114 | INDEX RANGE SCAN | I_OBJ4 | 1 | 12 | 3 (0)| 00:00:01 | |*115 | INDEX RANGE SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | 116 | NESTED LOOPS | | 1 | 32 | 4 (0)| 00:00:01 | |*117 | INDEX RANGE SCAN | I_OBJ4 | 1 | 12 | 3 (0)| 00:00:01 | |*118 | INDEX RANGE SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | ------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter(((("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88) OR BITAND("U"."SPARE1",16)=0 OR (INTERNAL_FUNCTION("O"."TYPE#") AND ((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 (("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88) OR BITAND("U"."SPARE1",16)=0 OR (INTERNAL_FUNCTION("O"."TYPE#") AND ((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 (("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88) OR BITAND("U"."SPARE1",16)=0 OR (INTERNAL_FUNCTION("O"."TYPE#") AND ((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 (("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88) OR BITAND("U"."SPARE1",16)=0 OR (INTERNAL_FUNCTION("O"."TYPE#") AND ((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))))) 34 - access("C"."RCON#"="RC"."CON#") 35 - access("RC"."NAME"="OC"."NAME") 40 - access("U"."NAME"=SYS_CONTEXT('USERENV','CURRENT_SCHEMA')) 41 - filter((DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME")=SYS_CONTEXT('USERENV','CURRENT_SCHEMA') AND "U"."NAME"=DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME"))) 42 - access("OC"."OWNER#"="USER#") 45 - filter(("C"."RCON#" IS NOT NULL AND 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 "C"."TYPE#"<>12 AND "C"."TYPE#"<>8 AND ("C"."TYPE#"<14 OR "C"."TYPE#">17))) 47 - access("OC"."CON#"="C"."CON#") 49 - access("RC"."OWNER#"="USER#") 50 - filter(((DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME")=DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAM E",0,30),"U"."NAME") OR DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME")=CASE WHEN (ROWID IS NOT NULL) THEN DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME") ELSE NULL END ) AND (CASE WHEN ROWID IS NOT NULL THEN DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME") ELSE NULL END =SYS_CONTEXT('USERENV','CURRENT_SCHEMA') OR DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME")=SYS_CONTEXT('USERENV','CURRENT_SCHEMA')))) 51 - access("OC"."OWNER#"="USER#") 53 - access("U"."NAME"=DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME")) 55 - access("C"."OWNER#"="U"."USER#" AND "OC"."NAME"="C"."NAME") 56 - filter(("CD"."TYPE#"<>12 AND ("CD"."TYPE#"<14 OR "CD"."TYPE#">17))) 57 - access("C"."CON#"="CD"."CON#") 58 - filter("CC"."POS#" IS NOT NULL) 59 - access("CD"."CON#"="CC"."CON#") 61 - access("CC"."OBJ#"="COL"."OBJ#" AND "CC"."INTCOL#"="COL"."INTCOL#") 62 - filter(("COL"."OBJ#"="AC"."OBJ#" AND "COL"."INTCOL#"="AC"."INTCOL#")) 63 - access("CC"."OBJ#"="O"."OBJ#") 64 - access("O"."OWNER#"="U"."USER#") 65 - access("C"."ENABLED"="OI"."OBJ#") 66 - access("OI"."OWNER#"="UI"."USER#") 68 - access("C"."OBJ#"="O"."OBJ#") 69 - access("O"."OWNER#"="U"."USER#") 70 - 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#"<>12 AND "C"."TYPE#"<>8 AND ("C"."TYPE#"<14 OR "C"."TYPE#">17))) 71 - access("OC"."CON#"="C"."CON#") 73 - access("C"."RCON#"="RC"."CON#") 74 - access("RC"."OWNER#"="USER#") 75 - access("C"."ENABLED"="OI"."OBJ#") 76 - access("OI"."OWNER#"="UI"."USER#") 78 - access("C"."OBJ#"="O"."OBJ#") 79 - access("O"."OWNER#"="U"."USER#") 81 - access("C"."OWNER#"="U"."USER#" AND "OC"."NAME"="C"."NAME") 82 - filter(("CD"."TYPE#"<>12 AND ("CD"."TYPE#"<14 OR "CD"."TYPE#">17))) 83 - access("C"."CON#"="CD"."CON#") 84 - filter(("CC"."POS#" IS NOT NULL AND "CC"."POS#"="CC"."POS#")) 85 - access("CD"."CON#"="CC"."CON#") 87 - access("CC"."OBJ#"="COL"."OBJ#" AND "CC"."INTCOL#"="COL"."INTCOL#") 88 - filter(("COL"."OBJ#"="AC"."OBJ#" AND "COL"."INTCOL#"="AC"."INTCOL#")) 89 - access("CC"."OBJ#"="O"."OBJ#") 90 - access("O"."OWNER#"="U"."USER#") 92 - filter((("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88) OR BITAND("U"."SPARE1",16)=0 OR (INTERNAL_FUNCTION("O"."TYPE#") AND ((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)))) 94 - access("O"."OBJ#"="C"."ROBJ#") 95 - access("O"."OWNER#"="U"."USER#") 97 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88) 98 - access("O2"."OWNER#"="U2"."USER#" AND "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) filter("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 100 - filter((("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88) OR BITAND("U"."SPARE1",16)=0 OR (INTERNAL_FUNCTION("O"."TYPE#") AND ((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)))) 102 - access("O"."OBJ#"="C"."ROBJ#") 103 - access("O"."OWNER#"="U"."USER#") 105 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88) 106 - access("O2"."OWNER#"="U2"."USER#" AND "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) filter("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 108 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88) 109 - access("O2"."OWNER#"="U2"."USER#" AND "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) filter("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 111 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88) 112 - access("O2"."OWNER#"="U2"."USER#" AND "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) filter("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 114 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88) 115 - access("O2"."OWNER#"="U2"."USER#" AND "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) filter("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 117 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88) 118 - access("O2"."OWNER#"="U2"."USER#" AND "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) filter("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) SQL_ID f5dcdg4pyfxwy, child number 1 ------------------------------------- WITH ref_cons AS (Select c.owner, c.constraint_name, c.table_name, c.r_owner, c.r_constraint_name, cc.position, cc.column_name FROM sys.DBA_CONSTRAINTS c, sys.DBA_CONS_COLUMNS cc WHERE c.constraint_type = 'R' AND c.owner = cc.owner AND sys_context('USERENV', 'CURRENT_SCHEMA') in (c.r_owner, c.owner) AND c.constraint_name = cc.constraint_name), pk_cons AS (Select c.owner, c.constraint_name, c.table_name, cc.position, cc.column_name FROM sys.DBA_CONSTRAINTS c, sys.DBA_CONS_COLUMNS cc WHERE c.constraint_type IN ('P', 'U') AND c.owner = cc.owner AND c.owner = sys_context('USERENV', 'CURRENT_SCHEMA') AND c.constraint_name = cc.constraint_name) SELECT 'REF_I Plan hash value: 1416335830 ------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | 1802 (100)| | | 1 | SORT ORDER BY | | 1 | 1088 | 1802 (2)| 00:00:10 | |* 2 | FILTER | | | | | | | 3 | NESTED LOOPS OUTER | | 1 | 1088 | 1801 (2)| 00:00:10 | | 4 | NESTED LOOPS OUTER | | 1 | 1086 | 1797 (2)| 00:00:10 | | 5 | NESTED LOOPS | | 1 | 1084 | 1793 (2)| 00:00:10 | | 6 | NESTED LOOPS | | 1 | 1062 | 1792 (2)| 00:00:10 | | 7 | NESTED LOOPS OUTER | | 1 | 1048 | 1790 (2)| 00:00:10 | | 8 | NESTED LOOPS | | 1 | 1004 | 1789 (2)| 00:00:10 | | 9 | NESTED LOOPS | | 1 | 978 | 1787 (2)| 00:00:10 | | 10 | NESTED LOOPS | | 1 | 959 | 1784 (2)| 00:00:10 | | 11 | NESTED LOOPS | | 1 | 949 | 1782 (2)| 00:00:10 | | 12 | NESTED LOOPS | | 1 | 919 | 1780 (2)| 00:00:10 | | 13 | NESTED LOOPS | | 1 | 897 | 1779 (2)| 00:00:10 | | 14 | NESTED LOOPS OUTER | | 1 | 861 | 1776 (2)| 00:00:10 | | 15 | NESTED LOOPS OUTER | | 1 | 857 | 1775 (2)| 00:00:10 | | 16 | NESTED LOOPS OUTER | | 1 | 847 | 1773 (2)| 00:00:10 | | 17 | NESTED LOOPS OUTER | | 1 | 843 | 1772 (2)| 00:00:10 | | 18 | NESTED LOOPS | | 1 | 832 | 1770 (2)| 00:00:10 | | 19 | NESTED LOOPS | | 1 | 808 | 1768 (2)| 00:00:10 | | 20 | NESTED LOOPS | | 1 | 786 | 1767 (2)| 00:00:10 | | 21 | NESTED LOOPS OUTER | | 1 | 750 | 1764 (2)| 00:00:10 | | 22 | NESTED LOOPS OUTER | | 1 | 746 | 1763 (2)| 00:00:10 | | 23 | NESTED LOOPS | | 1 | 736 | 1761 (2)| 00:00:10 | | 24 | NESTED LOOPS | | 1 | 714 | 1760 (2)| 00:00:10 | | 25 | NESTED LOOPS OUTER | | 1 | 700 | 1758 (2)| 00:00:10 | | 26 | NESTED LOOPS | | 1 | 656 | 1757 (2)| 00:00:10 | | 27 | NESTED LOOPS | | 1 | 630 | 1755 (2)| 00:00:10 | | 28 | NESTED LOOPS | | 1 | 611 | 1752 (2)| 00:00:10 | | 29 | NESTED LOOPS | | 1 | 601 | 1750 (2)| 00:00:10 | | 30 | NESTED LOOPS | | 1 | 571 | 1748 (2)| 00:00:10 | | 31 | NESTED LOOPS | | 1 | 554 | 1747 (2)| 00:00:10 | | 32 | NESTED LOOPS OUTER | | 4 | 1652 | 1743 (2)| 00:00:10 | | 33 | NESTED LOOPS | | 4 | 1088 | 1739 (2)| 00:00:09 | |* 34 | HASH JOIN | | 4 | 968 | 1731 (2)| 00:00:09 | |* 35 | HASH JOIN | | 25 | 5450 | 576 (3)| 00:00:03 | | 36 | NESTED LOOPS | | 18 | 3384 | 241 (0)| 00:00:02 | | 37 | NESTED LOOPS | | 1787 | 3384 | 241 (0)| 00:00:02 | | 38 | NESTED LOOPS | | 1 | 158 | 7 (0)| 00:00:01 | | 39 | ROWID TABLE ACCESS BY INDEX | USER$ | 1 | 17 | 2 (0)| 00:00:01 | |* 40 | INDEX UNIQUE SCAN | I_USER1 | 1 | | 1 (0)| 00:00:01 | |* 41 | TABLE ACCESS FULL | USER$ | 1 | 141 | 5 (0)| 00:00:01 | |* 42 | INDEX RANGE SCAN | I_CON1 | 1787 | | 16 (0)| 00:00:01 | | 43 | OWID TABLE ACCESS BY INDEX R | CON$ | 1787 | 53610 | 234 (0)| 00:00:02 | | 44 | TABLE ACCESS FULL | CON$ | 303K| 8901K| 331 (3)| 00:00:02 | |* 45 | TABLE ACCESS FULL | CDEF$ | 51941 | 1217K| 1155 (2)| 00:00:06 | | 46 | D TABLE ACCESS BY INDEX ROWI | CON$ | 1 | 30 | 2 (0)| 00:00:01 | |* 47 | INDEX UNIQUE SCAN | I_CON2 | 1 | | 1 (0)| 00:00:01 | | 48 | TABLE ACCESS CLUSTER | USER$ | 1 | 141 | 1 (0)| 00:00:01 | |* 49 | INDEX UNIQUE SCAN | I_USER# | 1 | | 0 (0)| | |* 50 | TABLE ACCESS CLUSTER | USER$ | 1 | 141 | 1 (0)| 00:00:01 | |* 51 | INDEX UNIQUE SCAN | I_USER# | 1 | | 0 (0)| | | 52 | TABLE ACCESS BY INDEX ROWID | USER$ | 1 | 17 | 1 (0)| 00:00:01 | |* 53 | INDEX UNIQUE SCAN | I_USER1 | 1 | | 0 (0)| | | 54 | TABLE ACCESS BY INDEX ROWID | CON$ | 1 | 30 | 2 (0)| 00:00:01 | |* 55 | INDEX UNIQUE SCAN | I_CON1 | 1 | | 1 (0)| 00:00:01 | |* 56 | TABLE ACCESS BY INDEX ROWID | CDEF$ | 1 | 10 | 2 (0)| 00:00:01 | |* 57 | INDEX UNIQUE SCAN | I_CDEF1 | 1 | | 1 (0)| 00:00:01 | |* 58 | TABLE ACCESS BY INDEX ROWID | CCOL$ | 1 | 19 | 3 (0)| 00:00:01 | |* 59 | INDEX RANGE SCAN | I_CCOL1 | 1 | | 2 (0)| 00:00:01 | | 60 | TABLE ACCESS BY INDEX ROWID | COL$ | 1 | 26 | 2 (0)| 00:00:01 | |* 61 | INDEX UNIQUE SCAN | I_COL3 | 1 | | 1 (0)| 00:00:01 | |* 62 | TABLE ACCESS CLUSTER | ATTRCOL$ | 1 | 44 | 1 (0)| 00:00:01 | |* 63 | INDEX RANGE SCAN | I_OBJ1 | 1 | 14 | 2 (0)| 00:00:01 | |* 64 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | 1 (0)| 00:00:01 | |* 65 | INDEX RANGE SCAN | I_OBJ1 | 1 | 10 | 2 (0)| 00:00:01 | |* 66 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | 1 (0)| 00:00:01 | | 67 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 1 | 36 | 3 (0)| 00:00:01 | |* 68 | INDEX RANGE SCAN | I_OBJ1 | 1 | | 2 (0)| 00:00:01 | |* 69 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | 1 (0)| 00:00:01 | |* 70 | TABLE ACCESS BY INDEX ROWID | CDEF$ | 1 | 24 | 2 (0)| 00:00:01 | |* 71 | INDEX UNIQUE SCAN | I_CDEF1 | 1 | | 1 (0)| 00:00:01 | | 72 | TABLE ACCESS BY INDEX ROWID | CON$ | 1 | 11 | 2 (0)| 00:00:01 | |* 73 | INDEX UNIQUE SCAN | I_CON2 | 1 | | 1 (0)| 00:00:01 | |* 74 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | 1 (0)| 00:00:01 | |* 75 | INDEX RANGE SCAN | I_OBJ1 | 1 | 10 | 2 (0)| 00:00:01 | |* 76 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | 1 (0)| 00:00:01 | | 77 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 1 | 36 | 3 (0)| 00:00:01 | |* 78 | INDEX RANGE SCAN | I_OBJ1 | 1 | | 2 (0)| 00:00:01 | |* 79 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | 1 (0)| 00:00:01 | | 80 | TABLE ACCESS BY INDEX ROWID | CON$ | 1 | 30 | 2 (0)| 00:00:01 | |* 81 | INDEX UNIQUE SCAN | I_CON1 | 1 | | 1 (0)| 00:00:01 | |* 82 | TABLE ACCESS BY INDEX ROWID | CDEF$ | 1 | 10 | 2 (0)| 00:00:01 | |* 83 | INDEX UNIQUE SCAN | I_CDEF1 | 1 | | 1 (0)| 00:00:01 | |* 84 | TABLE ACCESS BY INDEX ROWID | CCOL$ | 1 | 19 | 3 (0)| 00:00:01 | |* 85 | INDEX RANGE SCAN | I_CCOL1 | 1 | | 2 (0)| 00:00:01 | | 86 | TABLE ACCESS BY INDEX ROWID | COL$ | 1 | 26 | 2 (0)| 00:00:01 | |* 87 | INDEX UNIQUE SCAN | I_COL3 | 1 | | 1 (0)| 00:00:01 | |* 88 | TABLE ACCESS CLUSTER | ATTRCOL$ | 1 | 44 | 1 (0)| 00:00:01 | |* 89 | INDEX RANGE SCAN | I_OBJ1 | 1 | 14 | 2 (0)| 00:00:01 | |* 90 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | 1 (0)| 00:00:01 | | 91 | VIEW PUSHED PREDICATE | _CURRENT_EDITION_OBJ | 1 | 2 | 4 (0)| 00:00:01 | |* 92 | FILTER | | | | | | | 93 | NESTED LOOPS | | 1 | 36 | 4 (0)| 00:00:01 | |* 94 | INDEX RANGE SCAN | I_OBJ1 | 1 | 14 | 3 (0)| 00:00:01 | |* 95 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | 1 (0)| 00:00:01 | | 96 | NESTED LOOPS | | 1 | 32 | 4 (0)| 00:00:01 | |* 97 | INDEX RANGE SCAN | I_OBJ4 | 1 | 12 | 3 (0)| 00:00:01 | |* 98 | INDEX RANGE SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | 99 | VIEW PUSHED PREDICATE | _CURRENT_EDITION_OBJ | 1 | 2 | 4 (0)| 00:00:01 | |*100 | FILTER | | | | | | | 101 | NESTED LOOPS | | 1 | 36 | 4 (0)| 00:00:01 | |*102 | INDEX RANGE SCAN | I_OBJ1 | 1 | 14 | 3 (0)| 00:00:01 | |*103 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | 1 (0)| 00:00:01 | | 104 | NESTED LOOPS | | 1 | 32 | 4 (0)| 00:00:01 | |*105 | INDEX RANGE SCAN | I_OBJ4 | 1 | 12 | 3 (0)| 00:00:01 | |*106 | INDEX RANGE SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | 107 | NESTED LOOPS | | 1 | 32 | 4 (0)| 00:00:01 | |*108 | INDEX RANGE SCAN | I_OBJ4 | 1 | 12 | 3 (0)| 00:00:01 | |*109 | INDEX RANGE SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | 110 | NESTED LOOPS | | 1 | 32 | 4 (0)| 00:00:01 | |*111 | INDEX RANGE SCAN | I_OBJ4 | 1 | 12 | 3 (0)| 00:00:01 | |*112 | INDEX RANGE SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | 113 | NESTED LOOPS | | 1 | 32 | 4 (0)| 00:00:01 | |*114 | INDEX RANGE SCAN | I_OBJ4 | 1 | 12 | 3 (0)| 00:00:01 | |*115 | INDEX RANGE SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | | 116 | NESTED LOOPS | | 1 | 32 | 4 (0)| 00:00:01 | |*117 | INDEX RANGE SCAN | I_OBJ4 | 1 | 12 | 3 (0)| 00:00:01 | |*118 | INDEX RANGE SCAN | I_USER2 | 1 | 20 | 1 (0)| 00:00:01 | ------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter(((("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88) OR BITAND("U"."SPARE1",16)=0 OR (INTERNAL_FUNCTION("O"."TYPE#") AND ((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 (("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88) OR BITAND("U"."SPARE1",16)=0 OR (INTERNAL_FUNCTION("O"."TYPE#") AND ((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 (("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88) OR BITAND("U"."SPARE1",16)=0 OR (INTERNAL_FUNCTION("O"."TYPE#") AND ((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 (("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88) OR BITAND("U"."SPARE1",16)=0 OR (INTERNAL_FUNCTION("O"."TYPE#") AND ((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))))) 34 - access("C"."RCON#"="RC"."CON#") 35 - access("RC"."NAME"="OC"."NAME") 40 - access("U"."NAME"=SYS_CONTEXT('USERENV','CURRENT_SCHEMA')) 41 - filter((DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME")=SYS_CONTEXT('USERENV','CURRENT_SCHEMA') AND "U"."NAME"=DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME"))) 42 - access("OC"."OWNER#"="USER#") 45 - filter(("C"."RCON#" IS NOT NULL AND 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 "C"."TYPE#"<>12 AND "C"."TYPE#"<>8 AND ("C"."TYPE#"<14 OR "C"."TYPE#">17))) 47 - access("OC"."CON#"="C"."CON#") 49 - access("RC"."OWNER#"="USER#") 50 - filter(((DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME")=DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAM E",0,30),"U"."NAME") OR DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME")=CASE WHEN (ROWID IS NOT NULL) THEN DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME") ELSE NULL END ) AND (CASE WHEN ROWID IS NOT NULL THEN DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME") ELSE NULL END =SYS_CONTEXT('USERENV','CURRENT_SCHEMA') OR DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME")=SYS_CONTEXT('USERENV','CURRENT_SCHEMA')))) 51 - access("OC"."OWNER#"="USER#") 53 - access("U"."NAME"=DECODE("U"."TYPE#",2,SUBSTR("U"."EXT_USERNAME",0,30),"U"."NAME")) 55 - access("C"."OWNER#"="U"."USER#" AND "OC"."NAME"="C"."NAME") 56 - filter(("CD"."TYPE#"<>12 AND ("CD"."TYPE#"<14 OR "CD"."TYPE#">17))) 57 - access("C"."CON#"="CD"."CON#") 58 - filter("CC"."POS#" IS NOT NULL) 59 - access("CD"."CON#"="CC"."CON#") 61 - access("CC"."OBJ#"="COL"."OBJ#" AND "CC"."INTCOL#"="COL"."INTCOL#") 62 - filter(("COL"."OBJ#"="AC"."OBJ#" AND "COL"."INTCOL#"="AC"."INTCOL#")) 63 - access("CC"."OBJ#"="O"."OBJ#") 64 - access("O"."OWNER#"="U"."USER#") 65 - access("C"."ENABLED"="OI"."OBJ#") 66 - access("OI"."OWNER#"="UI"."USER#") 68 - access("C"."OBJ#"="O"."OBJ#") 69 - access("O"."OWNER#"="U"."USER#") 70 - 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#"<>12 AND "C"."TYPE#"<>8 AND ("C"."TYPE#"<14 OR "C"."TYPE#">17))) 71 - access("OC"."CON#"="C"."CON#") 73 - access("C"."RCON#"="RC"."CON#") 74 - access("RC"."OWNER#"="USER#") 75 - access("C"."ENABLED"="OI"."OBJ#") 76 - access("OI"."OWNER#"="UI"."USER#") 78 - access("C"."OBJ#"="O"."OBJ#") 79 - access("O"."OWNER#"="U"."USER#") 81 - access("C"."OWNER#"="U"."USER#" AND "OC"."NAME"="C"."NAME") 82 - filter(("CD"."TYPE#"<>12 AND ("CD"."TYPE#"<14 OR "CD"."TYPE#">17))) 83 - access("C"."CON#"="CD"."CON#") 84 - filter(("CC"."POS#" IS NOT NULL AND "CC"."POS#"="CC"."POS#")) 85 - access("CD"."CON#"="CC"."CON#") 87 - access("CC"."OBJ#"="COL"."OBJ#" AND "CC"."INTCOL#"="COL"."INTCOL#") 88 - filter(("COL"."OBJ#"="AC"."OBJ#" AND "COL"."INTCOL#"="AC"."INTCOL#")) 89 - access("CC"."OBJ#"="O"."OBJ#") 90 - access("O"."OWNER#"="U"."USER#") 92 - filter((("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88) OR BITAND("U"."SPARE1",16)=0 OR (INTERNAL_FUNCTION("O"."TYPE#") AND ((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)))) 94 - access("O"."OBJ#"="C"."ROBJ#") 95 - access("O"."OWNER#"="U"."USER#") 97 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88) 98 - access("O2"."OWNER#"="U2"."USER#" AND "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) filter("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 100 - filter((("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88) OR BITAND("U"."SPARE1",16)=0 OR (INTERNAL_FUNCTION("O"."TYPE#") AND ((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)))) 102 - access("O"."OBJ#"="C"."ROBJ#") 103 - access("O"."OWNER#"="U"."USER#") 105 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88) 106 - access("O2"."OWNER#"="U2"."USER#" AND "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) filter("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 108 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88) 109 - access("O2"."OWNER#"="U2"."USER#" AND "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) filter("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 111 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88) 112 - access("O2"."OWNER#"="U2"."USER#" AND "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) filter("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 114 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88) 115 - access("O2"."OWNER#"="U2"."USER#" AND "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) filter("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 117 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88) 118 - access("O2"."OWNER#"="U2"."USER#" AND "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) filter("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) Note ----- - cardinality feedback used for this statement