Skip to content

Instantly share code, notes, and snippets.

@Satalabaha

Satalabaha/gist:7a9ecabe423603844e249d1cdf6f2ff7

Created November 20, 2024 12:41
Download ZIP
Oracle12c_DictQuery_Stats
Raw
gistfile1.txt
SQL> SELECT
/*+
BEGIN_OUTLINE_DATA
MONITOR
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('12.1.0.2')
DB_VERSION('12.1.0.2')
OPT_PARAM('_px_adaptive_dist_method' 'off')
OPT_PARAM('_optimizer_strans_adaptive_pruning' 'false')
OPT_PARAM('_optimizer_nlj_hj_adaptive_join' 'false')
ALL_ROWS
OUTLINE_LEAF(@"SEL$6C051BA4")
UNNEST(@"SEL$1CF66C63")
OUTLINE_LEAF(@"SEL$4B882374")
MERGE(@"SEL$E8FDA8C1")
OUTLINE_LEAF(@"SEL$5")
OUTLINE_LEAF(@"SEL$6")
OUTLINE_LEAF(@"SEL$7")
OUTLINE_LEAF(@"SEL$9")
OUTLINE_LEAF(@"SEL$10")
OUTLINE_LEAF(@"SEL$11")
OUTLINE_LEAF(@"SEL$FE7E982E")
PUSH_PRED(@"SEL$07BDC5B4" "SO"@"SEL$3" 8)
OUTLINE_LEAF(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE_LEAF(@"SEL$1C8BC144")
UNNEST(@"SEL$F7A62D4D")
OUTLINE_LEAF(@"SEL$5BC85507")
MERGE(@"SEL$AD150BAD")
OUTLINE_LEAF(@"SEL$21")
OUTLINE_LEAF(@"SEL$22")
OUTLINE_LEAF(@"SEL$23")
OUTLINE_LEAF(@"SEL$25")
OUTLINE_LEAF(@"SEL$26")
OUTLINE_LEAF(@"SEL$27")
OUTLINE_LEAF(@"SEL$810C4A74")
PUSH_PRED(@"SEL$3B673E5C" "SO"@"SEL$19" 7)
OUTLINE_LEAF(@"SEL$3B673E5C")
MERGE(@"SEL$20")
OUTLINE_LEAF(@"SET$1")
OUTLINE_LEAF(@"SEL$2")
OUTLINE_LEAF(@"SEL$70B1039E")
MERGE(@"SEL$BB23D85A")
OUTLINE_LEAF(@"SEL$FCF381C3")
UNNEST(@"SEL$E7748E76")
OUTLINE_LEAF(@"SEL$96D14815")
MERGE(@"SEL$27E47649")
OUTLINE_LEAF(@"SEL$9DF0D31B")
UNNEST(@"SEL$03AE7C5B")
OUTLINE_LEAF(@"SEL$38")
OUTLINE_LEAF(@"SEL$39")
OUTLINE_LEAF(@"SEL$40")
OUTLINE_LEAF(@"SEL$51")
OUTLINE_LEAF(@"SEL$52")
OUTLINE_LEAF(@"SEL$53")
OUTLINE_LEAF(@"SEL$55")
OUTLINE_LEAF(@"SEL$56")
OUTLINE_LEAF(@"SEL$57")
OUTLINE_LEAF(@"SEL$BF0909A7")
PUSH_PRED(@"SEL$F1FA71CC" "O2"@"SEL$49" 5)
OUTLINE_LEAF(@"SEL$674ECF7B")
OUTLINE_LEAF(@"SEL$60")
OUTLINE_LEAF(@"SEL$61")
OUTLINE_LEAF(@"SEL$62")
OUTLINE_LEAF(@"SEL$F7F46460")
OUTLINE_LEAF(@"SET$BE4AEC69")
PUSH_PRED(@"SEL$EE64F57D" "INT$DBA_PROCEDURES"@"SEL$48" 5 4)
OUTLINE_LEAF(@"SEL$EE64F57D")
MERGE(@"SEL$48")
MERGE(@"SEL$4E97CFE8")
OUTLINE(@"SEL$12")
OUTLINE(@"SEL$1CF66C63")
MERGE(@"SEL$14")
OUTLINE(@"SEL$15")
OUTLINE(@"SEL$E8FDA8C1")
MERGE(@"SEL$DC4B4145")
OUTLINE(@"SEL$8")
OUTLINE(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
OUTLINE(@"SEL$28")
OUTLINE(@"SEL$F7A62D4D")
MERGE(@"SEL$30")
OUTLINE(@"SEL$31")
OUTLINE(@"SEL$AD150BAD")
MERGE(@"SEL$8C085B80")
OUTLINE(@"SEL$24")
OUTLINE(@"SEL$3B673E5C")
MERGE(@"SEL$20")
OUTLINE(@"SEL$19")
OUTLINE(@"SEL$20")
OUTLINE(@"SEL$63")
OUTLINE(@"SEL$BB23D85A")
MERGE(@"SEL$7337C6A8")
OUTLINE(@"SEL$67")
OUTLINE(@"SEL$E7748E76")
MERGE(@"SEL$69")
OUTLINE(@"SEL$41")
OUTLINE(@"SEL$27E47649")
MERGE(@"SEL$1822E6ED")
OUTLINE(@"SEL$45")
OUTLINE(@"SEL$03AE7C5B")
MERGE(@"SEL$47")
OUTLINE(@"SEL$54")
OUTLINE(@"SEL$F1FA71CC")
MERGE(@"SEL$50")
OUTLINE(@"SEL$260377DE")
MERGE(@"SEL$59")
OUTLINE(@"SET$2")
OUTLINE(@"SEL$EE64F57D")
MERGE(@"SEL$48")
MERGE(@"SEL$4E97CFE8")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$48")
OUTLINE(@"SEL$4E97CFE8")
MERGE(@"SEL$FF4A7D68")
OUTLINE(@"SEL$13")
OUTLINE(@"SEL$14")
OUTLINE(@"SEL$16")
OUTLINE(@"SEL$DC4B4145")
MERGE(@"SEL$18")
OUTLINE(@"SEL$29")
OUTLINE(@"SEL$30")
OUTLINE(@"SEL$32")
OUTLINE(@"SEL$8C085B80")
MERGE(@"SEL$34")
OUTLINE(@"SEL$64")
OUTLINE(@"SEL$7337C6A8")
MERGE(@"SEL$66")
OUTLINE(@"SEL$68")
OUTLINE(@"SEL$69")
OUTLINE(@"SEL$42")
OUTLINE(@"SEL$1822E6ED")
MERGE(@"SEL$44")
OUTLINE(@"SEL$46")
OUTLINE(@"SEL$47")
OUTLINE(@"SEL$49")
OUTLINE(@"SEL$5 2 0")
3 OUT 4 LINE(@"SEL$58")
OUT 5 LINE(@"SEL$ 6 59")
OUTLINE(@"SEL$35")
7 OUTLINE(@"SEL$FF4A7D68")
MERGE(@"SEL 8 $37")
OUTLINE(@"SEL$17" 9 )
OUTLINE(@"SEL$18")
OUTLINE(@"SEL$33" 10 )
OUTLINE(@"SEL$34")
OUTLINE(@"SEL$65")
OUTL 11 INE(@"SEL$66")
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 OUTLINE(@"SEL$43")
OUTLINE(@"SEL$44")
OUTLINE(@"SEL$36")
OUTLINE(@"SEL$37")
INDEX_RS_ASC(@"SEL$EE64F57D" "U"@"SEL$36" ("USER$"."NAME"))
BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$EE64F57D" "U"@"SEL$36")
INDEX_RS_ASC(@"SEL$EE64F57D" "O"@"SEL$37" ("OBJ$"."SPARE3" "OBJ$"."NAME" "OBJ$"."NAMESPACE" "OBJ$"."TYPE#"
"OBJ$"."OWNER#" "OBJ$"."REMOTEOWNER" "OBJ$"."LINKNAME" "OBJ$"."SUBNAME" "OBJ$"."OBJ#"))
BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$EE64F57D" "O"@"SEL$37")
INDEX(@"SEL$EE64F57D" "A"@"SEL$36" ("ARGUMENT$"."OBJ#" "ARGUMENT$"."PROCEDURE$" "ARGUMENT$"."OVERLOAD#"
"ARGUMENT$"."SEQUENCE#"))
INDEX_FFS(@"SEL$EE64F57D" "U"@"SEL$37" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2"))
NO_ACCESS(@"SEL$EE64F57D" "INT$DBA_PROCEDURES"@"SEL$48")
LEADING(@"SEL$EE64F57D" "U"@"SEL$36" "O"@"SEL$37" "A"@"SEL$36" "U"@"SEL$37" "INT$DBA_PROCEDURES"@"SEL$48")
USE_NL(@"SEL$EE64F57D" "O"@"SEL$37")
USE_NL(@"SEL$EE64F57D" "A"@"SEL$36")
NLJ_BATCHING(@"SEL$EE64F57D" "A"@"SEL$36")
USE_HASH(@"SEL$EE64F57D" "U"@"SEL$37")
USE_NL(@"SEL$EE64F57D" "INT$DBA_PROCEDURES"@"SEL$48")
SWAP_JOIN_INPUTS(@"SEL$EE64F57D" "U"@"SEL$37")
PQ_FILTER(@"SEL$EE64F57D" SERIAL)
INDEX_RS_ASC(@"SEL$F7F46460" "U"@"SEL$58" ("USER$"."NAME"))
INDEX_RS_ASC(@"SEL$F7F46460" "O"@"SEL$59" ("OBJ$"."OBJ#" "OBJ$"."OWNER#" "OBJ$"."TYPE#"))
BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$F7F46460" "O"@"SEL$59")
INDEX_FFS(@"SEL$F7F46460" "U"@"SEL$59" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2"))
INDEX_RS_ASC(@"SEL$F7F46460" "PI"@"SEL$58" ("PROCEDUREINFO$"."OBJ#" "PROCEDUREINFO$"."PROCEDURENAME"
"PROCEDUREINFO$"."OVERLOAD#"))
BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$F7F46460" "PI"@"SEL$58")
LEADING(@"SEL$F7F46460" "U"@"SEL$58" "O"@"SEL$59" "U"@"SEL$59" "PI"@"SEL$58")
USE_NL(@"SEL$F7F46460" "O"@"SEL$59")
USE_HASH(@"SEL$F7F46460" "U"@"SEL$59")
USE_HASH(@"SEL$F7F46460" "PI"@"SEL$58")
SWAP_JOIN_INPUTS(@"SEL$F7F46460" "U"@"SEL$59")
PQ_FILTER(@"SEL$F7F46460" SERIAL)
INDEX_RS_ASC(@"SEL$674ECF7B" "U"@"SEL$49" ("USER$"."NAME"))
INDEX_RS_ASC(@"SEL$674ECF7B" "PI"@"SEL$49" ("PROCEDUREINFO$"."OBJ#" "PROCEDUREINFO$"."PROCEDURENAME"
"PROCEDUREINFO$"."OVERLOAD#"))
BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$674ECF7B" "PI"@"SEL$49")
INDEX_RS_ASC(@"SEL$674ECF7B" "O"@"SEL$50" ("OBJ$"."OBJ#" "OBJ$"."OWNER#" "OBJ$"."TYPE#"))
BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$674ECF7B" "O"@"SEL$50")
NO_ACCESS(@"SEL$674ECF7B" "O2"@"SEL$49")
INDEX(@"SEL$674ECF7B" "U2"@"SEL$49" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2"))
INDEX(@"SEL$674ECF7B" "U"@"SEL$50" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2"))
LEADING(@"SEL$674ECF7B" "U"@"SEL$49" "PI"@"SEL$49" "O"@"SEL$50" "O2"@"SEL$49" "U2"@"SEL$49" "U"@"SEL$50")
USE_NL(@"SEL$674ECF7B" "PI"@"SEL$49")
USE_HASH(@"SEL$674ECF7B" "O"@"SEL$50")
USE_NL(@"SEL$674ECF7B" "O2"@"SEL$49")
USE_NL(@"SEL$674ECF7B" "U2"@"SEL$49")
USE_NL(@"SEL$674ECF7B" "U"@"SEL$50")
PQ_FILTER(@"SEL$674ECF7B" SERIAL)
INDEX_RS_ASC(@"SEL$BF0909A7" "O"@"SEL$54" ("OBJ$"."OBJ#" "OBJ$"."OWNER#" "OBJ$"."TYPE#"))
BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$BF0909A7" "O"@"SEL$54")
INDEX(@"SEL$BF0909A7" "U"@"SEL$54" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2"))
LEADING(@"SEL$BF0909A7" "O"@"SEL$54" "U"@"SEL$54")
USE_NL(@"SEL$BF0909A7" "U"@"SEL$54")
PQ_FILTER(@"SEL$BF0909A7" SERIAL)
INDEX(@"SEL$57" "O2"@"SEL$57" ("OBJ$"."DATAOBJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#"))
INDEX(@"SEL$57" "U2"@"SEL$57" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2"))
LEADING(@"SEL$57" "O2"@"SEL$57" "U2"@"SEL$57")
USE_NL(@"SEL$57" "U2"@"SEL$57")
PARTIAL_JOIN(@"SEL$57" "U2"@"SEL$57")
FULL(@"SEL$56" "UE"@"SEL$56")
FULL(@"SEL$55" "UE"@"SEL$55")
INDEX(@"SEL$53" "O2"@"SEL$53" ("OBJ$"."DATAOBJ152 153 154 155 156 157 158 159 160 161 162 #" "OBJ$"."TYPE#" "OB163 J$"."OWNER#"))
INDEX(@"SEL$53" "U2"@"SEL$53" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2"))
LEADING(@"SEL$53" "O2"@"SEL$53" "U2"@"SEL$53")
USE_NL(@"SEL$53" "U2"@"SEL$53")
PARTIAL_JOIN(@"SEL$53" "U2"@"SEL$53")
FULL(@"SEL$52" "UE"@"SEL$52")
FULL(@"SEL$51" "UE"@"SEL$51")
INDEX(@"SEL$62" "O2"@"SEL$62" ("OBJ$"."DATAOBJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#"))
INDEX(@"SEL$62" "U2"@"SEL$62" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2"))
LEADING(@"SEL$62" "O2"@"SEL$62" "U2"@"SEL$62")
USE_NL(@"SEL$62" "U2"@"SEL$62")
PARTIAL_JOIN(@"SEL$62" "U2"@"SEL$62")
FULL(@"SEL$61" "UE"@"SEL$61")
FULL(@"SEL$60" "UE"@"SEL$60")
INDEX(@"SEL$40" "O2"@"SEL$40" ("OBJ$"."DATAOBJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#"))
164 INDEX(@"SEL$40" "U2"@"SEL$40" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2"))
LE165 ADING(@"SEL$40" "O2"@"SEL$40" "U2"@"SEL$40"166 )
USE_NL(@"SEL$40" "U2"@"SEL$40")
167 PARTIAL_JOIN(@"SEL$40" "U2"@"SEL$40")
FU168 LL(@"SEL$39" "UE"@"SEL$39")
FULL(@"SEL$169 38" "UE"@"SEL$38")
INDEX(@"SEL$9DF0D31B" "OBJAUTH$"@"S170 EL$45" ("OBJAUTH$"."OBJ#" "OBJAUTH$"."GRANTOR#" "OBJA171 UTH$"."GRANTEE#"
"OBJAUTH$172 "."PRIVILEGE#" "OBJAUTH$"."COL#"))
FULL(@"SEL$9DF0D31B" "X$K173 ZSRO"@"SEL$47")
LEADING(@"SEL$9DF0D31B" "OBJAUTH$"@"SEL$45" "X$KZSRO"@"SEL$47")
USE_174 HASH(@"SEL$9DF0D31B" "X$KZSRO"@"SEL$47")
PARTIAL_JOIN(@"SE175 L$9DF0D31B" "X$KZSRO"@"SEL$47")
FULL(@"SEL$96D14815" "X$KZSPR"@"SEL$44")
INDEX(@"SEL$FCF381C3" "OBJAUT176 H$"@"SEL$67" ("OBJAUTH$"."OBJ#" "OBJAUTH$"."GRANTOR#" "OBJAUTH$"."GRANTEE#"
"OBJAUTH$"."PRIVI177 LEGE#" "OBJAUTH$"."COL#"))
FULL(@"SEL$F178 CF381C3" "X$KZSRO"@"SEL$69")
LEADING(@"SEL$FCF381C3" "OBJAU179 TH$"@"SEL$67" "X$KZSRO"@"SEL$69")
USE_HASH(@"SEL$FCF381C3" "X$KZSRO"@"SEL$69")180
PARTIAL_JOIN(@"SEL$FCF381C3" "X$KZSR181 O"@"SEL$69")
FULL(@"SEL$70B1039E" "X$KZ182 SPR"@"SEL$66")
NO_ACCESS(@"SEL$2" "A"@"S183 EL$2")
INDEX_FFS(@"SEL$3B673E5C" "U"@"SEL$20" (184 "USER$"."USER#" "USER$"."TYPE#" "USER$".185 "SPARE1" "USER$"."SPARE2"))
INDEX_RS_ASC(@"SEL$3B673E5C" "O"186 @"SEL$20" ("OBJ$"."OWNER#" "OBJ$"."NAME" "OBJ$"."NAMESPACE" "OBJ$"."REMOTEOWNER"
"OBJ$"."LINK187 NAME" "OBJ$"."SUBNAME" "OBJ$"."TYPE#" "OBJ$".188 "SPARE3" "OBJ$"."OBJ#"))
BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$189 3B673E5C" "O"@"SEL$20")
INDEX_RS_ASC(@"SEL$3B673E5C" "T"@"SEL$19" ("TYPE$"."TVOID"))
190 NO_ACCESS(@"SEL$3B673E5C" "SO"@"SEL$19")
INDEX(@"SEL$3B67191 3E5C" "SU"@"SEL$19" "I_USER#")
LEADING(@"192 SEL$3B673E5C" "U"@"SEL$20" "O"@"SEL$20" "T"@"SEL$19" "SO"@"SEL$19" "SU"@"SEL$19")
USE_NL(@"SEL$3B673E5C" 193 "O"@"SEL$20")
USE_NL(@"SEL$3B673E5C" "T"@"SEL$19")
USE_NL(@"SEL$3B673E5C" "SO"@"SEL$19")
USE194 _NL(@"SEL$3B673E5C" "SU"@"SEL$19")
PQ_FILTER(@"SEL$3B673E5C" SERIAL)
INDEX_FFS(@"SEL$07BDC5B4" "U"@"195 SEL$4" ("USER$"."USER#" "USER$"."TYPE#" "USE196 R$"."SPARE1" "USER$"."SPARE2"))
INDEX_R197 S_ASC(@"SEL$07BDC5B4" "O"@"SEL$4" ("OBJ$"."O198 WNER#" "OBJ$"."NAME" "OBJ$"."NAMESPACE" "OBJ199 $"."REMOTEOWNER"
"OBJ$"."LINK200 NAME" "OBJ$"."SUBNAME" "OBJ$"."TYPE#" "O201 BJ$"."SPARE3" "OBJ$"."OBJ#"))
BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$07BDC5B4" "O"@"SEL$4")
202 INDEX(@"SEL$07BDC5B4" "U"@"SEL$3" "I_USER#")
INDEX_RS_A203 SC(@"SEL$07BDC5B4" "T"@"SEL$3" ("TYPE$"."TVOID"))
NO_ACCESS(@"SEL$07BDC5B4" "SO"@"SEL$3")
INDEX(@"204 SEL$07BDC5B4" "SU"@"SEL$3" "I_USER#")
LEADING(@"SEL205 $07BDC5B4" "U"@"SEL$4" "O"@"SEL$4" "U"@"SEL206 $3" "T"@"SEL$3" "SO"@"SEL$3" "SU"@"SEL$3207 ")
USE_NL(@"SEL$07BDC5B4" "O"@"SEL$4")
USE_NL(@"SEL$07BDC5B4" "U"@"SEL$3")
208 USE_NL(@"SEL$07BDC5B4" "T"@"SEL$3")
USE_NL(@"SEL$07BDC5B4" "SO"@"SEL$3")
USE_NL(@"SEL$07209 BDC5B4" "SU"@"SEL$3")
PQ_FILTER(@"SEL$07BDC5B4"210 SERIAL)
INDEX_RS_ASC(@"SEL$FE7E211 982E" "O"@"SEL$8" ("OBJ$"."OID$"))
BAT212 CH_TABLE_ACCESS_BY_ROWID(@"SEL$FE7E9213 82E" "O"@"SEL$8")
INDEX_FFS(@"214 SEL$FE7E982E" "U"@"SEL$8" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPA215 RE2"))
LEADING(@"SEL$FE7E982E" "O"@"SEL$8" "U"@"SEL$8")
USE_HASH(@"SEL$FE7E982E" "U"@"SEL$8")216
PQ_FILTER(@"SEL$FE7E982E" SERIAL)
INDEX(217 @"SEL$11" "O2"@"SEL$11" ("OBJ$"."DATAO218 BJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#"))
219 INDEX(@"SEL$11" "U2"@"SEL$11" ("USER220 $"."USER#" "USER$"."TYPE#" "USER$"."221 SPARE1" "USER$"."SPARE2"))
LEADING(@"SEL$11" "O2"@"SEL$11" "U2"@"SEL$11")
US222 E_NL(@"SEL$11" "U2"@"SEL$11")
PARTIAL_JOIN(@"SEL$11" "U2"@"SEL$11")
FULL(@"SEL$10" "UE"@"SEL$223 10")
FULL(@"SEL$9" "UE"@"SEL$9")
INDEX(@"224 SEL$7" "O2"@"SEL$7" ("OBJ$"."DATAOBJ#"225 "OBJ$"."TYPE#" "OBJ$"."OWNER#"))
INDE226 X(@"SEL$7" "U2"@"SEL$7" ("USER$"."US227 ER#" "USER$"."TYPE#" "USER$"."SPARE1228 " "USER$"."SPARE2"))
LEADING(@"SEL$7" "O2"@"SEL$7" "U2"@"SEL$7")
USE_NL(@"SE229 L$7" "U2"@"SEL$7")
PARTIAL_JOIN(@"SEL$7" "U2"@"SEL$7")
FULL(@"SEL$6" "UE"@"SEL$6")
FULL230 (@"SEL$5" "UE"@"SEL$5")
FULL(@"SEL$4B882374" "X231 $KZSPR"@"SEL$18")
INDEX(@"SEL$6C232 051BA4" "OA"@"SEL$12" ("OBJAUTH$"."OBJ#" "OB233 JAUTH$"."GRANTOR#" "OBJAUTH$"."GRANT234 EE#"
"OBJAUTH$"."PRIVI235 LEGE#" "OBJAUTH$"."COL#"))
FULL(@"SEL$6C051BA4" "X$KZSRO"@"SEL$14")
LEADING(@"SEL$6C051BA4" "OA"@"S236 EL$12" "X$KZSRO"@"SEL$14")
USE_HASH(@"SEL$6C051BA4" 237 "X$KZSRO"@"SEL$14")
PARTIAL_JOIN(@"SEL$6C238 051BA4" "X$KZSRO"@"SEL$14")
INDEX_RS_ASC(@"SEL$810C4A74" "O"@"SE239 L$24" ("OBJ$"."OID$"))
BATCH_TABLE_ACCESS_BY_240 ROWID(@"SEL$810C4A74" "O"@"SEL$24")
INDEX_FFS(@"S241 EL$810C4A74" "U"@"SEL$24" ("USER$"."USER#" "USE242 R$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2"))
LEADING(@"SEL$810C4A74" "O"@"SEL$24" "U"@"SEL$24")
243 USE_HASH(@"SEL$810C4A74" "U"@"SEL$24")
PQ_FILTER(@"S244 EL$810C4A74" SERIAL)
INDEX(@"SEL$27" "O2"245 @"SEL$27" ("OBJ$"."DATAOBJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#"))
IN246 DEX(@"SEL$27" "U2"@"SEL$27" ("USER$"."USER#" "USER$247 "."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2"))
LEA248 DING(@"SEL$27" "O2"@"SEL$27" "U2"@"SEL$27")
249 USE_NL(@"SEL$27" "U2"@"SEL$27")
250 PARTIAL_JOIN(@"SEL$27" "U2"@"SEL$27")
FULL(@"SEL$26" "UE"@"SEL$26")
FULL(@"SEL$25" "UE"@"SEL$25")
251 INDEX(@"SEL$23" "O2"@"SEL$23" ("OBJ$"."DATAOBJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#"))
INDEX(@"SEL$23" "U2"@"SEL$252 23" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2"))
LEADING(@"SEL$23"253 "O2"@"SEL$23" "U2"@"SEL$23")
USE_NL(@"SEL$23" "U2"@"SEL$2254 3")
PARTIAL_JOIN(@"SEL$23" "U2"@"SEL$23")
FULL(@"SEL$22255 " "UE"@"SEL$22")
FULL(@"SEL$21" "UE"@"SEL256 $21")
FULL(@"SEL$5BC85507" "X$KZSPR"@"SEL$34")
257 INDEX(@"SEL$1C8BC144" "OA"@"SEL$28" ("OBJAUTH$"."OBJ#" "OBJAUTH$"."GRANTOR#" "OBJAUTH$"."GRA258 NTEE#"
"OBJAUTH$"."PRIVILEGE#259 " "OBJAUTH$"."COL#"))
FULL(@"SEL$1C8B260 C144" "X$KZSRO"@"SEL$30")
LEADING(@"SE261 L$1C8BC144" "OA"@"SEL$28" "X$KZSRO"@"SEL$30"262 )
USE_HASH(@"SEL$1C8BC144" "X$KZSR263 O"@"SEL$30")
PARTIAL_JOIN(@"SEL$1C8BC144" "X$KZSRO"@"SEL$30")
END_OUTLINE_DATA
*/
arg.package_name264 AS procedure_cat
,arg.OWNER AS procedure_schem
,arg.object_name AS PROCEDURE_NAME
,arg.argument_name AS column_nam265 e
,decode(arg.position, 0, 5, DECODE(arg.in_out, 'IN', 1, 'OUT', 4, 'IN/OUT', 2, 0)) AS column_266 type
,DECODE((
SELECT a.typecode
FROM ALL_TYPES A
WHE267 RE a.type_name = arg.data_type
), 'OBJECT', 2002268 , 'COLLECTION', 2003, DECODE(substr(arg.data_type, 1, 9), 'TIMESTA269 MP', DECODE(substr(arg.data_type, 10, 1), '(',270 DECODE(substr(arg.data_type, 19, 5), 'LOCAL', 102, 271 'TIME ', 101, 93), DECODE(substr(arg.data_type, 16, 5), 'LOCAL', 102, 'TIME', 101, 93)), 'INTERVAL ', DEC272 ODE(substr(arg.data_type, 10, 3), 'DAY', 1273 04, 'YEA', 103), DECODE(arg.data_type, 'BI274 NARY_DOUBLE', 101, 'BINARY_FLOAT', 100, 'B275 FILE', 13, 'BLOB', 2004, 'CHAR', 1, 'CLOB',276 2005, 'COLLECTION', 2003, 'DATE', 93, 'FLO277 AT', 6, 'LONG', 1, 'LONG RAW', 4, 'NCHAR278 ', 15, 'NCLOB', 2011, 'NUMBER', 2, 'NVARCHAR', 9, 'NVARCHAR2', 9279 , 'OBJECT', 2002, 'OPAQUE/XMLTYPE', 2009, 'RAW', 3, 'REF', 2006280 , 'ROWID', 8, 'SQLXML', 2009, 'UROWID', 8, 'VARCHAR2', 12, 'VARRAY, 2003,
XMLTYPE', 2009, 1111))) AS data_t281 ype
,decode(arg.data_type, 'OBJECT', arg.type_owner ||282 '.' || arg.type_name, arg.data_type) AS typ283 e_name
,decode(arg.data_precision, NULL284 , arg.data_length, arg.data_precision) AS precision
,arg.data_length AS length
,arg.da285 ta_scale AS scale
,10 AS radix
,1 AS nullable
,NULL AS remarks
,arg.default_value AS column_def
,NUL286 L AS sql_data_type
,NULL AS sql_datetime_sub
,decod287 e(arg.data_type, 'CHAR', 32767, 'VARCH288 AR2', 32767, 'LONG', 32767, 'RAW', 32767, 'L289 ONG RAW', 32767, NULL) AS char_octet290 _length
,(arg.sequence - 1) AS or291 dinal_position
,'YES' AS is_nullable
,NULL AS specific_name
,arg.sequence
,arg.ove292 rload
,arg.default_value
FROM all_arguments arg
,all_procedures PROC
WHERE arg.OWNER LIKE 'USER_TAXON293 E_ADM%' ESCAPE '/'
294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 AND arg.object_name LIKE 'SAF_PEGA_IDENT%' ESCAPE '/'
AND arg.data_level = 0
AND arg.OWNER = PROC.OWNER
AND arg.object_id = PROC.object_id
AND arg.subprogram_id = PROC.subprogram_id
AND arg.package_name IS NULL
AND (
arg.argument_name LIKE '%' ESCAPE '/'
OR (
arg.argument_name IS NULL
AND arg.data_type IS NOT NULL
)
)
ORDER BY procedure_schem
,PROCEDURE_NAME
,overload
,sequence;
366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
USER_TAXONE_ADM
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
SAF_PEGA_IDENT
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
P_NOME_TABELA
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
1 1
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
CHAR
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
10 1
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
32767 0 YES 1
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
USER_TAXONE_ADM
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
SAF_PEGA_IDENT
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
P_NOME_COLUNA
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
1 1
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
CHAR
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
10 1
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
32767 1 YES 2
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
USER_TAXONE_ADM
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
SAF_PEGA_IDENT
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
P_IDENT_OPERACAO
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
4 2
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
NUMBER
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
22 22 10 1
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
2 YES 3
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
PROCEDURE_CAT
--------------------------------------------------------------------------------
PROCEDURE_SCHEM
--------------------------------------------------------------------------------
PROCEDURE_NAME
--------------------------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_TYPE DATA_TYPE
----------- ----------
TYPE_NAME
--------------------------------------------------------------------------------
PRECISION LENGTH SCALE RADIX NULLABLE R
---------- ---------- ---------- ---------- ---------- -
COLUMN_DEF
--------------------------------------------------------------------------------
S S CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLAB S SEQUENCE
- - ----------------- ---------------- --------- - ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
Elapsed: 00:00:00.95
SQL>
SQL> @display
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID 1wdf08315gb6p, child number 0
-------------------------------------
SELECT /*+ BEGIN_OUTLINE_DATA MONITOR
IGNORE_OPTIM_EMBEDDED_HINTS OPTIMIZER_FEATURES_ENABLE('12.1.0.2')
DB_VERSION('12.1.0.2') OPT_PARAM('_px_adaptive_dist_method'
'off') OPT_PARAM('_optimizer_strans_adaptive_pruning' 'false')
OPT_PARAM('_optimizer_nlj_hj_adaptive_join' 'false') ALL_ROWS
OUTLINE_LEAF(@"SEL$6C051BA4") UNNEST(@"SEL$1CF66C63")
OUTLINE_LEAF(@"SEL$4B882374") MERGE(@"SEL$E8FDA8C1")
OUTLINE_LEAF(@"SEL$5") OUTLINE_LEAF(@"SEL$6")
OUTLINE_LEAF(@"SEL$7") OUTLINE_LEAF(@"SEL$9")
OUTLINE_LEAF(@"SEL$10") OUTLINE_LEAF(@"SEL$11")
OUTLINE_LEAF(@"SEL$FE7E982E") PUSH_PRED(@"SEL$07BDC5B4"
"SO"@"SEL$3" 8) OUTLINE_LEAF(@"SEL$07BDC5B4")
MERGE(@"SEL$4") OUTLINE_LEAF(@"SEL$1C8BC144")
UNNEST(@"SEL$F7A62D4D") OUTLINE_LEAF(@"SEL$5BC85507")
MERGE(@"SEL$AD150BAD") OUTLINE_LEAF(@"SEL$21")
OUTLINE_LEAF(@"SEL$22") OUTLINE_LEAF(
Plan hash value: 2322846737
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | Reads | OMem | 1Mem | Used-Mem |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | 3 |00:00:00.73 | 46056 | 1497 | | | |
| 1 | VIEW | ALL_TYPES | 2 | 2 | 2 |00:00:00.01 | 12227 | 0 | | | |
| 2 | SORT UNIQUE | | 2 | 2 | 2 |00:00:00.01 | 12227 | 0 | 2048 | 2048 | 2048 (0)|
| 3 | UNION-ALL | | 2 | | 2 |00:00:00.01 | 12227 | 0 | | | |
|* 4 | FILTER | | 2 | | 0 |00:00:00.01 | 6115 | 0 | | | |
| 5 | NESTED LOOPS OUTER | | 2 | 1 | 0 |00:00:00.01 | 6115 | 0 | | | |
| 6 | NESTED LOOPS OUTER | | 2 | 1 | 0 |00:00:00.01 | 6115 | 0 | | | |
| 7 | NESTED LOOPS | | 2 | 1 | 0 |00:00:00.01 | 6115 | 0 | | | |
| 8 | NESTED LOOPS | | 2 | 1 | 2 |00:00:00.01 | 6107 | 0 | | | |
| 9 | NESTED LOOPS | | 2 | 1 | 2 |00:00:00.01 | 6101 | 0 | | | |
| 10 | INDEX FAST FULL SCAN | I_USER2 | 2 | 987 | 1974 |00:00:00.01 | 20 | 0 | | | |
|* 11 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 1974 | 1 | 2 |00:00:00.01 | 6081 | 0 | | | |
|* 12 | INDEX RANGE SCAN | I_OBJ2 | 1974 | 1 | 2 |00:00:00.01 | 6079 | 0 | | | |
| 13 | TABLE ACCESS CLUSTER | USER$ | 2 | 1 | 2 |00:00:00.01 | 6 | 0 | | | |
|* 14 | INDEX UNIQUE SCAN | I_USER# | 2 | 1 | 2 |00:00:00.01 | 4 | 0 | | | |
|* 15 | TABLE ACCESS BY INDEX ROWID | TYPE$ | 2 | 1 | 0 |00:00:00.01 | 8 | 0 | | | |
|* 16 | INDEX UNIQUE SCAN | I_TYPE2 | 2 | 1 | 2 |00:00:00.01 | 6 | 0 | | | |
| 17 | VIEW PUSHED PREDICATE | _CURRENT_EDITION_OBJ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 18 | FILTER | | 0 | | 0 |00:00:00.01 | 0 | 0 | | | |
|* 19 | HASH JOIN | | 0 | 58 | 0 |00:00:00.01 | 0 | 0 | 968K| 968K| |
| 20 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 0 | 58 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 21 | INDEX RANGE SCAN | I_OBJ3 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
| 22 | INDEX FAST FULL SCAN | I_USER2 | 0 | 987 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 23 | TABLE ACCESS FULL | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
| 24 | NESTED LOOPS SEMI | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 25 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 26 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 27 | TABLE ACCESS FULL | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
| 28 | TABLE ACCESS CLUSTER | USER$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 29 | INDEX UNIQUE SCAN | I_USER# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 30 | HASH JOIN SEMI | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | 1483K| 1483K| |
|* 31 | INDEX RANGE SCAN | I_OBJAUTH1 | 0 | 2 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 32 | FIXED TABLE FULL | X$KZSRO | 0 | 2 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 33 | FIXED TABLE FULL | X$KZSPR | 0 | 8 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 34 | TABLE ACCESS FULL | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
| 35 | NESTED LOOPS SEMI | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 36 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 37 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 38 | TABLE ACCESS FULL | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 39 | FILTER | | 2 | | 2 |00:00:00.01 | 6112 | 0 | | | |
| 40 | NESTED LOOPS OUTER | | 2 | 1 | 2 |00:00:00.01 | 6109 | 0 | | | |
| 41 | NESTED LOOPS OUTER | | 2 | 1 | 2 |00:00:00.01 | 6109 | 0 | | | |
| 42 | NESTED LOOPS | | 2 | 1 | 2 |00:00:00.01 | 6109 | 0 | | | |
| 43 | NESTED LOOPS | | 2 | 1 | 2 |00:00:00.01 | 6101 | 0 | | | |
| 44 | INDEX FAST FULL SCAN | I_USER2 | 2 | 987 | 1974 |00:00:00.01 | 20 | 0 | | | |
|* 45 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 1974 | 1 | 2 |00:00:00.01 | 6081 | 0 | | | |
|* 46 | INDEX RANGE SCAN | I_OBJ2 | 1974 | 1 | 2 |00:00:00.01 | 6079 | 0 | | | |
|* 47 | TABLE ACCESS BY INDEX ROWID | TYPE$ | 2 | 1 | 2 |00:00:00.01 | 8 | 0 | | | |
|* 48 | INDEX UNIQUE SCAN | I_TYPE2 | 2 | 1 | 2 |00:00:00.01 | 6 | 0 | | | |
| 49 | VIEW PUSHED PREDICATE | _CURRENT_EDITION_OBJ | 2 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 50 | FILTER | | 2 | | 0 |00:00:00.01 | 0 | 0 | | | |
|* 51 | HASH JOIN | | 2 | 58 | 0 |00:00:00.01 | 0 | 0 | 968K| 968K| 220K (0)|
| 52 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 2 | 58 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 53 | INDEX RANGE SCAN | I_OBJ3 | 2 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
| 54 | INDEX FAST FULL SCAN | I_USER2 | 0 | 987 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 55 | TABLE ACCESS FULL | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
| 56 | NESTED LOOPS SEMI | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 57 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 58 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 59 | TABLE ACCESS FULL | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
| 60 | TABLE ACCESS CLUSTER | USER$ | 2 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 61 | INDEX UNIQUE SCAN | I_USER# | 2 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 62 | HASH JOIN SEMI | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | 1483K| 1483K| |
|* 63 | INDEX RANGE SCAN | I_OBJAUTH1 | 0 | 2 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 64 | FIXED TABLE FULL | X$KZSRO | 0 | 2 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 65 | FIXED TABLE FULL | X$KZSPR | 0 | 8 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 66 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 1 | 0 |00:00:00.01 | 3 | 0 | | | |
| 67 | NESTED LOOPS SEMI | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 68 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 69 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 70 | TABLE ACCESS FULL | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
| 71 | SORT ORDER BY | | 1 | 5 | 3 |00:00:00.73 | 46056 | 1497 | 2048 | 2048 | 2048 (0)|
|* 72 | FILTER | | 1 | | 3 |00:00:00.71 | 33829 | 1497 | | | |
| 73 | NESTED LOOPS | | 1 | 53 | 3 |00:00:00.71 | 33826 | 1497 | | | |
|* 74 | HASH JOIN | | 1 | 170K| 3 |00:00:00.71 | 33736 | 1494 | 1557K| 1557K| 1333K (0)|
| 75 | INDEX FAST FULL SCAN | I_USER2 | 1 | 987 | 987 |00:00:00.01 | 10 | 0 | | | |
| 76 | NESTED LOOPS | | 1 | 170K| 3 |00:00:00.71 | 33726 | 1494 | | | |
| 77 | NESTED LOOPS | | 1 | 6307K| 3 |00:00:00.71 | 33725 | 1494 | | | |
| 78 | NESTED LOOPS | | 1 | 6307K| 8236 |00:00:00.10 | 8076 | 178 | | | |
| 79 | TABLE ACCESS BY INDEX ROWID BATCHED | USER$ | 1 | 843 | 1 |00:00:00.01 | 8 | 0 | | | |
|* 80 | INDEX RANGE SCAN | I_USER1 | 1 | 843 | 1 |00:00:00.01 | 7 | 0 | | | |
| 81 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 1 | 7483 | 8236 |00:00:00.09 | 8068 | 178 | | | |
|* 82 | INDEX RANGE SCAN | I_OBJ5 | 1 | 7483 | 8236 |00:00:00.09 | 186 | 178 | | | |
|* 83 | INDEX RANGE SCAN | I_ARGUMENT1 | 8236 | 1 | 3 |00:00:00.61 | 25649 | 1316 | | | |
|* 84 | TABLE ACCESS BY INDEX ROWID | ARGUMENT$ | 3 | 1 | 3 |00:00:00.01 | 1 | 0 | | | |
|* 85 | VIEW | INT$DBA_PROCEDURES | 3 | 1 | 3 |00:00:00.01 | 90 | 3 | | | |
| 86 | UNION ALL PUSHED PREDICATE | | 3 | | 3 |00:00:00.01 | 90 | 3 | | | |
|* 87 | FILTER | | 3 | | 3 |00:00:00.01 | 42 | 3 | | | |
|* 88 | FILTER | | 3 | | 3 |00:00:00.01 | 39 | 3 | | | |
| 89 | NESTED LOOPS | | 3 | 1 | 3 |00:00:00.01 | 39 | 3 | | | |
| 90 | NESTED LOOPS OUTER | | 3 | 1 | 3 |00:00:00.01 | 33 | 3 | | | |
| 91 | NESTED LOOPS OUTER | | 3 | 1 | 3 |00:00:00.01 | 33 | 3 | | | |
|* 92 | HASH JOIN | | 3 | 1 | 3 |00:00:00.01 | 33 | 3 | 1126K| 1126K| 413K (0)|
| 93 | NESTED LOOPS | | 3 | 3 | 3 |00:00:00.01 | 21 | 3 | | | |
| 94 | TABLE ACCESS BY INDEX ROWID | USER$ | 3 | 1 | 3 |00:00:00.01 | 9 | 0 | | | |
|* 95 | INDEX UNIQUE SCAN | I_USER1 | 3 | 1 | 3 |00:00:00.01 | 6 | 0 | | | |
| 96 | TABLE ACCESS BY INDEX ROWID BATCHED | PROCEDUREINFO$ | 3 | 3 | 3 |00:00:00.01 | 12 | 3 | | | |
|* 97 | INDEX RANGE SCAN | I_PROCEDUREINFO1 | 3 | 3 | 3 |00:00:00.01 | 9 | 2 | | | |
|* 98 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 3 | 1 | 3 |00:00:00.01 | 12 | 0 | | | |
|* 99 | INDEX RANGE SCAN | I_OBJ1 | 3 | 1 | 3 |00:00:00.01 | 9 | 0 | | | |
| 100 | VIEW PUSHED PREDICATE | _CURRENT_EDITION_OBJ | 3 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*101 | FILTER | | 3 | | 0 |00:00:00.01 | 0 | 0 | | | |
| 102 | NESTED LOOPS | | 3 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
| 103 | TABLE ACCESS BY INDEX ROWID BATCHED| OBJ$ | 3 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*104 | INDEX RANGE SCAN | I_OBJ1 | 3 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*105 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*106 | TABLE ACCESS FULL | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
| 107 | NESTED LOOPS SEMI | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*108 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*109 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*110 | TABLE ACCESS FULL | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*111 | INDEX RANGE SCAN | I_USER2 | 3 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*112 | INDEX RANGE SCAN | I_USER2 | 3 | 1 | 3 |00:00:00.01 | 6 | 0 | | | |
|*113 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 1 | 0 |00:00:00.01 | 3 | 0 | | | |
| 114 | NESTED LOOPS SEMI | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*115 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*116 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*117 | TABLE ACCESS FULL | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*118 | FILTER | | 3 | | 0 |00:00:00.01 | 48 | 0 | | | |
|*119 | FILTER | | 3 | | 0 |00:00:00.01 | 48 | 0 | | | |
|*120 | FILTER | | 3 | | 0 |00:00:00.01 | 48 | 0 | | | |
|*121 | HASH JOIN OUTER | | 3 | 1 | 0 |00:00:00.01 | 48 | 0 | 840K| 840K| 179K (0)|
|*122 | HASH JOIN | | 3 | 1 | 0 |00:00:00.01 | 48 | 0 | 1557K| 1557K| 1337K (0)|
| 123 | INDEX FAST FULL SCAN | I_USER2 | 3 | 987 | 2961 |00:00:00.01 | 30 | 0 | | | |
| 124 | NESTED LOOPS | | 3 | 1 | 0 |00:00:00.01 | 18 | 0 | | | |
| 125 | TABLE ACCESS BY INDEX ROWID | USER$ | 3 | 1 | 3 |00:00:00.01 | 9 | 0 | | | |
|*126 | INDEX UNIQUE SCAN | I_USER1 | 3 | 1 | 3 |00:00:00.01 | 6 | 0 | | | |
|*127 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 3 | 1 | 0 |00:00:00.01 | 9 | 0 | | | |
|*128 | INDEX RANGE SCAN | I_OBJ1 | 3 | 1 | 0 |00:00:00.01 | 9 | 0 | | | |
| 129 | TABLE ACCESS BY INDEX ROWID BATCHED | PROCEDUREINFO$ | 0 | 3 | 0 |00:00:00.01 | 0 | 0 | | | |
|*130 | INDEX RANGE SCAN | I_PROCEDUREINFO1 | 0 | 3 | 0 |00:00:00.01 | 0 | 0 | | | |
|*131 | TABLE ACCESS FULL | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
| 132 | NESTED LOOPS SEMI | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*133 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*134 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*135 | TABLE ACCESS FULL | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*136 | FIXED TABLE FULL | X$KZSPR | 1 | 1 | 1 |00:00:00.01 | 0 | 0 | | | |
|*137 | HASH JOIN SEMI | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | 1393K| 1393K| |
|*138 | INDEX RANGE SCAN | I_OBJAUTH1 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*139 | FIXED TABLE FULL | X$KZSRO | 0 | 2 | 0 |00:00:00.01 | 0 | 0 | | | |
|*140 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 1 | 0 |00:00:00.01 | 3 | 0 | | | |
| 141 | NESTED LOOPS SEMI | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*142 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*143 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*144 | TABLE ACCESS FULL | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*145 | FIXED TABLE FULL | X$KZSPR | 1 | 1 | 1 |00:00:00.01 | 0 | 0 | | | |
|*146 | HASH JOIN SEMI | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | 1393K| 1393K| |
|*147 | INDEX RANGE SCAN | I_OBJAUTH1 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*148 | FIXED TABLE FULL | X$KZSRO | 0 | 2 | 0 |00:00:00.01 | 0 | 0 | | | |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
4 - filter((("O"."SPARE3"=USERENV('SCHEMAID') OR IS NOT NULL OR 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))))
11 - filter("O"."OID$" IS NOT NULL)
12 - access("O"."OWNER#"="U"."USER#" AND "O"."NAME"=DECODE(:B1,0,NULL,1,DECODE(:B2,2,'NVARCHAR2','VARCHAR2'),2,DECODE(:B3,(-127),'FLOAT','NUMBER'),3,'NATIVE
INTEGER',8,'LONG',9,DECODE(:B4,2,'NCHAR VARYING','VARCHAR'),11,'ROWID',12,'DATE',23,'RAW',24,'LONG
RAW',29,'BINARY_INTEGER',58,'OPAQUE/XMLTYPE',69,'ROWID',96,DECODE(:B5,2,'NCHAR','CHAR'),100,'BINARY_FLOAT',101,'BINARY_DOUBLE',102,'REF
CURSOR',104,'UROWID',105,'MLSLABEL',106,'MLSLABEL',110,'REF',111,'REF',112,DECODE(:B6,2,'NCLOB','CLOB'),113,'BLOB',114,'BFILE',115,'CFILE',121,'OBJECT',122,'TA
BLE',123,'VARRAY',178,'TIME',179,'TIME WITH TIME ZONE',180,'TIMESTAMP',181,'TIMESTAMP WITH TIME ZONE',231,'TIMESTAMP WITH LOCAL TIME ZONE',182,'INTERVAL YEAR
TO MONTH',183,'INTERVAL DAY TO SECOND',250,'PL/SQL RECORD',251,'PL/SQL TABLE',252,'PL/SQL BOOLEAN','UNDEFINED') AND "O"."SUBNAME" IS NULL)
filter(("O"."SUBNAME" IS NULL AND "O"."TYPE#"<>10))
14 - access("O"."SPARE3"="U"."USER#")
15 - filter(("T"."PACKAGE_OBJ#" IS NULL AND BITAND("T"."PROPERTIES",2048)=0 AND BITAND("T"."PROPERTIES",64)<>64))
16 - access("O"."OID$"="T"."TVOID")
18 - 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)))
19 - access("O"."OWNER#"="U"."USER#")
21 - access("O"."OID$"="T"."SUPERTOID")
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
23 - filter(("TYPE#"=:B1 AND "UE"."USER#"=:B2))
25 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
26 - 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')))
27 - filter(("UE"."TYPE#"=:B1 AND "UE"."USER#"=:B2))
29 - access("SO"."OWNER#"="SU"."USER#")
30 - access("GRANTEE#"="KZSROROL")
31 - access("OA"."OBJ#"=:B1)
32 - filter(("CON_ID"=0 OR "CON_ID"=3))
33 - filter((((-"KZSPRPRV")=(-184) OR (-"KZSPRPRV")=(-181)) AND INTERNAL_FUNCTION("CON_ID") AND "INST_ID"=USERENV('INSTANCE')))
34 - filter(("TYPE#"=:B1 AND "UE"."USER#"=:B2))
36 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
37 - 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')))
38 - filter(("UE"."TYPE#"=:B1 AND "UE"."USER#"=:B2))
39 - filter((("O"."SPARE3"=USERENV('SCHEMAID') OR IS NOT NULL OR 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))))
45 - filter("O"."OID$" IS NOT NULL)
46 - access("O"."OWNER#"="U"."USER#" AND "O"."NAME"=DECODE(:B1,0,NULL,1,DECODE(:B2,2,'NVARCHAR2','VARCHAR2'),2,DECODE(:B3,(-127),'FLOAT','NUMBER'),3,'NATIVE
INTEGER',8,'LONG',9,DECODE(:B4,2,'NCHAR VARYING','VARCHAR'),11,'ROWID',12,'DATE',23,'RAW',24,'LONG
RAW',29,'BINARY_INTEGER',58,'OPAQUE/XMLTYPE',69,'ROWID',96,DECODE(:B5,2,'NCHAR','CHAR'),100,'BINARY_FLOAT',101,'BINARY_DOUBLE',102,'REF
CURSOR',104,'UROWID',105,'MLSLABEL',106,'MLSLABEL',110,'REF',111,'REF',112,DECODE(:B6,2,'NCLOB','CLOB'),113,'BLOB',114,'BFILE',115,'CFILE',121,'OBJECT',122,'TA
BLE',123,'VARRAY',178,'TIME',179,'TIME WITH TIME ZONE',180,'TIMESTAMP',181,'TIMESTAMP WITH TIME ZONE',231,'TIMESTAMP WITH LOCAL TIME ZONE',182,'INTERVAL YEAR
TO MONTH',183,'INTERVAL DAY TO SECOND',250,'PL/SQL RECORD',251,'PL/SQL TABLE',252,'PL/SQL BOOLEAN','UNDEFINED') AND "O"."SUBNAME" IS NULL)
filter(("O"."SUBNAME" IS NULL AND "O"."TYPE#"<>10))
47 - filter(("T"."PACKAGE_OBJ#" IS NULL AND BITAND("T"."PROPERTIES",64)=64 AND BITAND("T"."PROPERTIES",2048)=0))
48 - access("O"."OID$"="T"."TVOID")
50 - 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)))
51 - access("O"."OWNER#"="U"."USER#")
53 - access("O"."OID$"="T"."SUPERTOID")
55 - filter(("TYPE#"=:B1 AND "UE"."USER#"=:B2))
57 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
58 - 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')))
59 - filter(("UE"."TYPE#"=:B1 AND "UE"."USER#"=:B2))
61 - access("SO"."OWNER#"="SU"."USER#")
62 - access("GRANTEE#"="KZSROROL")
63 - access("OA"."OBJ#"=:B1)
64 - filter(("CON_ID"=0 OR "CON_ID"=3))
65 - filter((((-"KZSPRPRV")=(-184) OR (-"KZSPRPRV")=(-181)) AND INTERNAL_FUNCTION("CON_ID") AND "INST_ID"=USERENV('INSTANCE')))
66 - filter(("TYPE#"=:B1 AND "UE"."USER#"=:B2))
68 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
69 - 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')))
70 - filter(("UE"."TYPE#"=:B1 AND "UE"."USER#"=:B2))
72 - filter((("U"."NAME"=SYS_CONTEXT('USERENV','CURRENT_USER') OR IS NOT NULL OR 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)) AND
("OWNER"=SYS_CONTEXT('USERENV','CURRENT_USER') OR IS NOT NULL OR IS NOT NULL)))
74 - access("O"."OWNER#"="U"."USER#")
80 - access("U"."NAME" LIKE 'USER_TAXONE_ADM%' ESCAPE '/')
filter("U"."NAME" LIKE 'USER_TAXONE_ADM%' ESCAPE '/')
82 - access("O"."SPARE3"="U"."USER#")
filter((INTERNAL_FUNCTION("O"."TYPE#") OR ("O"."TYPE#"=13 AND "O"."SUBNAME" IS NULL)))
83 - access("O"."OBJ#"="A"."OBJ#")
filter((DECODE("A"."PROCEDURE$",NULL,NULL,"O"."NAME") IS NULL AND NVL("A"."PROCEDURE$","O"."NAME") LIKE 'SAF_PEGA_IDENT%' ESCAPE '/'))
84 - filter(("A"."LEVEL#"=0 AND (("A"."ARGUMENT" IS NOT NULL AND "A"."ARGUMENT" IS NOT NULL AND "A"."ARGUMENT" LIKE '%' ESCAPE '/') OR ("A"."ARGUMENT" IS
NULL AND DECODE("A"."TYPE#",0,NULL,1,DECODE("A"."CHARSETFORM",2,'NVARCHAR2','VARCHAR2'),2,DECODE("A"."SCALE",(-127),'FLOAT','NUMBER'),3,'NATIVE
INTEGER',8,'LONG',9,DECODE("A"."CHARSETFORM",2,'NCHAR VARYING','VARCHAR'),11,'ROWID',12,'DATE',23,'RAW',24,'LONG
RAW',29,'BINARY_INTEGER',58,'OPAQUE/XMLTYPE',69,'ROWID',96,DECODE("A"."CHARSETFORM",2,'NCHAR','CHAR'),100,'BINARY_FLOAT',101,'BINARY_DOUBLE',102,'REF
CURSOR',104,'UROWID',105,'MLSLABEL',106,'MLSLABEL',110,'REF',111,'REF',112,DECODE("A"."CHARSETFORM",2,'NCLOB','CLOB'),113,'BLOB',114,'BFILE',115,'CFILE',121,'O
BJECT',122,'TABLE',123,'VARRAY',178,'TIME',179,'TIME WITH TIME ZONE',180,'TIMESTAMP',181,'TIMESTAMP WITH TIME ZONE',231,'TIMESTAMP WITH LOCAL TIME
ZONE',182,'INTERVAL YEAR TO MONTH',183,'INTERVAL DAY TO SECOND',250,'PL/SQL RECORD',251,'PL/SQL TABLE',252,'PL/SQL BOOLEAN','UNDEFINED') IS NOT NULL))))
85 - filter("A"."PROCEDURE#"="SUBPROGRAM_ID")
87 - 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)))
88 - filter("U"."NAME" LIKE 'USER_TAXONE_ADM%' ESCAPE '/')
92 - access("U"."USER#"="O"."SPARE3" AND "O"."OBJ#"="PI"."OBJ#")
95 - access("U"."NAME"="U"."NAME")
filter("U"."NAME" LIKE 'USER_TAXONE_ADM%' ESCAPE '/')
97 - access("PI"."OBJ#"="O"."OBJ#")
98 - filter(((INTERNAL_FUNCTION("O"."TYPE#") OR ("O"."TYPE#"=13 AND "O"."SUBNAME" IS NULL)) AND (TO_NUMBER(SYS_CONTEXT('USERENV','CON_ID'))=0 OR
TO_NUMBER(SYS_CONTEXT('USERENV','CON_ID'))=1 OR DECODE(BITAND("O"."FLAGS",196608),65536,1,131072,1,0)=0)))
99 - access("O"."OBJ#"="O"."OBJ#")
101 - 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)))
104 - access("O"."OBJ#"="PI"."ITYPEOBJ#")
105 - access("O"."OWNER#"="U"."USER#")
106 - filter(("TYPE#"=:B1 AND "UE"."USER#"=:B2))
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')))
110 - filter(("UE"."TYPE#"=:B1 AND "UE"."USER#"=:B2))
111 - access("O2"."OWNER#"="U2"."USER#")
112 - access("O"."OWNER#"="U"."USER#")
113 - filter(("TYPE#"=:B1 AND "UE"."USER#"=:B2))
115 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
116 - 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 - filter(("UE"."TYPE#"=:B1 AND "UE"."USER#"=:B2))
118 - 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)))
119 - filter("U"."NAME" LIKE 'USER_TAXONE_ADM%' ESCAPE '/')
120 - filter(("PI"."PROCEDURE#" IS NULL OR "PI"."PROCEDURE#"=1))
121 - access("O"."OBJ#"="PI"."OBJ#")
122 - access("O"."OWNER#"="U"."USER#")
126 - access("U"."NAME"="U"."NAME")
filter("U"."NAME" LIKE 'USER_TAXONE_ADM%' ESCAPE '/')
127 - filter(((TO_NUMBER(SYS_CONTEXT('USERENV','CON_ID'))=0 OR TO_NUMBER(SYS_CONTEXT('USERENV','CON_ID'))=1 OR
DECODE(BITAND("O"."FLAGS",196608),65536,1,131072,1,0)=0) AND "O"."SPARE3"="U"."USER#"))
128 - access("O"."OBJ#"="O"."OBJ#")
filter(("O"."TYPE#"=9 OR "O"."TYPE#"=12))
130 - access("PI"."OBJ#"="O"."OBJ#")
131 - filter(("TYPE#"=:B1 AND "UE"."USER#"=:B2))
133 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
134 - 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')))
135 - filter(("UE"."TYPE#"=:B1 AND "UE"."USER#"=:B2))
136 - filter((((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141)) AND INTERNAL_FUNCTION("CON_ID") AND "INST_ID"=USERENV('INSTANCE')))
137 - access("GRANTEE#"="KZSROROL")
138 - access("OBJ#"=:B1 AND "PRIVILEGE#"=12)
filter("PRIVILEGE#"=12)
139 - filter(("CON_ID"=0 OR "CON_ID"=3))
140 - filter(("TYPE#"=:B1 AND "UE"."USER#"=:B2))
142 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
143 - 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')))
144 - filter(("UE"."TYPE#"=:B1 AND "UE"."USER#"=:B2))
145 - filter((((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141)) AND INTERNAL_FUNCTION("CON_ID") AND "INST_ID"=USERENV('INSTANCE')))
146 - access("GRANTEE#"="KZSROROL")
147 - access("OBJ#"=:B1 AND "PRIVILEGE#"=12)
filter("PRIVILEGE#"=12)
148 - filter(("CON_ID"=0 OR "CON_ID"=3))
327 rows selected.
Elapsed: 00:00:00.23
SQL> @sqlm_sqlid
Enter value for sql_id: 1wdf08315gb6p
old 2: sql_id=> '&&sql_id',
new 2: sql_id=> '1wdf08315gb6p',
SQL Monitoring Report
SQL Text
------------------------------
SELECT /*+ BEGIN_OUTLINE_DATA MONITOR IGNORE_OPTIM_EMBEDDED_HINTS OPTIMIZER_FEATURES_ENABLE('12.1.0.2') DB_VERSION('12.1.0.2') OPT_PARAM('_px_adaptive_dist_method' 'off') OPT_PARAM('_optimizer_strans_adaptive_pruning' 'false') OPT_PARAM('_optimizer_nlj_hj_adaptive_join' 'false') ALL_ROWS OUTLINE_LEAF(@"SEL$6C051BA4") UNNEST(@"SEL$1CF66C63") OUTLINE_LEAF(@"SEL$4B882374") MERGE(@"SEL$E8FDA8C1") OUTLINE_LEAF(@"SEL$5") OUTLINE_LEAF(@"SEL$6") OUTLINE_LEAF(@"SEL$7") OUTLINE_LEAF(@"SEL$9")
OUTLINE_LEAF(@"SEL$10") OUTLINE_LEAF(@"SEL$11") OUTLINE_LEAF(@"SEL$FE7E982E") PUSH_PRED(@"SEL$07BDC5B4" "SO"@"SEL$3" 8) OUTLINE_LEAF(@"SEL$07BDC5B4") MERGE(@"SEL$4") OUTLINE_LEAF(@"SEL$1C8BC144") UNNEST(@"SEL$F7A62D4D") OUTLINE_LEAF(@"SEL$5BC85507") MERGE(@"SEL$AD150BAD") OUTLINE_LEAF(@"SEL$21") OUTLINE_LEAF(@"SEL$22") OUTLINE_LEAF(@"SEL$23") OUTLINE_LEAF(@"SEL$25") OUTLINE_LEAF(@"SEL$26") OUTLINE_LEAF(@"SEL$27") OUTLINE_LEAF(@"SEL$810C4A74") PUSH_PRED(@"SEL$3B673E5C" "SO"@"SEL$19" 7)
OUTLINE_LEAF(@"SEL$3B673E5C") MERGE(@"SEL$20") OUTLINE_LEAF(@"SET$1") OUTLINE_LEAF(@"SEL$2") OUTLINE_LEAF(@"SEL$70B1039E") MERGE(@"SEL$BB23D85A") OUTLINE_LEAF(@"SEL$FCF381C3") UNNEST(@"SEL$E7748E76") OUTLINE_LEAF(@"SEL$96D14815") MERGE(@"SEL$27E47649") OUTLINE_LEAF(@"SEL$9DF0D31B") UNNEST(@"SEL$03AE7C5B") OUTLINE_LEAF(@"SEL$38") OUTLINE_LEAF(@"SEL$39") OUTLINE_LEAF(@"SEL$40") OUTLINE_LEAF(@"SEL$51") OUTLINE_LEAF(@"SEL$52") OUTLINE_LEAF(@"SEL$53") OUTLINE_LEAF(@"SEL$55") OUTLINE_LEAF(@"SEL$56")
OUTLINE_LEAF(@"SEL$57") OUTLINE_LEAF(@"SEL$BF0909A7") PUSH_PRED(@"SEL$F1FA71CC" "O2"@"SEL$49" 5) OUTLINE_LEAF(@"SEL$674ECF7B") OUTLINE_LEAF(@"SEL$60") OUTLINE_LEAF(@"SEL$61") OUTLINE_LEAF(@"SEL$62") OUTLINE_LEAF(@"SEL$F7F46460") OUTLINE_LEAF(@"SET$BE4AEC69") PUSH_PRED(@"SEL$EE64F57D" "INT$DBA_PROCEDURES"@"SEL$48" 5 4) OUTLINE_LEAF(@"SEL$EE64F57D") MERGE(@"SEL$48") MERGE(@"SEL$4E97CFE8") OUTLINE(@"SEL$12") OUTLINE(@"SEL$1CF66C63") MERGE(@"SEL$14") OUTLINE(@"SEL$15") OUTLINE(@"SEL$E8FDA8C1")
MERGE(@"SEL$DC4B4145") OUTLINE(@"SEL$8") OUTLINE(@"SEL$07BDC5B4") MERGE(@"SEL$4") OUTLINE(@"SEL$3") OUTLINE(@"SEL$4") OUTLINE(@"SEL$28") OUTLINE(@"SEL$F7A62D4D") MERGE(@"SEL$30") OUTLINE(@"SEL$31") OUTLINE(@"SEL$AD150BAD") MERGE(@"SEL$8C085B80") OUTLINE(@"SEL$24") OUTLINE(@"SEL$3B673E5C") MERGE(@"SEL$20") OUTLINE(@"SEL$19") OUTLINE(@"SEL$20") OUTLINE(@"SEL$63") OUTLINE(@"SEL$BB23D85A") MERGE(@"SEL$7337C6A8") OUTLINE(@"SEL$67") OUTLINE(@"SEL$E7748E76") MERGE(@"SEL$69") OUTLINE(@"SEL$41")
OUTLINE(@"SEL$27E47649") MERGE(@"SEL$1822E6ED") OUTLINE(@"SEL$45") OUTLINE(@"SEL$03AE7C5B") MERGE(@"SEL$47") OUTLINE(@"SEL$54") OUTLINE(@"SEL$F1FA71CC") MERGE(@"SEL$50") OUTLINE(@"SEL$260377DE") MERGE(@"SEL$59") OUTLINE(@"SET$2") OUTLINE(@"SEL$EE64F57D") MERGE(@"SEL$48") MERGE(@"SEL$4E97CFE8") OUTLINE(@"SEL$1") OUTLINE(@"SEL$48") OUTLINE(@"SEL$4E97CFE8") MERGE(@"SEL$FF4A7D68") OUTLINE(@"SEL$13") OUTLINE(@"SEL$14") OUTLINE(@"SEL$16") OUTLINE(@"SEL$DC4B4145") MERGE(@"SEL$18") OUTLINE(@"SEL$29")
OUTLINE(@"SEL$30") OUTLINE(@"SEL$32") OUTLINE(@"SEL$8C085B80") MERGE(@"SEL$34") OUTLINE(@"SEL$64") OUTLINE(@"SEL$7337C6A8") MERGE(@"SEL$66") OUTLINE(@"SEL$68") OUTLINE(@"SEL$69") OUTLINE(@"SEL$42") OUTLINE(@"SEL$1822E6ED") MERGE(@"SEL$44") OUTLINE(@"SEL$46") OUTLINE(@"SEL$47") OUTLINE(@"SEL$49") OUTLINE(@"SEL$50") OUTLINE(@"SEL$58") OUTLINE(@"SEL$59") OUTLINE(@"SEL$35") OUTLINE(@"SEL$FF4A7D68") MERGE(@"SEL$37") OUTLINE(@"SEL$17") OUTLINE(@"SEL$18") OUTLINE(@"SEL$33") OUTLINE(@"SEL$34")
OUTLINE(@"SEL$65") OUTLINE(@"SEL$66") OUTLINE(@"SEL$43") OUTLINE(@"SEL$44") OUTLINE(@"SEL$36") OUTLINE(@"SEL$37") INDEX_RS_ASC(@"SEL$EE64F57D" "U"@"SEL$36" ("USER$"."NAME")) BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$EE64F57D" "U"@"SEL$36") INDEX_RS_ASC(@"SEL$EE64F57D" "O"@"SEL$37" ("OBJ$"."SPARE3" "OBJ$"."NAME" "OBJ$"."NAMESPACE" "OBJ$"."TYPE#" "OBJ$"."OWNER#" "OBJ$"."REMOTEOWNER" "OBJ$"."LINKNAME" "OBJ$"."SUBNAME" "OBJ$"."OBJ#")) BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$EE64F57D" "O"@"SEL$37")
INDEX(@"SEL$EE64F57D" "A"@"SEL$36" ("ARGUMENT$"."OBJ#" "ARGUMENT$"."PROCEDURE$" "ARGUMENT$"."OVERLOAD#" "ARGUMENT$"."SEQUENCE#")) INDEX_FFS(@"SEL$EE64F57D" "U"@"SEL$37" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) NO_ACCESS(@"SEL$EE64F57D" "INT$DBA_PROCEDURES"@"SEL$48") LEADING(@"SEL$EE64F57D" "U"@"SEL$36" "O"@"SEL$37" "A"@"SEL$36" "U"@"SEL$37" "INT$DBA_PROCEDURES"@"SEL$48") USE_NL(@"SEL$EE64F57D" "O"@"SEL$37") USE_NL(@"SEL$EE64F57D" "A"@"SEL$36")
NLJ_BATCHING(@"SEL$EE64F57D" "A"@"SEL$36") USE_HASH(@"SEL$EE64F57D" "U"@"SEL$37") USE_NL(@"SEL$EE64F57D" "INT$DBA_PROCEDURES"@"SEL$48") SWAP_JOIN_INPUTS(@"SEL$EE64F57D" "U"@"SEL$37") PQ_FILTER(@"SEL$EE64F57D" SERIAL) INDEX_RS_ASC(@"SEL$F7F46460" "U"@"SEL$58" ("USER$"."NAME")) INDEX_RS_ASC(@"SEL$F7F46460" "O"@"SEL$59" ("OBJ$"."OBJ#" "OBJ$"."OWNER#" "OBJ$"."TYPE#")) BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$F7F46460" "O"@"SEL$59") INDEX_FFS(@"SEL$F7F46460" "U"@"SEL$59" ("USER$"."USER#" "USER$"."TYPE#"
"USER$"."SPARE1" "USER$"."SPARE2")) INDEX_RS_ASC(@"SEL$F7F46460" "PI"@"SEL$58" ("PROCEDUREINFO$"."OBJ#" "PROCEDUREINFO$"."PROCEDURENAME" "PROCEDUREINFO$"."OVERLOAD#")) BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$F7F46460" "PI"@"SEL$58") LEADING(@"SEL$F7F46460" "U"@"SEL$58" "O"@"SEL$59" "U"@"SEL$59" "PI"@"SEL$58") USE_NL(@"SEL$F7F46460" "O"@"SEL$59") USE_HASH(@"SEL$F7F46460" "U"@"SEL$59") USE_HASH(@"SEL$F7F46460" "PI"@"SEL$58") SWAP_JOIN_INPUTS(@"SEL$F7F46460" "U"@"SEL$59") PQ_FILTER(@"SEL$F7F46460"
SERIAL) INDEX_RS_ASC(@"SEL$674ECF7B" "U"@"SEL$49" ("USER$"."NAME")) INDEX_RS_ASC(@"SEL$674ECF7B" "PI"@"SEL$49" ("PROCEDUREINFO$"."OBJ#" "PROCEDUREINFO$"."PROCEDURENAME" "PROCEDUREINFO$"."OVERLOAD#")) BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$674ECF7B" "PI"@"SEL$49") INDEX_RS_ASC(@"SEL$674ECF7B" "O"@"SEL$50" ("OBJ$"."OBJ#" "OBJ$"."OWNER#" "OBJ$"."TYPE#")) BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$674ECF7B" "O"@"SEL$50") NO_ACCESS(@"SEL$674ECF7B" "O2"@"SEL$49") INDEX(@"SEL$674ECF7B" "U2"@"SEL$49"
("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) INDEX(@"SEL$674ECF7B" "U"@"SEL$50" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) LEADING(@"SEL$674ECF7B" "U"@"SEL$49" "PI"@"SEL$49" "O"@"SEL$50" "O2"@"SEL$49" "U2"@"SEL$49" "U"@"SEL$50") USE_NL(@"SEL$674ECF7B" "PI"@"SEL$49") USE_HASH(@"SEL$674ECF7B" "O"@"SEL$50") USE_NL(@"SEL$674ECF7B" "O2"@"SEL$49") USE_NL(@"SEL$674ECF7B" "U2"@"SEL$49") USE_NL(@"SEL$674ECF7B" "U"@"SEL$50") PQ_FILTER(@"SEL$674ECF7B"
SERIAL) INDEX_RS_ASC(@"SEL$BF0909A7" "O"@"SEL$54" ("OBJ$"."OBJ#" "OBJ$"."OWNER#" "OBJ$"."TYPE#")) BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$BF0909A7" "O"@"SEL$54") INDEX(@"SEL$BF0909A7" "U"@"SEL$54" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) LEADING(@"SEL$BF0909A7" "O"@"SEL$54" "U"@"SEL$54") USE_NL(@"SEL$BF0909A7" "U"@"SEL$54") PQ_FILTER(@"SEL$BF0909A7" SERIAL) INDEX(@"SEL$57" "O2"@"SEL$57" ("OBJ$"."DATAOBJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#")) INDEX(@"SEL$57" "U2"@"SEL$57"
("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) LEADING(@"SEL$57" "O2"@"SEL$57" "U2"@"SEL$57") USE_NL(@"SEL$57" "U2"@"SEL$57") PARTIAL_JOIN(@"SEL$57" "U2"@"SEL$57") FULL(@"SEL$56" "UE"@"SEL$56") FULL(@"SEL$55" "UE"@"SEL$55") INDEX(@"SEL$53" "O2"@"SEL$53" ("OBJ$"."DATAOBJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#")) INDEX(@"SEL$53" "U2"@"SEL$53" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) LEADING(@"SEL$53" "O2"@"SEL$53" "U2"@"SEL$53") USE_NL(@"SEL$53"
"U2"@"SEL$53") PARTIAL_JOIN(@"SEL$53" "U2"@"SEL$53") FULL(@"SEL$52" "UE"@"SEL$52") FULL(@"SEL$51" "UE"@"SEL$51") INDEX(@"SEL$62" "O2"@"SEL$62" ("OBJ$"."DATAOBJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#")) INDEX(@"SEL$62" "U2"@"SEL$62" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) LEADING(@"SEL$62" "O2"@"SEL$62" "U2"@"SEL$62") USE_NL(@"SEL$62" "U2"@"SEL$62") PARTIAL_JOIN(@"SEL$62" "U2"@"SEL$62") FULL(@"SEL$61" "UE"@"SEL$61") FULL(@"SEL$60" "UE"@"SEL$60") INDEX(@"SEL$40"
"O2"@"SEL$40" ("OBJ$"."DATAOBJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#")) INDEX(@"SEL$40" "U2"@"SEL$40" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) LEADING(@"SEL$40" "O2"@"SEL$40" "U2"@"SEL$40") USE_NL(@"SEL$40" "U2"@"SEL$40") PARTIAL_JOIN(@"SEL$40" "U2"@"SEL$40") FULL(@"SEL$39" "UE"@"SEL$39") FULL(@"SEL$38" "UE"@"SEL$38") INDEX(@"SEL$9DF0D31B" "OBJAUTH$"@"SEL$45" ("OBJAUTH$"."OBJ#" "OBJAUTH$"."GRANTOR#" "OBJAUTH$"."GRANTEE#" "OBJAUTH$"."PRIVILEGE#" "OBJAUTH$"."COL#"))
FULL(@"SEL$9DF0D31B" "X$KZSRO"@"SEL$47") LEADING(@"SEL$9DF0D31B" "OBJAUTH$"@"SEL$45" "X$KZSRO"@"SEL$47") USE_HASH(@"SEL$9DF0D31B" "X$KZSRO"@"SEL$47") PARTIAL_JOIN(@"SEL$9DF0D31B" "X$KZSRO"@"SEL$47") FULL(@"SEL$96D14815" "X$KZSPR"@"SEL$44") INDEX(@"SEL$FCF381C3" "OBJAUTH$"@"SEL$67" ("OBJAUTH$"."OBJ#" "OBJAUTH$"."GRANTOR#" "OBJAUTH$"."GRANTEE#" "OBJAUTH$"."PRIVILEGE#" "OBJAUTH$"."COL#")) FULL(@"SEL$FCF381C3" "X$KZSRO"@"SEL$69") LEADING(@"SEL$FCF381C3" "OBJAUTH$"@"SEL$67" "X$KZSRO"@"SEL$69")
USE_HASH(@"SEL$FCF381C3" "X$KZSRO"@"SEL$69") PARTIAL_JOIN(@"SEL$FCF381C3" "X$KZSRO"@"SEL$69") FULL(@"SEL$70B1039E" "X$KZSPR"@"SEL$66") NO_ACCESS(@"SEL$2" "A"@"SEL$2") INDEX_FFS(@"SEL$3B673E5C" "U"@"SEL$20" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) INDEX_RS_ASC(@"SEL$3B673E5C" "O"@"SEL$20" ("OBJ$"."OWNER#" "OBJ$"."NAME" "OBJ$"."NAMESPACE" "OBJ$"."REMOTEOWNER" "OBJ$"."LINKNAME" "OBJ$"."SUBNAME" "OBJ$"."TYPE#" "OBJ$"."SPARE3" "OBJ$"."OBJ#"))
BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$3B673E5C" "O"@"SEL$20") INDEX_RS_ASC(@"SEL$3B673E5C" "T"@"SEL$19" ("TYPE$"."TVOID")) NO_ACCESS(@"SEL$3B673E5C" "SO"@"SEL$19") INDEX(@"SEL$3B673E5C" "SU"@"SEL$19" "I_USER#") LEADING(@"SEL$3B673E5C" "U"@"SEL$20" "O"@"SEL$20" "T"@"SEL$19" "SO"@"SEL$19" "SU"@"SEL$19") USE_NL(@"SEL$3B673E5C" "O"@"SEL$20") USE_NL(@"SEL$3B673E5C" "T"@"SEL$19") USE_NL(@"SEL$3B673E5C" "SO"@"SEL$19") USE_NL(@"SEL$3B673E5C" "SU"@"SEL$19") PQ_FILTER(@"SEL$3B673E5C" SERIAL)
INDEX_FFS(@"SEL$07BDC5B4" "U"@"SEL$4" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) INDEX_RS_ASC(@"SEL$07BDC5B4" "O"@"SEL$4" ("OBJ$"."OWNER#" "OBJ$"."NAME" "OBJ$"."NAMESPACE" "OBJ$"."REMOTEOWNER" "OBJ$"."LINKNAME" "OBJ$"."SUBNAME" "OBJ$"."TYPE#" "OBJ$"."SPARE3" "OBJ$"."OBJ#")) BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$07BDC5B4" "O"@"SEL$4") INDEX(@"SEL$07BDC5B4" "U"@"SEL$3" "I_USER#") INDEX_RS_ASC(@"SEL$07BDC5B4" "T"@"SEL$3" ("TYPE$"."TVOID")) NO_ACCESS(@"SEL$07BDC5B4"
"SO"@"SEL$3") INDEX(@"SEL$07BDC5B4" "SU"@"SEL$3" "I_USER#") LEADING(@"SEL$07BDC5B4" "U"@"SEL$4" "O"@"SEL$4" "U"@"SEL$3" "T"@"SEL$3" "SO"@"SEL$3" "SU"@"SEL$3") USE_NL(@"SEL$07BDC5B4" "O"@"SEL$4") USE_NL(@"SEL$07BDC5B4" "U"@"SEL$3") USE_NL(@"SEL$07BDC5B4" "T"@"SEL$3") USE_NL(@"SEL$07BDC5B4" "SO"@"SEL$3") USE_NL(@"SEL$07BDC5B4" "SU"@"SEL$3") PQ_FILTER(@"SEL$07BDC5B4" SERIAL) INDEX_RS_ASC(@"SEL$FE7E982E" "O"@"SEL$8" ("OBJ$"."OID$")) BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$FE7E982E" "O"@"SEL$8")
INDEX_FFS(@"SEL$FE7E982E" "U"@"SEL$8" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) LEADING(@"SEL$FE7E982E" "O"@"SEL$8" "U"@"SEL$8") USE_HASH(@"SEL$FE7E982E" "U"@"SEL$8") PQ_FILTER(@"SEL$FE7E982E" SERIAL) INDEX(@"SEL$11" "O2"@"SEL$11" ("OBJ$"."DATAOBJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#")) INDEX(@"SEL$11" "U2"@"SEL$11" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) LEADING(@"SEL$11" "O2"@"SEL$11" "U2"@"SEL$11") USE_NL(@"SEL$11" "U2"@"SEL$11")
PARTIAL_JOIN(@"SEL$11" "U2"@"SEL$11") FULL(@"SEL$10" "UE"@"SEL$10") FULL(@"SEL$9" "UE"@"SEL$9") INDEX(@"SEL$7" "O2"@"SEL$7" ("OBJ$"."DATAOBJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#")) INDEX(@"SEL$7" "U2"@"SEL$7" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) LEADING(@"SEL$7" "O2"@"SEL$7" "U2"@"SEL$7") USE_NL(@"SEL$7" "U2"@"SEL$7") PARTIAL_JOIN(@"SEL$7" "U2"@"SEL$7") FULL(@"SEL$6" "UE"@"SEL$6") FULL(@"SEL$5" "UE"@"SEL$5") FULL(@"SEL$4B882374" "X$KZSPR"@"SEL$18")
INDEX(@"SEL$6C051BA4" "OA"@"SEL$12" ("OBJAUTH$"."OBJ#" "OBJAUTH$"."GRANTOR#" "OBJAUTH$"."GRANTEE#" "OBJAUTH$"."PRIVILEGE#" "OBJAUTH$"."COL#")) FULL(@"SEL$6C051BA4" "X$KZSRO"@"SEL$14") LEADING(@"SEL$6C051BA4" "OA"@"SEL$12" "X$KZSRO"@"SEL$14") USE_HASH(@"SEL$6C051BA4" "X$KZSRO"@"SEL$14") PARTIAL_JOIN(@"SEL$6C051BA4" "X$KZSRO"@"SEL$14") INDEX_RS_ASC(@"SEL$810C4A74" "O"@"SEL$24" ("OBJ$"."OID$")) BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$810C4A74" "O"@"SEL$24") INDEX_FFS(@"SEL$810C4A74" "U"@"SEL$24"
("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) LEADING(@"SEL$810C4A74" "O"@"SEL$24" "U"@"SEL$24") USE_HASH(@"SEL$810C4A74" "U"@"SEL$24") PQ_FILTER(@"SEL$810C4A74" SERIAL) INDEX(@"SEL$27" "O2"@"SEL$27" ("OBJ$"."DATAOBJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#")) INDEX(@"SEL$27" "U2"@"SEL$27" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) LEADING(@"SEL$27" "O2"@"SEL$27" "U2"@"SEL$27") USE_NL(@"SEL$27" "U2"@"SEL$27") PARTIAL_JOIN(@"SEL$27" "U2"@"SEL$27")
FULL(@"SEL$26" "UE"@"SEL$26") FULL(@"SEL$25" "UE"@"SEL$25") INDEX(@"SEL$23" "O2"@"SEL$23" ("OBJ$"."DATAOBJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#")) INDEX(@"SEL$23" "U2"@"SEL$23" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2")) LEADING(@"SEL$23" "O2"@"SEL$23" "U2"@"SEL$23") USE_NL(@"SEL$23" "U2"@"SEL$23") PARTIAL_JOIN(@"SEL$23" "U2"@"SEL$23") FULL(@"SEL$22" "UE"@"SEL$22") FULL(@"SEL$21" "UE"@"SEL$21") FULL(@"SEL$5BC85507" "X$KZSPR"@"SEL$34") INDEX(@"SEL$1C8BC144" "OA"@"SEL$28"
("OBJAUTH$"."OBJ#" "OBJAUTH$"."GRANTOR#" "OBJAUTH$"."GRANTEE#" "OBJAUTH$"."PRIVILEGE#" "OBJAUTH$"."COL#")) FULL(@"SEL$1C8BC144" "X$KZSRO"@"SEL$30") LEADING(@"SEL$1C8BC144" "OA"@"SEL$28" "X$KZSRO"@"SEL$30") USE_HASH(@"SEL$1C8BC144" "X$KZSRO"@"SEL$30") PARTIAL_JOIN(@"SEL$1C8BC144" "X$KZSRO"@"SEL$30") END_OUTLINE_DATA */ arg.package_name AS procedure_cat ,arg.OWNER AS procedure_schem ,arg.object_name AS PROCEDURE_NAME ,arg.argument_name AS column_name ,decode(arg.position, 0, 5, DECODE(arg.in_out,
'IN', 1, 'OUT', 4, 'IN/OUT', 2, 0)) AS column_type ,DECODE(( SELECT a.typecode FROM ALL_TYPES A WHERE a.type_name = arg.data_type ), 'OBJECT', 2002, 'COLLECTION', 2003, DECODE(substr(arg.data_type, 1, 9), 'TIMESTAMP', DECODE(substr(arg.data_type, 10, 1), '(', DECODE(substr(arg.data_type, 19, 5), 'LOCAL', 102, 'TIME ', 101, 93), DECODE(substr(arg.data_type, 16, 5), 'LOCAL', 102, 'TIME', 101, 93)), 'INTERVAL ', DECODE(substr(arg.data_type, 10, 3), 'DAY', 104, 'YEA', 103), DECODE(arg.data_type,
'BINARY_DOUBLE', 101, 'BINARY_FLOAT', 100, 'BFILE', 13, 'BLOB', 2004, 'CHAR', 1, 'CLOB', 2005, 'COLLECTION', 2003, 'DATE', 93, 'FLOAT', 6, 'LONG', 1, 'LONG RAW', 4, 'NCHAR', 15, 'NCLOB', 2011, 'NUMBER', 2, 'NVARCHAR', 9, 'NVARCHAR2', 9, 'OBJECT', 2002, 'OPAQUE/XMLTYPE', 2009, 'RAW', 3, 'REF', 2006, 'ROWID', 8, 'SQLXML', 2009, 'UROWID', 8, 'VARCHAR2', 12, 'VARRAY, 2003, XMLTYPE', 2009, 1111))) AS data_type ,decode(arg.data_type, 'OBJECT', arg.type_owner || '.' || arg.type_name, arg.data_type) AS
type_name ,decode(arg.data_precision, NULL, arg.data_length, arg.data_precision) AS precision ,arg.data_length AS length ,arg.data_scale AS scale ,10 AS radix ,1 AS nullable ,NULL AS remarks ,arg.default_value AS column_def ,NULL AS sql_data_type ,NULL AS sql_datetime_sub ,decode(arg.data_type, 'CHAR', 32767, 'VARCHAR2', 32767, 'LONG', 32767, 'RAW', 32767, 'LONG RAW', 32767, NULL) AS char_octet_length ,(arg.sequence - 1) AS ordinal_position ,'YES' AS is_nullable ,NULL AS specific_name
,arg.sequence ,arg.overload ,arg.default_value FROM all_arguments arg ,all_procedures PROC WHERE arg.OWNER LIKE 'USER_TAXONE_ADM%' ESCAPE '/' AND arg.object_name LIKE 'SAF_PEGA_IDENT%' ESCAPE '/' AND arg.data_level = 0 AND arg.OWNER = PROC.OWNER AND arg.object_id = PROC.object_id AND arg.subprogram_id = PROC.subprogram_id AND arg.package_name IS NULL AND ( arg.argument_name LIKE '%' ESCAPE '/' OR ( arg.argument_name IS NULL AND arg.data_type IS NOT NULL ) ) ORDER BY procedure_schem
,PROCEDURE_NAME ,overload ,sequence
Global Information
------------------------------
Status : DONE (ALL ROWS)
Instance ID : 1
Session : SYS (452:54043)
SQL ID : 1wdf08315gb6p
SQL Execution ID : 16777216
Execution Started : 11/20/2024 09:27:53
First Refresh Time : 11/20/2024 09:27:53
Last Refresh Time : 11/20/2024 09:27:54
Duration : 1s
Module/Action : sqlplus@zdk0n2e4y2ezywi (TNS V1-V3)/-
Service : pdbu0572_1.a261952290908.amazonaws.com
Program : sqlplus@zdk0n2e4y2ezywi (TNS V1-V3)
Fetch Calls : 4
Global Stats
================================================================
| Elapsed | Cpu | IO | Fetch | Buffer | Read | Read |
| Time(s) | Time(s) | Waits(s) | Calls | Gets | Reqs | Bytes |
================================================================
| 0.74 | 0.08 | 0.66 | 4 | 46056 | 1497 | 12MB |
================================================================
SQL Plan Monitoring Details (Plan Hash Value=2322846737)
============================================================================================================================================================================================================
| Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Mem | Activity | Activity Detail |
| | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | (Max) | (%) | (# samples) |
============================================================================================================================================================================================================
| 0 | SELECT STATEMENT | | | | 1 | +1 | 2 | 2 | | | | | |
| 1 | VIEW | ALL_TYPES | 2 | 3981 | 1 | +1 | 2 | 2 | | | | | |
| 2 | SORT UNIQUE | | 2 | 3981 | 1 | +1 | 2 | 2 | | | 2048 | | |
| 3 | UNION-ALL | | | | 1 | +1 | 2 | 2 | | | | | |
| 4 | FILTER | | | | | | 2 | | | | | | |
| 5 | NESTED LOOPS OUTER | | 1 | 1990 | | | 2 | | | | | | |
| 6 | NESTED LOOPS OUTER | | 1 | 1989 | | | 2 | | | | | | |
| 7 | NESTED LOOPS | | 1 | 1982 | 1 | +1 | 2 | 0 | | | | | |
| 8 | NESTED LOOPS | | 1 | 1980 | 1 | +1 | 2 | 2 | | | | | |
| 9 | NESTED LOOPS | | 1 | 1979 | 1 | +1 | 2 | 2 | | | | | |
| 10 | INDEX FAST FULL SCAN | I_USER2 | 987 | 3 | 1 | +1 | 2 | 1974 | | | | | |
| 11 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 1 | 4 | 1 | +1 | 1974 | 2 | | | | | |
| 12 | INDEX RANGE SCAN | I_OBJ2 | 1 | 3 | 1 | +1 | 1974 | 2 | | | | | |
| 13 | TABLE ACCESS CLUSTER | USER$ | 1 | 1 | 1 | +1 | 2 | 2 | | | | | |
| 14 | INDEX UNIQUE SCAN | I_USER# | 1 | | 1 | +1 | 2 | 2 | | | | | |
| 15 | TABLE ACCESS BY INDEX ROWID | TYPE$ | 1 | 2 | 1 | +1 | 2 | 0 | | | | | |
| 16 | INDEX UNIQUE SCAN | I_TYPE2 | 1 | 1 | 1 | +1 | 2 | 2 | | | | | |
| 17 | VIEW PUSHED PREDICATE | _CURRENT_EDITION_OBJ | 1 | 7 | | | | | | | | | |
| 18 | FILTER | | | | | | | | | | | | |
| 19 | HASH JOIN | | 58 | 7 | | | | | | | | | |
| 20 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 58 | 4 | | | | | | | | | |
| 21 | INDEX RANGE SCAN | I_OBJ3 | 1 | 3 | | | | | | | | | |
| 22 | INDEX FAST FULL SCAN | I_USER2 | 987 | 3 | | | | | | | | | |
| 23 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | | | | | | | |
| 24 | NESTED LOOPS SEMI | | 1 | 4 | | | | | | | | | |
| 25 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | | | | | |
| 26 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | | | | | |
| 27 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | | | | | | | |
| 28 | TABLE ACCESS CLUSTER | USER$ | 1 | 1 | | | | | | | | | |
| 29 | INDEX UNIQUE SCAN | I_USER# | 1 | | | | | | | | | | |
| 30 | HASH JOIN SEMI | | 1 | 3 | | | | | | | | | |
| 31 | INDEX RANGE SCAN | I_OBJAUTH1 | 2 | 3 | | | | | | | | | |
| 32 | FIXED TABLE FULL | X$KZSRO | 2 | | | | | | | | | | |
| 33 | FIXED TABLE FULL | X$KZSPR | 8 | | | | | | | | | | |
| 34 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | | | | | | | |
| 35 | NESTED LOOPS SEMI | | 1 | 4 | | | | | | | | | |
| 36 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | | | | | |
| 37 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | | | | | |
| 38 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | | | | | | | |
| 39 | FILTER | | | | 1 | +1 | 2 | 2 | | | | | |
| 40 | NESTED LOOPS OUTER | | 1 | 1989 | 1 | +1 | 2 | 2 | | | | | |
| 41 | NESTED LOOPS OUTER | | 1 | 1988 | 1 | +1 | 2 | 2 | | | | | |
| 42 | NESTED LOOPS | | 1 | 1981 | 1 | +1 | 2 | 2 | | | | | |
| 43 | NESTED LOOPS | | 1 | 1979 | 1 | +1 | 2 | 2 | | | | | |
| 44 | INDEX FAST FULL SCAN | I_USER2 | 987 | 3 | 1 | +1 | 2 | 1974 | | | | | |
| 45 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 1 | 4 | 1 | +1 | 1974 | 2 | | | | | |
| 46 | INDEX RANGE SCAN | I_OBJ2 | 1 | 3 | 1 | +1 | 1974 | 2 | | | | | |
| 47 | TABLE ACCESS BY INDEX ROWID | TYPE$ | 1 | 2 | 1 | +1 | 2 | 2 | | | | | |
| 48 | INDEX UNIQUE SCAN | I_TYPE2 | 1 | 1 | 1 | +1 | 2 | 2 | | | | | |
| 49 | VIEW PUSHED PREDICATE | _CURRENT_EDITION_OBJ | 1 | 7 | | | 2 | | | | | | |
| 50 | FILTER | | | | | | 2 | | | | | | |
| 51 | HASH JOIN | | 58 | 7 | | | 2 | | | | 225K | | |
| 52 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 58 | 4 | | | 2 | | | | | | |
| 53 | INDEX RANGE SCAN | I_OBJ3 | 1 | 3 | | | 2 | | | | | | |
| 54 | INDEX FAST FULL SCAN | I_USER2 | 987 | 3 | | | | | | | | | |
| 55 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | | | | | | | |
| 56 | NESTED LOOPS SEMI | | 1 | 4 | | | | | | | | | |
| 57 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | | | | | |
| 58 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | | | | | |
| 59 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | | | | | | | |
| 60 | TABLE ACCESS CLUSTER | USER$ | 1 | 1 | | | 2 | | | | | | |
| 61 | INDEX UNIQUE SCAN | I_USER# | 1 | | | | 2 | | | | | | |
| 62 | HASH JOIN SEMI | | 1 | 3 | | | | | | | | | |
| 63 | INDEX RANGE SCAN | I_OBJAUTH1 | 2 | 3 | | | | | | | | | |
| 64 | FIXED TABLE FULL | X$KZSRO | 2 | | | | | | | | | | |
| 65 | FIXED TABLE FULL | X$KZSPR | 8 | | | | | | | | | | |
| 66 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | 1 | | | | | | |
| 67 | NESTED LOOPS SEMI | | 1 | 4 | | | | | | | | | |
| 68 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | | | | | |
| 69 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | | | | | |
| 70 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | | | | | | | |
| 71 | SORT ORDER BY | | 5 | 29M | 1 | +1 | 1 | 3 | | | 2048 | | |
| 72 | FILTER | | | | 1 | +1 | 1 | 3 | | | | | |
| 73 | NESTED LOOPS | | 53 | 29M | 1 | +1 | 1 | 3 | | | | | |
| 74 | HASH JOIN | | 171K | 24M | 1 | +1 | 1 | 3 | | | 1M | | |
| 75 | INDEX FAST FULL SCAN | I_USER2 | 987 | 3 | 1 | +1 | 1 | 987 | | | | | |
| 76 | NESTED LOOPS | | 171K | 24M | 1 | +1 | 1 | 3 | | | | | |
| 77 | NESTED LOOPS | | 6M | 24M | 1 | +1 | 1 | 3 | | | | | |
| 78 | NESTED LOOPS | | 6M | 3M | 1 | +1 | 1 | 8236 | | | | | |
| 79 | TABLE ACCESS BY INDEX ROWID BATCHED | USER$ | 843 | 743 | 1 | +1 | 1 | 1 | | | | | |
| 80 | INDEX RANGE SCAN | I_USER1 | 843 | 7 | 1 | +1 | 1 | 1 | | | | | |
| 81 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 7483 | 4611 | 1 | +1 | 1 | 8236 | | | | | |
| 82 | INDEX RANGE SCAN | I_OBJ5 | 7483 | 183 | 1 | +1 | 1 | 8236 | 178 | 1MB | | 100.00 | db file sequential read (1) |
| 83 | INDEX RANGE SCAN | I_ARGUMENT1 | 1 | 3 | 1 | +1 | 8236 | 3 | 1316 | 10MB | | | |
| 84 | TABLE ACCESS BY INDEX ROWID | ARGUMENT$ | 1 | 4 | 1 | +1 | 3 | 3 | | | | | |
| 85 | VIEW | INT$DBA_PROCEDURES | 1 | 28 | 1 | +1 | 3 | 3 | | | | | |
| 86 | UNION ALL PUSHED PREDICATE | | | | 1 | +1 | 3 | 3 | | | | | |
| 87 | FILTER | | | | 1 | +1 | 3 | 3 | | | | | |
| 88 | FILTER | | | | 1 | +1 | 3 | 3 | | | | | |
| 89 | NESTED LOOPS | | 1 | 16 | 1 | +1 | 3 | 3 | | | | | |
| 90 | NESTED LOOPS OUTER | | 1 | 15 | 1 | +1 | 3 | 3 | | | | | |
| 91 | NESTED LOOPS OUTER | | 1 | 14 | 1 | +1 | 3 | 3 | | | | | |
| 92 | HASH JOIN | | 1 | 9 | 1 | +1 | 3 | 3 | | | 423K | | |
| 93 | NESTED LOOPS | | 3 | 5 | 1 | +1 | 3 | 3 | | | | | |
| 94 | TABLE ACCESS BY INDEX ROWID | USER$ | 1 | 2 | 1 | +1 | 3 | 3 | | | | | |
| 95 | INDEX UNIQUE SCAN | I_USER1 | 1 | 1 | 1 | +1 | 3 | 3 | | | | | |
| 96 | TABLE ACCESS BY INDEX ROWID BATCHED | PROCEDUREINFO$ | 3 | 3 | 1 | +1 | 3 | 3 | 1 | 8192 | | | |
| 97 | INDEX RANGE SCAN | I_PROCEDUREINFO1 | 3 | 2 | 1 | +1 | 3 | 3 | 2 | 16384 | | | |
| 98 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 1 | 4 | 1 | +1 | 3 | 3 | | | | | |
| 99 | INDEX RANGE SCAN | I_OBJ1 | 1 | 3 | 1 | +1 | 3 | 3 | | | | | |
| 100 | VIEW PUSHED PREDICATE | _CURRENT_EDITION_OBJ | 1 | 5 | | | 3 | | | | | | |
| 101 | FILTER | | | | | | 3 | | | | | | |
| 102 | NESTED LOOPS | | 1 | 5 | | | 3 | | | | | | |
| 103 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 1 | 4 | | | 3 | | | | | | |
| 104 | INDEX RANGE SCAN | I_OBJ1 | 1 | 3 | | | 3 | | | | | | |
| 105 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | | | | | |
| 106 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | | | | | | | |
| 107 | NESTED LOOPS SEMI | | 1 | 4 | | | | | | | | | |
| 108 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | | | | | |
| 109 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | | | | | |
| 110 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | | | | | | | |
| 111 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | 3 | | | | | | |
| 112 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | 1 | +1 | 3 | 3 | | | | | |
| 113 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | 1 | | | | | | |
| 114 | NESTED LOOPS SEMI | | 1 | 4 | | | | | | | | | |
| 115 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | | | | | |
| 116 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | | | | | |
| 117 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | | | | | | | |
| 118 | FILTER | | | | | | 3 | | | | | | |
| 119 | FILTER | | | | | | 3 | | | | | | |
| 120 | FILTER | | | | | | 3 | | | | | | |
| 121 | HASH JOIN OUTER | | 1 | 12 | | | 3 | | | | 183K | | |
| 122 | HASH JOIN | | 1 | 8 | 1 | +1 | 3 | 0 | | | 1M | | |
| 123 | INDEX FAST FULL SCAN | I_USER2 | 987 | 3 | 1 | +1 | 3 | 2961 | | | | | |
| 124 | NESTED LOOPS | | 1 | 5 | 1 | +1 | 3 | 0 | | | | | |
| 125 | TABLE ACCESS BY INDEX ROWID | USER$ | 1 | 2 | 1 | +1 | 3 | 3 | | | | | |
| 126 | INDEX UNIQUE SCAN | I_USER1 | 1 | 1 | 1 | +1 | 3 | 3 | | | | | |
| 127 | TABLE ACCESS BY INDEX ROWID BATCHED | OBJ$ | 1 | 3 | | | 3 | | | | | | |
| 128 | INDEX RANGE SCAN | I_OBJ1 | 1 | 2 | | | 3 | | | | | | |
| 129 | TABLE ACCESS BY INDEX ROWID BATCHED | PROCEDUREINFO$ | 3 | 4 | | | | | | | | | |
| 130 | INDEX RANGE SCAN | I_PROCEDUREINFO1 | 3 | 3 | | | | | | | | | |
| 131 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | | | | | | | |
| 132 | NESTED LOOPS SEMI | | 1 | 4 | | | | | | | | | |
| 133 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | | | | | |
| 134 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | | | | | |
| 135 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | | | | | | | |
| 136 | FIXED TABLE FULL | X$KZSPR | 1 | | 1 | +1 | 1 | 1 | | | | | |
| 137 | HASH JOIN SEMI | | 1 | 3 | | | | | | | | | |
| 138 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 3 | | | | | | | | | |
| 139 | FIXED TABLE FULL | X$KZSRO | 2 | | | | | | | | | | |
| 140 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | 1 | | | | | | |
| 141 | NESTED LOOPS SEMI | | 1 | 4 | | | | | | | | | |
| 142 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | | | | | |
| 143 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | | | | | |
| 144 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 | | | | | | | | | |
| 145 | FIXED TABLE FULL | X$KZSPR | 1 | | 1 | +1 | 1 | 1 | | | | | |
| 146 | HASH JOIN SEMI | | 1 | 3 | | | | | | | | | |
| 147 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 3 | | | | | | | | | |
| 148 | FIXED TABLE FULL | X$KZSRO | 2 | | | | | | | | | | |
============================================================================================================================================================================================================
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment