Skip to content

Instantly share code, notes, and snippets.

@Satalabaha

Satalabaha/gist:28afc543cb43662c3934ebb836d9c627

Created November 20, 2024 13:10
Show Gist options
  • Save Satalabaha/28afc543cb43662c3934ebb836d9c627 to your computer and use it in GitHub Desktop.
Save Satalabaha/28afc543cb43662c3934ebb836d9c627 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle19c_DictQuery_2
Raw
gistfile1.txt
SQL> SELECT
/*+
BEGIN_OUTLINE_DATA
MONITOR
IGNORE_OPTIM_EMBEDDED_HINTS
2 3 4 5 6 OPTIMIZER_FEATURES_ENABLE('12.1.0.2')
OPT_PARAM('container_data' 'current_directory')
DB_VERSION('12.1.0.2')
OPT_PARAM('_px_adaptive_dist_method' 'off')
OPT_PARAM('_optimizer_strans_adaptive_pruning' 'false')
OPT_PARAM('_o 7 ptimizer_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")
8 9 10 11 12 13 14 15 16 17 18 19 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(@"SE 20 L$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_LEA 21 F(@"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")
22 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(@ 23 "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( 24 @"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")
25 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$ 26 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")
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 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")
82 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")
83 MERGE(@"SEL$50")
OUTLINE(@"SEL$260377DE")
MERGE(@"SEL$59")
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 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")
112 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")
113 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(114 @"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")
115 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$3116 6" ("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$"."LINKN117 AME" "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#"))
118 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"119 "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")120
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$F7F4646121 0" "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"
"PROCEDUR122 EINFO$"."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"@"SE123 L$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" "124 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#" "OB125 J$"."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$6126 74ECF7B" "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_H127 ASH(@"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#" "OB128 J$"."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$".129 "SPARE2"))
LEADING(@"SEL$BF0909A7" 130 "O"@"SEL$54" "U"@"SEL$54")
131 USE_NL(@"SEL$BF0909A7132 " "U"@"SEL$54")
PQ_133 FILTER(@"SEL$BF0909A7" SE134 RIAL)
INDEX(@"SEL$5135 7" "O2"@"SEL$57" ("OBJ$"."DATAO136 BJ#" "OBJ$"."TYPE#" "OB137 J$"."OWNER#"))
INDE138 X(@"SEL$57" "U2"@"SEL$57"139 ("USER$"."USER#" "USER$"140 ."TYPE#" "USER$"."SPARE1"141 "USER$"."SPARE2"))
142 LEADING(@"SEL$57" "O2"@"143 SEL$57" "U2"@"SEL$57")
144 USE_NL(@"SEL$57" "U2"@"SEL$145 57")
PARTIAL_JOIN146 (@"SEL$57" "U2"@"SEL$57")147
FULL(@"SEL$56" "UE148 "@"SEL$56")
FULL(@"149 SEL$55" "UE"@"SEL$55")
150 INDEX(@"SEL$53" "O2"@151 "SEL$53" ("OBJ$"."DATAOBJ152 #" "OBJ$"."TYPE#" "OBJ$".153 "OWNER#"))
INDEX(@"154 SEL$53" "U2"@"SEL$53" ("U155 SER$"."USER#" "USER$"."TY156 PE#" "USER$"."SPARE1" "USER$"."SPARE2"))
LEADING(@"SEL$53" "157 O2"@"SEL$53" "U2"@"SEL$53")
USE_NL(@"SEL$53" "U2"@"SEL$53"158 )
PARTIAL_JOIN(@"SEL$53" "U2"@"SEL$53")
FULL(@"SEL$52" "UE"@"SEL$52")
FULL(@"SEL$51" "UE"@"SEL$159 51")
INDEX(@"SEL$62" "O2"@"SEL$62" ("OBJ$"."DATAOBJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#"))
IND160 EX(@"SEL$62" "U2"@"SEL$62" ("USER$"."USER#" "USER$"."TYPE#" "USE161 R$"."SPARE1" "USER$"."SPARE2"))
LEADING(@"SEL$62" "O2"@"SEL$62" "U2"@"SEL$62")
USE_NL(@"SEL$62" "U162 2"@"SEL$62")
PARTIAL_JOIN(@"SEL$62163 " "U2"@"SEL$62")
FULL(@"SEL$61" "UE"@"SEL$61")
FULL(@"SEL$60" "UE"@"SEL$60")
INDEX(@"SEL$40" "O2164 "@"SEL$40" ("OBJ$"."DATAOBJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#"))
165 INDEX(@"SEL$40" "U2"@"SEL$40" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPARE2"))
LE166 ADING(@"SEL$40" "O2"@"SEL$40" "U2"@"SEL$40"167 )
USE_NL(@"SEL$40" "U2"@"SEL$40")
168 PARTIAL_JOIN(@"SEL$40" "U2"@"SEL$40")
FU169 LL(@"SEL$39" "UE"@"SEL$39")
FULL(@"SEL$170 38" "UE"@"SEL$38")
INDEX(@"SEL$9DF0D31B" "OBJAUTH$"@"S171 EL$45" ("OBJAUTH$"."OBJ#" "OBJAUTH$"."GRANTOR#" "OBJA172 UTH$"."GRANTEE#"
"OBJAUTH$173 "."PRIVILEGE#" "OBJAUTH$"."COL#"))
FULL(@"SEL$9DF0D31B" "X$K174 ZSRO"@"SEL$47")
LEADING(@"SEL$9DF0D31B" "OBJAUTH$"@"SEL$45" "X$KZSRO"@"SEL$47")
USE_175 HASH(@"SEL$9DF0D31B" "X$KZSRO"@"SEL$47")
PARTIAL_JOIN(@"SE176 L$9DF0D31B" "X$KZSRO"@"SEL$47")
FULL(@"SEL$96D14815" "X$KZSPR"@"SEL$44")
INDEX(@"SEL$FCF381C3" "OBJAUT177 H$"@"SEL$67" ("OBJAUTH$"."OBJ#" "OBJAUTH$"."GRANTOR#" "OBJAUTH$"."GRANTEE#"
"OBJAUTH$"."PRIVI178 LEGE#" "OBJAUTH$"."COL#"))
FULL(@"SEL$F179 CF381C3" "X$KZSRO"@"SEL$69")
LEADING(@"SEL$FCF381C3" "OBJAU180 TH$"@"SEL$67" "X$KZSRO"@"SEL$69")
USE_HASH(@"SEL$FCF381C3" "X$KZSRO"@"SEL$69")181
PARTIAL_JOIN(@"SEL$FCF381C3" "X$KZSR182 O"@"SEL$69")
FULL(@"SEL$70B1039E" "X$KZ183 SPR"@"SEL$66")
NO_ACCESS(@"SEL$2" "A"@"S184 EL$2")
INDEX_FFS(@"SEL$3B673E5C" "U"@"SEL$20" (185 "USER$"."USER#" "USER$"."TYPE#" "USER$".186 "SPARE1" "USER$"."SPARE2"))
INDEX_RS_ASC(@"SEL$3B673E5C" "O"187 @"SEL$20" ("OBJ$"."OWNER#" "OBJ$"."NAME" "OBJ$"."NAMESPACE" "OBJ$"."REMOTEOWNER"
"OBJ$"."LINK188 NAME" "OBJ$"."SUBNAME" "OBJ$"."TYPE#" "OBJ$".189 "SPARE3" "OBJ$"."OBJ#"))
BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$190 3B673E5C" "O"@"SEL$20")
INDEX_RS_ASC(@"SEL$3B673E5C" "T"@"SEL$19" ("TYPE$"."TVOID"))
191 NO_ACCESS(@"SEL$3B673E5C" "SO"@"SEL$19")
INDEX(@"SEL$3B67192 3E5C" "SU"@"SEL$19" "I_USER#")
LEADING(@"193 SEL$3B673E5C" "U"@"SEL$20" "O"@"SEL$20" "T"@"SEL$19" "SO"@"SEL$19" "SU"@"SEL$19")
USE_NL(@"SEL$3B673E5C" 194 "O"@"SEL$20")
USE_NL(@"SEL$3B673E5C" "T"@"SEL$19")
USE_NL(@"SEL$3B673E5C" "SO"@"SEL$19")
USE195 _NL(@"SEL$3B673E5C" "SU"@"SEL$19")
PQ_FILTER(@"SEL$3B673E5C" SERIAL)
INDEX_FFS(@"SEL$07BDC5B4" "U"@"196 SEL$4" ("USER$"."USER#" "USER$"."TYPE#" "USE197 R$"."SPARE1" "USER$"."SPARE2"))
INDEX_R198 S_ASC(@"SEL$07BDC5B4" "O"@"SEL$4" ("OBJ$"."O199 WNER#" "OBJ$"."NAME" "OBJ$"."NAMESPACE" "OBJ200 $"."REMOTEOWNER"
"OBJ$"."LINK201 NAME" "OBJ$"."SUBNAME" "OBJ$"."TYPE#" "O202 BJ$"."SPARE3" "OBJ$"."OBJ#"))
BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$07BDC5B4" "O"@"SEL$4")
203 INDEX(@"SEL$07BDC5B4" "U"@"SEL$3" "I_USER#")
INDEX_RS_A204 SC(@"SEL$07BDC5B4" "T"@"SEL$3" ("TYPE$"."TVOID"))
NO_ACCESS(@"SEL$07BDC5B4" "SO"@"SEL$3")
INDEX(@"205 SEL$07BDC5B4" "SU"@"SEL$3" "I_USER#")
LEADING(@"SEL206 $07BDC5B4" "U"@"SEL$4" "O"@"SEL$4" "U"@"SEL207 $3" "T"@"SEL$3" "SO"@"SEL$3" "SU"@"SEL$3208 ")
USE_NL(@"SEL$07BDC5B4" "O"@"SEL$4")
USE_NL(@"SEL$07BDC5B4" "U"@"SEL$3")
209 USE_NL(@"SEL$07BDC5B4" "T"@"SEL$3")
USE_NL(@"SEL$07BDC5B4" "SO"@"SEL$3")
USE_NL(@"SEL$07210 BDC5B4" "SU"@"SEL$3")
PQ_FILTER(@"SEL$07BDC5B4"211 SERIAL)
INDEX_RS_ASC(@"SEL$FE7E212 982E" "O"@"SEL$8" ("OBJ$"."OID$"))
BAT213 CH_TABLE_ACCESS_BY_ROWID(@"SEL$FE7E9214 82E" "O"@"SEL$8")
INDEX_FFS(@"215 SEL$FE7E982E" "U"@"SEL$8" ("USER$"."USER#" "USER$"."TYPE#" "USER$"."SPARE1" "USER$"."SPA216 RE2"))
LEADING(@"SEL$FE7E982E" "O"@"SEL$8" "U"@"SEL$8")
USE_HASH(@"SEL$FE7E982E" "U"@"SEL$8")217
PQ_FILTER(@"SEL$FE7E982E" SERIAL)
INDEX(218 @"SEL$11" "O2"@"SEL$11" ("OBJ$"."DATAO219 BJ#" "OBJ$"."TYPE#" "OBJ$"."OWNER#"))
220 INDEX(@"SEL$11" "U2"@"SEL$11" ("USER221 $"."USER#" "USER$"."TYPE#" "USER$"."222 SPARE1" "USER$"."SPARE2"))
LEADING(@"SEL$11" "O2"@"SEL$11" "U2"@"SEL$11")
US223 E_NL(@"SEL$11" "U2"@"SEL$11")
PARTIAL_JOIN(@"SEL$11" "U2"@"SEL$11")
FULL(@"SEL$10" "UE"@"SEL$224 10")
FULL(@"SEL$9" "UE"@"SEL$9")
INDEX(@"225 SEL$7" "O2"@"SEL$7" ("OBJ$"."DATAOBJ#"226 "OBJ$"."TYPE#" "OBJ$"."OWNER#"))
227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 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$"."CO294 L#"))
FULL(@"SEL$6C051BA4" "X$KZSRO"@"SEL$14")
LEADING(@"SEL$6C051BA4" "OA"@"SEL$12" "X$KZSRO"@"SEL$14")
295 296 297 298 299 300 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)
INDE301 X(@"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" "302 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#"))303
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
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 ,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
339 340 341 342 343 344 ), '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 A345 S 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
346 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;
347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
S SEQUENCE
- ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
32767 0
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_NULLABLE
--------------------------------------------------------------------------------
S SEQUENCE
- ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
YES
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_NULLABLE
--------------------------------------------------------------------------------
S SEQUENCE
- ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
S SEQUENCE
- ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
32767 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_NULLABLE
--------------------------------------------------------------------------------
S SEQUENCE
- ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
YES
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_NULLABLE
--------------------------------------------------------------------------------
S SEQUENCE
- ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
S SEQUENCE
- ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
S SEQUENCE
- ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
YES
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_NULLABLE
--------------------------------------------------------------------------------
S SEQUENCE
- ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
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_NULLABLE
--------------------------------------------------------------------------------
S SEQUENCE
- ----------
OVERLOAD
--------------------------------------------------------------------------------
DEFAULT_VALUE
--------------------------------------------------------------------------------
3 rows selected.
SQL_ID: 6f9csgt0as1m1
Elapsed: 00:00:44.25
SQL> SQL> @display
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID 6f9csgt0as1m1, child number 1
-------------------------------------
SELECT /*+ BEGIN_OUTLINE_DATA MONITOR
IGNORE_OPTIM_EMBEDDED_HINTS OPTIMIZER_FEATURES_ENABLE('12.1.0.2')
OPT_PARAM('container_data' 'current_directory')
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"
Plan hash value: 1257791643
-------------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | OMem | 1Mem | Used-Mem |
-------------------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | 3 |00:00:44.15 | 5325K| | | |
| 1 | VIEW | ALL_TYPES | 2 | 2 | 2 |00:00:24.15 | 3298K| | | |
| 2 | SORT UNIQUE | | 2 | 2 | 2 |00:00:24.15 | 3298K| 2048 | 2048 | 2048 (0)|
| 3 | UNION-ALL | | 2 | | 2 |00:00:24.15 | 3298K| | | |
|* 4 | FILTER | | 2 | | 0 |00:00:00.01 | 5592 | | | |
| 5 | NESTED LOOPS OUTER | | 2 | 1 | 0 |00:00:00.01 | 5592 | | | |
|* 6 | HASH JOIN OUTER | | 2 | 1 | 0 |00:00:00.01 | 5592 | 787K| 787K| 207K (0)|
| 7 | NESTED LOOPS | | 2 | 1 | 0 |00:00:00.01 | 5592 | | | |
| 8 | NESTED LOOPS | | 2 | 1 | 2 |00:00:00.01 | 5584 | | | |
| 9 | NESTED LOOPS | | 2 | 1 | 2 |00:00:00.01 | 5578 | | | |
| 10 | INDEX FAST FULL SCAN | I_USER2 | 2 | 1008 | 2016 |00:00:00.01 | 14 | | | |
|* 11 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 2016 | 1 | 2 |00:00:00.01 | 5564 | | | |
|* 12 | INDEX RANGE SCAN | I_OBJ2 | 2016 | 1 | 2 |00:00:00.01 | 5562 | | | |
| 13 | TABLE ACCESS CLUSTER | USER$ | 2 | 1 | 2 |00:00:00.01 | 6 | | | |
|* 14 | INDEX UNIQUE SCAN | I_USER# | 2 | 1 | 2 |00:00:00.01 | 4 | | | |
|* 15 | TABLE ACCESS BY INDEX ROWID | TYPE$ | 2 | 1 | 0 |00:00:00.01 | 8 | | | |
|* 16 | INDEX UNIQUE SCAN | I_TYPE2 | 2 | 1 | 2 |00:00:00.01 | 6 | | | |
| 17 | VIEW | _CURRENT_EDITION_OBJ | 0 | 15M| 0 |00:00:00.01 | 0 | | | |
|* 18 | FILTER | | 0 | | 0 |00:00:00.01 | 0 | | | |
|* 19 | HASH JOIN | | 0 | 15M| 0 |00:00:00.01 | 0 | 1196K| 1196K| |
| 20 | INDEX FAST FULL SCAN | I_USER2 | 0 | 1008 | 0 |00:00:00.01 | 0 | | | |
| 21 | TABLE ACCESS FULL | OBJ$ | 0 | 15M| 0 |00:00:00.01 | 0 | | | |
|* 22 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 23 | INDEX RANGE SCAN | I_USER_EDITIONING | 0 | 2 | 0 |00:00:00.01 | 0 | | | |
| 24 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 25 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 26 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 27 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 28 | INDEX RANGE SCAN | I_USER_EDITIONING | 0 | 2 | 0 |00:00:00.01 | 0 | | | |
| 29 | TABLE ACCESS CLUSTER | USER$ | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 30 | INDEX UNIQUE SCAN | I_USER# | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 31 | FILTER | | 0 | | 0 |00:00:00.01 | 0 | | | |
|* 32 | INDEX RANGE SCAN | I_OBJAUTH1 | 0 | 2 | 0 |00:00:00.01 | 0 | | | |
|* 33 | FIXED TABLE FULL | X$KZSRO | 0 | 50 | 0 |00:00:00.01 | 0 | | | |
|* 34 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 35 | INDEX RANGE SCAN | I_USER_EDITIONING | 0 | 2 | 0 |00:00:00.01 | 0 | | | |
| 36 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 37 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 38 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 39 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 40 | INDEX RANGE SCAN | I_USER_EDITIONING | 0 | 2 | 0 |00:00:00.01 | 0 | | | |
|* 41 | FILTER | | 2 | | 2 |00:00:24.15 | 3292K| | | |
| 42 | NESTED LOOPS OUTER | | 2 | 1 | 2 |00:00:24.15 | 3292K| | | |
|* 43 | HASH JOIN OUTER | | 2 | 1 | 2 |00:00:24.15 | 3292K| 938K| 938K| 445K (0)|
| 44 | NESTED LOOPS | | 2 | 1 | 2 |00:00:00.01 | 5586 | | | |
| 45 | NESTED LOOPS | | 2 | 1 | 2 |00:00:00.01 | 5578 | | | |
| 46 | INDEX FAST FULL SCAN | I_USER2 | 2 | 1008 | 2016 |00:00:00.01 | 14 | | | |
|* 47 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 2016 | 1 | 2 |00:00:00.01 | 5564 | | | |
|* 48 | INDEX RANGE SCAN | I_OBJ2 | 2016 | 1 | 2 |00:00:00.01 | 5562 | | | |
|* 49 | TABLE ACCESS BY INDEX ROWID | TYPE$ | 2 | 1 | 2 |00:00:00.01 | 8 | | | |
|* 50 | INDEX UNIQUE SCAN | I_TYPE2 | 2 | 1 | 2 |00:00:00.01 | 6 | | | |
| 51 | VIEW | _CURRENT_EDITION_OBJ | 2 | 15M| 30M|00:00:20.37 | 3286K| | | |
|* 52 | FILTER | | 2 | | 30M|00:00:17.78 | 3286K| | | |
|* 53 | HASH JOIN | | 2 | 15M| 30M|00:00:09.88 | 469K| 1651K| 1651K| 1689K (0)|
| 54 | INDEX FAST FULL SCAN | I_USER2 | 2 | 1008 | 2016 |00:00:00.01 | 14 | | | |
| 55 | TABLE ACCESS FULL | OBJ$ | 2 | 15M| 30M|00:00:03.70 | 469K| | | |
|* 56 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 2817K| 1 | 1 |00:00:02.22 | 2817K| | | |
|* 57 | INDEX RANGE SCAN | I_USER_EDITIONING | 2817K| 2 | 1 |00:00:01.67 | 2817K| | | |
| 58 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 59 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 60 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 61 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 62 | INDEX RANGE SCAN | I_USER_EDITIONING | 0 | 2 | 0 |00:00:00.01 | 0 | | | |
| 63 | TABLE ACCESS CLUSTER | USER$ | 2 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 64 | INDEX UNIQUE SCAN | I_USER# | 2 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 65 | FILTER | | 0 | | 0 |00:00:00.01 | 0 | | | |
|* 66 | INDEX RANGE SCAN | I_OBJAUTH1 | 0 | 2 | 0 |00:00:00.01 | 0 | | | |
|* 67 | FIXED TABLE FULL | X$KZSRO | 0 | 50 | 0 |00:00:00.01 | 0 | | | |
|* 68 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 1 | 0 |00:00:00.01 | 1 | | | |
|* 69 | INDEX RANGE SCAN | I_USER_EDITIONING | 1 | 2 | 0 |00:00:00.01 | 1 | | | |
| 70 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 71 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 72 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 73 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|* 74 | INDEX RANGE SCAN | I_USER_EDITIONING | 0 | 2 | 0 |00:00:00.01 | 0 | | | |
| 75 | SORT ORDER BY | | 1 | 1 | 3 |00:00:44.15 | 5325K| 2048 | 2048 | 2048 (0)|
|* 76 | FILTER | | 1 | | 3 |00:00:20.00 | 2027K| | | |
| 77 | NESTED LOOPS | | 1 | 1 | 3 |00:00:20.00 | 2027K| | | |
| 78 | NESTED LOOPS | | 1 | 1 | 3 |00:00:20.00 | 2027K| | | |
|* 79 | HASH JOIN | | 1 | 679 | 20362 |00:00:19.90 | 1998K| 3345K| 1217K| 3530K (0)|
|* 80 | HASH JOIN | | 1 | 592K| 20558 |00:00:16.49 | 1764K| 1399K| 1399K| 750K (0)|
|* 81 | TABLE ACCESS FULL | USER$ | 1 | 841 | 1 |00:00:00.01 | 82 | | | |
| 82 | VIEW | INT$DBA_PROCEDURES | 1 | 592K| 20558 |00:00:16.48 | 1764K| | | |
| 83 | UNION-ALL | | 1 | | 20558 |00:00:16.48 | 1764K| | | |
|* 84 | FILTER | | 1 | | 18743 |00:00:16.46 | 1756K| | | |
|* 85 | HASH JOIN OUTER | | 1 | 549K| 18743 |00:00:16.45 | 1756K| 3067K| 1228K| 10M (0)|
|* 86 | HASH JOIN OUTER | | 1 | 549K| 18743 |00:00:16.44 | 1756K| 3067K| 1228K| 10M (0)|
|* 87 | HASH JOIN | | 1 | 549K| 18743 |00:00:03.38 | 112K| 1754K| 1221K| 11M (0)|
|* 88 | HASH JOIN | | 1 | 189K| 8256 |00:00:00.02 | 8207 | 1683K| 1282K| 3304K (0)|
| 89 | NESTED LOOPS | | 1 | 189K| 8256 |00:00:00.01 | 8200 | | | |
|* 90 | TABLE ACCESS FULL | USER$ | 1 | 841 | 1 |00:00:00.01 | 82 | | | |
|* 91 | TABLE ACCESS BY INDEX ROWID| OBJ$ | 1 | 225 | 8256 |00:00:00.01 | 8118 | | | |
|* 92 | INDEX RANGE SCAN | I_OBJ5 | 1 | | 8256 |00:00:00.01 | 125 | | | |
| 93 | INDEX FAST FULL SCAN | I_USER2 | 1 | 1008 | 1008 |00:00:00.01 | 7 | | | |
| 94 | TABLE ACCESS FULL | PROCEDUREINFO$ | 1 | 14M| 14M|00:00:01.26 | 104K| | | |
| 95 | VIEW | _CURRENT_EDITION_OBJ | 1 | 15M| 15M|00:00:10.38 | 1643K| | | |
|* 96 | FILTER | | 1 | | 15M|00:00:09.11 | 1643K| | | |
|* 97 | HASH JOIN | | 1 | 15M| 15M|00:00:05.20 | 234K| 1695K| 1695K| 1741K (0)|
| 98 | INDEX FAST FULL SCAN | I_USER2 | 1 | 1008 | 1008 |00:00:00.01 | 7 | | | |
| 99 | TABLE ACCESS FULL | OBJ$ | 1 | 15M| 15M|00:00:02.03 | 234K| | | |
|*100 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1409K| 1 | 1 |00:00:01.11 | 1409K| | | |
|*101 | INDEX RANGE SCAN | I_USER_EDITIONING | 1409K| 2 | 1 |00:00:00.84 | 1409K| | | |
| 102 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*103 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*104 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*105 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*106 | INDEX RANGE SCAN | I_USER_EDITIONING | 0 | 2 | 0 |00:00:00.01 | 0 | | | |
| 107 | INDEX FAST FULL SCAN | I_USER2 | 1 | 1008 | 1008 |00:00:00.01 | 7 | | | |
|*108 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 4 | 1 | 0 |00:00:00.01 | 4 | | | |
|*109 | INDEX RANGE SCAN | I_USER_EDITIONING | 4 | 2 | 0 |00:00:00.01 | 4 | | | |
| 110 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*111 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*112 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*113 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*114 | INDEX RANGE SCAN | I_USER_EDITIONING | 0 | 2 | 0 |00:00:00.01 | 0 | | | |
|*115 | FILTER | | 1 | | 1815 |00:00:00.02 | 7228 | | | |
|*116 | FILTER | | 1 | | 1815 |00:00:00.02 | 7226 | | | |
| 117 | NESTED LOOPS OUTER | | 1 | 44484 | 14556 |00:00:00.02 | 7226 | | | |
|*118 | HASH JOIN | | 1 | 47000 | 1989 |00:00:00.01 | 1240 | 951K| 951K| 1009K (0)|
| 119 | NESTED LOOPS | | 1 | 47000 | 1989 |00:00:00.01 | 1233 | | | |
|*120 | TABLE ACCESS FULL | USER$ | 1 | 841 | 1 |00:00:00.01 | 82 | | | |
|*121 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 1 | 56 | 1989 |00:00:00.01 | 1151 | | | |
|*122 | INDEX RANGE SCAN | I_OBJ5 | 1 | | 1989 |00:00:00.01 | 125 | | | |
| 123 | INDEX FAST FULL SCAN | I_USER2 | 1 | 1008 | 1008 |00:00:00.01 | 7 | | | |
| 124 | TABLE ACCESS BY INDEX ROWID | PROCEDUREINFO$ | 1989 | 3 | 14346 |00:00:00.01 | 5986 | | | |
|*125 | INDEX RANGE SCAN | I_PROCEDUREINFO1 | 1989 | 3 | 14346 |00:00:00.01 | 3662 | | | |
|*126 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 2 | 1 | 0 |00:00:00.01 | 2 | | | |
|*127 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 2 | 0 |00:00:00.01 | 2 | | | |
| 128 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*129 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*130 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*131 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*132 | INDEX RANGE SCAN | I_USER_EDITIONING | 0 | 2 | 0 |00:00:00.01 | 0 | | | |
|*133 | TABLE ACCESS FULL | OBJ$ | 1 | 6417K| 6462K|00:00:02.42 | 234K| | | |
|*134 | TABLE ACCESS BY INDEX ROWID | ARGUMENT$ | 20362 | 1 | 3 |00:00:00.09 | 28292 | | | |
|*135 | INDEX RANGE SCAN | I_ARGUMENT2 | 20362 | 1 | 98491 |00:00:00.03 | 20991 | | | |
|*136 | INDEX RANGE SCAN | I_USER2 | 3 | 1 | 3 |00:00:00.01 | 5 | | | |
|*137 | FIXED TABLE FULL | X$KZSPR | 1 | 1 | 1 |00:00:00.01 | 0 | | | |
|*138 | FILTER | | 0 | | 0 |00:00:00.01 | 0 | | | |
|*139 | INDEX RANGE SCAN | I_OBJAUTH1 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*140 | FIXED TABLE FULL | X$KZSRO | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*141 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 1 | 0 |00:00:00.01 | 1 | | | |
|*142 | INDEX RANGE SCAN | I_USER_EDITIONING | 1 | 2 | 0 |00:00:00.01 | 1 | | | |
| 143 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*144 | INDEX RANGE SCAN | I_OBJ4 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*145 | INDEX RANGE SCAN | I_USER2 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*146 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*147 | INDEX RANGE SCAN | I_USER_EDITIONING | 0 | 2 | 0 |00:00:00.01 | 0 | | | |
|*148 | FIXED TABLE FULL | X$KZSPR | 1 | 1 | 1 |00:00:00.01 | 0 | | | |
|*149 | FILTER | | 0 | | 0 |00:00:00.01 | 0 | | | |
|*150 | INDEX RANGE SCAN | I_OBJAUTH1 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|*151 | FIXED TABLE FULL | X$KZSRO | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
-------------------------------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
4 - filter((("O"."SPARE3"=USERENV('SCHEMAID') OR ORA_CHECK_SYS_PRIVILEGE("O"."SPARE3","O"."TYPE#")=1 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))))
6 - access("T"."SUPERTOID"="SO"."OID$")
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','NUM
BER'),3,'NATIVE INTEGER',8,'LONG',9,DECODE(:B2,2,'NCHAR VARYING','VARCHAR'),11,'ROWID',12,'DATE',23,'RAW',24,'LONG
RAW',29,'BINARY_INTEGER',58,'OPAQUE/XMLTYPE',69,'ROWID',96,DECODE(:B2,2,'NCHAR','CHAR'),100,'BINARY_FLOAT',101,'BINARY_DOUBLE',102,'REF
CURSOR',104,'UROWID',105,'MLSLABEL',106,'MLSLABEL',110,'REF',111,'REF',112,DECODE(:B2,2,'NCLOB','CLOB'),113,'BLOB',114,'BFILE',115,'CFILE',121,
'OBJECT',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') 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))
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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#")
22 - filter("TYPE#"=:B1)
23 - access("UE"."USER#"=:B1)
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)
28 - access("UE"."USER#"=:B1)
30 - access("SO"."OWNER#"="SU"."USER#")
31 - filter( IS NOT NULL)
32 - access("OA"."OBJ#"=:B1)
33 - filter(("KZSROROL"=:B1 AND INTERNAL_FUNCTION("CON_ID")))
34 - filter("TYPE#"=:B1)
35 - access("UE"."USER#"=:B1)
37 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
38 - 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')))
39 - filter("UE"."TYPE#"=:B1)
40 - access("UE"."USER#"=:B1)
41 - filter((("O"."SPARE3"=USERENV('SCHEMAID') OR ORA_CHECK_SYS_PRIVILEGE("O"."SPARE3","O"."TYPE#")=1 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))))
43 - access("T"."SUPERTOID"="SO"."OID$")
47 - filter("O"."OID$" IS NOT NULL)
48 - access("O"."OWNER#"="U"."USER#" AND "O"."NAME"=DECODE(:B1,0,NULL,1,DECODE(:B2,2,'NVARCHAR2','VARCHAR2'),2,DECODE(:B3,(-127),'FLOAT','NUM
BER'),3,'NATIVE INTEGER',8,'LONG',9,DECODE(:B2,2,'NCHAR VARYING','VARCHAR'),11,'ROWID',12,'DATE',23,'RAW',24,'LONG
RAW',29,'BINARY_INTEGER',58,'OPAQUE/XMLTYPE',69,'ROWID',96,DECODE(:B2,2,'NCHAR','CHAR'),100,'BINARY_FLOAT',101,'BINARY_DOUBLE',102,'REF
CURSOR',104,'UROWID',105,'MLSLABEL',106,'MLSLABEL',110,'REF',111,'REF',112,DECODE(:B2,2,'NCLOB','CLOB'),113,'BLOB',114,'BFILE',115,'CFILE',121,
'OBJECT',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') AND "O"."SUBNAME" IS NULL)
filter(("O"."SUBNAME" IS NULL AND "O"."TYPE#"<>10))
49 - filter(("T"."PACKAGE_OBJ#" IS NULL AND BITAND("T"."PROPERTIES",64)=64 AND BITAND("T"."PROPERTIES",2048)=0))
50 - access("O"."OID$"="T"."TVOID")
52 - 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)))
53 - access("O"."OWNER#"="U"."USER#")
56 - filter("TYPE#"=:B1)
57 - access("UE"."USER#"=:B1)
59 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
60 - 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')))
61 - filter("UE"."TYPE#"=:B1)
62 - access("UE"."USER#"=:B1)
64 - access("SO"."OWNER#"="SU"."USER#")
65 - filter( IS NOT NULL)
66 - access("OA"."OBJ#"=:B1)
67 - filter(("KZSROROL"=:B1 AND INTERNAL_FUNCTION("CON_ID")))
68 - filter("TYPE#"=:B1)
69 - access("UE"."USER#"=:B1)
71 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
72 - 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')))
73 - filter("UE"."TYPE#"=:B1)
74 - access("UE"."USER#"=:B1)
76 - 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)))
79 - access("O"."OBJ#"="OBJECT_ID" AND "O"."SPARE3"="U"."USER#")
80 - access("U"."NAME"="OWNER")
81 - filter("U"."NAME" LIKE :SYS_B_107 ESCAPE :SYS_B_108)
84 - 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)))
85 - access("O2"."OWNER#"="U2"."USER#")
86 - access("PI"."ITYPEOBJ#"="O2"."OBJ#")
87 - access("O"."OBJ#"="PI"."OBJ#")
88 - access("O"."OWNER#"="U"."USER#")
90 - filter("U"."NAME" LIKE :SYS_B_107 ESCAPE :SYS_B_108)
91 - filter((SYS_CONTEXT('USERENV','IS_APPLICATION_ROOT')='NO' OR (SYS_CONTEXT('USERENV','IS_APPLICATION_ROOT')='YES' AND
BITAND("O"."FLAGS",4194304)<>4194304) OR TO_NUMBER(SYS_CONTEXT('USERENV','CON_ID'))=0))
92 - access("U"."USER#"="O"."SPARE3")
filter((INTERNAL_FUNCTION("O"."TYPE#") OR ("O"."TYPE#"=13 AND "O"."SUBNAME" IS NULL)))
96 - 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)))
97 - access("O"."OWNER#"="U"."USER#")
100 - filter("TYPE#"=:B1)
101 - access("UE"."USER#"=:B1)
103 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
104 - 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')))
105 - filter("UE"."TYPE#"=:B1)
106 - access("UE"."USER#"=:B1)
108 - filter("TYPE#"=:B1)
109 - access("UE"."USER#"=:B1)
111 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
112 - access("O2"."OWNER#"="U2"."USER#" AND "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
filter("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
113 - filter("UE"."TYPE#"=:B1)
114 - access("UE"."USER#"=:B1)
115 - 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)))
116 - filter(("PI"."PROCEDURE#" IS NULL OR "PI"."PROCEDURE#"=1))
118 - access("O"."OWNER#"="U"."USER#")
120 - filter("U"."NAME" LIKE :SYS_B_107 ESCAPE :SYS_B_108)
121 - filter((SYS_CONTEXT('USERENV','IS_APPLICATION_ROOT')='NO' OR (SYS_CONTEXT('USERENV','IS_APPLICATION_ROOT')='YES' AND
BITAND("O"."FLAGS",4194304)<>4194304) OR TO_NUMBER(SYS_CONTEXT('USERENV','CON_ID'))=0))
122 - access("O"."SPARE3"="U"."USER#")
filter(("O"."TYPE#"=9 OR "O"."TYPE#"=12))
125 - access("O"."OBJ#"="PI"."OBJ#")
126 - filter("TYPE#"=:B1)
127 - access("UE"."USER#"=:B1)
129 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
130 - 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')))
131 - filter("UE"."TYPE#"=:B1)
132 - access("UE"."USER#"=:B1)
133 - filter((INTERNAL_FUNCTION("O"."TYPE#") OR ("O"."TYPE#"=13 AND "O"."SUBNAME" IS NULL)))
134 - filter((DECODE("A"."PROCEDURE$",NULL,NULL,"O"."NAME") IS NULL AND NVL("A"."PROCEDURE$","O"."NAME") LIKE :SYS_B_109 ESCAPE :SYS_B_110
AND ("A"."ARGUMENT" LIKE :SYS_B_112 ESCAPE :SYS_B_113 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',10
2,'REF CURSOR',104,'UROWID',105,'MLSLABEL',106,'MLSLABEL',110,'REF',111,'REF',112,DECODE("A"."CHARSETFORM",2,'NCLOB','CLOB'),113,'BLOB',114,'BF
ILE',115,'CFILE',121,'OBJECT',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)) AND "A"."LEVEL#"=:SYS_B_111))
135 - access("O"."OBJ#"="A"."OBJ#" AND "A"."PROCEDURE#"="SUBPROGRAM_ID")
136 - access("O"."OWNER#"="U"."USER#")
137 - filter((((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141)) AND INTERNAL_FUNCTION("CON_ID") AND "INST_ID"=USERENV('INSTANCE')))
138 - filter( IS NOT NULL)
139 - access("OBJ#"=:B1 AND "PRIVILEGE#"=12)
filter("PRIVILEGE#"=12)
140 - filter(("KZSROROL"=:B1 AND INTERNAL_FUNCTION("CON_ID")))
141 - filter("TYPE#"=:B1)
142 - access("UE"."USER#"=:B1)
144 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
145 - 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')))
146 - filter("UE"."TYPE#"=:B1)
147 - access("UE"."USER#"=:B1)
148 - filter((((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141)) AND INTERNAL_FUNCTION("CON_ID") AND "INST_ID"=USERENV('INSTANCE')))
149 - filter( IS NOT NULL)
150 - access("OBJ#"=:B1 AND "PRIVILEGE#"=12)
filter("PRIVILEGE#"=12)
151 - filter(("KZSROROL"=:B1 AND INTERNAL_FUNCTION("CON_ID")))
Note
-----
- statistics feedback used for this statement
- this is an adaptive plan
348 rows selected.
SQL_ID: 5272z4mmnckkt
Elapsed: 00:00:00.17
SQL> @sqlm
SQL Plan Ref Elaps CPU IOWt AppWt ConWt
Sid,Serial ORAUSER SQL_ID Exec Id SQL_EXEC_START Hash Cnt STA Module Secs Secs Secs BGETS DREADS Secs Secs Wait Event
---------- -------- ------------- --------- ----------------- ----------- ----- ---------- -------------------- --------- ------ --------- ---------- -------- ----- ----- ----------------------------
724,23839 SYS 5f3qky7vfx13u 16777216 2024/11/20 10:03: 4048185872 32 DONE (ALL sqlplus@f2b7f3d3e67c 62.6 45.6 16.9 1557280 6845 0 0 SQL*Net message to client
39
724,23839 SYS 6f9csgt0as1m1 16777216 2024/11/20 10:06: 1257791643 29 DONE (ALL sqlplus@f2b7f3d3e67c 44.7 44.4 .0 5325404 0 0 0 SQL*Net message to client
06
724,23839 SYS 6f9csgt0as1m1 16777217 2024/11/20 10:07: 1257791643 29 DONE (ALL sqlplus@f2b7f3d3e67c 44.2 44.0 .0 5325401 0 0 0 SQL*Net message to client
06
1575,20081 SYS 43d22capup3wz 16777216 2024/11/20 04:28: 320132052 ##### EXECUTING sqlplus@f2b7f3d3e67c 20,432.1 ###### .1 ########## 217 0 0 db file sequential read
22
4 rows selected.
Elapsed: 00:00:00.05
SQL> @sqlm_sqlid
Enter value for sql_id: 6f9csgt0as1m1
SQL Monitoring Report
SQL Text
------------------------------
SELECT /*+ BEGIN_OUTLINE_DATA MONITOR IGNORE_OPTIM_EMBEDDED_HINTS OPTIMIZER_FEATURES_ENABLE('12.1.0.2') OPT_PARAM('container_data' 'current_directory') 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, :"SYS_B_000",
:"SYS_B_001", DECODE(arg.in_out, :"SYS_B_002", :"SYS_B_003", :"SYS_B_004", :"SYS_B_005", :"SYS_B_006", :"SYS_B_007", :"SYS_B_008")) AS column_type ,DECODE(( SELECT a.typecode FROM ALL_TYPES A WHERE a.type_name = arg.data_type ), :"SYS_B_009", :"SYS_B_010", :"SYS_B_011", :"SYS_B_012", DECODE(substr(arg.data_type, :"SYS_B_013", :"SYS_B_014"), :"SYS_B_015", DECODE(substr(arg.data_type, :"SYS_B_016", :"SYS_B_017"), :"SYS_B_018", DECODE(substr(arg.data_type, :"SYS_B_019", :"SYS_B_020"),
:"SYS_B_021", :"SYS_B_022", :"SYS_B_023", :"SYS_B_024", :"SYS_B_025"), DECODE(substr(arg.data_type, :"SYS_B_026", :"SYS_B_027"), :"SYS_B_028", :"SYS_B_029", :"SYS_B_030", :"SYS_B_031", :"SYS_B_032")), :"SYS_B_033", DECODE(substr(arg.data_type, :"SYS_B_034", :"SYS_B_035"), :"SYS_B_036", :"SYS_B_037", :"SYS_B_038", :"SYS_B_039"), DECODE(arg.data_type, :"SYS_B_040", :"SYS_B_041", :"SYS_B_042", :"SYS_B_043", :"SYS_B_044", :"SYS_B_045", :"SYS_B_046", :"SYS_B_047", :"SYS_B_048", :"SYS_B_049",
:"SYS_B_050", :"SYS_B_051", :"SYS_B_052", :"SYS_B_053", :"SYS_B_054", :"SYS_B_055", :"SYS_B_056", :"SYS_B_057", :"SYS_B_058", :"SYS_B_059", :"SYS_B_060", :"SYS_B_061", :"SYS_B_062", :"SYS_B_063", :"SYS_B_064", :"SYS_B_065", :"SYS_B_066", :"SYS_B_067", :"SYS_B_068", :"SYS_B_069", :"SYS_B_070", :"SYS_B_071", :"SYS_B_072", :"SYS_B_073", :"SYS_B_074", :"SYS_B_075", :"SYS_B_076", :"SYS_B_077", :"SYS_B_078", :"SYS_B_079", :"SYS_B_080", :"SYS_B_081", :"SYS_B_082", :"SYS_B_083", :"SYS_B_084",
:"SYS_B_085", :"SYS_B_086", :"SYS_B_087", :"SYS_B_088", :"SYS_B_089", :"SYS_B_090"))) AS data_type ,decode(arg.data_type, :"SYS_B_091", arg.type_owner || :"SYS_B_092" || 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 ,:"SYS_B_093" AS radix ,:"SYS_B_094" 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, :"SYS_B_095", :"SYS_B_096", :"SYS_B_097", :"SYS_B_098", :"SYS_B_099", :"SYS_B_100", :"SYS_B_101", :"SYS_B_102", :"SYS_B_103", :"SYS_B_104", NULL) AS char_octet_length ,(arg.sequence - :"SYS_B_105") AS ordinal_position ,:"SYS_B_106" 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 :"SYS_B_107" ESCAPE :"SYS_B_108" AND arg.object_name LIKE :"SYS_B_109" ESCAPE :"SYS_B_110" AND
arg.data_level = :"SYS_B_111" 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 :"SYS_B_112" ESCAPE :"SYS_B_113" 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 (724:23839)
SQL ID : 6f9csgt0as1m1
SQL Execution ID : 16777217
Execution Started : 11/20/2024 10:07:06
First Refresh Time : 11/20/2024 10:07:06
Last Refresh Time : 11/20/2024 10:07:51
Duration : 45s
Module/Action : sqlplus@f2b7f3d3e67c4c4 (TNS V1-V3)/-
Service : pdbu0572_1
Program : sqlplus@f2b7f3d3e67c4c4 (TNS V1-V3)
Fetch Calls : 4
Binds
========================================================================================================================
| Name | Position | Type | Value |
========================================================================================================================
| :SYS_B_107 | 108 | VARCHAR2(32) | USER_TAXONE_ADM% |
| :SYS_B_108 | 109 | VARCHAR2(32) | / |
| :SYS_B_109 | 110 | VARCHAR2(32) | SAF_PEGA_IDENT% |
| :SYS_B_110 | 111 | VARCHAR2(32) | / |
| :SYS_B_111 | 112 | NUMBER | 0 |
| :SYS_B_112 | 113 | VARCHAR2(32) | % |
| :SYS_B_113 | 114 | VARCHAR2(32) | / |
========================================================================================================================
Global Stats
=================================================
| Elapsed | Cpu | Other | Fetch | Buffer |
| Time(s) | Time(s) | Waits(s) | Calls | Gets |
=================================================
| 44 | 44 | 0.29 | 4 | 5M |
=================================================
SQL Plan Monitoring Details (Plan Hash Value=1257791643)
==================================================================================================================================================================================
| Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Mem | Activity | Activity Detail |
| | | | (Estim) | | Active(s) | Active | | (Actual) | (Max) | (%) | (# samples) |
==================================================================================================================================================================================
| 0 | SELECT STATEMENT | | | | 12 | +34 | 2 | 2 | . | | |
| 1 | VIEW | ALL_TYPES | 2 | 339K | 12 | +34 | 2 | 2 | . | | |
| 2 | SORT UNIQUE | | 2 | 339K | 12 | +34 | 2 | 2 | 2048 | | |
| 3 | UNION-ALL | | | | 12 | +34 | 2 | 2 | . | | |
| 4 | FILTER | | | | | | 2 | | . | | |
| 5 | NESTED LOOPS OUTER | | 1 | 170K | | | 2 | | . | | |
| 6 | HASH JOIN OUTER | | 1 | 170K | | | 2 | | 207KB | | |
| 7 | NESTED LOOPS | | 1 | 2027 | 13 | +22 | 2 | 0 | . | | |
| 8 | NESTED LOOPS | | 1 | 2025 | 13 | +22 | 2 | 2 | . | | |
| 9 | NESTED LOOPS | | 1 | 2024 | 13 | +22 | 2 | 2 | . | | |
| 10 | INDEX FAST FULL SCAN | I_USER2 | 1008 | 4 | 13 | +22 | 2 | 2016 | . | | |
| 11 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 1 | 4 | 13 | +22 | 2016 | 2 | . | | |
| 12 | INDEX RANGE SCAN | I_OBJ2 | 1 | 3 | 13 | +22 | 2016 | 2 | . | | |
| 13 | TABLE ACCESS CLUSTER | USER$ | 1 | 1 | 13 | +22 | 2 | 2 | . | | |
| 14 | INDEX UNIQUE SCAN | I_USER# | 1 | | 13 | +22 | 2 | 2 | . | | |
| 15 | TABLE ACCESS BY INDEX ROWID | TYPE$ | 1 | 2 | 13 | +22 | 2 | 0 | . | | |
| 16 | INDEX UNIQUE SCAN | I_TYPE2 | 1 | 1 | 13 | +22 | 2 | 2 | . | | |
| 17 | VIEW | _CURRENT_EDITION_OBJ | 15M | 167K | | | | | . | | |
| 18 | FILTER | | | | | | | | . | | |
| 19 | HASH JOIN | | 15M | 167K | | | | | . | | |
| 20 | INDEX FAST FULL SCAN | I_USER2 | 1008 | 4 | | | | | . | | |
| 21 | TABLE ACCESS FULL | OBJ$ | 15M | 167K | | | | | . | | |
| 22 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | | | | | . | | |
| 23 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | | | | | . | | |
| 24 | NESTED LOOPS | | 1 | 4 | | | | | . | | |
| 25 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | . | | |
| 26 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | . | | |
| 27 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | | | | | . | | |
| 28 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | | | | | . | | |
| 29 | TABLE ACCESS CLUSTER | USER$ | 1 | 1 | | | | | . | | |
| 30 | INDEX UNIQUE SCAN | I_USER# | 1 | | | | | | . | | |
| 31 | FILTER | | | | | | | | . | | |
| 32 | INDEX RANGE SCAN | I_OBJAUTH1 | 2 | 3 | | | | | . | | |
| 33 | FIXED TABLE FULL | X$KZSRO | 50 | | | | | | . | | |
| 34 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | | | | | . | | |
| 35 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | | | | | . | | |
| 36 | NESTED LOOPS | | 1 | 4 | | | | | . | | |
| 37 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | . | | |
| 38 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | . | | |
| 39 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | | | | | . | | |
| 40 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | | | | | . | | |
| 41 | FILTER | | | | 12 | +34 | 2 | 2 | . | | |
| 42 | NESTED LOOPS OUTER | | 1 | 170K | 12 | +34 | 2 | 2 | . | | |
| 43 | HASH JOIN OUTER | | 1 | 170K | 24 | +22 | 2 | 2 | 445KB | | |
| 44 | NESTED LOOPS | | 1 | 2026 | 13 | +22 | 2 | 2 | . | | |
| 45 | NESTED LOOPS | | 1 | 2024 | 13 | +22 | 2 | 2 | . | | |
| 46 | INDEX FAST FULL SCAN | I_USER2 | 1008 | 4 | 13 | +22 | 2 | 2016 | . | | |
| 47 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 1 | 4 | 13 | +22 | 2016 | 2 | . | | |
| 48 | INDEX RANGE SCAN | I_OBJ2 | 1 | 3 | 13 | +22 | 2016 | 2 | . | | |
| 49 | TABLE ACCESS BY INDEX ROWID | TYPE$ | 1 | 2 | 13 | +22 | 2 | 2 | . | | |
| 50 | INDEX UNIQUE SCAN | I_TYPE2 | 1 | 1 | 13 | +22 | 2 | 2 | . | | |
| 51 | VIEW | _CURRENT_EDITION_OBJ | 15M | 167K | 24 | +22 | 2 | 31M | . | | |
| 52 | FILTER | | | | 24 | +22 | 2 | 31M | . | | |
| 53 | HASH JOIN | | 15M | 167K | 24 | +22 | 2 | 31M | 2MB | | |
| 54 | INDEX FAST FULL SCAN | I_USER2 | 1008 | 4 | 13 | +22 | 2 | 2016 | . | | |
| 55 | TABLE ACCESS FULL | OBJ$ | 15M | 167K | 24 | +22 | 2 | 31M | . | | |
| 56 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | 12 | +22 | 3M | 1 | . | | |
| 57 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | 16 | +22 | 3M | 1 | . | | |
| 58 | NESTED LOOPS | | 1 | 4 | | | | | . | | |
| 59 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | . | | |
| 60 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | . | | |
| 61 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | | | | | . | | |
| 62 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | | | | | . | | |
| 63 | TABLE ACCESS CLUSTER | USER$ | 1 | 1 | | | 2 | | . | | |
| 64 | INDEX UNIQUE SCAN | I_USER# | 1 | | | | 2 | | . | | |
| 65 | FILTER | | | | | | | | . | | |
| 66 | INDEX RANGE SCAN | I_OBJAUTH1 | 2 | 3 | | | | | . | | |
| 67 | FIXED TABLE FULL | X$KZSRO | 50 | | | | | | . | | |
| 68 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | | | 1 | | . | | |
| 69 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | | | 1 | | . | | |
| 70 | NESTED LOOPS | | 1 | 4 | | | | | . | | |
| 71 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | . | | |
| 72 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | . | | |
| 73 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | | | | | . | | |
| 74 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | | | | | . | | |
| 75 | SORT ORDER BY | | 1 | 1M | 12 | +34 | 1 | 3 | 2048 | | |
| 76 | FILTER | | | | 12 | +34 | 1 | 3 | . | | |
| 77 | HASH JOIN | | 1 | 1M | 24 | +22 | 1 | 1 | . | | |
| 78 | NESTED LOOPS | | 1 | 1M | 24 | +22 | 1 | 3 | . | | |
| 79 | STATISTICS COLLECTOR | | | | 24 | +22 | 1 | 3 | . | | |
| 80 | NESTED LOOPS | | 1 | 1M | 5 | +18 | 1 | 3 | . | | |
| 81 | HASH JOIN | | 679 | 1M | 5 | +18 | 1 | 20362 | 3MB | | |
| 82 | NESTED LOOPS | | 679 | 1M | 1 | +18 | 1 | 1 | . | | |
| 83 | STATISTICS COLLECTOR | | | | 1 | +18 | 1 | 20558 | . | | |
| 84 | HASH JOIN | | 592K | 871K | 17 | +2 | 1 | 20558 | 750KB | | |
| 85 | TABLE ACCESS FULL | USER$ | 841 | 58 | 1 | +2 | 1 | 1 | . | | |
| 86 | VIEW | INT$DBA_PROCEDURES | 593K | 871K | 1 | +18 | 1 | 20558 | . | | |
| 87 | UNION-ALL | | | | 1 | +18 | 1 | 20558 | . | | |
| 88 | FILTER | | | | 1 | +18 | 1 | 18743 | . | | |
| 89 | HASH JOIN OUTER | | 549K | 594K | 3 | +16 | 1 | 18743 | 11MB | | |
| 90 | HASH JOIN OUTER | | 549K | 581K | 17 | +2 | 1 | 18743 | 11MB | | |
| 91 | HASH JOIN | | 549K | 306K | 5 | +2 | 1 | 18743 | 12MB | | |
| 92 | NESTED LOOPS | | 549K | 306K | 1 | +2 | 1 | 1 | . | | |
| 93 | STATISTICS COLLECTOR | | | | 1 | +2 | 1 | 8256 | . | | |
| 94 | HASH JOIN | | 190K | 171K | 1 | +2 | 1 | 8256 | 3MB | | |
| 95 | HASH JOIN | | 190K | 169K | 1 | +2 | 1 | 1 | . | | |
| 96 | NESTED LOOPS | | 190K | 169K | 1 | +2 | 1 | 8256 | . | | |
| 97 | STATISTICS COLLECTOR | | | | 1 | +2 | 1 | 1 | . | | |
| 98 | TABLE ACCESS FULL | USER$ | 841 | 58 | 1 | +2 | 1 | 1 | . | | |
| 99 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 225 | 168K | 1 | +2 | 1 | 8256 | . | | |
| 100 | INDEX RANGE SCAN | I_OBJ5 | | | 1 | +2 | 1 | 8256 | . | | |
| 101 | TABLE ACCESS FULL | OBJ$ | 197K | 168K | | | | | . | | |
| 102 | INDEX FAST FULL SCAN | I_USER2 | 1008 | 4 | 1 | +2 | 1 | 1008 | . | | |
| 103 | TABLE ACCESS BY INDEX ROWID | PROCEDUREINFO$ | 3 | 74592 | | | | | . | | |
| 104 | INDEX RANGE SCAN | I_PROCEDUREINFO1 | | | | | | | . | | |
| 105 | TABLE ACCESS FULL | PROCEDUREINFO$ | 14M | 74592 | 5 | +2 | 1 | 14M | . | | |
| 106 | VIEW | _CURRENT_EDITION_OBJ | 15M | 167K | 14 | +5 | 1 | 15M | . | | |
| 107 | FILTER | | | | 13 | +6 | 1 | 15M | . | | |
| 108 | HASH JOIN | | 15M | 167K | 13 | +6 | 1 | 15M | 2MB | | |
| 109 | INDEX FAST FULL SCAN | I_USER2 | 1008 | 4 | 1 | +6 | 1 | 1008 | . | | |
| 110 | TABLE ACCESS FULL | OBJ$ | 15M | 167K | 13 | +6 | 1 | 15M | . | | |
| 111 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | 1 | +6 | 1M | 1 | . | | |
| 112 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | 1 | +6 | 1M | 1 | . | | |
| 113 | NESTED LOOPS | | 1 | 4 | | | | | . | | |
| 114 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | . | | |
| 115 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | . | | |
| 116 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | | | | | . | | |
| 117 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | | | | | . | | |
| 118 | INDEX FAST FULL SCAN | I_USER2 | 1008 | 4 | 1 | +18 | 1 | 1008 | . | | |
| 119 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | | | 4 | | . | | |
| 120 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | | | 4 | | . | | |
| 121 | NESTED LOOPS | | 1 | 4 | | | | | . | | |
| 122 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | . | | |
| 123 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | . | | |
| 124 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | | | | | . | | |
| 125 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | | | | | . | | |
| 126 | FILTER | | | | 1 | +18 | 1 | 1815 | . | | |
| 127 | FILTER | | | | 1 | +18 | 1 | 1815 | . | | |
| 128 | NESTED LOOPS OUTER | | 44484 | 277K | 1 | +18 | 1 | 14556 | . | | |
| 129 | HASH JOIN | | 47000 | 168K | 1 | +18 | 1 | 1989 | 1MB | | |
| 130 | HASH JOIN | | 47000 | 168K | 1 | +18 | 1 | 1 | . | | |
| 131 | NESTED LOOPS | | 47000 | 168K | 1 | +18 | 1 | 1989 | . | | |
| 132 | STATISTICS COLLECTOR | | | | 1 | +18 | 1 | 1 | . | | |
| 133 | TABLE ACCESS FULL | USER$ | 841 | 58 | 1 | +18 | 1 | 1 | . | | |
| 134 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 56 | 167K | 1 | +18 | 1 | 1989 | . | | |
| 135 | INDEX RANGE SCAN | I_OBJ5 | | | 1 | +18 | 1 | 1989 | . | | |
| 136 | TABLE ACCESS FULL | OBJ$ | 48733 | 167K | | | | | . | | |
| 137 | INDEX FAST FULL SCAN | I_USER2 | 1008 | 4 | 1 | +18 | 1 | 1008 | . | | |
| 138 | TABLE ACCESS BY INDEX ROWID | PROCEDUREINFO$ | 3 | 3 | 1 | +18 | 1989 | 14346 | . | | |
| 139 | INDEX RANGE SCAN | I_PROCEDUREINFO1 | 3 | 2 | 1 | +18 | 1989 | 14346 | . | | |
| 140 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | | | 2 | | . | | |
| 141 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | | | 2 | | . | | |
| 142 | NESTED LOOPS | | 1 | 4 | | | | | . | | |
| 143 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | . | | |
| 144 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | . | | |
| 145 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | | | | | . | | |
| 146 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | | | | | . | | |
| 147 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 1 | 167K | | | | | . | | |
| 148 | INDEX RANGE SCAN | I_OBJ1 | | | | | | | . | | |
| 149 | TABLE ACCESS FULL | OBJ$ | 6M | 167K | 5 | +18 | 1 | 6M | . | | |
| 150 | TABLE ACCESS BY INDEX ROWID | ARGUMENT$ | 1 | 4 | 5 | +18 | 20362 | 3 | . | | |
| 151 | INDEX RANGE SCAN | I_ARGUMENT2 | 1 | 3 | 5 | +18 | 20362 | 98491 | . | | |
| 152 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | 24 | +22 | 3 | 3 | . | | |
| 153 | INDEX FAST FULL SCAN | I_USER2 | 1 | 1 | | | | | . | | |
| 154 | FIXED TABLE FULL | X$KZSPR | 1 | | 1 | +22 | 1 | 1 | . | | |
| 155 | FILTER | | | | | | | | . | | |
| 156 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 3 | | | | | . | | |
| 157 | FIXED TABLE FULL | X$KZSRO | 1 | | | | | | . | | |
| 158 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | | | 1 | | . | | |
| 159 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | | | 1 | | . | | |
| 160 | NESTED LOOPS | | 1 | 4 | | | | | . | | |
| 161 | INDEX RANGE SCAN | I_OBJ4 | 1 | 3 | | | | | . | | |
| 162 | INDEX RANGE SCAN | I_USER2 | 1 | 1 | | | | | . | | |
| 163 | TABLE ACCESS BY INDEX ROWID | USER_EDITIONING$ | 1 | 2 | | | | | . | | |
| 164 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | 1 | | | | | . | | |
| 165 | FIXED TABLE FULL | X$KZSPR | 1 | | 1 | +22 | 1 | 1 | . | | |
| 166 | FILTER | | | | | | | | . | | |
| 167 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 3 | | | | | . | | |
| 168 | FIXED TABLE FULL | X$KZSRO | 1 | | | | | | . | | |
==================================================================================================================================================================================
1 row selected.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment