DB Statistics to SGA Variable Mapping Oracle 12.2.0.1 create table dbstat_sgavar_map as select statistic#, name, decode(name,display_name,null,display_name) display_name from v$statname order by 1; alter table dbstat_sgavar_map add stat_sgavar varchar2(50); oradebug setmypid oradebug dumpsga The "Namespace ksusta (statistics)" section in the trace file looks like kywmosqt_ = 0 kywmsrtc_ = 1 ksuxxl_ = 2 ... Change them to update dbstat_sgavar_map set stat_sgavar = 'kywmosqt_' where statistic# = 0; update dbstat_sgavar_map set stat_sgavar = 'kywmsrtc_' where statistic# = 1; update dbstat_sgavar_map set stat_sgavar = 'ksuxxl_' where statistic# = 2; ... and run the SQLs. The statistic name to its SGA variable mapping may help decipher certain variable names. SQL> select statistic#, name, stat_sgavar, display_name from dbstat_sgavar_map order by 1; STATISTIC# NAME STAT_SGAVAR DISPLAY_NAME ---------- --------------------------------------------------------------- -------------------------------------------------- --------------------------------------- 0 OS CPU Qt wait time kywmosqt_ 1 Requests to/from client kywmsrtc_ 2 logons cumulative ksuxxl_ 3 logons current ksuxcl_ 4 opened cursors cumulative ksuxoc_ 5 opened cursors current ksuxcc_ 6 user commits ksuxuc_ 7 user rollbacks ksuxur_ 8 user calls ksuxxt_ 9 recursive calls ksuxxr_ 10 recursive cpu usage ksuxrc_ 11 pinned cursors current ksuxpc_ 12 user logons cumulative ksuxul_ 13 user logouts cumulative ksuxlo_ 14 session logical reads ksuxis_ 15 session logical reads in local numa group ksuxis_local_ 16 session logical reads in remote numa group ksuxis_remote_ 17 session stored procedure space ksuxpp_ 18 CPU used when call started ksuxps_ 19 CPU used by this session ksuxpu_ 20 DB time ksuxpe_ 21 CPU used by LWTs for this session ksuxpult_ 22 DB time of LWTs for this session ksuxpelt_ 23 cluster wait time ksuxrac_ 24 concurrency wait time ksuxcxr_ 25 application wait time ksuxapp_ 26 user I/O wait time ksuxuio_ 27 scheduler wait time ksuxres_ 28 non-idle wait time ksuxniw_ 29 non-idle wait count ksuxniwc_ 30 in call idle wait time ksuxicidle_ 31 session connect time ksuxtc_ 32 process last non-idle time ksuxti_ 33 session uga memory ksuxuz_ 34 session uga memory max ksuxmz_ 35 messages sent ksuxms_ 36 messages received ksuxmr_ 37 background timeouts ksuxbt_ 38 remote Oradebug requests ksdxstat_oradebug_remote_ 39 session pga memory ksmpcu_ 40 session pga memory max ksmpst_ 41 recursive system API invocations ksestat_inter_recur_ 42 enqueue timeouts ksqxxt_ 43 enqueue waits ksqxxw_ 44 enqueue deadlocks ksqxxd_ 45 enqueue requests ksqxxe_ 46 enqueue conversions ksqxxc_ 47 enqueue releases ksqxxf_ 48 global enqueue gets sync ksigsc_ 49 global enqueue gets async ksigac_ 50 global enqueue get time ksigt_ 51 global enqueue releases ksirsc_ 52 physical read total IO requests ksfdprtr_ 53 physical read total multi block requests ksfdprm_ 54 physical read requests optimized ksfdfrr_ 55 physical read total bytes optimized ksfdfrtbo_ 56 physical read partial requests ksfdrpr_ 57 physical read total bytes ksfdprtb_ 58 physical write requests optimized ksfdwro_ 59 physical write total bytes optimized ksfdwbo_ 60 cell writes to flash cache ksfdwrf_ 61 cell overwrites in flash cache ksfdwrr_ 62 cell partial writes in flash cache ksfdwpr_ 63 physical write total IO requests ksfdpwtr_ 64 physical write total multi block requests ksfdpwm_ 65 physical write total bytes ksfdpwtb_ 66 cell physical IO interconnect bytes ksfd_bytes_exchanged_storage_ 67 spare statistic 1 ksparst1_ 68 spare statistic 2 ksparst2_ 69 spare statistic 3 ksparst3_ 70 spare statistic 4 ksparst4_ 71 spare statistic 5 ksparst5_ 72 spare statistic 6 ksparst6_ 73 spare statistic 7 ksparst7_ 74 spare statistic 8 ksparst8_ 75 spare statistic 9 ksparst9_ 76 spare statistic 10 ksparst10_ 77 spare statistic 11 ksparst11_ 78 spare statistic 12 ksparst12_ 79 spare statistic 13 ksparst13_ 80 spare statistic 14 ksparst14_ 81 spare statistic 15 ksparst15_ 82 spare statistic 16 ksparst16_ 83 spare statistic 17 ksparst17_ 84 spare statistic 18 ksparst18_ 85 spare statistic 19 ksparst19_ 86 spare statistic 20 ksparst20_ 87 spare statistic 21 ksparst21_ 88 spare statistic 22 ksparst22_ 89 spare statistic 23 ksparst23_ 90 spare statistic 24 ksparst24_ 91 spare statistic 25 ksparst25_ 92 spare statistic 26 ksparst26_ 93 spare statistic 27 ksparst27_ 94 spare statistic 28 ksparst28_ 95 spare statistic 29 ksparst29_ 96 spare statistic 30 ksparst30_ 97 spare statistic 31 ksparst31_ 98 spare statistic 32 ksparst32_ 99 spare statistic 33 ksparst33_ 100 spare statistic 34 ksparst34_ 101 spare statistic 35 ksparst35_ 102 spare statistic 36 ksparst36_ 103 spare statistic 37 ksparst37_ 104 spare statistic 38 ksparst38_ 105 spare statistic 39 ksparst39_ 106 spare statistic 40 ksparst40_ 107 IPC CPU used by this session ksxpxcpu_ 108 physical read snap IO requests base ksfdssprsrb_ 109 physical read snap IO requests copy ksfdssprsrc_ 110 physical read snap IO requests no data ksfdssprsrs_ 111 physical read snap bytes base ksfdssprsbb_ 112 physical read snap bytes copy ksfdssprsbc_ 113 physical write snap IO requests new allocations ksfdsspwsrn_ 114 gcs messages sent kjibms_ 115 ges messages sent kjims_ 116 global enqueue CPU used by this session kjixcpu_ 117 gcs read-mostly lock grants kjblrmgr_ 118 gcs anti-locks created kjblanti_ 119 gcs read-mostly lock failures kjblrmfail_ 120 gcs affinity lock grants kjblaffgr_ 121 gcs affinity lock failures kjblafffail_ 122 ka messages sent kjkmstms_ 123 ka grants received kjkmstast_ 124 ka local messages received kjkmstlmsg_ 125 ka local message waits kjkmstlwt_ 126 ka wait due to timeout kjkmstotw_ 127 ka wait due to trigger kjkmstodw_ 128 ka wait calls suppressed kjkmstosw_ 129 ka wait calls for invalid kga kjkmstoikw_ 130 ka wait calls attempted kjkmstoaw_ 131 ka wait calls other kjkmstoow_ 132 max cf enq hold time kcc_control_file_transaction_max_time_ maximum time control file enqueue held 133 total cf enq hold time kcc_control_file_transaction_time_ total time control file enqueue held 134 total number of cf enq holders kcc_control_file_transaction_count_ total control file enqueue acquisitions 135 db block gets kcbycu_ 136 db block gets from cache kcbycuc_ 137 db block gets from cache (fastpath) kcbycufc_ 138 db block gets direct kcbycud_ 139 consistent gets kcbycr_ 140 consistent gets from cache kcbycrc_ 141 consistent gets pin kcbycp_ 142 consistent gets pin (fastpath) kcbycfp_ 143 consistent gets examination kcbycx_ 144 consistent gets examination (fastpath) kcbycfx_ 145 consistent gets direct kcbycrd_ 146 fastpath consistent get quota limit kcbycrfcf_ 147 logical read bytes from cache kcbylrb_ 148 physical reads kcbypr_ physical blocks read 149 physical reads cache kcbypcr_ 150 physical read flash cache hits kcbyl2cr_ 151 physical reads direct kcbydr_ 152 physical read IO requests kcbyprc_ 153 physical read bytes kcbyprb_ 154 db block changes kcbycc_ 155 consistent changes kcbyxc_ 156 recovery blocks read kcbyvb_ 157 recovery blocks read for lost write detection kcbyvbr_ 158 recovery blocks skipped lost write checks kcbywkl_ 159 physical writes kcbypw_ 160 physical writes direct kcbydw_ 161 physical writes from cache kcbypcw_ 162 physical write IO requests kcbypwc_ 163 flash cache inserts kcbyl2cw_ 164 physical reads direct temporary tablespace kcbydrtt_ 165 physical writes direct temporary tablespace kcbydwtt_ 166 physical write bytes kcbypwb_ 167 flash cache eviction: invalidated kcbyl2inv_ 168 flash cache eviction: buffer pinned kcbyl2invc_ 169 flash cache eviction: aged out kcbyl2aout_ 170 flash cache insert skip: not current kcbyl2nowrnc_ 171 flash cache insert skip: DBWR overloaded kcbyl2nowrf_ 172 flash cache insert skip: exists kcbyl2nowrh_ 173 flash cache insert skip: not useful kcbyl2nowrncp_ 174 flash cache insert skip: modification kcbyl2nowrm_ 175 flash cache insert skip: corrupt kcbyl2nowrc_ 176 db corrupt blocks detected kcbycbd_ 177 db corrupt blocks recovered kcbycbr_ 178 session referenced a buffer on dram kcbydramtouch_ 179 session referenced a buffer on xmem kcbynvmtouch_ 180 physical writes non checkpoint kcbymw_ 181 summed dirty queue length kcbylw_ 182 DBWR checkpoint buffers written kcbbwc_ 183 DBWR thread checkpoint buffers written kcbbthwc_ 184 DBWR tablespace checkpoint buffers written kcbbtswc_ 185 DBWR parallel query checkpoint buffers written kcbbpqwc_ 186 DBWR object drop buffers written kcbbowc_ 187 DBWR transaction table writes kcbxtw_ 188 DBWR undo block writes kcbubw_ 189 DBWR revisited being-written buffer kcbyos_ 190 DBWR lru scans kcbyls_ 191 DBWR checkpoints kcbybc_ 192 DBWR fusion writes kcbylf_ 193 prefetch clients - keep kcbk_keep_clnts_ 194 prefetch clients - recycle kcbk_recycle_clnts_ 195 prefetch clients - default kcbk_default_clnts_ 196 prefetch clients - 2k kcbk_2k_clnts_ 197 prefetch clients - 4k kcbk_4k_clnts_ 198 prefetch clients - 8k kcbk_8k_clnts_ 199 prefetch clients - 16k kcbk_16k_clnts_ 200 prefetch clients - 32k kcbk_32k_clnts_ 201 BPS commit wait kcbbpstxw_ 202 BPS redo wait kcbbpsrew_ 203 BPS session wait kcbbpssew_ 204 change write time kcbytc_ 205 exchange deadlocks kcbyxd_ 206 free buffer requested kcbyfr_ 207 dirty buffers inspected kcbyds_ 208 pinned buffers inspected kcbypi_ 209 hot buffers moved to head of LRU kcbyhm_ 210 free buffer inspected kcbyfi_ 211 commit cleanout failures: write disabled kcbywd_ 212 commit cleanout failures: block lost kcbylo_ 213 commit cleanout failures: cannot pin kcbynp_ 214 commit cleanout failures: hot backup in progress kcbyhb_ 215 commit cleanout failures: buffer being written kcbybw_ 216 commit cleanout failures: callback failure kcbycf_ 217 commit cleanout failures: delayed log kcbydl_ 218 commit cleanout failures: flashback kcbyfb_ 219 commit cleanouts kcbytn_ 220 commit cleanouts successfully completed kcbycs_ 221 saved cleanout failures: write disabled kcbsywd_ 222 saved cleanout failures: cannot pin kcbsynp_ 223 saved cleanout failures: hot backup in progress kcbsyhb_ 224 saved cleanout failures: buffer being written kcbsybw_ 225 saved cleanout failures: callback failure kcbsycf_ 226 saved cleanout failures: flashback kcbsyfb_ 227 saved cleanout failures: delayed log kcbsydl_ 228 saved cleanouts kcbsytn_ 229 saved cleanouts successfully completed kcbsycs_ 230 recovery array reads kcbyva_ 231 recovery array read time kcbyvt_ 232 CR blocks created kcbycb_ 233 current blocks converted for CR kcbycv_ 234 switch current to new buffer kcbysc_ 235 switch current caused by our pin kcbyscsi_ 236 write clones created in foreground kcbywc_ 237 write clones created in background kcbydwc_ 238 write clones created for recovery kcbyrwc_ 239 checkpoint clones created for ADG recovery kcbycwc_ 240 recovery block gets from cache kcbyvbc_ 241 physical reads cache prefetch kcbypf_ 242 physical reads prefetch warmup kcbycpw_ 243 prefetched blocks aged out before use kcbypa_ 244 prefetch warmup blocks aged out before use kcbypwa_ 245 prefetch warmup blocks flushed out before use kcbypwf_ 246 physical reads retry corrupt kcbydrr_ 247 physical reads direct (lob) kcbydrlb_ 248 physical writes direct (lob) kcbydwlb_ 249 cold recycle reads kcbyrc_ 250 shared hash latch upgrades - no wait kcbycn_ 251 shared hash latch upgrades - wait kcbycw_ 252 physical reads for flashback new kcbrfbfn_ 253 flashback cache read optimizations for block new kcbycfbo_ 254 flashback direct read optimizations for block new kcbydfbo_ 255 flashback securefile cache read optimizations for block new kcbycsbo_ 256 flashback securefile direct read optimizations for block new kcbydsbo_ 257 physical reads cache for securefile flashback block new kcbycsbno_ 258 physical reads direct for securefile flashback block new kcbydsbno_ 259 blocks encrypted kcbybenc_ 260 blocks decrypted kcbybdec_ 261 data warehousing scanned objects kcbydwo_ 262 data warehousing scanned blocks kcbydwb_ 263 data warehousing scanned blocks - memory kcbydwb1_ 264 data warehousing scanned blocks - flash kcbydwb2_ 265 data warehousing scanned blocks - disk kcbydwbd_ 266 data warehousing scanned blocks - offload kcbydwbo_ 267 data warehousing evicted objects kcbydweo_ 268 data warehousing evicted objects - cooling kcbydweoc_ 269 data warehousing evicted objects - replace kcbydweor_ 270 data warehousing cooling action kcbydwca_ 271 dram clean buffers available and above threshold kcbxma1_ 272 dram clean buffers available and is requested kcbxma11_ 273 xmem clean buffers available and used kcbxma2_ 274 xmem clean buffers not available so switch to main kcbxma21_ 275 xmem buffer switch needed but no free dram buffer kcbxmsw_ 276 xmem: dram enforced but no free buffer kcbxmsdf_ 277 calls to kcmgcs kcmzcs_ 278 calls to kcmgrs kcmzrs_ 279 calls to kcmgas kcmzas_ 280 SCN increments due to another database kcmzis_ 281 calls to get snapshot scn: kcmgss kcmzss_ 282 redo blocks read for recovery kcrarbr_ 283 redo k-bytes read for recovery kcrarkbr_ 284 redo k-bytes read for terminal recovery kcrarkbtr_ 285 Streaming Stall Reap krsu_st_strm_st_reap_ 286 Streaming No-Stall Reap krsu_st_strm_nost_reap_ 287 redo entries kcrqte_ 288 redo size kcrqts_ 289 redo entries for lost write detection kcrqtre_ 290 redo size for lost write detection kcrqtrs_ 291 redo size for direct writes kcrqtsdw_ 292 redo buffer allocation retries kcrqaf_ 293 redo wastage kcrqwa_ 294 redo write active strands kcrqas_ 295 redo writes kcrqwc_ 296 redo writes (group 0) kcrqwc_slvgroup0_ 297 redo writes (group 1) kcrqwc_slvgroup1_ 298 redo writes (group 2) kcrqwc_slvgroup2_ 299 redo writes (group 3) kcrqwc_slvgroup3_ 300 redo writes (group 4) kcrqwc_slvgroup4_ 301 redo writes (group 5) kcrqwc_slvgroup5_ 302 redo writes (group 6) kcrqwc_slvgroup6_ 303 redo writes (group 7) kcrqwc_slvgroup7_ 304 redo writes adaptive all kcrqwc_adaptive_all_ 305 redo writes adaptive worker kcrqwc_adaptive_slave_ 306 redo blocks written kcrqwb_ 307 redo blocks written (group 0) kcrqwb_slvgroup0_ 308 redo blocks written (group 1) kcrqwb_slvgroup1_ 309 redo blocks written (group 2) kcrqwb_slvgroup2_ 310 redo blocks written (group 3) kcrqwb_slvgroup3_ 311 redo blocks written (group 4) kcrqwb_slvgroup4_ 312 redo blocks written (group 5) kcrqwb_slvgroup5_ 313 redo blocks written (group 6) kcrqwb_slvgroup6_ 314 redo blocks written (group 7) kcrqwb_slvgroup7_ 315 redo write size count ( 4KB) kcrqws_4kb_ 316 redo write size count ( 8KB) kcrqws_8kb_ 317 redo write size count ( 16KB) kcrqws_16kb_ 318 redo write size count ( 32KB) kcrqws_32kb_ 319 redo write size count ( 64KB) kcrqws_64kb_ 320 redo write size count ( 128KB) kcrqws_128kb_ 321 redo write size count ( 256KB) kcrqws_256kb_ 322 redo write size count ( 512KB) kcrqws_512kb_ 323 redo write size count (1024KB) kcrqws_1mb_ 324 redo write size count (inf) kcrqws_inf_ 325 redo write time kcrqwt_ 326 redo write time (usec) kcrqwt_usec_ 327 redo write worker delay (usec) kcrqwd_ 328 redo write worker delay count kcrqwdc_ 329 redo blocks checksummed by FG (exclusive) kcrqfe_ 330 redo blocks checksummed by LGWR kcrqlc_ 331 redo log space requests kcrqgs_ 332 redo log space wait time kcrqgt_ 333 redo ordering marks kcrqor_ 334 redo subscn max counts kcrqsm_ 335 redo write broadcast ack time kcrqat_ 336 redo write broadcast ack count kcrqac_ 337 redo write broadcast lgwr post count kcrqal_ 338 redo synch time kcrqst_ redo log file sync time 339 redo synch time (usec) kcrqst_usec_ redo log file sync time (usec) 340 redo synch time overhead (usec) kcrqsto_usec_ redo log file sync time overhead (usec) 341 redo synch time overhead count ( 2ms) kcrqstoc_2msec_ redo log file sync overhead ( 2ms) 342 redo synch time overhead count ( 8ms) kcrqstoc_8msec_ redo log file sync overhead ( 8ms) 343 redo synch time overhead count ( 32ms) kcrqstoc_32msec_ redo log file sync overhead ( 32ms) 344 redo synch time overhead count (128ms) kcrqstoc_128msec_ redo log file sync overhead (128ms) 345 redo synch time overhead count (inf) kcrqstoc_inf_ redo log file sync overhead (inf) 346 redo synch writes kcrqsw_ redo log file sync writes 347 redo synch long waits kcrqlw_ redo log file sync long waits 348 redo write gather time kcrls1_ redo log write gather time 349 redo write schedule time kcrls2_ redo log write schedule time 350 redo write issue time kcrls3_ redo log write issue time 351 redo write finish time kcrls4_ redo log write finish time 352 redo write total time kcrls5_ redo log write total time 353 redo synch poll writes kcrqpw_ redo log file sync poll writes 354 redo synch polls kcrqsp_ redo log file sync polls 355 redo write info find kcrqwnfo_find_ 356 redo write info find fail kcrqwnfo_find_fail_ 357 file io service time kcfiost_ data file io service time 358 file io wait time kcfiowt_ data file io wait time 359 gc cr blocks served kclncrs_ 360 gc cr block flush time kclcrft_ 361 gc cr blocks flushed kclcrfn_ 362 gc cr block build time kclcrbt_ 363 gc cr blocks built kclcrbn_ 364 gc read time waited kclcrrwt_ 365 gc read waits kclcrrwsr_ 366 gc read wait failures kclcrrwfa_ 367 gc read wait timeouts kclcrrwto_ 368 gc current blocks served kclncurs_ 369 gc current block pin time kclcurpt_ 370 gc current blocks pinned kclcurpn_ 371 gc current block flush time kclcurft_ 372 gc current blocks flushed kclcurfn_ 373 gc cr blocks received kclncrr_ 374 gc cr block receive time kclcrrt_ 375 gc current blocks received kclncurr_ 376 gc current block receive time kclcurrt_ 377 gc ka grants received kclnkar_ 378 gc ka grant receive time kclkart_ 379 gc cr multiblock grants received kclnmbdgr_ 380 gc cr multiblock grant time kclmbdgrt_ 381 gc status messages received kclsmrcv_ 382 gc status messages sent kclsmsnt_ 383 gc cluster flash cache reads served kclncl2s_ 384 gc cluster flash cache reads received kclncl2r_ 385 gc cluster flash cache received read time kclcl2rt_ 386 gc cluster flash cache reads failure kclncl2rf_ 387 gc flash cache reads served kclnl2rs_ 388 gc flash cache served read time kcll2rst_ 389 gc local grants kclnlgrt_ 390 gc remote grants kclnrgrt_ 391 gc kbytes sent kclbysnd_ 392 gc kbytes saved kclbycom_ 393 gc blocks compressed kclbynum_ 394 gc merge pi fg kclmrgfg_ 395 gc merge pi bg kclmrgbg_ 396 gc cleanout saved kclclsav_ 397 gc cleanout applied kclclapp_ 398 gc cleanout no space kclclns_ 399 gc reader bypass grants kclrbg_ 400 gc reader bypass waits kclrbwt_ 401 gc blocks lost kclncrto_ 402 gc claim blocks lost kclnccto_ 403 gc blocks corrupt kclncrc_ 404 gc send failures kclnsfail_ 405 undo block recovery disk reads skipped kcludrs_ 406 gc CPU used by this session kclxpu_ 407 gc force cr read cr kclfcrdr_ 408 gc force cr read current kclfcror_ 409 gc current blocks received with BPS kclncurrbps_ 410 gc current blocks served with BPS kclncursbps_ 411 gc cr blocks received with BPS kclncrrbps_ 412 gc cr blocks served with BPS kclncrsbps_ 413 gc BPS array full kclndlff_ 414 gc cr bypass requests kclcrbyr_ 415 gc cr anti locks created kclalcrt_ 416 gc cr anti locks expanded kclalcex_ 417 gc cr anti locks shrunk kclalcsh_ 418 gc index split wait timeouts kcliswnto_ 419 gc index split too many slots kcliswnsf_ 420 gc index split too many segments kcliswnuf_ 421 gc index split slot collisions kcliswnsc_ 422 gc IM grants kclimcgr_ 423 gc IM blocks invalidated kclimcinv_ 424 gc IM expands kclimcexp_ 425 gc IM shrinks kclimcshr_ 426 gc flashback wait kclfbwait_ 427 total number of slots kcblnslt_ 428 Effective IO time kcbleio_ 429 Number of read IOs issued kcblnio_ 430 background checkpoints started kcvybs_ 431 background checkpoints completed kcvybc_ 432 BA files created count kbcstat_filecreated_ 433 BA files deleted count kbcstat_filedeleted_ 434 BA file bytes allocated kbcstat_bytesalloced_ 435 BA au bytes allocated kbcstat_spaceused_ 436 BA file bytes deleted kbcstat_bytesdeleted_ 437 BA non-flash bytes requested kbcstat_bytesregular_ 438 BA flash bytes requested kbcstat_bytesflash_ 439 BA bytes for file maps kbcstat_bytesfmaps_ 440 BA bytes read from flash kbcstat_bytesreadflash_ 441 BA bytes read from disk kbcstat_bytesreaddisk_ 442 BA count when 10% of buckets in pb kbcstat_pb_10pct_ 443 BA count when 25% of buckets in pb kbcstat_pb_25pct_ 444 BA count when 50% of buckets in pb kbcstat_pb_50pct_ 445 BA count when 75% of buckets in pb kbcstat_pb_75pct_ 446 BA count when 90% of buckets in pb kbcstat_pb_90pct_ 447 BA count - borrowed from other node kbcstat_usedothernode_ 448 BA count - searched in pb kbcstat_pbox_search_ 449 BA count - total allocation requests kbcstat_allocrequests_ 450 BA count - unable to short circuit in idn kbcstat_fail_sc_idn_ 451 BA count - short circuit in idn kbcstat_succeed_sc_idn_ 452 BA count - cache miss kbcstat_cache_miss_ 453 BA count - cache denied kbcstat_cache_denied_ 454 BA spare statistic 1 kbcstat_spare1_ 455 BA spare statistic 2 kbcstat_spare2_ 456 BA spare statistic 3 kbcstat_spare3_ 457 BA spare statistic 4 kbcstat_spare4_ 458 BA spare statistic 5 kbcstat_spare5_ 459 BA spare statistic 6 kbcstat_spare6_ 460 BA spare statistic 7 kbcstat_spare7_ 461 BA spare statistic 8 kbcstat_spare8_ 462 BA spare statistic 9 kbcstat_spare9_ 463 BA spare statistic 10 kbcstat_spare10_ 464 BA spare statistic 11 kbcstat_spare11_ 465 BA spare statistic 12 kbcstat_spare12_ 466 ADG parselock X get attempts krdrsb_parselock_xget_ 467 ADG parselock X get successes krdrsb_parselock_xget_success_ 468 ADG global flush krdrsb_global_flush_ 469 ADG segment statistics defer invalidation krdrsb_segstat_xdefer_ 470 ADG influx scn advance krdrsb_scnstat_xinflux_ 471 ADG query scn advance krdrsb_scnstat_xquery_ 472 read-only violation count krdrsbrov_cnt_stat_ 473 flashback log writes krfwlgw_ 474 flashback log write bytes krfwlgwb_ 475 redo KB read kcrfrrt_ 476 redo KB read (memory) kcrfrrm_ 477 redo KB read for transport kcrfrrtl_ 478 redo KB read (memory) for transport kcrfrrml_ 479 redo non-durable records skipped kcrfrbsk_ 480 cell physical IO bytes saved during optimized file creation kcfis_oss_fcre_bytes_pushed_ 481 cell physical IO bytes saved during optimized RMAN file restore kcfis_oss_rman_restore_bytes_pushed_ 482 cell physical IO bytes eligible for predicate offload kcfis_bytes_exchanged_disk_ 483 cell physical IO bytes eligible for smart IOs kcfis_eligible_for_io_size_ 484 cell physical IO bytes saved by columnar cache kcfis_bytes_saved_by_colc_ 485 cell physical IO bytes saved by storage index kcfis_bytes_saved_by_storidx_ 486 cell physical IO bytes sent directly to DB node to balance CPU kcfis_bytes_pushed_back_mpp_ 487 cell num bytes in passthru due to quarantine kcfis_bytes_skipped_by_quarantine_ 488 cell smart IO session cache lookups kcfis_ses_cache_lookups_ 489 cell smart IO session cache hits kcfis_ses_cache_hits_ 490 cell smart IO session cache soft misses kcfis_ses_cache_soft_misses_ 491 cell smart IO session cache hard misses kcfis_ses_cache_hard_misses_ 492 cell smart IO session cache hwm kcfis_ses_cache_hwm_ 493 cell num smart IO sessions in rdbms block IO due to user kcfis_ses_using_rdbms_blockio_user_request_ 494 cell num smart IO sessions in rdbms block IO due to open fail kcfis_ses_using_rdbms_blockio_open_fail_ 495 cell num smart IO sessions in rdbms block IO due to no cell mem kcfis_ses_using_rdbms_blockio_cell_nomem_ 496 cell num smart IO sessions in rdbms block IO due to big payload kcfis_num_ses_rdbms_blockio_big_payload_ 497 cell num smart IO sessions using passthru mode due to user kcfis_num_ses_cellpassthru_user_request_ 498 cell num smart IO sessions using passthru mode due to cellsrv kcfis_num_ses_cellpassthru_cellsrv_ 499 cell num smart IO sessions using passthru mode due to timezone kcfis_num_ses_cellpassthru_no_tzf_ 500 cell num smart file creation sessions using rdbms block IO mode kcfis_num_fcre_ses_using_blockio_ 501 cell num block IOs due to a file instant restore in progress kcfis_num_blockio_caused_by_rpop_ 502 cell physical IO interconnect bytes returned by smart scan kcfis_bytes_ret_by_smartscan_ 503 cell num bytes in passthru during predicate offload kcfis_passthru_bytes_ret_ 504 cell num bytes in block IO during predicate offload kcfis_blockio_bytes_ret_ 505 cell num fast response sessions kcfis_num_fast_response_sessions_ 506 cell num fast response sessions continuing to smart scan kcfis_num_fast_response_sessions_using_smart_scan_ 507 cell num smartio automem buffer allocation attempts kcfis_num_smartio_automem_buf_alloc_attempts_ 508 cell num smartio automem buffer allocation failures kcfis_num_smartio_automem_buf_alloc_failures_ 509 cell num smartio transient cell failures kcfis_num_smartio_transient_cell_failures_ 510 cell num smartio permanent cell failures kcfis_num_smartio_permanent_cell_failures_ 511 cell num bytes of IO reissued due to relocation kcfis_bytes_of_io_reissued_due_to_relocation_ 512 cell physical write bytes saved by smart file initialization kcfis_bytes_ffi_ 513 cell XT granules requested for predicate offload kcfis_xtss_granules_req_ 514 cell XT granule bytes requested for predicate offload kcfis_xtss_bytes_req_ 515 cell interconnect bytes returned by XT smart scan kcfis_xtss_bytes_ret_ 516 cell XT granule predicate offload retries kcfis_xtss_retries_ 517 cell XT granule IO bytes saved by storage index kcfis_xtss_bytes_saved_by_storidx_ 518 cell num map elem cancellation kcfis_num_map_elem_cancellation_ 519 cell statistics spare1 kcfis_spare_stat1_ 520 cell statistics spare2 kcfis_spare_stat2_ 521 cell statistics spare3 kcfis_spare_stat3_ 522 cell statistics spare4 kcfis_spare_stat4_ 523 cell statistics spare5 kcfis_spare_stat5_ 524 cell statistics spare6 kcfis_spare_stat6_ 525 Batched IO vector read count kcbpvrc_ 526 Batched IO vector block count kcbpvbc_ 527 Batched IO single block count kcbpsbc_ 528 Batched IO zero block count kcbpzbc_ 529 Batched IO block miss count kcbpbmc_ 530 Batched IO double miss count kcbpdmc_ 531 Batched IO (full) vector count kcbpfvc_ 532 Batched IO (space) vector count kcbpsvc_ 533 Batched IO (bound) vector count kcbpbvc_ 534 Batched IO same unit count kcbpsuc_ 535 Batched IO buffer defrag count kcbpbdc_ 536 Batched IO slow jump count kcbpsjc_ 537 shared io pool buffer get success kcbi_getsuc_ 538 shared io pool buffer get failure kcbi_getfail_ 539 physical reads for data transfer kcnf_stat_pr_ 540 recovery marker krpmmr_ 541 recovery cvmap unavailable krpmcv_ 542 recovery recieve buffer unavailable krpmunavbuf_ 543 recovery local buffer unavailable krpmlunavbuf_ 544 recovery local buffer freed krpmlfrbuf_ 545 recovery remote buffer received krpmrcvdbuf_ 546 recovery remote buffer sent krpmsntbuf_ 547 recovery logmerger catchup krpm_catch_up_ 548 temp space allocated (bytes) kta_tempspc_sesstat_ 549 serializable aborts ktbsza_ 550 transaction lock foreground requests ktufg_ 551 transaction lock foreground wait time ktuft_ 552 transaction lock background gets ktubg_ 553 transaction lock background get time ktubt_ 554 undo change vector size ktuus_ 555 txn cache local read hits ktuimtxnlrh_ 556 txn cache local read misses ktuimtxnlrm_ 557 txn cache local loscn read misses ktuimtxnllscn_ 558 txn cache remote loscn read misses ktuimtxnrlscn_ 559 txn cache local writes ktuimtxnlwt_ 560 txn cache local usn hash write misses ktuimtxnlhwm_ 561 txn cache local usn hash read misses ktuimtxnlhrm_ 562 txn cache remote usn hash read misses ktuimtxnrhrm_ 563 txn cache remote read hits ktuimtxnrrh_ 564 txn cache remote read misses ktuimtxnrrm_ 565 txn cache remote writes ktuimtxnrwt_ 566 txn cache remote active read misses ktuimtxnram_ 567 txn cache local ac read misses ktuimtxnlam_ 568 txn cache redo sync reads ktuimtxnrs_ 569 txn cache remote copy hits ktuimtxnrch_ 570 txn cache remote copy misses ktuimtxnrcm_ 571 txn cache remote ts/inst mismatch ktuimtxnrctm_ 572 txn cache remote proc misses ktuimtxnrpm_ 573 txn cache local proc misses ktuimtxnlpm_ 574 txn cache upper bound misses ktuimtxnum_ 575 txn cache local preset misses ktuimtxnpsm_ 576 txn cache local slot misses ktuimtxnlsm_ 577 txn cache remote slot misses ktuimtxnrsm_ 578 txn cache local seq num misses ktuimtxnlsqm_ 579 txn cache remote seq num misses ktuimtxnrsqm_ 580 txn cache local empty slot misses ktuimtxnlsme_ 581 txn cache remote empty slot misses ktuimtxnrsme_ 582 txn cache local sync commit scn misses ktuimtxnlssm_ 583 txn cache remote sync commit scn misses ktuimtxnrssm_ 584 txn cache remote read msg sent ktuimtxnrms_ 585 txn cache remote fetch double pass ktuimtxnrf_ 586 txn cache remote prefetch count ktuimtxnpf_ 587 txn cache lookup usn exceeds max ktuimtxnluem_ 588 txn cache lookup slot exceeds max ktuimtxnlsem_ 589 txn cache lookup fail read even version ktuimtxnlfrev_ 590 txn cache lookup conflicting write exact ktuimtxnlcwe_ 591 txn cache lookup conflicting write uppper ktuimtxnlcwu_ 592 txn cache init usn slot mismatch ktuimtxniusm_ 593 txn cache init usn exceeds max ktuimtxniuem_ 594 txn cache write usn exceeds max ktuimtxnwuem_ 595 txn cache write slot mismatch ktuimtxnwsm_ 596 transaction tables consistent reads - undo records applied ktuuct_ 597 transaction tables consistent read rollbacks ktutct_ 598 data blocks consistent reads - undo records applied ktuucb_ 599 no work - consistent read gets ktutcn_ 600 cleanouts only - consistent read gets ktutcl_ 601 rollbacks only - consistent read gets ktutcr_ 602 cleanouts and rollbacks - consistent read gets ktutcb_ 603 RowCR attempts kturcf_ 604 RowCR hits kturce_ 605 RowCR - row contention kturcd_ 606 RowCR - resume kturc_resume_ 607 rollback changes - undo records applied ktuurx_ 608 transaction rollbacks ktutrx_ 609 immediate (CURRENT) block cleanout applications ktutlx_ 610 immediate (CR) block cleanout applications ktutlc_ 611 deferred (CURRENT) block cleanout applications ktutld_ 612 commit txn count during cleanout ktuccs_ 613 active txn count during cleanout ktuacs_ 614 cleanout - number of ktugct calls ktucg_ 615 immediate CR cleanouts (index blocks) ktucri_ 616 deferred CUR cleanouts (index blocks) ktucui_ 617 Commit SCN cached ktucsc_ 618 Cached Commit SCN referenced ktucsr_ 619 Block Cleanout Optim referenced ktuclor_ 620 blocks cleaned out using minact ktumi_ 621 min active SCN optimization applied on CR ktumascncr_ 622 auto extends on undo tablespace ktunuax_ 623 drop segment calls in space pressure ktundsp_ 624 total number of undo segments dropped ktunusd_ 625 doubling up with imu segment ktudis_ 626 tune down retentions in space pressure ktutdur_ 627 steps of tune down ret. in space pressure ktustdur_ 628 space was found by tune down ktusftd_ 629 space was not found by tune down ktusnftd_ 630 commit batch/immediate requested ktucwbir_ 631 commit batch requested ktucwbr_ 632 commit immediate requested ktucwir_ 633 commit batch/immediate performed ktucwbip_ 634 commit batch performed ktucwbp_ 635 commit immediate performed ktucwip_ 636 commit wait/nowait requested ktucwsnr_ 637 commit nowait requested ktucwnr_ 638 commit wait requested ktucwsr_ 639 commit wait/nowait performed ktucwsnp_ 640 commit nowait performed ktucwnp_ 641 commit wait performed ktucwsp_ 642 global undo segment hints helped ktughgood_ 643 global undo segment hints were stale ktughstale_ 644 local undo segment hints helped kturhgood_ 645 local undo segment hints were stale kturhstale_ 646 undo segment header was pinned ktuuspin_ 647 IMU commits kticmc_ 648 IMU Flushes ktiflc_ 649 IMU contention ktiwfc_ 650 IMU recursive-transaction flush ktirtf_ 651 IMU undo retention flush ktiutf_ 652 IMU ktichg flush ktinif_ 653 IMU bind flushes ktibnf_ 654 IMU mbu flush ktimbf_ 655 IMU pool not allocated ktipaf_ 656 IMU CR rollbacks kticrb_ 657 IMU undo allocation size ktiuas_ 658 IMU Redo allocation size ktiras_ 659 IMU- failed to get a private strand ktipsf_ 660 Misses for writing mapping ktfmwm_ 661 tracked transactions ktfanutt_ 662 foreground propagated tracked transactions ktfanufpt_ 663 slave propagated tracked transactions ktfanuspt_ 664 large tracked transactions ktfanult_ 665 very large tracked transactions ktfanuvlt_ 666 fbda woken up ktfanufwu_ 667 tracked rows ktfanutr_ 668 CLI Flush ktlistatfls_ 669 CLI BG attempt Flush ktlistatbgfls_ 670 CLI Client Flush ktlistatcfls_ 671 CLI Imm Wrt ktlistatiwrt_ 672 CLI Buf Wrt ktlistatbwrt_ 673 CLI Thru Wrt ktlistattwrt_ 674 CLI Prvtz Lob ktlistatprvt_ 675 CLI SGA Alloc ktlistatsalc_ 676 CLI BG ENQ ktlistatbgeq_ 677 CLI BG Fls done ktlistatbgflsdone_ 678 CLI Flstask create ktlistatflstskcrt_ 679 CLI bytes fls to table ktlistatbytesflstab_ 680 CLI bytes fls to ext ktlistatbytesflsext_ 681 Heatmap SegLevel - Write ktilm_segstat_write_ 682 Heatmap SegLevel - Full Table Scan ktilm_segstat_fts_ 683 Heatmap SegLevel - IndexLookup ktilm_segstat_index_lookup_ 684 Heatmap SegLevel - TableLookup ktilm_segstat_table_lookup_ 685 Heatmap SegLevel - Flush ktilm_segstat_flush_ 686 Heatmap SegLevel - Segments flushed ktilm_segstat_flush_nseg_ 687 IM populate blocks invalid ktm_populate_blksinv_ 688 IM populate transactions check ktm_populate_txchk_ 689 IM populate undo segheader rollback ktm_populate_urb_ 690 IM populate undo records applied ktm_populate_ura_ 691 IM populate transactions active ktm_populate_txact_ 692 IM populate checkpoint time (ms) ktm_populate_cbotime_ 693 IM populate direct read time (ms) ktm_populate_drtime_ 694 IM populate cache read time (ms) ktm_populate_cachetime_ 695 IM repopulate blocks invalid ktm_repopulate_blksinv_ 696 IM repopulate transactions check ktm_repopulate_txchk_ 697 IM repopulate undo segheader rollback ktm_repopulate_urb_ 698 IM repopulate undo records applied ktm_repopulate_ura_ 699 IM repopulate transactions active ktm_repopulate_txact_ 700 IM repopulate transactions copied ktm_repopulate_txcopy_ 701 IM repopulate previous SMU invalid ktm_repopulate_invdold_ 702 IM repopulate checkpoints ktm_repopulate_cbo_ 703 IM repopulate optimized ktm_repopulate_optim_ 704 IM repopulate old SMU nil ktm_repopulate_nullold_ 705 IM repopulate invalid rows ktm_repopulate_actrows_ 706 IM repopulate invalid blks ktm_repopulate_actblks_ 707 IM repopulate blocks now valid ktm_repopulate_blksvld_ 708 IM repopulate optimized RAC/downgrade ktm_repopulate_bibmap_ 709 IM repopulate invalidation transfer time ktm_repopulate_transtime_ 710 IM scan CUs rollback ktm_query_undo_ 711 IM scan CUs no rollback ktm_query_noundo_ 712 IM scan CUs undo records applied ktm_query_urap_ 713 IM scan CUs cleanout ktm_query_smu_cleanout_ 714 IM scan CUs no cleanout ktm_query_smu_nocleanout_ 715 IM scan journal cleanout ktm_query_jrnl_cleanout_ 716 IM scan journal no cleanout ktm_query_jrnl_nocleanout_ 717 IM scan journal ktm_query_jrnl_ 718 IM scan rows journal total ktm_query_jrnl_trows_ 719 IM scan found invalid CU ktm_query_invsmu_ 720 IM repopulate smu colmap used ktm_repopulate_smucolmap_used_ 721 IM scan smu colmap hit ktm_query_smucolmaphit_ 722 IM scan smu colmap miss due to inserts ktm_query_smucolmapmiss_ins_ 723 IM scan smu colmap miss due to deletes ktm_query_smucolmapmiss_del_ 724 IM scan smu colmap miss due to invalid blocks ktm_query_smucolmapmiss_blkinv_ 725 IM scan smu colmap miss due to update ktm_query_smucolmapmiss_upd_ 726 IM scan smu colmap miss due to untracked changes ktm_query_smucolmapmiss_untracked_ 727 IM scan CUs low query scn ktm_query_lowscn_ 728 IM scan CUs notfound dbclose ktm_query_dbclose_ 729 IM scan CUs notfound lob ktm_query_lob_ 730 IM scan CUs notfound ktm_query_notfound_ 731 IM scan CUs invisible smu ktm_query_notvis_ 732 IM scan CUs ref-invis smu ktm_query_refnvis_ 733 IM scan CUs drop-invis smu ktm_query_drpnvis_ 734 IM scan CUs previous ktm_query_oldsmuimcu_ 735 IM scan CUs lowscn no previous ktm_query_lowscn_no_old_ 736 IM scan CUs wait notvis ktm_query_waitvis_ 737 IM scan CUs wait notvis (doublebuffer) ktm_query_waitvis2_ 738 IM scan CUs previous current ktm_query_oldcur_ 739 IM scan CUs current ktm_query_cur_ 740 IM scan CUs maxretry done ktm_query_maxretry_ 741 IM scan CUs no imcu ktm_query_noimcu_ 742 IM transactions ktm_txns_ 743 IM transactions rows journaled ktm_txn_jrnl_rws_added_ 744 IM transactions rows invalidated ktm_txn_smu_rws_added_ 745 IM transactions downgrade ktm_txns_dwngr_ 746 IM transactions blocks invalidated ktm_txn_blksinv_ 747 IM transactions CU cleanout ktm_txn_smu_cleanout_ 748 IM transactions journal cleanout ktm_txn_jrnl_cleanout_ 749 IM transactions found invalid CU ktm_txn_invsmu_ 750 IM transactions self-cleanout no active ktm_txn_selfcln_ 751 IM populate no checkpoint ktm_populate_nodrct_ 752 IM transactions full cleanout ktm_txn_clnthresh_ 753 IM transaction rows array-journal calls ktm_txn_array_call_ 754 IM transaction rows array-journaled ktm_txn_array_rws_added_ 755 IM transaction wait ref-smu ktm_txn_waitref_ 756 IM transactions CUs invalid ktm_txn_imcuinv_ 757 IM rac blocks invalid ktm_rac_blksinv_ 758 IM rac CUs invalid ktm_rac_imcuinv_ 759 IM populate via direct reads ktm_populate_reads_drct_ 760 IM repopulate via direct reads ktm_repopulate_reads_drct_ 761 IM ADG registration failure (quiesce) ktm_load_quiesced_ 762 IM ADG registration attempts ktm_loading_attempt_ 763 IM scan CUs CR cache hit ktm_crclone_ch_ 764 IM scan CUs CR cache miss ktm_crclone_cm_ 765 IM scan CUs CR Incremental ktm_crclone_inc_ 766 IM scan CUs CR skipped large rowids ktm_crclone_largerids_ 767 IM scan CUs readlist creation accumulated time ktmbread_accu_time_ 768 IM scan CUs readlist creation accumulated time (CR) ktmbread_accu_timecr_ 769 IM scan CUs readlist creation number ktmbread_freq_ 770 IM scan CUs readlist creation number (CR) ktmbread_freqcr_ 771 IM scan uncommitted PJ granule ktm_query_ucgranule_ 772 IM repopulate (ADG) transactions copied ktm_repop_numule_transfer_ 773 IM transactions block change blocks already invalid ktmbchg_early_exit_ 774 IM txn zzzz spare1 ktm_imcu_spare1_ 775 IM txn zzzz spare2 ktm_imcu_spare2_ 776 IM txn zzzz spare3 ktm_imcu_spare3_ 777 IM txn zzzz spare4 ktm_imcu_spare4_ 778 IM txn zzzz spare5 ktm_imcu_spare5_ 779 IM ADG corrupt undo blocks seen ktma_corrupt_undo_ 780 IM ADG inv pdb due to corrupt undo ktma_invpdb_crptundo_ 781 IM ADG inv all due to corrupt undo ktma_invall_crptundo_ 782 IM ADG blocks in flush ktma_blks_invadg_ 783 IM ADG redo records seen ktma_rec_seen_ 784 IM ADG non-IMC transactions ktma_txns_nomod_ 785 IM ADG number of query scn moves ktma_qscn_move_ 786 IM ADG time for query scn moves (ms) ktma_qscn_movetime_ 787 IM ADG transactions flushed ktma_txns_flushed_ 788 IM ADG transactions compiled for flush ktma_txns_flushcalls_ 789 IM ADG nothing to flush ktma_flush_noblk_ 790 IM ADG invalidated pdb partial transaction ktma_pdbinv_nobgn_ 791 IM ADG invalidated pdb DDL ktma_pdbinv_misc_ 792 IM ADG invalidated object DDL ktma_objinv_misc_ 793 IM ADG invalidated all objects ktma_all_objinv_ 794 IM ADG commit nodes added ktma_ltnode_add_ 795 IM ADG commit nodes freed ktma_ltnode_free_ 796 IM ADG commit journal destroy ktma_lt_empty_ 797 IM ADG commit journal emptied ktma_lt_flushall_ 798 IM ADG journal sort ktma_jrn_sort_ 799 IM ADG granule split ktma_gran_split_ 800 segment dispenser load tasks ktsld_dispenser_load_ 801 segment dispenser load empty ktsld_dispenser_load_empty_ 802 segment dispenser allocations ktsld_dispenser_invocation_ 803 segment cfs allocations ktsld_cfs_invocation_ 804 segment chunks allocation from dispenser ktsld_dispenser_allocation_ 805 segment total chunk allocation ktsld_all_allocation_ 806 TBS Extension: tasks created kttstat_tc_ 807 TBS Extension: tasks executed kttstat_tx_ 808 TBS Extension: files extended kttstat_fx_ 809 TBS Extension: bytes extended kttstat_bx_ 810 GDR: Active ranges cleared tbsgdr_arc_ 811 GDR: Active blocks cleared tbsgdr_abc_ 812 GDR: Inactive ranges cleared tbsgdr_iarc_ 813 GDR: Inactive blocks cleared tbsgdr_iabc_ 814 GDR: Unused ranges cleared tbsgdr_uarc_ 815 GDR: Unused blocks cleared tbsgdr_uabc_ 816 GDR: Total segments processed tbsgdr_nseg_ 817 GDR: Total segments skipped tbsgdr_nsskip_ 818 GDR: Total blocks skipped tbsgdr_nbskip_ 819 GDR: Total files processed tbsgdr_nfiles_ 820 total number of times SMON posted ktmsttotl_ 821 SMON posted for undo segment recovery ktmsturcv_ 822 SMON posted for txn recovery for other instances ktmstircv_ 823 SMON posted for instance recovery ktmstirca_ 824 SMON posted for undo segment shrink ktmstussh_ 825 SMON posted for dropping temp segment ktmstdtms_ 826 KTFB alloc req ktfbstat_alloc_req_ 827 KTFB alloc space (block) ktfbstat_alloc_byte_ 828 KTFB alloc time (ms) ktfbstat_alloc_time_ 829 KTFB free req ktfbstat_free_req_ 830 KTFB free space (block) ktfbstat_free_byte_ 831 KTFB free time (ms) ktfbstat_free_time_ 832 KTFB apply req ktfbstat_apply_req_ 833 KTFB apply time (ms) ktfbstat_apply_time_ 834 KTFB commit req ktfbstat_commit_req_ 835 KTFB commit time (ms) ktfbstat_commit_time_ 836 KTFB alloc myinst ktfbstat_alloc_myinst_ 837 KTFB alloc steal ktfbstat_alloc_steal_ 838 KTFB alloc search FFB ktfbstat_alloc_l1_ 839 segment prealloc tasks ktslj_prealloc_tasks_ 840 segment prealloc ops ktslj_prealloc_ops_ 841 segment prealloc bytes ktslj_prealloc_bytes_ 842 segment prealloc time (ms) ktslj_prealloc_time_ 843 segment prealloc ufs2cfs bytes ktslj_prealloc_mvbytes_ 844 Heatmap BlkLevel Tracked ktfs_set_stat_ 845 Heatmap BlkLevel Not Tracked - Memory ktfs_notset_mem_ 846 Heatmap BlkLevel Not Updated - Repeat ktfs_notset_rep_ 847 Heatmap BlkLevel Flushed ktfs_blocks_flushed_ 848 Heatmap BlkLevel Flushed to SYSAUX ktfs_blocks_flushed_sa_ 849 Heatmap BlkLevel Flushed to BF ktfs_blocks_flushed_bf_ 850 Heatmap BlkLevel Ranges Flushed ktfs_ranges_flushed_ 851 Heatmap BlkLevel Ranges Skipped ktfs_range_flush_skipped_ 852 Heatmap BlkLevel Flush Task Create ktfs_create_flush_task_ 853 Heatmap Blklevel Flush Task Count ktfs_flush_task_ 854 IM default area resized ktsimastatvar_imdefresize_ 855 IM space CU extents allocated ktsimstatvar_imcuea_ 856 IM space SMU extents allocated ktsimstatvar_smuea_ 857 IM space CU bytes allocated ktsimstatvar_imcuba_ 858 IM space SMU bytes allocated ktsimstatvar_smuba_ 859 IM space CU creations initiated ktsimstatvar_imcui_ 860 IM space SMU creations initiated ktsimstatvar_smui_ 861 IM space CU creations committed ktsimstatvar_imcuc_ 862 IM space SMU creations committed ktsimstatvar_smuc_ 863 IM space private journal extents allocated ktsimstatvar_pjea_ 864 IM space ADG extents allocated ktsimstatvar_adea_ 865 IM space private journal bytes allocated ktsimstatvar_pjba_ 866 IM space ADG bytes allocated ktsimstatvar_adba_ 867 IM space shared journal extents allocated ktsimstatvar_sjea_ 868 IM space shared journal bytes allocated ktsimstatvar_sjba_ 869 IM space CU extents freed ktsimstatvar_imcuef_ 870 IM space SMU extents freed ktsimstatvar_smuef_ 871 IM space CU bytes freed ktsimstatvar_imcubf_ 872 IM space SMU bytes freed ktsimstatvar_smubf_ 873 IM space private journal extents freed ktsimstatvar_pjef_ 874 IM space ADG journal extents freed ktsimstatvar_adef_ 875 IM space private journal bytes freed ktsimstatvar_pjbf_ 876 IM space ADG bytes freed ktsimstatvar_adbf_ 877 IM space shared journal extents freed ktsimstatvar_sjef_ 878 IM space shared journal bytes freed ktsimstatvar_sjbf_ 879 IM space segments allocated ktsimstatvar_imcsa_ 880 IM space private journal segments allocated ktsimstatvar_pjsa_ 881 IM space ADG segments allocated ktsimstatvar_adsa_ 882 IM space shared journal segments allocated ktsimstatvar_sjsa_ 883 IM space segments freed ktsimstatvar_imcsf_ 884 IM space private journal segments freed ktsimstatvar_pjsf_ 885 IM space ADG segments freed ktsimstatvar_adsf_ 886 IM space shared journal segments freed ktsimstatvar_sjsf_ 887 ASSM gsp:use space reservation ktsp_gsp_spcrsv_ 888 ASSM gsp:Alignment unavailable in space res ktsp_gsp_alignrej_spcrsv_ 889 ASSM gsp:space reservation success ktsp_gsp_suc_spcrsv_ 890 ASSM gsp:blocks requested by space reservation ktsp_gsp_blksreq_spcrsv_ 891 ASSM gsp:blocks provided by space reservation ktsp_gsp_blksprov_spcrsv_ 892 ASSM gsp:blocks rejected by access layer callback ktsp_gsp_cbkrej_spcrsv_ 893 ASSM gsp:get free block ktsp_gsp_nreq_ 894 ASSM gsp:get free critical block ktsp_gsp_critical_nreq_ 895 ASSM gsp:get free data block ktsp_gsp_data_nreq_ 896 ASSM gsp:get free lob block ktsp_gsp_lob_nreq_ 897 ASSM gsp:get free index block ktsp_gsp_index_nreq_ 898 ASSM cbk:blocks examined ktsp_gsp_examined_ 899 ASSM cbk:blocks rejected ktsp_gsp_cbk_rejects_ 900 ASSM cbk:blocks accepted ktsp_gsp_cbk_success_ 901 ASSM cbk:blocks marked full ktsp_gsp_cbk_markedfull_ 902 ASSM gsp:L1 bitmaps examined ktsp_gsp_l1pin_ 903 ASSM gsp:L2 bitmaps examined ktsp_gsp_l2pin_ 904 ASSM gsp:L3 bitmaps examined ktsp_gsp_l3pin_ 905 ASSM gsp:L2 bitmap full ktsp_gsp_l2full_ 906 ASSM gsp:Search all ktsp_gsp_all_ 907 ASSM gsp:Search hint ktsp_gsp_hint_ 908 ASSM gsp:Search steal ktsp_gsp_steal_ 909 ASSM gsp:bump HWM ktsp_gsp_bump_hwm_ 910 ASSM gsp:reject db ktsp_rc_adddb_ 911 ASSM gsp:reject L1 ktsp_rc_addl1_ 912 ASSM gsp:reject L2 ktsp_rc_addl2_ 913 ASSM gsp:reject L3 ktsp_rc_addl3_ 914 ASSM gsp:Optimized reject DB ktsp_rc_opt_rejdb_ 915 ASSM gsp:Optimized reject l1 ktsp_rc_opt_rejl1_ 916 ASSM gsp:Optimized reject l2 ktsp_rc_opt_rejl2_ 917 ASSM gsp:good hint ktsp_rc_good_hint_ 918 ASSM gsp:Optimized index block rejects ktsp_gsp_index_rej_ 919 ASSM gsp:Optimized data block rejects ktsp_gsp_data_rej_ 920 ASSM gsp:add extent ktsp_add_extent_ 921 ASSM wasted db state change ktsp_wated_stchg_ 922 ASSM bg: segment fix monitor ktsp_bg_segfix_monitor_ 923 ASSM fg: submit segment fix task ktsp_fg_submit_fixtask_ 924 ASSM bg:mark segment for fix ktsp_bg_mark_segfix_ 925 ASSM bg:create segment fix task ktsp_bg_create_fixtask_ 926 ASSM bg:slave fix one segment ktsp_bgslave_fix1seg_ 927 ASSM bg:slave compress block ktsp_bgslave_compblk_ 928 ASSM bg:slave fix state ktsp_bgslave_fixstate_ 929 ASSM rsv:fill reserve ktsp_rsv_fill_ 930 ASSM rsv:alloc from reserve ktsp_rsv_gsp_ 931 ASSM rsv:alloc from reserve fail ktsp_rsv_gsp_fail_ 932 ASSM rsv:alloc from reserve succ ktsp_rsv_gsp_succ_ 933 ASSM rsv:clear reserve ktsp_rsv_clear_ 934 table scans (short tables) kdstss_ 935 table scans (long tables) kdstsl_ 936 table scans (rowid ranges) kdstsr_ 937 table scans (IM) kdstim_ 938 table scans (cache partitions) kdstsc_ 939 table scans (direct read) kdstsd_ 940 table scan rows gotten kdsrws_ 941 table scan rs1 kdsrs1_ 942 table scan rs2 kdsrs2_ 943 table scan disk non-IMC rows gotten kdsrws_nonimc_ 944 table scan disk IMC fallback kdsrws_imc_ 945 table scan blocks gotten kdstsb_ 946 table fetch by rowid kdsbri_ 947 table fetch continued row kdsbco_ 948 cluster key scans kdscsi_ 949 cluster key scan block gets kdsbch_ 950 rows fetched via callback kdscbr_ 951 cell scans kdssag_ 952 cell blocks processed by cache layer kdsscpss_ 953 cell blocks processed by txn layer kdsstpss_ 954 cell blocks processed by data layer kdssdpss_ 955 cell blocks processed by index layer kdssipss_ 956 cell filtered blocks failed block check kdssbkck_ 957 cell commit cache queries kdsstccq_ 958 cell transactions found in commit cache kdsstccf_ 959 cell blocks helped by commit cache kdsstcch_ 960 cell blocks helped by minscn optimization kdsstmsh_ 961 cell chained rows skipped kdssdchn_ 962 cell chained rows processed kdsscrpr_ 963 cell chained row pieces fetched kdsscrpft_ 964 cell chained rows rejected kdsscrrj_ 965 error count cleared by cell kdssderc_ 966 cell blocks sent kdssssb_ 967 cell blocks pivoted kdsspvt_ 968 cell IO uncompressed bytes kdssszuc_ 969 cell scan CUs pcode aggregation pushdown kdsspgby_ 970 cell scan rows pcode aggregated kdssprwsa_ 971 cell scan CUs pcode selective done kdsspsel_ 972 cell scan CUs pcode pred evaled kdssppred_ 973 cell scan CUs pcode pred evaled using rowsets kdssprset_ 974 cell simulated physical IO bytes eligible for predicate offload kdsskinp_ 975 cell simulated physical IO bytes returned by predicate offload kdsskout_ 976 queue update without cp update kducp_fail_ 977 index crx upgrade (prefetch) kdifkca_ 978 index crx upgrade (found) kdifkcb_ 979 index crx upgrade (positioned) kdifkcc_ 980 index cmph dm, split for cu migrate row kdihcms_ 981 index cmph dm, cu migrate row kdihcmr_ 982 index cmph dm, insert unpurge CU row kdiinupr_ 983 index cmpl ro, prefix change at block kdiapca_ 984 index cmpl ro, prefix no change at block kdiapcb_ 985 index cmpl ro, blocks not compressed kdiapcc_ 986 index cmpl ro, reorg avoid load new block kdiapcd_ 987 index cmpl ro, reorg avoid split kdiapce_ 988 index cmpl co, prefix mismatch kdiapcf_ 989 index split cancel wait noclean kdiscnw_ 990 index split cancel wait clean kdiscdw_ 991 index split cancel op set kdiscop_ 992 leaf node splits kdisln_ 993 leaf node 90-10 splits kdislr_ 994 index cmph sp, leaf recompress kdisaln_ 995 index cmph sp, leaf norecomp nospace kdisrfa_ 996 index cmph sp, leaf norecomp negcomp kdisrfb_ 997 index cmph sp, leaf norecomp oversize kdisrfc_ 998 index cmph sp, leaf norecomp zerocur kdisrfd_ 999 index cmph sp, leaf norecomp limit kdisrfe_ 1000 index cmph sp, leaf norecomp notry kdisrfz_ 1001 index cmph sp, leaf 90_10 failed kdisflr_ 1002 branch node splits kdisbn_ 1003 root node splits kdisrn_ 1004 failed probes on index block reclamation kdisfprb_ 1005 recursive aborts on index block reclamation kdisabrt_ 1006 index reclamation/extension switch kdisrejs_ 1007 lob reads kdlss_read_ops_ 1008 lob writes kdlss_write_ops_ 1009 lob writes unaligned kdlss_uwrite_ops_ 1010 cell index scans kdircis_ 1011 index fast full scans (full) kdirffsf_ 1012 index fast full scans (rowid ranges) kdirffsr_ 1013 index fast full scans (direct read) kdirffsd_ 1014 index fetch by key kdifks_ 1015 index scans kdiixs1 kdiixc_ 1016 index cmph sc, ffs decomp buffers kdirffsbd_ 1017 index cmph sc, ffs decomp buffers rows avail kdirffsra_ 1018 index cmph sc, ffs decomp buffers rows used kdirffsru_ 1019 index cmph sc, ffs decomp failures kdirffsdf_ 1020 index cmph sc, ffs decomp buffers released and found valid kdirffsbv_ 1021 queue splits kdqs_splits_ 1022 queue flush kdqs_flush_ 1023 queue position update kdqs_position_ 1024 queue single row kdqs_single_row_enqueues_ 1025 queue ocp pages kdqs_create_overflow_ 1026 queue qno pages kdqs_ooo_ 1027 heap block compress kdbcst_ 1028 HSC OLTP Space Saving kdbhscsave_ 1029 HSC OLTP Compressed Blocks kdbhscnblk_ 1030 HSC IDL Compressed Blocks kdbidlcmp_ 1031 HSC Compressed Segment Block Changes kdbhscchg_ 1032 HSC Heap Segment Block Changes kdbheapchg_ 1033 HSC OLTP Non Compressible Blocks kdbhscoffBlk_ 1034 HSC OLTP positive compression kdboltppos_ 1035 HSC OLTP negative compression kdboltpneg_ 1036 HSC OLTP recursive compression kdboltprec_ 1037 HSC OLTP inline compression kdboltpinline_ 1038 HSC OLTP partial compression kdboltppartial_ 1039 HSC OLTP Drop Column kdbhscdrop_ 1040 HSC OLTP Compression skipped rows kdbskipped_ 1041 HSC OLTP compression block checked kdboltpblkchk_ 1042 Heap Segment Array Inserts kdbheaparins_ 1043 Heap Segment Array Updates kdbheaparupd_ 1044 HSC OLTP Compression wide compressed row pieces kdboltpwiderowp_ 1045 securefile allocation bytes kdliss_spc_bytes_ 1046 securefile allocation chunks kdliss_spc_chunks_ 1047 securefile direct read bytes kdliss_ior_bytes_ 1048 securefile direct write bytes kdliss_iow_bytes_ 1049 securefile direct read ops kdliss_ior_ops_ 1050 securefile direct write ops kdliss_iow_ops_ 1051 securefile inode read time kdliss_tread_ 1052 securefile inode write time kdliss_twrite_ 1053 securefile inode ioreap time kdliss_tioreap_ 1054 securefile inode lhb redo kdliss_hredo_ 1055 securefile inode itree redo kdliss_iredo_ 1056 securefile bytes non-transformed kdlw_flush_bytes_ 1057 securefile number of non-transformed flushes kdlw_flush_ops_ 1058 securefile bytes encrypted kdlxss_enc_bytes_ 1059 securefile bytes cleartext kdlxss_ctxt_bytes_ 1060 securefile compressed bytes kdlxss_cmp_bytes_ 1061 securefile uncompressed bytes kdlxss_ucmp_bytes_ 1062 securefile bytes deduplicated kdlxdupbyt_ 1063 securefile create dedup set kdlxdupcwl_ 1064 securefile destroy dedup set kdlxdupdwl_ 1065 securefile add dedupd lob to set kdlxdupask_ 1066 securefile rmv from dedup set kdlxduprsk_ 1067 securefile reject deduplication kdlxduprej_ 1068 securefile dedup prefix hash match kdlxdupphm_ 1069 securefile number of flushes kdlxdupflush_ 1070 securefile dedup flush too low kdlxdupftl_ 1071 securefile dedup callback oper final kdlxdupcbk_ 1072 securefile dedup hash collision kdlxduphcl_ 1073 securefile dedup fits inline kdlxdupfil_ 1074 securefile dedup wapp cache miss kdlxdupwac_ 1075 HCC load direct CUs kdz_cus_comp_ 1076 HCC load conventional CUs kdz_cus_comp_dml_ 1077 HCC load direct CUs query low kdz_cus_comp_low_ 1078 HCC load direct CUs query high kdz_cus_comp_high_ 1079 HCC load direct CUs archive high kdz_cus_comp_archive_high_ 1080 HCC load direct CUs archive low kdz_cus_comp_archive_low_ 1081 HCC load conventional CUs query low kdz_cus_comp_low_dml_ 1082 HCC load conventional CUs query high kdz_cus_comp_high_dml_ 1083 HCC load conventional CUs archive high kdz_cus_comp_archive_high_dml_ 1084 HCC load conventional CUs archive low kdz_cus_comp_archive_low_dml_ 1085 HCC load direct bytes compressed kdz_comp_len_comp_ 1086 HCC load conventional bytes compressed kdz_comp_len_comp_dml_ 1087 HCC load direct bytes uncompressed kdz_decomp_len_comp_ 1088 HCC load conventional bytes uncompressed kdz_decomp_len_comp_dml_ 1089 HCC load direct rows kdz_comp_rows_comp_ 1090 HCC load conventional rows kdz_comp_rows_comp_dml_ 1091 HCC load direct rows not compressed kdz_uncomp_rows_comp_ 1092 HCC load conventional rows not compressed kdz_uncomp_rows_comp_dml_ 1093 HCC load direct CUs row pieces kdz_total_pieces_comp_ 1094 HCC load conventional CUs row pieces kdz_total_pieces_comp_dml_ 1095 HCC scan rdbms CUs decompressed kdz_cus_decomp_ 1096 HCC scan cell CUs decompressed kdz_cus_decomp_cell_ 1097 HCC scan rdbms CUs query low kdz_cus_decomp_low_ 1098 HCC scan cell CUs query low kdz_cus_decomp_low_cell_ 1099 HCC scan rdbms CUs query high kdz_cus_decomp_high_ 1100 HCC scan cell CUs query high kdz_cus_decomp_high_cell_ 1101 HCC scan rdbms CUs archive high kdz_cus_decomp_archive_high_ 1102 HCC scan cell CUs archive high kdz_cus_decomp_archive_high_cell_ 1103 HCC scan rdbms CUs archive low kdz_cus_decomp_archive_low_ 1104 HCC scan cell CUs archive low kdz_cus_decomp_archive_low_cell_ 1105 HCC scan rdbms bytes compressed kdz_comp_len_decomp_ 1106 HCC scan cell bytes compressed kdz_comp_len_decomp_cell_ 1107 HCC scan rdbms bytes decompressed kdz_decomp_len_decomp_ 1108 HCC scan cell bytes decompressed kdz_decomp_len_decomp_cell_ 1109 HCC scan rdbms CUs columns accessed kdz_num_cols_decomp_ 1110 HCC scan cell CUs columns accessed kdz_num_cols_decomp_cell_ 1111 HCC scan rdbms columns theoretical max kdz_total_cols_decomp_ 1112 HCC scan cell columns theoretical max kdz_total_cols_decomp_cell_ 1113 HCC scan rdbms rows kdz_total_rows_decomp_ 1114 HCC scan cell rows kdz_total_rows_decomp_cell_ 1115 HCC scan rdbms CUs row pieces accessed kdz_pieces_buffered_decomp_ 1116 HCC scan cell CUs row pieces accessed kdz_pieces_buffered_decomp_cell_ 1117 HCC scan rdbms CUs row pieces total kdz_total_pieces_decomp_ 1118 HCC scan cell CUs row pieces total kdz_total_pieces_decomp_cell_ 1119 HCC scan rdbms CUs decompression time kdz_decomp_time_ 1120 HCC scan cell CUs decompression time kdz_decomp_time_cell_ 1121 HCC DML CUs kdz_dml_cus_decomp_ 1122 HCC scan rdbms CUs normal kdz_scan_cus_decomp_ 1123 HCC scan rdbms CUs turbo kdz_turbo_scan_cus_decomp_ 1124 HCC fetch by rowid CUs kdz_rowid_cus_decomp_ 1125 HCC analyze table CUs kdz_dg_cus_decomp_ 1126 HCC block dump CUs kdz_dmp_cus_decomp_ 1127 HCC block check CUs kdz_chk_cus_decomp_ 1128 HCC analyzer calls kdz_analyze_calls_ 1129 HCC usage ZFS kdz_zfs_hcc_ 1130 HCC usage pillar kdz_pillar_hcc_ 1131 HCC usage cloud kdz_cloud_hcc_ 1132 HCC DML conventional kdz_hccconvdml_ 1133 cellmemory IM scan CUs processed for query kdzf_cus_decomp_cc_query_ 1134 cellmemory IM scan CUs processed for capacity kdzf_cus_decomp_cc_capac_ 1135 cellmemory IM scan CUs processed no memcompress kdzf_cus_decomp_cc_none_ 1136 cellmemory IM load CUs for query kdzf_cus_comp_cc_query_ 1137 cellmemory IM load CUs for capacity kdzf_cus_comp_cc_capac_ 1138 cellmemory IM load CUs no memcompress kdzf_cus_comp_cc_none_ 1139 cellmemory IM scan CUs rejected for query kdzf_cus_reject_cc_query_ 1140 cellmemory IM scan CUs rejected for capacity kdzf_cus_reject_cc_capac_ 1141 cellmemory IM scan CUs rejected no memcompress kdzf_cus_reject_cc_none_ 1142 cellmemory IM scan stat 1 kdzf_cus_cc_stat1_ 1143 cellmemory IM scan stat 2 kdzf_cus_cc_stat2_ 1144 cellmemory IM scan stat 3 kdzf_cus_cc_stat3_ 1145 cellmemory IM scan stat 4 kdzf_cus_cc_stat4_ 1146 cellmemory IM scan stat 5 kdzf_cus_cc_stat5_ 1147 HCC block compressions completed kdz_noncucomp_ 1148 HCC block compressions attempted kdz_noncutries_ 1149 HCC scan rdbms CUs predicates received kdz_mm_pred_recv_ 1150 HCC scan cell CUs predicates received kdz_mm_pred_recv_cell_ 1151 HCC scan rdbms CUs predicates optimized kdz_mm_pred_some_ 1152 HCC scan cell CUs predicates optimized kdz_mm_pred_some_cell_ 1153 HCC scan rdbms CUs predicates applied kdz_mm_pred_appl_ 1154 HCC scan cell CUs predicates applied kdz_mm_pred_appl_cell_ 1155 HCC scan rdbms CUs optimized read kdz_mm_cu_all_ 1156 HCC scan cell CUs optimized read kdz_mm_cu_all_cell_ 1157 HCC scan rdbms CUs pruned kdz_mm_cu_none_ 1158 HCC scan cell CUs pruned kdz_mm_cu_none_cell_ 1159 HCC scan cell CUs sent uncompressed kdz_scuuc_ 1160 HCC scan cell CUs sent compressed kdz_scucc_ 1161 HCC scan cell CUs sent head piece kdz_scuhp_ 1162 HCC scan cell CUs processed for uncompressed kdz_scupu_ 1163 HCC scan cell CUs processed for compressed kdz_scupc_ 1164 HCC scan CUs pcode selective done kdz_pcode_do_sel_ 1165 SecureFiles DBFS Link Operations kdla_ops_ 1166 SecureFiles Move to DBFS Link kdla_puts_ 1167 SecureFiles Copy from DBFS Link kdla_gets_ 1168 SecureFiles Get DBFS Link Reference kdla_get_refs_ 1169 SecureFiles Put DBFS Link Reference kdla_put_refs_ 1170 SecureFiles Implicit Copy from DBFS Link kdla_implicit_gets_ 1171 SecureFiles DBFS Link streaming reads kdla_stream_reads_ 1172 SecureFiles DBFS Link Overwrites kdla_overwrites_ 1173 IM populate segments requested kdm_populate_seg_ 1174 IM prepopulate segments requested kdm_prepopulate_seg_ 1175 IM repopulate segments requested kdm_repopulate_seg_ 1176 IM populate segments kdm_populate_seg_succ_ 1177 IM prepopulate segments kdm_prepopulate_seg_succ_ 1178 IM repopulate segments kdm_repopulate_seg_succ_ 1179 IM populate CUs requested kdm_populate_cu_ 1180 IM prepopulate CUs requested kdm_prepopulate_cu_ 1181 IM repopulate CUs requested kdm_repopulate_cu_ 1182 IM repopulate (trickle) CUs requested kdm_trepopulate_cu_ 1183 IM repopulate (scan) CUs requested kdm_scanrepopulate_cu_ 1184 IM repopulate (incremental) CUs requested kdm_incremental_repop_cu_ 1185 IM repopulate (doublebuffering) CUs requested kdm_dblbuf_repop_cu_req_ 1186 IM repopulate (incremental) CUs old CU unavailable kdm_incremental_oldcu_unavail_ 1187 IM repopulate (incremental) CUs old CU empty kdm_incremental_oldcu_empty_ 1188 IM repopulate (incremental) CUs old CU defchg kdm_incremental_oldcu_defchg_ 1189 IM populate CUs resubmitted kdm_populate_cu_resubmit_ 1190 IM prepopulate CUs resubmitted kdm_prepopulate_cu_resubmit_ 1191 IM repopulate CUs resubmitted kdm_repopulate_cu_resubmit_ 1192 IM repopulate (trickle) CUs resubmitted kdm_trepopulate_cu_resubmit_ 1193 IM repopulate (scan) CUs resubmitted kdm_scanrepopulate_cu_resubmit_ 1194 IM populate CUs not kdm_populate_cu_not_ 1195 IM prepopulate CUs not kdm_prepopulate_cu_not_ 1196 IM repopulate CUs not kdm_repopulate_cu_not_ 1197 IM repopulate (trickle) CUs not kdm_trepopulate_cu_not_ 1198 IM repopulate (scan) CUs not kdm_scanrepopulate_cu_not_ 1199 IM populate CUs nop kdm_populate_cu_nop_ 1200 IM prepopulate CUs nop kdm_prepopulate_cu_nop_ 1201 IM repopulate CUs nop kdm_repopulate_cu_nop_ 1202 IM repopulate (trickle) CUs nop kdm_trepopulate_cu_nop_ 1203 IM repopulate (scan) CUs nop kdm_scanrepopulate_cu_nop_ 1204 IM populate CUs no blocks kdm_populate_cu_noblocks_ 1205 IM prepopulate CUs no blocks kdm_prepopulate_cu_noblocks_ 1206 IM populate CUs kdm_populate_cu_succ_ 1207 IM prepopulate CUs kdm_prepopulate_cu_succ_ 1208 IM repopulate CUs kdm_repopulate_cu_succ_ 1209 IM repopulate (trickle) CUs kdm_trepopulate_cu_succ_ 1210 IM repopulate (scan) CUs kdm_scanrepopulate_cu_succ_ 1211 IM repopulate (incremental) CUs kdm_incremental_repop_cu_succ_ 1212 IM repopulate (doublebuffering) CUs kdm_dblbuf_repop_cu_succ_ 1213 IM repopulate (incremental) CUs using population kdm_incremental_pop_cu_succ_ 1214 IM populate bytes from storage kdm_populate_bytes_storage_ 1215 IM prepopulate bytes from storage kdm_prepopulate_bytes_storage_ 1216 IM repopulate bytes from storage kdm_repopulate_bytes_storage_ 1217 IM repopulate (trickle) bytes from storage kdm_trepopulate_bytes_storage_ 1218 IM repopulate due to row threshold hit kdm_repopulate_rowthresh_ 1219 IM repopulate due to block threshold hit kdm_repopulate_blkthresh_ 1220 IM populate accumulated time (ms) kdm_populate_accumulated_time_ 1221 IM populate segments wall clock time (ms) kdm_imc_populate_wall_clock_time_ 1222 IM prepopulate accumulated time (ms) kdm_prepopulate_accumulated_time_ 1223 IM repopulate accumulated time (ms) kdm_repopulate_accumulated_time_ 1224 IM repopulate (trickle) accumulated time (ms) kdm_trepopulate_accumulated_time_ 1225 IM repopulate read time (ms) kdm_repopulate_read_time_ 1226 IM populate buffer direct read time (ms) kdm_populate_drtime_ 1227 IM populate CUs empty kdm_populate_cu_empty_ 1228 IM repopulate CUs empty kdm_repopulate_cu_empty_ 1229 IM prepopulate CUs empty kdm_prepopulate_cu_empty_ 1230 IM repopulate (trickle) CUs empty kdm_trepopulate_cu_empty_ 1231 IM populate CUs columns kdm_populate_cu_cols_ 1232 IM prepopulate CUs columns kdm_prepopulate_cu_cols_ 1233 IM repopulate CUs columns kdm_repopulate_cu_cols_ 1234 IM repopulate (trickle) CUs columns kdm_trepopulate_cu_cols_ 1235 IM populate bytes in-memory data kdm_comp_len_comp_ 1236 IM prepopulate bytes in-memory data kdm_comp_len_comp_prepop_ 1237 IM repopulate bytes in-memory data kdm_comp_len_comp_repop_ 1238 IM repopulate (trickle) bytes in-memory data kdm_comp_len_comp_trepop_ 1239 IM populate bytes uncompressed data kdm_decomp_len_comp_ 1240 IM prepopulate bytes uncompressed data kdm_decomp_len_comp_prepop_ 1241 IM repopulate bytes uncompressed data kdm_decomp_len_comp_repop_ 1242 IM repopulate (trickle) bytes uncompressed data kdm_decomp_len_comp_trepop_ 1243 IM populate rows kdm_comp_rows_comp_ 1244 IM prepopulate rows kdm_comp_rows_comp_prepop_ 1245 IM repopulate rows kdm_comp_rows_comp_repop_ 1246 IM repopulate (trickle) rows kdm_comp_rows_comp_trepop_ 1247 IM populate CUs chain pieces kdm_total_pieces_comp_ 1248 IM prepopulate CUs chain pieces kdm_total_pieces_comp_prepop_ 1249 IM repopulate CUs chain pieces kdm_total_pieces_comp_repop_ 1250 IM repopulate (trickle) CUs chain pieces kdm_total_pieces_comp_trepop_ 1251 IM populate CUs no memcompress kdm_cus_comp_imc_nocompress_ 1252 IM prepopulate CUs no memcompress kdm_cus_comp_imc_nocompress_prepop_ 1253 IM repopulate CUs no memcompress kdm_cus_comp_imc_nocompress_repop_ 1254 IM repopulate (trickle) CUs no memcompress kdm_cus_comp_imc_nocompress_trepop_ 1255 IM populate CUs memcompress for dml kdm_cus_comp_imc_dml_ 1256 IM prepopulate CUs memcompress for dml kdm_cus_comp_imc_dml_prepop_ 1257 IM repopulate CUs memcompress for dml kdm_cus_comp_imc_dml_repop_ 1258 IM repopulate (trickle) CUs memcompress for dml kdm_cus_comp_imc_dml_trepop_ 1259 IM populate CUs memcompress for query low kdm_cus_comp_imc_querylow_ 1260 IM prepopulate CUs memcompress for query low kdm_cus_comp_imc_querylow_prepop_ 1261 IM repopulate CUs memcompress for query low kdm_cus_comp_imc_querylow_repop_ 1262 IM repopulate (trickle) CUs memcompress for query low kdm_cus_comp_imc_querylow_trepop_ 1263 IM populate CUs memcompress for query high kdm_cus_comp_imc_queryhigh_ 1264 IM prepopulate CUs memcompress for query high kdm_cus_comp_imc_queryhigh_prepop_ 1265 IM repopulate CUs memcompress for query high kdm_cus_comp_imc_queryhigh_repop_ 1266 IM repopulate (trickle) CUs memcompress for query high kdm_cus_comp_imc_queryhigh_trepop_ 1267 IM populate CUs memcompress for capacity low kdm_cus_comp_imc_capacitylow_ 1268 IM prepopulate CUs memcompress for capacity low kdm_cus_comp_imc_capacitylow_prepop_ 1269 IM repopulate CUs memcompress for capacity low kdm_cus_comp_imc_capacitylow_repop_ 1270 IM repopulate (trickle) CUs memcompress for capacity low kdm_cus_comp_imc_capacitylow_trepop_ 1271 IM populate CUs memcompress for capacity high kdm_cus_comp_imc_capacityhigh_ 1272 IM prepopulate CUs memcompress for capacity high kdm_cus_comp_imc_capacityhigh_prepop_ 1273 IM repopulate CUs memcompress for capacity high kdm_cus_comp_imc_capacityhigh_repop_ 1274 IM repopulate (trickle) CUs memcompress for capacity high kdm_cus_comp_imc_capacityhigh_trepop_ 1275 IM scan CUs pcode aggregation pushdown kdm_pcode_agg_gby_ 1276 IM scan rows pcode aggregated kdm_rows_aggregated_ 1277 IM scan CUs pcode selective done kdm_pcode_do_sel_ 1278 IM scan CUs pcode pred evaled kdm_pcode_pred_eva_ 1279 IM scan CUs pcode pred evaled using rowsets kdm_pcode_pred_rset_ 1280 IM scan CUs pcode aggregation IME kdm_pcode_ime_agg_ 1281 IM scan dict engine results stored kdm_dict_engi_stored_ 1282 IM scan dict engine results reused kdm_dict_engi_reused_ 1283 IM faststart read data accumulated time (ms) kdm_imc_loadfs_loadcu_time_ 1284 IM faststart read CUs problems kdm_imc_loadfs_problem_ 1285 IM faststart read headers accumulated time (ms) kdm_imc_loadfs_fshdr_time_ 1286 IM faststart read accumulated time (ms) kdm_imc_loadfs_time_ 1287 IM faststart read verify accumulated time (ms) kdm_imc_loadfs_dmlverify_time_ 1288 IM faststart read CUs requested kdm_imc_loadfs_requests_ 1289 IM faststart read CUs kdm_imc_loadfs_success_ 1290 IM faststart read CUs not accessible kdm_imc_loadfs_corrupted_reads_ 1291 IM faststart read bytes kdm_imc_loadfs_bytes_ 1292 IM faststart read CUs incompatible kdm_imc_loadfs_incompatsp_ 1293 IM faststart read CUs invalid kdm_imc_loadfs_invalidsp_ 1294 IM faststart write bytes kdm_imc_savefs_bytes_ 1295 IM faststart write CUs kdm_imc_savefs_success_ 1296 IM faststart write CUs requested kdm_imc_savefs_requests_ 1297 IM faststart write CUs problems kdm_imc_savefs_problem_ 1298 IM faststart write accumulated time (ms) kdm_imc_savefs_time_ 1299 IM faststart write CUs encryption mismatch kdm_imc_savefs_enc_skip_ 1300 IM faststart write CUs evicted kdm_imc_fs_evicted_cnt_ 1301 IM faststart write CUs too dirty kdm_imc_savefs_cu2dirty_ 1302 IM faststart write deferred CUs requested kdm_imc_savefsdw_requests_ 1303 IM faststart write deferred CUs kdm_imc_savefsdw_success_ 1304 IM faststart write deferred accumulated (ms) kdm_imc_dwsafefs_time_ 1305 IM faststart write deferred timeouts kdm_imc_dw_tskto_cnt_ 1306 IM faststart write deferred CUs not found kdm_imc_savefsdw_nfound_ 1307 IM faststart coordinator accumulated time (ms) kdm_imc_dwcord_time_ 1308 IM faststart coordinator cycle aborts kdm_imc_dwcord_aborts_ 1309 IM faststart coordinator cycle overruns kdm_imc_dwcord_cycle_ovrs_ 1310 IM faststart coordinator runs kdm_imc_dwcord_cnt_ 1311 IM faststart coordinator throttle down kdm_imc_dwcord_throttledown_ 1312 IM faststart coordinator task submitted priority p1 kdm_imc_savefs_prio_pop_ 1313 IM faststart coordinator task submitted priority p2 kdm_imc_savefs_prio_repop_ 1314 IM faststart coordinator task submitted priority p3 kdm_imc_savefs_prio_pen_ 1315 IM faststart coordinator task priority p1 to p2 kdm_imc_savefs_prio_pop2repop_ 1316 IM faststart coordinator task priority p2 extended kdm_imc_savefs_prio_repopext_ 1317 IM faststart coordinator task priority p2 to p3 kdm_imc_savefs_prio_repop2pen_ 1318 IM faststart coordinator scheduler restarted kdm_imc_dw_schedlr_restart_ 1319 IM faststart delete CUs problem kdm_imc_deletefs_problem_ 1320 IM populate EUs requested kdm_populate_imeu_ 1321 IM populate EUs kdm_populate_imeu_succ_ 1322 IM prepopulate EUs requested kdm_prepopulate_imeu_ 1323 IM prepopulate EUs kdm_prepopulate_imeu_succ_ 1324 IM repopulate EUs requested kdm_repopulate_imeu_ 1325 IM repopulate EUs kdm_repopulate_imeu_succ_ 1326 IM repopulate (incremental) EUs requested kdm_increpopulate_imeu_ 1327 IM repopulate (incremental) EUs kdm_increpopulate_imeu_succ_ 1328 IM repopulate (trickle) EUs requested kdm_trepopulate_imeu_ 1329 IM repopulate (trickle) EUs kdm_trepopulate_imeu_succ_ 1330 IM repopulate (scan) EUs requested kdm_scanrepopulate_imeu_ 1331 IM repopulate (scan) EUs kdm_scanrepopulate_imeu_succ_ 1332 IM populate EUs accumulated time (ms) kdm_populate_imeu_accumulated_time_ 1333 IM prepopulate EUs accumulated time (ms) kdm_prepopulate_imeu_accumulated_time_ 1334 IM repopulate EUs accumulated time (ms) kdm_repopulate_imeu_accumulated_time_ 1335 IM repopulate (trickle) EUs accumulated time (ms) kdm_trepopulate_imeu_accumulated_time_ 1336 IM populate EUs columns kdm_populate_imeu_cols_ 1337 IM prepopulate EUs columns kdm_prepopulate_imeu_cols_ 1338 IM repopulate EUs columns kdm_repopulate_imeu_cols_ 1339 IM repopulate (trickle) EUs columns kdm_trepopulate_imeu_cols_ 1340 IM populate bytes in-memory EU data kdm_comp_imeu_len_comp_ 1341 IM prepopulate bytes in-memory EU data kdm_comp_imeu_len_comp_prepop_ 1342 IM repopulate bytes in-memory EU data kdm_comp_imeu_len_comp_repop_ 1343 IM repopulate (trickle) bytes in-memory EU data kdm_comp_imeu_len_comp_trepop_ 1344 IM populate bytes uncompressed EU data kdm_decomp_imeu_len_comp_ 1345 IM prepopulate bytes uncompressed EU data kdm_decomp_imeu_len_comp_prepop_ 1346 IM repopulate bytes uncompressed EU data kdm_decomp_imeu_len_comp_repop_ 1347 IM repopulate (trickle) bytes uncompressed EU data kdm_decomp_imeu_len_comp_trepop_ 1348 IM populate EUs no memcompress kdm_cus_comp_imeu_nocompress_ 1349 IM prepopulate EUs no memcompress kdm_cus_comp_imeu_nocompress_prepop_ 1350 IM repopulate EUs no memcompress kdm_cus_comp_imeu_nocompress_repop_ 1351 IM repopulate (trickle) EUs no memcompress kdm_cus_comp_imeu_nocompress_trepop_ 1352 IM populate EUs memcompress for dml kdm_cus_comp_imeu_dml_ 1353 IM prepopulate EUs memcompress for dml kdm_cus_comp_imeu_dml_prepop_ 1354 IM repopulate EUs memcompress for dml kdm_cus_comp_imeu_dml_repop_ 1355 IM repopulate (trickle) EUs memcompress for dml kdm_cus_comp_imeu_dml_trepop_ 1356 IM populate EUs memcompress for query low kdm_cus_comp_imeu_querylow_ 1357 IM prepopulate EUs memcompress for query low kdm_cus_comp_imeu_querylow_prepop_ 1358 IM repopulate EUs memcompress for query low kdm_cus_comp_imeu_querylow_repop_ 1359 IM repopulate (trickle) EUs memcompress for query low kdm_cus_comp_imeu_querylow_trepop_ 1360 IM populate EUs memcompress for query high kdm_cus_comp_imeu_queryhigh_ 1361 IM prepopulate EUs memcompress for query high kdm_cus_comp_imeu_queryhigh_prepop_ 1362 IM repopulate EUs memcompress for query high kdm_cus_comp_imeu_queryhigh_repop_ 1363 IM repopulate (trickle) EUs memcompress for query high kdm_cus_comp_imeu_queryhigh_trepop_ 1364 IM populate EUs memcompress for capacity low kdm_cus_comp_imeu_capacitylow_ 1365 IM prepopulate EUs memcompress for capacity low kdm_cus_comp_imeu_capacitylow_prepop_ 1366 IM repopulate EUs memcompress for capacity low kdm_cus_comp_imeu_capacitylow_repop_ 1367 IM repopulate (trickle) EUs memcompress for capacity low kdm_cus_comp_imeu_capacitylow_trepop_ 1368 IM populate EUs memcompress for capacity high kdm_cus_comp_imeu_capacityhigh_ 1369 IM prepopulate EUs memcompress for capacity high kdm_cus_comp_imeu_capacityhigh_prepop_ 1370 IM repopulate EUs memcompress for capacity high kdm_cus_comp_imeu_capacityhigh_repop_ 1371 IM repopulate (trickle) EUs memcompress for capacity high kdm_cus_comp_imeu_capacityhigh_trepop_ 1372 IM scan CUs no memcompress kdm_cus_decomp_imc_nocompress_ 1373 IM scan CUs memcompress for dml kdm_cus_decomp_imc_dml_ 1374 IM scan CUs memcompress for query low kdm_cus_decomp_imc_querylow_ 1375 IM scan CUs memcompress for query high kdm_cus_decomp_imc_queryhigh_ 1376 IM scan CUs memcompress for capacity low kdm_cus_decomp_imc_capacitylow_ 1377 IM scan CUs memcompress for capacity high kdm_cus_decomp_imc_capacityhigh_ 1378 IM scan EUs no memcompress kdm_eus_decomp_imc_nocompress_ 1379 IM scan EUs memcompress for dml kdm_eus_decomp_imc_dml_ 1380 IM scan EUs memcompress for query low kdm_eus_decomp_imc_querylow_ 1381 IM scan EUs memcompress for query high kdm_eus_decomp_imc_queryhigh_ 1382 IM scan EUs memcompress for capacity low kdm_eus_decomp_imc_capacitylow_ 1383 IM scan EUs memcompress for capacity high kdm_eus_decomp_imc_capacityhigh_ 1384 IM scan CUs doublebuffering kdm_cus_dblbfr_ 1385 session logical reads - IM kdm_sess_logical_reads_ 1386 IM scan segments disk kdm_segs_disk_ 1387 IM scan bytes in-memory kdm_comp_len_decomp_ 1388 IM scan bytes uncompressed kdm_decomp_len_decomp_ 1389 IM scan CUs columns accessed kdm_num_cols_access_ 1390 IM scan CUs columns decompressed kdm_num_cols_decomp_ 1391 IM scan CUs columns theoretical max kdm_total_cols_decomp_ 1392 IM scan EU bytes in-memory kdm_comp_len_decomp_eu_ 1393 IM scan EU bytes uncompressed kdm_decomp_len_decomp_eu_ 1394 IM scan EUs columns accessed kdm_num_cols_access_eu_ 1395 IM scan EUs columns decompressed kdm_num_cols_decomp_eu_ 1396 IM scan EUs columns theoretical max kdm_total_cols_decomp_eu_ 1397 IM scan EU rows kdm_total_rows_decomp_eu_ 1398 IM scan rows kdm_total_rows_decomp_ 1399 IM simd compare calls kdm_hpk_cmp_calls_ 1400 IM simd decode calls kdm_hpk_decode_calls_ 1401 IM simd rle burst calls kdm_hpk_decode_rle_burst_calls_ 1402 IM simd set membership calls kdm_hpk_in_set_calls_ 1403 IM simd bloom filter calls kdm_hpk_bloom_calls_ 1404 IM simd decode unpack calls kdm_hpk_unpack_calls_ 1405 IM simd decode symbol calls kdm_hpk_symbol_calls_ 1406 IM simd compare selective calls kdm_hpk_cmp_selective_calls_ 1407 IM simd decode selective calls kdm_hpk_decode_selective_calls_ 1408 IM simd rle burst selective calls kdm_hpk_decode_rle_burst_selective_calls_ 1409 IM simd set membership selective calls kdm_hpk_in_set_selective_calls_ 1410 IM simd bloom filter selective calls kdm_hpk_bloom_selective_calls_ 1411 IM simd decode unpack selective calls kdm_hpk_unpack_selective_calls_ 1412 IM simd decode symbol selective calls kdm_hpk_symbol_selective_calls_ 1413 IM simd compare HW offload calls kdm_hpk_cmp_offload_calls_ 1414 IM simd decode HW offload calls kdm_hpk_decode_offload_calls_ 1415 IM simd rle burst HW offload calls kdm_hpk_decode_rle_burst_offload_calls_ 1416 IM simd set membership HW offload calls kdm_hpk_in_set_offload_calls_ 1417 IM simd decode unpack HW offload calls kdm_hpk_unpack_offload_calls_ 1418 IM hpk spare1 kdm_hpk_spare1_ 1419 IM hpk spare2 kdm_hpk_spare2_ 1420 IM hpk spare3 kdm_hpk_spare3_ 1421 IM hpk spare4 kdm_hpk_spare4_ 1422 IM hpk spare5 kdm_hpk_spare5_ 1423 IM hpk spare6 kdm_hpk_spare6_ 1424 IM scan rows valid kdm_total_rows_valid_ 1425 IM scan rows range excluded kdm_total_rows_range_ 1426 IM scan rows discontinuous kdm_total_rows_discont_ 1427 IM scan rows excluded kdm_total_rows_zeroed_ 1428 IM scan rows optimized kdm_total_rows_opt_ 1429 IM scan rows projected kdm_total_rows_proj_ 1430 IM scan rows cache kdm_disk_rows_ 1431 IM scan blocks cache kdm_disk_blocks_ 1432 IM scan fetches journal kdm_jscan_fetch_ 1433 IM scan rows journal kdm_jscan_frows_ 1434 IM fetches by rowid from journal kdm_fbrid_jimcu_ 1435 IM scan CUs split pieces kdm_total_pieces_decomp_ 1436 IM scan EUs split pieces kdm_total_pieces_decomp_eu_ 1437 IM repopulate (incremental) total rows kdm_totrwcnt_repop_ 1438 IM repopulate (trickle incremental) total rows kdm_totrwcnt_trepop_ 1439 IM repopulate (incremental) fetched rows kdm_ftcrwcnt_repop_ 1440 IM repopulate (trickle incremental) fetched rows kdm_ftcrwcnt_trepop_ 1441 IM repopulate (incremental) valid CU rows kdm_oldcuvalidcnt_repop_ 1442 IM repopulate (trickle incremental) valid CU rows kdm_oldcuvalidcnt_trepop_ 1443 IM repopulate (incremental) invalid CU rows kdm_oldcuinvalidcnt_repop_ 1444 IM repopulate (trickle incremental) invalid CU rows kdm_oldcuinvalidcnt_trepop_ 1445 IM repopulate (incremental) CUs columns kdm_incre_col_repop_ 1446 IM repopulate (trickle incremental) CUs columns kdm_incre_col_trepop_ 1447 IM repopulate (incremental) CUs columns dict reused kdm_olddict_repop_ 1448 IM repopulate (trickle incremental) CUs columns dict reused kdm_olddict_trepop_ 1449 IM repopulate (incremental) CUs columns reused kdm_oldcu_repop_ 1450 IM repopulate (trickle incremental) CUs columns reused kdm_oldcu_trepop_ 1451 IM repopulate (incremental) CU blocks kdm_cublocks_repop_ 1452 IM repopulate (trickle incremental) CU blocks kdm_cublocks_trepop_ 1453 IM repopulate (incremental) blocks read kdm_ioblocks_repop_ 1454 IM repopulate (trickle incremental) blocks read kdm_ioblocks_trepop_ 1455 IM repopulate (incremental) modified blocks kdm_mdblocks_repop_ 1456 IM repopulate (trickle incremental) modified blocks kdm_mdblocks_trepop_ 1457 IM repopulate (incremental) CUs valid columns optimized kdm_validcol_repop_ 1458 IM repopulate (trickle incremental) CUs valid columns optimized kdm_validcol_trepop_ 1459 IM populate SMU/DLM locks fail kdm_lockmem_fail_ 1460 IM repopulate SMU/DLM locks fail kdm_lockmem_fail_repop_ 1461 IM populate no contiguous inmemory space kdm_no_contig_imspace_ 1462 IM repopulate no contiguous inmemory space kdm_no_contig_imspace_repop_ 1463 IM populate no space in PGA kdm_no_space_pga_ 1464 IM repopulate no space in PGA kdm_no_space_pga_repop_ 1465 IM scan CUs predicates received kdm_mm_pred_recv_ 1466 IM scan CUs predicates applied kdm_mm_pred_appl_ 1467 IM scan CUs predicates optimized kdm_mm_pred_optim_ 1468 IM scan CUs optimized read kdm_mm_cu_all_ 1469 IM scan CUs pruned kdm_mm_cu_none_ 1470 IM scan segments minmax eligible kdm_segs_minmax_eligible_ 1471 IM fetches by rowid from IMCU kdm_fbrid_imcu_ 1472 IM fetches by rowid from disk kdm_fbrid_disk_ 1473 IM fetches by rowid from fetch list kdm_fbrid_list_ 1474 IM fetches by rowid row invalid in IMCU kdm_fbrid_invalid_ 1475 IM scan CUs column not in memory kdm_imcu_not_inmem_ 1476 IM scan CUs invalid kdm_imcu_inv_ 1477 IM scan invalid all blocks kdm_imcu_blks_inv_ 1478 IM scan CUs invalid or missing revert to on disk extent kdm_imcu_not_loaded_ 1479 IM scan CUs failed to reget pin kdm_imcu_lost_ 1480 IM scan CUs invalid (all rows are invalid) kdm_imcu_no_valid_ 1481 IM scan (dynamic) rows kdm_parallel_scan_rows_ 1482 IM scan (dynamic) multi-threaded scans kdm_parallel_scans_ 1483 IM scan (dynamic) max degree kdm_parallel_scan_degree_ 1484 IM scan (dynamic) tasks processed by thread kdm_parallel_task_thread_ 1485 IM scan (dynamic) tasks processed by parent kdm_parallel_task_parent_ 1486 IM scan (dynamic) rs2 rowsets kdm_parallel_rs2_ 1487 IM scan (dynamic) spare1 kdm_parallel_spare1_ 1488 IM scan (dynamic) spare2 kdm_parallel_spare2_ 1489 IM split CUs requested kdm_split_cus_ 1490 IM split CUs kdm_split_cu_succ_ 1491 IM split get smaller CUs kdm_get_smaller_cus_ 1492 IM split fail no space kdm_split_fail_no_space_ 1493 IM split CU too small kdm_split_too_small_ 1494 IM split fail kdm_split_fail_ 1495 IM zzzz spare1 kdm_imcu_spare1_ 1496 IM zzzz spare2 kdm_imcu_spare2_ 1497 IM zzzz spare3 kdm_imcu_spare3_ 1498 IM zzzz spare4 kdm_imcu_spare4_ 1499 IM zzzz spare5 kdm_imcu_spare5_ 1500 IM zzzz spare6 kdm_imcu_spare6_ 1501 IM zzzz spare7 kdm_imcu_spare7_ 1502 IM zzzz spare8 kdm_imcu_spare8_ 1503 IM zzzz spare9 kdm_imcu_spare9_ 1504 IM zzzz spare10 kdm_imcu_spare10_ 1505 IM zzzz spare11 kdm_imcu_spare11_ 1506 IM zzzz spare12 kdm_imcu_spare12_ 1507 IM zzzz spare13 kdm_imcu_spare13_ 1508 IM zzzz spare14 kdm_imcu_spare14_ 1509 IM zzzz spare15 kdm_imcu_spare15_ 1510 IM zzzz spare16 kdm_imcu_spare16_ 1511 IM zzzz spare17 kdm_imcu_spare17_ 1512 IM zzzz spare18 kdm_imcu_spare18_ 1513 IM zzzz spare19 kdm_imcu_spare19_ 1514 IM zzzz spare20 kdm_imcu_spare20_ 1515 IM SubCU-MM bytes allocated kdm_subcu_mmarr_bytes_ 1516 IM SubCU-Hist bytes allocated kdm_subcu_hist_bytes_ 1517 IM SubCU-IndEnc bytes allocated kdm_subcu_indenc_bytes_ 1518 IM SubCU-InvIdx bytes allocated kdm_subcu_invidx_bytes_ 1519 IM SubCU-MM CUs kdm_subcu_mmarr_cnt_ 1520 IM SubCU-Hist CUs kdm_subcu_hist_cnt_ 1521 IM SubCU-IndEnc CUs kdm_subcu_indenc_cnt_ 1522 IM SubCU-InvIdx CUs kdm_subcu_invidx_cnt_ 1523 IM SubCU-MM CUs Examined kdm_subcu_mmarr_cucnt_ 1524 IM SubCU-MM CUs Selected kdm_subcu_mmarr_cusel_ 1525 IM SubCU-MM SubCUs Eliminated kdm_subcu_mmarr_scuelm_ 1526 IM SubCU-MM SubCUs in Selected CUs kdm_subcu_mmarr_scucnt_ 1527 IM SubCU-Hist CUs Examined kdm_subcu_hist_cucnt_ 1528 IM SubCU-Hist CUs Selected kdm_subcu_hist_cusel_ 1529 IM SubCU-Hist SubCUs Eliminated kdm_subcu_hist_scuelm_ 1530 IM SubCU-Hist SubCUs in Selected CUs kdm_subcu_hist_scucnt_ 1531 IM SubCU-InvIdx CUs Examined kdm_subcu_invidx_cucnt_ 1532 IM SubCU-InvIdx CUs Selected kdm_subcu_invidx_cusel_ 1533 index cmph ld, CU under-est kdilud_ 1534 index cmph ld, CU fit, add rows kdilfa_ 1535 index cmph ld, CU fit kdilf_ 1536 index cmph ld, CU over-est kdilov_ 1537 index cmph ld, retry in over-est kdilrt_ 1538 index cmph ld, CU negative comp kdilng_ 1539 index cmph ld, lf blks flushed kdillbf_ 1540 index cmph ld, lf blks w/o CU kdillbwocu_ 1541 index cmph ld, lf blks w/o unc r kdillbwour_ 1542 index cmph ld, lf blks w/ und CU kdillbwucu_ 1543 index cmph ld, rows compressed kdilcr_ 1544 index cmph ld, rows uncompressed kdilur_ 1545 index cmph ld, infinite loop kdilil_ 1546 index cmph cu, uncomp sentinels kdizoltpucs_ 1547 index cmph sp, leaf recomp fewer ucs kdizsruc_ 1548 index cmph sp, leaf recomp zero ucs kdizsrns_ 1549 index cmph dm, cu lock expand kdiocms_ 1550 index cmph dm, split for cu lock expand kdiocis_ 1551 index cmph dm, purge dummy CU kdiopdc_ 1552 index cmph sp, recomp localmem0 kdiorlm0_ 1553 index cmph sp, recomp localmem1 kdiorlm1_ 1554 index cmph sp, recomp localmem2 kdiorlm2_ 1555 index cmph sp, recomp localmem3 kdiorlm3_ 1556 index cmph sp, recomp localmem4 kdiorlm4_ 1557 index cmph sp, recomp localmem5 kdiorlm5_ 1558 index cmph sp, recomp buf0 kdiorblm0_ 1559 index cmph sp, recomp buf1 kdiorblm1_ 1560 index cmph sp, recomp buf2 kdiorblm2_ 1561 index cmph sp, recomp buf3 kdiorblm3_ 1562 index cmph sp, recomp buf4 kdiorblm4_ 1563 index cmph sp, recomp buf5 kdiorblm5_ 1564 sql area purged kksspcnt_ 1565 sql area evicted kkssacnt_ 1566 CCursor + sql area evicted kkscecnt_ 1567 No. of Encrypt ops kzececr_ 1568 No. of Decrypt ops kzecdcr_ 1569 No. of XS Sessions Created kzxtsescr_ 1570 No. of XS Sessions Attached kzxtsesad_ 1571 No. of Namespaces Created kzxtnascr_ 1572 No. of User Callbacks Executed kzxtusrcb_ 1573 No. of Roles Enabled or Disabled kzxtroled_ 1574 No. of Principal Cache Misses kzxtprncm_ 1575 No. of Principal Invalidations kzxtprniv_ 1576 Number of NONE redactions kzradmstat0_ 1577 Number of FULL redactions kzradmstat1_ 1578 Number of PARTIAL redactions kzradmstat2_ 1579 Number of FORMAT_PRESERVING redactions kzradmstat3_ 1580 Number of RANDOM redactions kzradmstat4_ 1581 Number of REGEXP redactions kzradmstat5_ 1582 Number of NULLIFY redactions kzradmstat6_ 1583 Number of REGEXP_WIDTH redactions kzradmstat7_ 1584 DX/BB enqueue lock foreground requests k2qfg_ 1585 DX/BB enqueue lock foreground wait time k2qft_ 1586 DX/BB enqueue lock background gets k2qbg_ 1587 DX/BB enqueue lock background get time k2qbt_ 1588 Clusterwide global transactions k2q_cwgtxn_ 1589 Clusterwide global transactions spanning RAC nodes k2q_multinode_ 1590 Forwarded 2PC commands across RAC nodes k2q_forward2pc_ 1591 GTX processes spawned by autotune k2q_gtxinc_ 1592 GTX processes stopped by autotune k2q_gtxdec_ 1593 session cursor cache hits kkshit_ 1594 session cursor cache count kkscnt_ 1595 cursor reload failures kksrlf_ 1596 java call heap total size joxctz_ 1597 java call heap total size max joxctm_ 1598 java call heap used size joxcuz_ 1599 java call heap used size max joxcum_ 1600 java call heap live size joxclz_ 1601 java call heap live size max joxclm_ 1602 java call heap object count joxcoc_ 1603 java call heap object count max joxcox_ 1604 java call heap live object count joxclc_ 1605 java call heap live object count max joxclx_ 1606 java call heap gc count joxcgc_ 1607 java call heap collected count joxcgo_ 1608 java call heap collected bytes joxcgb_ 1609 java session heap used size joxsuz_ 1610 java session heap used size max joxsum_ 1611 java session heap live size joxslz_ 1612 java session heap live size max joxslm_ 1613 java session heap object count joxsoc_ 1614 java session heap object count max joxsox_ 1615 java session heap live object count joxslc_ 1616 java session heap live object count max joxslx_ 1617 java session heap gc count joxsgc_ 1618 java session heap collected count joxsgo_ 1619 java session heap collected bytes joxsgb_ 1620 cursor authentications kksact_ 1621 queries parallelized kxfqryp_ 1622 DML statements parallelized kxfdmlp_ 1623 DDL statements parallelized kxfddlp_ 1624 DFO trees parallelized kxfddfo_ 1625 Parallel operations not downgraded kxfpxops_ 1626 Parallel operations downgraded to serial kxfpxser_ 1627 Parallel operations downgraded 75 to 99 pct kxfpxd99_ 1628 Parallel operations downgraded 50 to 75 pct kxfpxd75_ 1629 Parallel operations downgraded 25 to 50 pct kxfpxd50_ 1630 Parallel operations downgraded 1 to 25 pct kxfpxd25_ 1631 PX local messages sent kxflms_ 1632 PX local messages recv'd kxflmr_ 1633 PX remote messages sent kxfrms_ 1634 PX remote messages recv'd kxfrmr_ 1635 buffer is pinned count ksxisp_ 1636 buffer is not pinned count ksxinp_ 1637 no buffer to keep pinned count ksxnbp_ 1638 workarea memory allocated qesmmwm_ 1639 workarea executions - optimal qesmmcow_ 1640 workarea executions - onepass qesmmc1w_ 1641 workarea executions - multipass qesmmcmw_ 1642 key vector CUs filtered qesxlcufilt_ 1643 key vector CUs min/max filtered qesxlcuminmax_ 1644 key vector CU codes processed qesxlcucodes_ 1645 key vector rows processed by value qesxlvalrows_ 1646 key vector rows processed by code qesxlcoderows_ 1647 key vector CUs processed using cached packed numbers qesxlcun2bcache_ 1648 key vector rows filtered qesxlrowsfilt_ 1649 key vector filtered on cell qesxlrowsoflfilt_ 1650 key vector probed on cell qesxlrowsofl_ 1651 key vectors sent to cell qesxloffloaded_ 1652 key vectors sent to cell in lite mode due to layout qesxlliteofltype_ 1653 key vectors sent to cell in lite mode due to quota qesxlliteoflquota_ 1654 key vector serializations for cell qesxlflattened_ 1655 key vector serializations in lite mode for cell qesxlflattenedlite_ 1656 key vector queries qesxlqueries_ 1657 key vectors created qesxlcreated_ 1658 key vectors created (simple layout) qesxlcreatedsim_ 1659 key vectors created (indirect layout) qesxlcreatedind_ 1660 key vectors created (offset layout) qesxlcreatedoff_ 1661 key vectors created (doubly indirect layout) qesxlcreated2ind_ 1662 key vectors created (hash layout) qesxlcreatedhash_ 1663 key vectors created (bit wide) qesxlcreatedbit_ 1664 key vectors created (nibble wide) qesxlcreatednib_ 1665 key vectors created (byte wide) qesxlcreatedub1_ 1666 key vectors created (2 byte wide) qesxlcreatedub2_ 1667 key vectors created (4 byte wide) qesxlcreatedub4_ 1668 key vectors bypassed qesxlfailed_ 1669 key vector stubs created qesxlstubs_ 1670 key vector cas merge locking retrial qesxlcaslockretry_ 1671 key vector cas merge abort qesxlcaslockedout_ 1672 key vector cas merge operations qesxlcasmergecnt_ 1673 key vector non cas merge operations qesxlnoncascnt_ 1674 key vector dgk batch parcels qesxlbatchdgkparcel_ 1675 key vector dgk range parcels qesxlrngdgkparcel_ 1676 vector group by operations sent to cell qesgvoffloaded_ 1677 vector group by operations not sent to cell due to key vector qesgvxlnooffload_ 1678 vector group by operations not sent to cell due to cardinality qesgvcardnooffload_ 1679 vector group by rows processed on cell qesgvoffloadedrowsproc_ 1680 vector group by rows returned by cell qesgvoffloadedrowsret_ 1681 vector group by used qesgvused_ 1682 vector group by rowsources adapted qesgvfailed_ 1683 vector group by accumspace cardinality qesgvaccumspacecard_ 1684 vector group by accumspace size qesgvaccumspacesize_ 1685 vector group by out of line rows qesgvoolrows_ 1686 vector group by out of line size qesgvoolsize_ 1687 vector group by string allocations size qesgvstrsize_ 1688 vector group by string allocations qesgvstrallocs_ 1689 vector group by string resizes qesgvstrresizes_ 1690 vector group by rowsets processed on cell qesgvoffloadedrowsets_ 1691 vector encoded rows qesdsbencval_ 1692 vector encoded rows decoded qesdsbdecval_ 1693 vector encoded row operations qesdsbarith_ 1694 vector encoded rowsets qesdsbencrs_ 1695 vector encoded rowsets decoded qesdsbdecrs_ 1696 vector encoded rowset operations qesdsbarithrs_ 1697 vector encoded arithmetic exceptions qesdsbarithexc_ 1698 LOB table id lookup cache misses kokli_cache_miss_ 1699 parse time cpu prstic_ 1700 parse time elapsed prstie_ 1701 parse count (total) prscnt_ 1702 parse count (hard) prscnth_ 1703 parse count (failures) prscnfp_ 1704 parse count (describe) prscnds_ 1705 frame signature mismatch kksfsigmm_ 1706 execute count execnt_ 1707 bytes sent via SQL*Net to client opissbc_ 1708 bytes received via SQL*Net from client opisrbc_ 1709 SQL*Net roundtrips to/from client opisrtc_ 1710 bytes sent via SQL*Net to dblink opissbr_ 1711 bytes received via SQL*Net from dblink opisrbr_ 1712 SQL*Net roundtrips to/from dblink opisrtr_ 1713 bytes via SQL*Net vector to client opisvsbc_ 1714 bytes via SQL*Net vector from client opisvrbc_ 1715 bytes via SQL*Net vector to dblink opisvsbr_ 1716 bytes via SQL*Net vector from dblink opisvrbr_ 1717 sorts (memory) sorsho_ 1718 sorts (disk) sorlon_ 1719 sorts (rows) sorrws_ 1720 OTC commit optimization attempts kpotxca_ 1721 OTC commit optimization hits kpotxcs_ 1722 OTC commit optimization failure - setup kpotxcsf_ 1723 OLAP Paging Manager Cache Hit xspgcachehits_ 1724 OLAP Paging Manager Cache Miss xspgcachemisses_ 1725 OLAP Paging Manager New Page xspgnewpage_ 1726 OLAP Paging Manager Cache Write xspgcachewrite_ 1727 OLAP Session Cache Hit xssescachehits_ 1728 OLAP Session Cache Miss xssescachemisses_ 1729 OLAP Aggregate Function Calc xsagfcalc_ 1730 OLAP Aggregate Function Precompute xsagfprecompute_ 1731 OLAP Aggregate Function Logical NA xsagflogicalna_ 1732 OLAP Paging Manager Pool Size xspgpoolsize_ 1733 OLAP Import Rows Pushed xsrowspushed_ 1734 OLAP Import Rows Loaded xsrowsloaded_ 1735 OLAP Row Source Rows Processed xstfrowsprocessed_ 1736 OLAP Engine Calls xstrncnt_ 1737 OLAP Temp Segments xsiotsegcnt_ 1738 OLAP Temp Segment Read xsiotlobread_ 1739 OLAP Perm LOB Read xsioplobread_ 1740 OLAP Paging Manager Cache Changed Page xspgchg_ 1741 OLAP Fast Limit xstwlmtfast_ 1742 OLAP GID Limit xstwlmtgid_ 1743 OLAP Unique Key Attribute Limit xstwlmtuka_ 1744 OLAP INHIER Limit xstwlmtinh_ 1745 OLAP Full Limit xstwlmtslow_ 1746 OLAP Custom Member Limit xstwlmtapcm_ 1747 OLAP Row Id Limit xstwlmturid_ 1748 OLAP Limit Time xstwlmttime_ 1749 OLAP Row Load Time xsrowloadtime_ 1750 cell flash cache read hits kfkcfcrh_ 1751 cell flash cache read hits for controlfile reads kfkcfcrhcf_ 1752 cell flash cache read hits for smart IO kfkcfcrhss_ 1753 Workload Capture: size (in bytes) of recording kecrwksz_ 1754 Workload Capture: dbtime kecrdbtm_ 1755 Workload Capture: user calls kecruc_ 1756 Workload Capture: user calls flushed kecrucf_ 1757 Workload Capture: unreplayable user calls kecrucempty_ 1758 Workload Capture: user txns kecrutxn_ 1759 Workload Capture: user logins kecrulogins_ 1760 Workload Capture: unsupported user calls kecrnsuc_ 1761 Workload Capture: errors kecrerr_ 1762 Workload Capture: PL/SQL user subcalls kecrpusc_ 1763 Workload Capture: PL/SQL user calls kecrpuc_ 1764 Workload Capture: PL/SQL subcall size of recording kecrpswksz_ 1765 Workload Capture: PL/SQL dbtime kecrpdbtm_ 1766 Workload Replay: dbtime kecpdbtm_ 1767 Workload Replay: network time kecpntwk_ 1768 Workload Replay: think time kecpthnk_ 1769 Workload Replay: time gain kecpgain_ 1770 Workload Replay: time loss kecploss_ 1771 Workload Replay: user calls kecpuc_ 1772 Workload Replay: deadlocks resolved kecpdlr_ 1773 Workload Replay: PL/SQL user calls kecppuc_ 1774 Workload Replay: PL/SQL user subcalls kecppusc_ 1775 Workload Replay: PL/SQL dbtime kecppdbtm_ 1776 cell physical write IO bytes eligible for offload kxdbio_htw_bytes_to_disk_ 1777 cell physical write IO host network bytes written during offloa kxdbio_htw_bytes_from_db_ 1778 cell logical write IO requests kxdbio_htw_tot_write_reqs_ 1779 cell logical write IO requests eligible for offload kxdbio_htw_off_write_reqs_ 1780 backup pieces compressed locally kxdbc_bpcl_stat_ 1781 backup data compressed locally kxdbc_bdcl_stat_ 1782 backup compressed data written locally kxdbc_bcdwl_stat_ 1783 backup piece local processing time kxdbc_bplpt_stat_ 1784 backup pieces compressed remotely kxdbc_bpcr_stat_ 1785 backup data compressed remotely kxdbc_bdcr_stat_ 1786 backup compressed data written remotely kxdbc_bcdwr_stat_ 1787 backup piece remote processing time kxdbc_bprpt_stat_ 1788 OS User time used 1789 OS System time used 1790 OS Maximum resident set size 1791 OS Integral shared text size 1792 OS Integral unshared data size 1793 OS Integral unshared stack size 1794 OS Page reclaims 1795 OS Page faults 1796 OS Swaps 1797 OS Block input operations 1798 OS Block output operations 1799 OS Socket messages sent 1800 OS Socket messages received 1801 OS Signals received 1802 OS Voluntary context switches 1803 OS Involuntary context switches 1804 rows selected.