システム統計一覧

12cR2までのシステム統計一覧です。
・versionは該当の統計が存在するバージョンを表します。(11.2以降は初期リリースで確認していますのでPSR適用により追加されたものが無い可能性があります)
・classは値を2進数に変換した各ビットが以下の意味を持ちます。
(40であれば32と8のビットがたつためキャッシュ+Real Application Clustersを表す)
1 - ユーザー
2 - REDO
4 - エンキュー
8 - キャッシュ
16 - OS
32 - Real Application Clusters
64 - SQL
128 - デバッグ
・stat_idは10g以降も利用されている統計のみ値が入ります。
・~timeといった時間を表す統計値はほぼ1/100秒単位です



 version:  class:
versionstat_nameclassstat_id
12cR2-12cR2ADG global flush12326993276
12cR2-12cR2ADG influx scn advance12229881047
12cR2-12cR2ADG parselock X get attempts1564381705
12cR2-12cR2ADG parselock X get successes13808229129
12cR2-12cR2ADG query scn advance1529913931
12cR2-12cR2ADG segment statistics defer invalidation11419363480
12cR2-12cR2ASSM bg: segment fix monitor1283600562081
12cR2-12cR2ASSM bg:create segment fix task1281845671331
12cR2-12cR2ASSM bg:mark segment for fix1283233663104
12cR2-12cR2ASSM bg:slave compress block1284114663421
12cR2-12cR2ASSM bg:slave fix one segment1282686948083
12cR2-12cR2ASSM bg:slave fix state1283467989665
12cR2-12cR2ASSM cbk:blocks accepted1283977749145
12cR2-12cR2ASSM cbk:blocks examined1283025660006
12cR2-12cR2ASSM cbk:blocks marked full128543563681
12cR2-12cR2ASSM cbk:blocks rejected1283959015082
12cR2-12cR2ASSM fg: submit segment fix task1284013817796
12cR2-12cR2ASSM gsp:Alignment unavailable in space res1283857431883
12cR2-12cR2ASSM gsp:L1 bitmaps examined12836759613
12cR2-12cR2ASSM gsp:L2 bitmap full128707314816
12cR2-12cR2ASSM gsp:L2 bitmaps examined1281421641762
12cR2-12cR2ASSM gsp:L3 bitmaps examined1281014565797
12cR2-12cR2ASSM gsp:Optimized data block rejects1283796175806
12cR2-12cR2ASSM gsp:Optimized index block rejects1281844937515
12cR2-12cR2ASSM gsp:Optimized reject DB1281696725763
12cR2-12cR2ASSM gsp:Optimized reject l1128413289430
12cR2-12cR2ASSM gsp:Optimized reject l21282718989392
12cR2-12cR2ASSM gsp:Search all1282708228179
12cR2-12cR2ASSM gsp:Search hint1283746828975
12cR2-12cR2ASSM gsp:Search steal1283149411117
12cR2-12cR2ASSM gsp:add extent1283150270891
12cR2-12cR2ASSM gsp:blocks provided by space reservation1283699276507
12cR2-12cR2ASSM gsp:blocks rejected by access layer callback1283070512611
12cR2-12cR2ASSM gsp:blocks requested by space reservation1281960313251
12cR2-12cR2ASSM gsp:bump HWM1281611919346
12cR2-12cR2ASSM gsp:get free block1283327194600
12cR2-12cR2ASSM gsp:get free critical block128560535870
12cR2-12cR2ASSM gsp:get free data block1281637532864
12cR2-12cR2ASSM gsp:get free index block1283312674464
12cR2-12cR2ASSM gsp:get free lob block1282067056395
12cR2-12cR2ASSM gsp:good hint1281025619664
12cR2-12cR2ASSM gsp:reject L11281741885029
12cR2-12cR2ASSM gsp:reject L2128394722525
12cR2-12cR2ASSM gsp:reject L312843660122
12cR2-12cR2ASSM gsp:reject db1281791327309
12cR2-12cR2ASSM gsp:space reservation success128424532898
12cR2-12cR2ASSM gsp:use space reservation1281880473007
12cR2-12cR2ASSM rsv:alloc from reserve1283293553667
12cR2-12cR2ASSM rsv:alloc from reserve fail1281869849637
12cR2-12cR2ASSM rsv:alloc from reserve succ1282220692781
12cR2-12cR2ASSM rsv:clear reserve1282134155164
12cR2-12cR2ASSM rsv:fill reserve1283799525063
12cR2-12cR2ASSM wasted db state change1282452375215
12cR1-12cR1AVM au bytes allocated1283441520794
12cR1-12cR1AVM bytes for file maps1282904743103
12cR1-12cR1AVM bytes read from disk1282004986892
12cR1-12cR1AVM bytes read from flash1284263147678
12cR1-12cR1AVM count - borrowed from other node1284037843577
12cR1-12cR1AVM count - searched in pb1284000147916
12cR1-12cR1AVM count when 10% of buckets in pb128652947275
12cR1-12cR1AVM count when 25% of buckets in pb1283588709547
12cR1-12cR1AVM count when 50% of buckets in pb1282879014823
12cR1-12cR1AVM count when 75% of buckets in pb1281964315023
12cR1-12cR1AVM count when 90% of buckets in pb128226051874
12cR1-12cR1AVM file bytes allocated1283731650962
12cR1-12cR1AVM file bytes deleted1281514042146
12cR1-12cR1AVM files created count1281887082337
12cR1-12cR1AVM files deleted count1284223523824
12cR1-12cR1AVM flash bytes requested128965137504
12cR1-12cR1AVM non-flash bytes requested1281829484955
12cR1-12cR1AVM spare statistic 112847653185
12cR1-12cR1AVM spare statistic 21283191674657
12cR1-12cR1AVM spare statistic 31282665872976
12cR1-12cR1AVM spare statistic 41282816010972
12cR1-12cR1AVM spare statistic 51284250363583
12cR1-12cR1AVM spare statistic 61283756487597
12cR1-12cR1AVM spare statistic 71282604881032
12cR1-12cR1AVM spare statistic 8128176682480
12cR2-12cR2BA au bytes allocated1282076076626
12cR2-12cR2BA bytes for file maps1281005864914
12cR2-12cR2BA bytes read from disk1282828065810
12cR2-12cR2BA bytes read from flash1281360157216
12cR2-12cR2BA count - borrowed from other node1283901028939
12cR2-12cR2BA count - cache denied1281983407914
12cR2-12cR2BA count - cache miss128224331773
12cR2-12cR2BA count - searched in pb1283855092072
12cR2-12cR2BA count - short circuit in idn1283536746303
12cR2-12cR2BA count - total allocation requests1281052493063
12cR2-12cR2BA count - unable to short circuit in idn1282358548067
12cR2-12cR2BA count when 10% of buckets in pb1282454505349
12cR2-12cR2BA count when 25% of buckets in pb1282580813032
12cR2-12cR2BA count when 50% of buckets in pb1281165582639
12cR2-12cR2BA count when 75% of buckets in pb1282738576169
12cR2-12cR2BA count when 90% of buckets in pb1281718312399
12cR2-12cR2BA file bytes allocated1282557250349
12cR2-12cR2BA file bytes deleted12859529456
12cR2-12cR2BA files created count128391278156
12cR2-12cR2BA files deleted count1283628410054
12cR2-12cR2BA flash bytes requested1281003190122
12cR2-12cR2BA non-flash bytes requested1283822012382
12cR2-12cR2BA spare statistic 11283696379180
12cR2-12cR2BA spare statistic 101281817975766
12cR2-12cR2BA spare statistic 111283487488923
12cR2-12cR2BA spare statistic 121284125173246
12cR2-12cR2BA spare statistic 21282245338743
12cR2-12cR2BA spare statistic 3128254689232
12cR2-12cR2BA spare statistic 4128559071111
12cR2-12cR2BA spare statistic 51283426175027
12cR2-12cR2BA spare statistic 61281248165399
12cR2-12cR2BA spare statistic 71282020825348
12cR2-12cR2BA spare statistic 81282831186742
12cR2-12cR2BA spare statistic 91284153748178
12cR2-12cR2BPS commit wait401275209935
12cR2-12cR2BPS redo wait403379118445
12cR2-12cR2BPS session wait402229232071
11gR1-12cR2Batched IO (bound) vector count722669900039
11gR1-12cR2Batched IO (full) vector count723326798362
11gR1-12cR2Batched IO (space) vector count723732543888
11gR1-12cR2Batched IO block miss count72398227664
11gR1-12cR2Batched IO buffer defrag count723691310830
11gR1-12cR2Batched IO double miss count721818000820
11gR1-12cR2Batched IO same unit count721157040815
11gR1-12cR2Batched IO single block count723409550379
11gR1-12cR2Batched IO slow jump count72808096169
11gR1-12cR2Batched IO vector block count72779198283
11gR1-12cR2Batched IO vector read count723940039938
11gR1-12cR2Batched IO zero block count721754742469
11gR1-12cR2Block Cleanout Optim referenced128750832557
11gR2-11gR2CC Analyze CUs Decompressed1284192475422
11gR2-11gR2CC Analyzer Calls1281449718227
11gR2-11gR2CC Archive CUs Compressed1282882040743
11gR2-11gR2CC Archive CUs Decompressed1283500034667
11gR2-11gR2CC CU Row Pieces Compressed128498521509
11gR2-11gR2CC CUs Compressed1281661374578
11gR2-11gR2CC CUs Decompressed128551192857
11gR2-11gR2CC Check CUs Decompressed1282800822390
11gR2-11gR2CC Columns Decompressed1283489505157
11gR2-11gR2CC Compressed Length Compressed1281208936085
11gR2-11gR2CC Compressed Length Decompressed1283629430582
11gR2-11gR2CC DML CUs Decompressed128448294311
11gR2-11gR2CC Decompressed Length Compressed128949949779
11gR2-11gR2CC Decompressed Length Decompressed128259212857
11gR2-11gR2CC Dump CUs Decompressed1281372769363
11gR2-11gR2CC Pieces Buffered for Decompression1283794914662
11gR2-11gR2CC Query High CUs Compressed128419861891
11gR2-11gR2CC Query High CUs Decompressed128912128960
11gR2-11gR2CC Query Low CUs Compressed1283700315823
11gR2-11gR2CC Query Low CUs Decompressed1281032556686
11gR2-11gR2CC Rowid CUs Decompressed1281701155713
11gR2-11gR2CC Rows Compressed128662085552
11gR2-11gR2CC Rows Not Compressed1283277098000
11gR2-11gR2CC Scan CUs Decompressed1281735090050
11gR2-11gR2CC Total Columns for Decompression1282020849711
11gR2-11gR2CC Total Pieces for Decompression1283414173997
11gR2-11gR2CC Total Rows for Decompression1282497304200
11gR2-11gR2CC Turbo Scan CUs Decompressed1284063570860
10gR2-12cR2CCursor + sql area evicted64938276153
12cR1-12cR2CLI BG ENQ1282537508108
12cR1-12cR2CLI BG Fls done1281898500432
12cR1-12cR2CLI BG attempt Flush1282751550570
12cR1-12cR2CLI Buf Wrt1281466815534
12cR1-12cR2CLI Client Flush1282418073855
12cR1-12cR2CLI Flstask create1284150293767
12cR1-12cR2CLI Flush128670819718
12cR1-12cR2CLI Imm Wrt12847996927
12cR1-12cR2CLI Prvtz Lob1281688196485
12cR1-12cR2CLI SGA Alloc1282076026298
12cR1-12cR2CLI Thru Wrt1282721289668
12cR1-12cR2CLI bytes fls to ext1282251457522
12cR1-12cR2CLI bytes fls to table128872375576
12cR2-12cR2CPU used by LWTs for this session1852059243
8i-12cR2CPU used by this session124469293
8i-12cR2CPU used when call started128572264820
8i-12cR2CR blocks created8516801181
8i-12cR2Cached Commit SCN referenced1282374582560
11gR1-12cR2Clusterwide global transactions334124661496
11gR1-12cR2Clusterwide global transactions spanning RAC nodes333534283427
8i-12cR2Commit SCN cached1282460709063
10gR1-12cR2DB time13649082374
12cR2-12cR2DB time of LWTs for this session11679612087
8i-10gR1DBWR buffers scanned8105885844
8i-12cR2DBWR checkpoint buffers written81208600358
8i-12cR2DBWR checkpoints81732023165
8i-9iDBWR cross instance writes40
8i-10gR1DBWR free buffers found81360869216
9i-12cR2DBWR fusion writes402313150541
8i-12cR2DBWR lru scans82139101792
8i-10gR2DBWR make free requests81237874725
10gR1-12cR2DBWR object drop buffers written8658143835
10gR1-12cR2DBWR parallel query checkpoint buffers written81768645316
8i-12cR2DBWR revisited being-written buffer82773697723
8i-10gR1DBWR summed scan depth81586660302
10gR1-12cR2DBWR tablespace checkpoint buffers written82649259263
10gR1-12cR2DBWR thread checkpoint buffers written83905787588
8i-12cR2DBWR transaction table writes82146120386
8i-12cR2DBWR undo block writes8111270822
8i-12cR2DDL statements parallelized324115134636
8i-12cR2DFO trees parallelized322753131890
8i-12cR2DML statements parallelized323791923855
11gR1-12cR2DX/BB enqueue lock background get time1281423799991
11gR1-12cR2DX/BB enqueue lock background gets1282384348591
11gR1-12cR2DX/BB enqueue lock foreground requests128560233336
11gR1-12cR2DX/BB enqueue lock foreground wait time1281889009391
12cR1-12cR1EHCC Analyze CUs Decompressed1281754934147
12cR1-12cR1EHCC Analyzer Calls1282609447759
12cR1-12cR1EHCC Archive CUs Compressed1282332476297
12cR1-12cR1EHCC Archive CUs Decompressed1283219000004
12cR1-12cR1EHCC Attempted Block Compressions128726324667
12cR1-12cR1EHCC Block Compressions1282852097326
12cR1-12cR1EHCC CU Row Pieces Compressed1281875994900
12cR1-12cR1EHCC CUs Compressed128367847514
12cR1-12cR1EHCC CUs Decompressed1282050416976
12cR1-12cR1EHCC Check CUs Decompressed1283824258835
12cR1-12cR1EHCC Columns Decompressed1283449104294
12cR1-12cR1EHCC Compressed Length Compressed1284194752021
12cR1-12cR1EHCC Compressed Length Decompressed1283359669819
12cR1-12cR1EHCC Conventional DMLs128547882683
12cR1-12cR1EHCC DML CUs Decompressed1282171628482
12cR1-12cR1EHCC Decompressed Length Compressed1282639391085
12cR1-12cR1EHCC Decompressed Length Decompressed1281376060606
12cR1-12cR1EHCC Dump CUs Decompressed128490679437
12cR1-12cR1EHCC Normal Scan CUs Decompressed12812676786
12cR1-12cR1EHCC Pieces Buffered for Decompression1281843043005
12cR1-12cR1EHCC Query High CUs Compressed1283382680758
12cR1-12cR1EHCC Query High CUs Decompressed128658646273
12cR1-12cR1EHCC Query Low CUs Compressed1283245723647
12cR1-12cR1EHCC Query Low CUs Decompressed1281294049085
12cR1-12cR1EHCC Rowid CUs Decompressed1281639970104
12cR1-12cR1EHCC Rows Compressed128781935931
12cR1-12cR1EHCC Rows Not Compressed1283525654818
12cR1-12cR1EHCC Total Columns for Decompression1283772480754
12cR1-12cR1EHCC Total Pieces for Decompression1281269622577
12cR1-12cR1EHCC Total Rows for Decompression128626128372
12cR1-12cR1EHCC Turbo Scan CUs Decompressed1282177750092
12cR1-12cR1EHCC Used on Pillar Tablespace1283901974308
12cR1-12cR1EHCC Used on ZFS Tablespace1282536989047
11gR1-12cR2Effective IO time84166892036
11gR1-12cR2Forwarded 2PC commands across RAC nodes334274163731
12cR2-12cR2GDR: Active blocks cleared1281292926743
12cR2-12cR2GDR: Active ranges cleared1282202117211
12cR2-12cR2GDR: Inactive blocks cleared128523857201
12cR2-12cR2GDR: Inactive ranges cleared1282703550740
12cR2-12cR2GDR: Total blocks skipped128746310650
12cR2-12cR2GDR: Total files processed1282149571045
12cR2-12cR2GDR: Total segments processed1281324804040
12cR2-12cR2GDR: Total segments skipped1282855816703
12cR2-12cR2GDR: Unused blocks cleared1281448363883
12cR2-12cR2GDR: Unused ranges cleared1283892250592
11gR1-12cR2GTX processes spawned by autotune32719092076
11gR1-12cR2GTX processes stopped by autotune32457066669
12cR2-12cR2HCC DML CUs1284034897298
12cR2-12cR2HCC DML conventional1282313830661
12cR2-12cR2HCC analyze table CUs1282661394218
12cR2-12cR2HCC analyzer calls1281419887876
12cR2-12cR2HCC block check CUs1284291005575
12cR2-12cR2HCC block compressions attempted128235886388
12cR2-12cR2HCC block compressions completed1282215294102
12cR2-12cR2HCC block dump CUs1282850106874
12cR2-12cR2HCC fetch by rowid CUs1281391719254
12cR2-12cR2HCC load conventional CUs1283919567719
12cR2-12cR2HCC load conventional CUs archive high1283512535284
12cR2-12cR2HCC load conventional CUs archive low1281224662375
12cR2-12cR2HCC load conventional CUs query high1283413416822
12cR2-12cR2HCC load conventional CUs query low1281721092376
12cR2-12cR2HCC load conventional CUs row pieces1283012134785
12cR2-12cR2HCC load conventional bytes compressed1281619345569
12cR2-12cR2HCC load conventional bytes uncompressed1283847196807
12cR2-12cR2HCC load conventional rows128375912845
12cR2-12cR2HCC load conventional rows not compressed1284269178160
12cR2-12cR2HCC load direct CUs128165533286
12cR2-12cR2HCC load direct CUs archive high1283517682519
12cR2-12cR2HCC load direct CUs archive low1281878555981
12cR2-12cR2HCC load direct CUs query high1283271346033
12cR2-12cR2HCC load direct CUs query low1283454328651
12cR2-12cR2HCC load direct CUs row pieces1281641862033
12cR2-12cR2HCC load direct bytes compressed128233965907
12cR2-12cR2HCC load direct bytes uncompressed1283860793481
12cR2-12cR2HCC load direct rows1283172228581
12cR2-12cR2HCC load direct rows not compressed1281741816940
12cR2-12cR2HCC scan CUs pcode selective done128946590827
12cR2-12cR2HCC scan cell CUs archive high1281116993839
12cR2-12cR2HCC scan cell CUs archive low1283551315023
12cR2-12cR2HCC scan cell CUs columns accessed1282637510611
12cR2-12cR2HCC scan cell CUs decompressed1281386703004
12cR2-12cR2HCC scan cell CUs decompression time128508541739
12cR2-12cR2HCC scan cell CUs optimized read1281476759914
12cR2-12cR2HCC scan cell CUs predicates applied12847686140
12cR2-12cR2HCC scan cell CUs predicates optimized128169984186
12cR2-12cR2HCC scan cell CUs predicates received1281350707909
12cR2-12cR2HCC scan cell CUs processed for compressed64141378642
12cR2-12cR2HCC scan cell CUs processed for uncompressed643192571267
12cR2-12cR2HCC scan cell CUs pruned1283440002331
12cR2-12cR2HCC scan cell CUs query high1281717570521
12cR2-12cR2HCC scan cell CUs query low1281244381121
12cR2-12cR2HCC scan cell CUs row pieces accessed128250755895
12cR2-12cR2HCC scan cell CUs row pieces total1284086318843
12cR2-12cR2HCC scan cell CUs sent compressed643302590270
12cR2-12cR2HCC scan cell CUs sent head piece641558179565
12cR2-12cR2HCC scan cell CUs sent uncompressed64287102046
12cR2-12cR2HCC scan cell bytes compressed128104954692
12cR2-12cR2HCC scan cell bytes decompressed128627532502
12cR2-12cR2HCC scan cell columns theoretical max12849203267
12cR2-12cR2HCC scan cell rows128662890138
12cR2-12cR2HCC scan rdbms CUs archive high1281718511789
12cR2-12cR2HCC scan rdbms CUs archive low1283966376949
12cR2-12cR2HCC scan rdbms CUs columns accessed1281644973549
12cR2-12cR2HCC scan rdbms CUs decompressed1284091869454
12cR2-12cR2HCC scan rdbms CUs decompression time128528768038
12cR2-12cR2HCC scan rdbms CUs normal12884868886
12cR2-12cR2HCC scan rdbms CUs optimized read1282739893870
12cR2-12cR2HCC scan rdbms CUs predicates applied1281179095652
12cR2-12cR2HCC scan rdbms CUs predicates optimized1284194791767
12cR2-12cR2HCC scan rdbms CUs predicates received1282612836700
12cR2-12cR2HCC scan rdbms CUs pruned1281249637154
12cR2-12cR2HCC scan rdbms CUs query high1281764275095
12cR2-12cR2HCC scan rdbms CUs query low1284214970697
12cR2-12cR2HCC scan rdbms CUs row pieces accessed1282935456010
12cR2-12cR2HCC scan rdbms CUs row pieces total1283693675171
12cR2-12cR2HCC scan rdbms CUs turbo128733216865
12cR2-12cR2HCC scan rdbms bytes compressed1281136549488
12cR2-12cR2HCC scan rdbms bytes decompressed1281403686664
12cR2-12cR2HCC scan rdbms columns theoretical max128899569891
12cR2-12cR2HCC scan rdbms rows12893843591
12cR2-12cR2HCC usage ZFS1283622152422
12cR2-12cR2HCC usage cloud1283307087668
12cR2-12cR2HCC usage pillar128926671818
11gR1-12cR2HSC Compressed Segment Block Changes64539480718
11gR1-12cR2HSC Heap Segment Block Changes64399567576
11gR1-12cR2HSC IDL Compressed Blocks642406770549
11gR1-12cR2HSC OLTP Compressed Blocks642175876847
11gR1-12cR2HSC OLTP Compression skipped rows1283456750894
12cR1-12cR2HSC OLTP Compression wide compressed row pieces128784760009
11gR1-12cR2HSC OLTP Drop Column128559591604
11gR1-12cR2HSC OLTP Non Compressible Blocks64262999502
11gR1-12cR2HSC OLTP Space Saving64841396643
11gR1-12cR2HSC OLTP compression block checked1282637393546
11gR1-12cR2HSC OLTP inline compression1282650019963
11gR1-12cR2HSC OLTP negative compression128269936937
12cR2-12cR2HSC OLTP partial compression128182439741
11gR1-12cR2HSC OLTP positive compression1281017140011
11gR1-12cR2HSC OLTP recursive compression12857927558
11gR1-12cR2Heap Segment Array Inserts641532155417
11gR1-12cR2Heap Segment Array Updates642275749997
12cR1-12cR2Heatmap BlkLevel Flush Task Create1281236100146
12cR1-12cR2Heatmap BlkLevel Flushed1283201601810
12cR1-12cR2Heatmap BlkLevel Flushed to BF128329477246
12cR1-12cR2Heatmap BlkLevel Flushed to SYSAUX128153666168
12cR1-12cR2Heatmap BlkLevel Not Tracked - Memory1283244920981
12cR1-12cR2Heatmap BlkLevel Not Updated - Repeat1281235344528
12cR1-12cR2Heatmap BlkLevel Ranges Flushed1283869669302
12cR1-12cR2Heatmap BlkLevel Ranges Skipped128120128078
12cR1-12cR2Heatmap BlkLevel Tracked128417269865
12cR1-12cR2Heatmap Blklevel Flush Task Count1281887039906
12cR1-12cR2Heatmap SegLevel - Flush1283466367062
12cR1-12cR2Heatmap SegLevel - Full Table Scan1283635715785
12cR1-12cR2Heatmap SegLevel - IndexLookup1284088384827
12cR1-12cR2Heatmap SegLevel - Segments flushed1282885452372
12cR1-12cR2Heatmap SegLevel - TableLookup12826595750
12cR1-12cR2Heatmap SegLevel - Write1282305866014
12cR2-12cR2IM ADG blocks in flush1282643938392
12cR2-12cR2IM ADG commit journal destroy1281062216118
12cR2-12cR2IM ADG commit journal emptied1281219157601
12cR2-12cR2IM ADG commit nodes added1283589509200
12cR2-12cR2IM ADG commit nodes freed128893205542
12cR2-12cR2IM ADG corrupt undo blocks seen1281522012737
12cR2-12cR2IM ADG granule split1281563259767
12cR2-12cR2IM ADG inv all due to corrupt undo1282166038026
12cR2-12cR2IM ADG inv pdb due to corrupt undo128812797608
12cR2-12cR2IM ADG invalidated all objects1283894316468
12cR2-12cR2IM ADG invalidated object DDL1284278903855
12cR2-12cR2IM ADG invalidated pdb DDL1281082334166
12cR2-12cR2IM ADG invalidated pdb partial transaction1282654980280
12cR2-12cR2IM ADG journal sort1282926884134
12cR2-12cR2IM ADG non-IMC transactions12837004723
12cR2-12cR2IM ADG nothing to flush128968317731
12cR2-12cR2IM ADG number of query scn moves1284088666459
12cR2-12cR2IM ADG redo records seen1282265494525
12cR2-12cR2IM ADG registration attempts1283262016710
12cR2-12cR2IM ADG registration failure (quiesce)1282569714015
12cR2-12cR2IM ADG time for query scn moves (ms)1283758414819
12cR2-12cR2IM ADG transactions compiled for flush128133105357
12cR2-12cR2IM ADG transactions flushed1284279820660
12cR2-12cR2IM SubCU-Hist CUs1282143173040
12cR2-12cR2IM SubCU-Hist CUs Examined1281109306055
12cR2-12cR2IM SubCU-Hist CUs Selected1282756294314
12cR2-12cR2IM SubCU-Hist SubCUs Eliminated1282518197768
12cR2-12cR2IM SubCU-Hist SubCUs in Selected CUs128465371602
12cR2-12cR2IM SubCU-Hist bytes allocated128630577609
12cR2-12cR2IM SubCU-IndEnc CUs12861679533
12cR2-12cR2IM SubCU-IndEnc bytes allocated1283585568379
12cR2-12cR2IM SubCU-InvIdx CUs1284118126755
12cR2-12cR2IM SubCU-InvIdx CUs Examined1284001196145
12cR2-12cR2IM SubCU-InvIdx CUs Selected128584133516
12cR2-12cR2IM SubCU-InvIdx bytes allocated1283500441351
12cR2-12cR2IM SubCU-MM CUs128704705717
12cR2-12cR2IM SubCU-MM CUs Examined1281572803999
12cR2-12cR2IM SubCU-MM CUs Selected1281155802227
12cR2-12cR2IM SubCU-MM SubCUs Eliminated128202207180
12cR2-12cR2IM SubCU-MM SubCUs in Selected CUs1281493400096
12cR2-12cR2IM SubCU-MM bytes allocated1282700207077
12cR2-12cR2IM default area resized1282715919735
12cR2-12cR2IM faststart coordinator accumulated time (ms)1282150984103
12cR2-12cR2IM faststart coordinator cycle aborts128404301313
12cR2-12cR2IM faststart coordinator cycle overruns1281516757308
12cR2-12cR2IM faststart coordinator runs128810518709
12cR2-12cR2IM faststart coordinator scheduler restarted1283503458813
12cR2-12cR2IM faststart coordinator task priority p1 to p21281591858011
12cR2-12cR2IM faststart coordinator task priority p2 extended1283653247918
12cR2-12cR2IM faststart coordinator task priority p2 to p31282510604378
12cR2-12cR2IM faststart coordinator task submitted priority p11283110153046
12cR2-12cR2IM faststart coordinator task submitted priority p21284221905300
12cR2-12cR2IM faststart coordinator task submitted priority p3128289360081
12cR2-12cR2IM faststart coordinator throttle down1281785069298
12cR2-12cR2IM faststart delete CUs problem1282966203353
12cR2-12cR2IM faststart read CUs1283185249763
12cR2-12cR2IM faststart read CUs incompatible128226574100
12cR2-12cR2IM faststart read CUs invalid1282281882395
12cR2-12cR2IM faststart read CUs not accessible1282211736513
12cR2-12cR2IM faststart read CUs problems1281170400619
12cR2-12cR2IM faststart read CUs requested1283752838964
12cR2-12cR2IM faststart read accumulated time (ms)1283994416335
12cR2-12cR2IM faststart read bytes1283489132426
12cR2-12cR2IM faststart read data accumulated time (ms)1282678779505
12cR2-12cR2IM faststart read headers accumulated time (ms)1284280272097
12cR2-12cR2IM faststart read verify accumulated time (ms)1281663401166
12cR2-12cR2IM faststart write CUs1284113641993
12cR2-12cR2IM faststart write CUs encryption mismatch1283691114625
12cR2-12cR2IM faststart write CUs evicted1283713239352
12cR2-12cR2IM faststart write CUs problems128399526922
12cR2-12cR2IM faststart write CUs requested1281162434741
12cR2-12cR2IM faststart write CUs too dirty1283330120530
12cR2-12cR2IM faststart write accumulated time (ms)128299858254
12cR2-12cR2IM faststart write bytes1282293141066
12cR2-12cR2IM faststart write deferred CUs1282282678364
12cR2-12cR2IM faststart write deferred CUs not found128196373289
12cR2-12cR2IM faststart write deferred CUs requested128676960038
12cR2-12cR2IM faststart write deferred accumulated (ms)1281859461364
12cR2-12cR2IM faststart write deferred timeouts128112589568
12cR2-12cR2IM fetches by rowid from IMCU1282222525418
12cR2-12cR2IM fetches by rowid from disk1283551135753
12cR2-12cR2IM fetches by rowid from fetch list1283967912537
12cR2-12cR2IM fetches by rowid from journal1282882284668
12cR2-12cR2IM fetches by rowid row invalid in IMCU1282595785150
12cR2-12cR2IM hpk spare11281240156707
12cR2-12cR2IM hpk spare2128859185653
12cR2-12cR2IM hpk spare31282242095804
12cR2-12cR2IM hpk spare41284153582075
12cR2-12cR2IM hpk spare51281254878537
12cR2-12cR2IM hpk spare61283792434376
12cR2-12cR2IM populate CUs1282955308651
12cR2-12cR2IM populate CUs chain pieces1283057873239
12cR2-12cR2IM populate CUs columns1283662127981
12cR2-12cR2IM populate CUs empty1283153968654
12cR2-12cR2IM populate CUs memcompress for capacity high1281618424729
12cR2-12cR2IM populate CUs memcompress for capacity low1284248708517
12cR2-12cR2IM populate CUs memcompress for dml1282276229407
12cR2-12cR2IM populate CUs memcompress for query high1282927358019
12cR2-12cR2IM populate CUs memcompress for query low1282296351543
12cR2-12cR2IM populate CUs no blocks1283062353187
12cR2-12cR2IM populate CUs no memcompress128775377590
12cR2-12cR2IM populate CUs nop1281829142423
12cR2-12cR2IM populate CUs not128233016916
12cR2-12cR2IM populate CUs requested1282413778628
12cR2-12cR2IM populate CUs resubmitted128308005141
12cR2-12cR2IM populate EUs1282116640316
12cR2-12cR2IM populate EUs accumulated time (ms)128687249909
12cR2-12cR2IM populate EUs columns1281350961266
12cR2-12cR2IM populate EUs memcompress for capacity high1281381048888
12cR2-12cR2IM populate EUs memcompress for capacity low1282481174812
12cR2-12cR2IM populate EUs memcompress for dml1283213183441
12cR2-12cR2IM populate EUs memcompress for query high128335804787
12cR2-12cR2IM populate EUs memcompress for query low1284209951701
12cR2-12cR2IM populate EUs no memcompress128771409126
12cR2-12cR2IM populate EUs requested1283915298720
12cR2-12cR2IM populate SMU/DLM locks fail1283222893716
12cR2-12cR2IM populate accumulated time (ms)1281797503078
12cR2-12cR2IM populate blocks invalid1282258197490
12cR2-12cR2IM populate buffer direct read time (ms)1283064337535
12cR2-12cR2IM populate bytes from storage1283934470247
12cR2-12cR2IM populate bytes in-memory EU data1282480197577
12cR2-12cR2IM populate bytes in-memory data1281410708842
12cR2-12cR2IM populate bytes uncompressed EU data1281059746531
12cR2-12cR2IM populate bytes uncompressed data1281101147916
12cR2-12cR2IM populate cache read time (ms)1281677235905
12cR2-12cR2IM populate checkpoint time (ms)1282777277809
12cR2-12cR2IM populate direct read time (ms)1283354173668
12cR2-12cR2IM populate no checkpoint1283870866996
12cR2-12cR2IM populate no contiguous inmemory space1283304185040
12cR2-12cR2IM populate no space in PGA1282307446945
12cR2-12cR2IM populate rows1283819237794
12cR2-12cR2IM populate segments1282422255134
12cR2-12cR2IM populate segments requested1281177949291
12cR2-12cR2IM populate segments wall clock time (ms)1284180082378
12cR2-12cR2IM populate transactions active1283005048602
12cR2-12cR2IM populate transactions check1281349591587
12cR2-12cR2IM populate undo records applied1283483655676
12cR2-12cR2IM populate undo segheader rollback1282663289634
12cR2-12cR2IM populate via direct reads128505862029
12cR2-12cR2IM prepopulate CUs1281040950306
12cR2-12cR2IM prepopulate CUs chain pieces1283913374690
12cR2-12cR2IM prepopulate CUs columns1282459071718
12cR2-12cR2IM prepopulate CUs empty1283490607210
12cR2-12cR2IM prepopulate CUs memcompress for capacity high128909483832
12cR2-12cR2IM prepopulate CUs memcompress for capacity low1282110586149
12cR2-12cR2IM prepopulate CUs memcompress for dml1281849943413
12cR2-12cR2IM prepopulate CUs memcompress for query high128776286091
12cR2-12cR2IM prepopulate CUs memcompress for query low1283417921356
12cR2-12cR2IM prepopulate CUs no blocks1282987880596
12cR2-12cR2IM prepopulate CUs no memcompress1281656716518
12cR2-12cR2IM prepopulate CUs nop1282984659368
12cR2-12cR2IM prepopulate CUs not1281321364424
12cR2-12cR2IM prepopulate CUs requested1283171698645
12cR2-12cR2IM prepopulate CUs resubmitted1281397146827
12cR2-12cR2IM prepopulate EUs1282254296876
12cR2-12cR2IM prepopulate EUs accumulated time (ms)1282967685739
12cR2-12cR2IM prepopulate EUs columns1281185389362
12cR2-12cR2IM prepopulate EUs memcompress for capacity high1282635927907
12cR2-12cR2IM prepopulate EUs memcompress for capacity low128255511502
12cR2-12cR2IM prepopulate EUs memcompress for dml1284150796749
12cR2-12cR2IM prepopulate EUs memcompress for query high128537634578
12cR2-12cR2IM prepopulate EUs memcompress for query low128435765836
12cR2-12cR2IM prepopulate EUs no memcompress1282226535720
12cR2-12cR2IM prepopulate EUs requested1281858117363
12cR2-12cR2IM prepopulate accumulated time (ms)1282050372822
12cR2-12cR2IM prepopulate bytes from storage128615994772
12cR2-12cR2IM prepopulate bytes in-memory EU data1282296387979
12cR2-12cR2IM prepopulate bytes in-memory data1281084553061
12cR2-12cR2IM prepopulate bytes uncompressed EU data1282804448302
12cR2-12cR2IM prepopulate bytes uncompressed data1281199609386
12cR2-12cR2IM prepopulate rows1283047560337
12cR2-12cR2IM prepopulate segments1281274634774
12cR2-12cR2IM prepopulate segments requested128644112111
12cR2-12cR2IM rac CUs invalid128738076331
12cR2-12cR2IM rac blocks invalid1281326785366
12cR2-12cR2IM repopulate (ADG) transactions copied1282174103894
12cR2-12cR2IM repopulate (doublebuffering) CUs1281081929888
12cR2-12cR2IM repopulate (doublebuffering) CUs requested128217149768
12cR2-12cR2IM repopulate (incremental) CU blocks1283900271180
12cR2-12cR2IM repopulate (incremental) CUs12876806242
12cR2-12cR2IM repopulate (incremental) CUs columns128922919154
12cR2-12cR2IM repopulate (incremental) CUs columns dict reused1283030083807
12cR2-12cR2IM repopulate (incremental) CUs columns reused1282191278376
12cR2-12cR2IM repopulate (incremental) CUs old CU defchg1282011532078
12cR2-12cR2IM repopulate (incremental) CUs old CU empty1282827982589
12cR2-12cR2IM repopulate (incremental) CUs old CU unavailable1283621498711
12cR2-12cR2IM repopulate (incremental) CUs requested1283508253935
12cR2-12cR2IM repopulate (incremental) CUs using population128655981285
12cR2-12cR2IM repopulate (incremental) CUs valid columns optimized128647815820
12cR2-12cR2IM repopulate (incremental) EUs1283750739561
12cR2-12cR2IM repopulate (incremental) EUs requested1283329468677
12cR2-12cR2IM repopulate (incremental) blocks read1282506450026
12cR2-12cR2IM repopulate (incremental) fetched rows128925162847
12cR2-12cR2IM repopulate (incremental) invalid CU rows1282879239743
12cR2-12cR2IM repopulate (incremental) modified blocks128828277095
12cR2-12cR2IM repopulate (incremental) total rows1283705837794
12cR2-12cR2IM repopulate (incremental) valid CU rows128615651681
12cR2-12cR2IM repopulate (scan) CUs1283243397478
12cR2-12cR2IM repopulate (scan) CUs nop1283190198422
12cR2-12cR2IM repopulate (scan) CUs not128322138344
12cR2-12cR2IM repopulate (scan) CUs requested128118679609
12cR2-12cR2IM repopulate (scan) CUs resubmitted128682530991
12cR2-12cR2IM repopulate (scan) EUs1283644043093
12cR2-12cR2IM repopulate (scan) EUs requested1281706965346
12cR2-12cR2IM repopulate (trickle incremental) CU blocks1282722389118
12cR2-12cR2IM repopulate (trickle incremental) CUs columns1281631668465
12cR2-12cR2IM repopulate (trickle incremental) CUs columns dict reused128822797786
12cR2-12cR2IM repopulate (trickle incremental) CUs columns reused128155204997
12cR2-12cR2IM repopulate (trickle incremental) CUs valid columns optimized1282855599599
12cR2-12cR2IM repopulate (trickle incremental) blocks read128300970648
12cR2-12cR2IM repopulate (trickle incremental) fetched rows1282415010356
12cR2-12cR2IM repopulate (trickle incremental) invalid CU rows1282037370930
12cR2-12cR2IM repopulate (trickle incremental) modified blocks1283045408308
12cR2-12cR2IM repopulate (trickle incremental) total rows128263772751
12cR2-12cR2IM repopulate (trickle incremental) valid CU rows1282418146509
12cR2-12cR2IM repopulate (trickle) CUs1282075146753
12cR2-12cR2IM repopulate (trickle) CUs chain pieces128301991306
12cR2-12cR2IM repopulate (trickle) CUs columns1282864599907
12cR2-12cR2IM repopulate (trickle) CUs empty1281766269893
12cR2-12cR2IM repopulate (trickle) CUs memcompress for capacity high1283056065547
12cR2-12cR2IM repopulate (trickle) CUs memcompress for capacity low12865449171
12cR2-12cR2IM repopulate (trickle) CUs memcompress for dml128999732158
12cR2-12cR2IM repopulate (trickle) CUs memcompress for query high1281053181522
12cR2-12cR2IM repopulate (trickle) CUs memcompress for query low1284241275046
12cR2-12cR2IM repopulate (trickle) CUs no memcompress1282982343484
12cR2-12cR2IM repopulate (trickle) CUs nop1281951644109
12cR2-12cR2IM repopulate (trickle) CUs not1284148871639
12cR2-12cR2IM repopulate (trickle) CUs requested1284176474684
12cR2-12cR2IM repopulate (trickle) CUs resubmitted1283433367641
12cR2-12cR2IM repopulate (trickle) EUs1283034289225
12cR2-12cR2IM repopulate (trickle) EUs accumulated time (ms)1284008376754
12cR2-12cR2IM repopulate (trickle) EUs columns1281163061245
12cR2-12cR2IM repopulate (trickle) EUs memcompress for capacity high1282190460684
12cR2-12cR2IM repopulate (trickle) EUs memcompress for capacity low1281478322433
12cR2-12cR2IM repopulate (trickle) EUs memcompress for dml1281236651186
12cR2-12cR2IM repopulate (trickle) EUs memcompress for query high1281542496920
12cR2-12cR2IM repopulate (trickle) EUs memcompress for query low1283166353398
12cR2-12cR2IM repopulate (trickle) EUs no memcompress1283568311379
12cR2-12cR2IM repopulate (trickle) EUs requested1282338049329
12cR2-12cR2IM repopulate (trickle) accumulated time (ms)1283383674922
12cR2-12cR2IM repopulate (trickle) bytes from storage128328500101
12cR2-12cR2IM repopulate (trickle) bytes in-memory EU data128767662871
12cR2-12cR2IM repopulate (trickle) bytes in-memory data128246537910
12cR2-12cR2IM repopulate (trickle) bytes uncompressed EU data1283039339056
12cR2-12cR2IM repopulate (trickle) bytes uncompressed data1281138928130
12cR2-12cR2IM repopulate (trickle) rows1281774640318
12cR2-12cR2IM repopulate CUs1283832315249
12cR2-12cR2IM repopulate CUs chain pieces128104256212
12cR2-12cR2IM repopulate CUs columns1283042381736
12cR2-12cR2IM repopulate CUs empty128406630946
12cR2-12cR2IM repopulate CUs memcompress for capacity high128980426332
12cR2-12cR2IM repopulate CUs memcompress for capacity low1282103600276
12cR2-12cR2IM repopulate CUs memcompress for dml1283820524328
12cR2-12cR2IM repopulate CUs memcompress for query high1283679462872
12cR2-12cR2IM repopulate CUs memcompress for query low1281785891955
12cR2-12cR2IM repopulate CUs no memcompress1284111284545
12cR2-12cR2IM repopulate CUs nop1281858293252
12cR2-12cR2IM repopulate CUs not1281748883379
12cR2-12cR2IM repopulate CUs requested1282026879952
12cR2-12cR2IM repopulate CUs resubmitted1281766351035
12cR2-12cR2IM repopulate EUs1281071404845
12cR2-12cR2IM repopulate EUs accumulated time (ms)1281633339355
12cR2-12cR2IM repopulate EUs columns1284212721548
12cR2-12cR2IM repopulate EUs memcompress for capacity high128448069826
12cR2-12cR2IM repopulate EUs memcompress for capacity low1283194307366
12cR2-12cR2IM repopulate EUs memcompress for dml128130266217
12cR2-12cR2IM repopulate EUs memcompress for query high1282800990389
12cR2-12cR2IM repopulate EUs memcompress for query low1282769089891
12cR2-12cR2IM repopulate EUs no memcompress1282761954461
12cR2-12cR2IM repopulate EUs requested1282257404347
12cR2-12cR2IM repopulate SMU/DLM locks fail1283915284276
12cR2-12cR2IM repopulate accumulated time (ms)1281832192659
12cR2-12cR2IM repopulate blocks invalid1283683774235
12cR2-12cR2IM repopulate blocks now valid128688886253
12cR2-12cR2IM repopulate bytes from storage1281229442380
12cR2-12cR2IM repopulate bytes in-memory EU data1281872307237
12cR2-12cR2IM repopulate bytes in-memory data128918879133
12cR2-12cR2IM repopulate bytes uncompressed EU data1283249852502
12cR2-12cR2IM repopulate bytes uncompressed data128706709849
12cR2-12cR2IM repopulate checkpoints128279476941
12cR2-12cR2IM repopulate due to block threshold hit1284378661
12cR2-12cR2IM repopulate due to row threshold hit1281095207924
12cR2-12cR2IM repopulate invalid blks1282989627994
12cR2-12cR2IM repopulate invalid rows1281421186525
12cR2-12cR2IM repopulate invalidation transfer time1283055393544
12cR2-12cR2IM repopulate no contiguous inmemory space1282391852442
12cR2-12cR2IM repopulate no space in PGA1283064704536
12cR2-12cR2IM repopulate old SMU nil1281825432315
12cR2-12cR2IM repopulate optimized128280635369
12cR2-12cR2IM repopulate optimized RAC/downgrade1283380223169
12cR2-12cR2IM repopulate previous SMU invalid1282662099019
12cR2-12cR2IM repopulate read time (ms)1281835677423
12cR2-12cR2IM repopulate rows128156983380
12cR2-12cR2IM repopulate segments1281051208932
12cR2-12cR2IM repopulate segments requested1282647450618
12cR2-12cR2IM repopulate smu colmap used1282910005046
12cR2-12cR2IM repopulate transactions active1281716359684
12cR2-12cR2IM repopulate transactions check128568583122
12cR2-12cR2IM repopulate transactions copied1284072711348
12cR2-12cR2IM repopulate undo records applied1281323957107
12cR2-12cR2IM repopulate undo segheader rollback1283624529679
12cR2-12cR2IM repopulate via direct reads1284133374468
12cR2-12cR2IM scan (dynamic) max degree1283752585184
12cR2-12cR2IM scan (dynamic) multi-threaded scans1282156724065
12cR2-12cR2IM scan (dynamic) rows1283410208663
12cR2-12cR2IM scan (dynamic) rs2 rowsets1281808664032
12cR2-12cR2IM scan (dynamic) spare11282377846929
12cR2-12cR2IM scan (dynamic) spare21281725492961
12cR2-12cR2IM scan (dynamic) tasks processed by parent1283381497459
12cR2-12cR2IM scan (dynamic) tasks processed by thread128867975901
12cR2-12cR2IM scan CUs CR Incremental1281207641590
12cR2-12cR2IM scan CUs CR cache hit1281939629411
12cR2-12cR2IM scan CUs CR cache miss1282423065321
12cR2-12cR2IM scan CUs CR skipped large rowids128983416835
12cR2-12cR2IM scan CUs cleanout128938790658
12cR2-12cR2IM scan CUs column not in memory1281315085039
12cR2-12cR2IM scan CUs columns accessed1283262565804
12cR2-12cR2IM scan CUs columns decompressed1283487035914
12cR2-12cR2IM scan CUs columns theoretical max1284011277422
12cR2-12cR2IM scan CUs current1284123663860
12cR2-12cR2IM scan CUs doublebuffering1281408679476
12cR2-12cR2IM scan CUs drop-invis smu1281919469035
12cR2-12cR2IM scan CUs failed to reget pin1283935778541
12cR2-12cR2IM scan CUs invalid1281509625352
12cR2-12cR2IM scan CUs invalid (all rows are invalid)1282495342952
12cR2-12cR2IM scan CUs invalid or missing revert to on disk extent1283876534371
12cR2-12cR2IM scan CUs invisible smu128828098396
12cR2-12cR2IM scan CUs low query scn128958079402
12cR2-12cR2IM scan CUs lowscn no previous1282067282123
12cR2-12cR2IM scan CUs maxretry done128346132981
12cR2-12cR2IM scan CUs memcompress for capacity high1282266722500
12cR2-12cR2IM scan CUs memcompress for capacity low128864068915
12cR2-12cR2IM scan CUs memcompress for dml1281818148785
12cR2-12cR2IM scan CUs memcompress for query high1283065223572
12cR2-12cR2IM scan CUs memcompress for query low1283763254709
12cR2-12cR2IM scan CUs no cleanout1283716758295
12cR2-12cR2IM scan CUs no imcu1283109263430
12cR2-12cR2IM scan CUs no memcompress1284042495865
12cR2-12cR2IM scan CUs no rollback1282408715569
12cR2-12cR2IM scan CUs notfound1282931436942
12cR2-12cR2IM scan CUs notfound dbclose1281199989407
12cR2-12cR2IM scan CUs notfound lob1281214339502
12cR2-12cR2IM scan CUs optimized read1282200972175
12cR2-12cR2IM scan CUs pcode aggregation IME1282400667507
12cR2-12cR2IM scan CUs pcode aggregation pushdown1282387485877
12cR2-12cR2IM scan CUs pcode pred evaled128643883314
12cR2-12cR2IM scan CUs pcode pred evaled using rowsets128409245346
12cR2-12cR2IM scan CUs pcode selective done1284080242895
12cR2-12cR2IM scan CUs predicates applied1283440428945
12cR2-12cR2IM scan CUs predicates optimized12886458618
12cR2-12cR2IM scan CUs predicates received1283626182130
12cR2-12cR2IM scan CUs previous1283394119073
12cR2-12cR2IM scan CUs previous current128685918719
12cR2-12cR2IM scan CUs pruned12849325066
12cR2-12cR2IM scan CUs readlist creation accumulated time1281271467443
12cR2-12cR2IM scan CUs readlist creation accumulated time (CR)1283020149408
12cR2-12cR2IM scan CUs readlist creation number1282046578391
12cR2-12cR2IM scan CUs readlist creation number (CR)1281011059911
12cR2-12cR2IM scan CUs ref-invis smu1281669916299
12cR2-12cR2IM scan CUs rollback1282118247488
12cR2-12cR2IM scan CUs split pieces1283776055719
12cR2-12cR2IM scan CUs undo records applied1281285587050
12cR2-12cR2IM scan CUs wait notvis128779421300
12cR2-12cR2IM scan CUs wait notvis (doublebuffer)1283607181589
12cR2-12cR2IM scan EU bytes in-memory1283447323410
12cR2-12cR2IM scan EU bytes uncompressed1281274614140
12cR2-12cR2IM scan EU rows1282290378991
12cR2-12cR2IM scan EUs columns accessed1283295504360
12cR2-12cR2IM scan EUs columns decompressed1282153457955
12cR2-12cR2IM scan EUs columns theoretical max128713198009
12cR2-12cR2IM scan EUs memcompress for capacity high1282578961295
12cR2-12cR2IM scan EUs memcompress for capacity low1282601042155
12cR2-12cR2IM scan EUs memcompress for dml1281647642264
12cR2-12cR2IM scan EUs memcompress for query high1283760640187
12cR2-12cR2IM scan EUs memcompress for query low1281862284337
12cR2-12cR2IM scan EUs no memcompress128605926888
12cR2-12cR2IM scan EUs split pieces128107081157
12cR2-12cR2IM scan blocks cache1284094161950
12cR2-12cR2IM scan bytes in-memory1282386807519
12cR2-12cR2IM scan bytes uncompressed1281673250399
12cR2-12cR2IM scan dict engine results reused128388150043
12cR2-12cR2IM scan dict engine results stored1283657493699
12cR2-12cR2IM scan fetches journal128481569166
12cR2-12cR2IM scan found invalid CU1281110725215
12cR2-12cR2IM scan invalid all blocks1282670936428
12cR2-12cR2IM scan journal128267182879
12cR2-12cR2IM scan journal cleanout1283657991024
12cR2-12cR2IM scan journal no cleanout128816291792
12cR2-12cR2IM scan rows1284102715135
12cR2-12cR2IM scan rows cache128514235889
12cR2-12cR2IM scan rows discontinuous1283104047917
12cR2-12cR2IM scan rows excluded1284074538799
12cR2-12cR2IM scan rows journal1284169555641
12cR2-12cR2IM scan rows journal total1283043546308
12cR2-12cR2IM scan rows optimized1283379634641
12cR2-12cR2IM scan rows pcode aggregated1281754331210
12cR2-12cR2IM scan rows projected1284244190754
12cR2-12cR2IM scan rows range excluded1282596604857
12cR2-12cR2IM scan rows valid1281483538274
12cR2-12cR2IM scan segments disk128451217544
12cR2-12cR2IM scan segments minmax eligible1282711829362
12cR2-12cR2IM scan smu colmap hit1282104777800
12cR2-12cR2IM scan smu colmap miss due to deletes1282384187531
12cR2-12cR2IM scan smu colmap miss due to inserts128416506643
12cR2-12cR2IM scan smu colmap miss due to invalid blocks1282696581246
12cR2-12cR2IM scan smu colmap miss due to untracked changes128659092677
12cR2-12cR2IM scan smu colmap miss due to update1283135962818
12cR2-12cR2IM scan uncommitted PJ granule128350537545
12cR2-12cR2IM simd bloom filter calls1282199257108
12cR2-12cR2IM simd bloom filter selective calls1282022198951
12cR2-12cR2IM simd compare HW offload calls1282659500771
12cR2-12cR2IM simd compare calls1281044792186
12cR2-12cR2IM simd compare selective calls1283230112240
12cR2-12cR2IM simd decode HW offload calls1281609083103
12cR2-12cR2IM simd decode calls1283204138354
12cR2-12cR2IM simd decode selective calls128302664824
12cR2-12cR2IM simd decode symbol calls128159859823
12cR2-12cR2IM simd decode symbol selective calls1281198320044
12cR2-12cR2IM simd decode unpack HW offload calls1283206894071
12cR2-12cR2IM simd decode unpack calls128867326784
12cR2-12cR2IM simd decode unpack selective calls1282168821232
12cR2-12cR2IM simd rle burst HW offload calls1282814218811
12cR2-12cR2IM simd rle burst calls1281758783692
12cR2-12cR2IM simd rle burst selective calls1282758070240
12cR2-12cR2IM simd set membership HW offload calls1282835344988
12cR2-12cR2IM simd set membership calls1281418926056
12cR2-12cR2IM simd set membership selective calls1283328384443
12cR2-12cR2IM space ADG bytes allocated1282809591919
12cR2-12cR2IM space ADG bytes freed1281329349552
12cR2-12cR2IM space ADG extents allocated1281672799686
12cR2-12cR2IM space ADG journal extents freed1281034271991
12cR2-12cR2IM space ADG segments allocated1281846379012
12cR2-12cR2IM space ADG segments freed1283832579894
12cR2-12cR2IM space CU bytes allocated1283221225183
12cR2-12cR2IM space CU bytes freed128681378792
12cR2-12cR2IM space CU creations committed1281369470929
12cR2-12cR2IM space CU creations initiated1282742958628
12cR2-12cR2IM space CU extents allocated1282727989488
12cR2-12cR2IM space CU extents freed1284056620908
12cR2-12cR2IM space SMU bytes allocated1284185711678
12cR2-12cR2IM space SMU bytes freed1281701490127
12cR2-12cR2IM space SMU creations committed1284257219417
12cR2-12cR2IM space SMU creations initiated128992067343
12cR2-12cR2IM space SMU extents allocated128419242889
12cR2-12cR2IM space SMU extents freed1281164872707
12cR2-12cR2IM space private journal bytes allocated128706858115
12cR2-12cR2IM space private journal bytes freed1281105703986
12cR2-12cR2IM space private journal extents allocated1284141686621
12cR2-12cR2IM space private journal extents freed1283583816549
12cR2-12cR2IM space private journal segments allocated1283544265112
12cR2-12cR2IM space private journal segments freed1283994815895
12cR2-12cR2IM space segments allocated1281542261970
12cR2-12cR2IM space segments freed1281011906324
12cR2-12cR2IM space shared journal bytes allocated1283701264133
12cR2-12cR2IM space shared journal bytes freed1282580902581
12cR2-12cR2IM space shared journal extents allocated1284063791326
12cR2-12cR2IM space shared journal extents freed1283602701801
12cR2-12cR2IM space shared journal segments allocated128754504065
12cR2-12cR2IM space shared journal segments freed128301035159
12cR2-12cR2IM split CU too small128685690186
12cR2-12cR2IM split CUs1281194208353
12cR2-12cR2IM split CUs requested1283168700245
12cR2-12cR2IM split fail1283875113117
12cR2-12cR2IM split fail no space1282137664925
12cR2-12cR2IM split get smaller CUs128418372806
12cR2-12cR2IM transaction rows array-journal calls128990159678
12cR2-12cR2IM transaction rows array-journaled1281242511747
12cR2-12cR2IM transaction wait ref-smu1282065909932
12cR2-12cR2IM transactions1282390666123
12cR2-12cR2IM transactions CU cleanout128357919351
12cR2-12cR2IM transactions CUs invalid1281130699339
12cR2-12cR2IM transactions block change blocks already invalid1282641640064
12cR2-12cR2IM transactions blocks invalidated1281852715731
12cR2-12cR2IM transactions downgrade1282376736678
12cR2-12cR2IM transactions found invalid CU1282710587808
12cR2-12cR2IM transactions full cleanout1282127113765
12cR2-12cR2IM transactions journal cleanout1283593488204
12cR2-12cR2IM transactions rows invalidated1282152704
12cR2-12cR2IM transactions rows journaled1283385557299
12cR2-12cR2IM transactions self-cleanout no active128593788626
12cR2-12cR2IM txn zzzz spare11281536693641
12cR2-12cR2IM txn zzzz spare21282541797585
12cR2-12cR2IM txn zzzz spare31282134789498
12cR2-12cR2IM txn zzzz spare41284257140173
12cR2-12cR2IM txn zzzz spare51283803459038
12cR2-12cR2IM zzzz spare11281193238672
12cR2-12cR2IM zzzz spare101283238213154
12cR2-12cR2IM zzzz spare11128561064055
12cR2-12cR2IM zzzz spare121283392753424
12cR2-12cR2IM zzzz spare1312854878071
12cR2-12cR2IM zzzz spare141284045339953
12cR2-12cR2IM zzzz spare15128292806368
12cR2-12cR2IM zzzz spare161283961798953
12cR2-12cR2IM zzzz spare171283599149048
12cR2-12cR2IM zzzz spare181283513999986
12cR2-12cR2IM zzzz spare191283845657028
12cR2-12cR2IM zzzz spare21283645833388
12cR2-12cR2IM zzzz spare201283876079753
12cR2-12cR2IM zzzz spare31282143383440
12cR2-12cR2IM zzzz spare4128506728043
12cR2-12cR2IM zzzz spare51283499009924
12cR2-12cR2IM zzzz spare61281682366385
12cR2-12cR2IM zzzz spare71282258007153
12cR2-12cR2IM zzzz spare81282259606611
12cR2-12cR2IM zzzz spare91282588062830
10gR1-12cR2IMU CR rollbacks1282225124543
10gR1-12cR2IMU Flushes1282099506212
10gR1-12cR2IMU Redo allocation size1283945654623
10gR1-12cR2IMU bind flushes1282756376339
10gR1-12cR2IMU commits1281914489094
10gR1-12cR2IMU contention1282909373607
10gR1-12cR2IMU ktichg flush1281206609541
10gR1-12cR2IMU mbu flush1283723686946
10gR1-12cR2IMU pool not allocated128659017805
10gR1-12cR2IMU recursive-transaction flush1282591100633
10gR1-12cR2IMU undo allocation size128244193920
10gR1-12cR2IMU undo retention flush1282087226422
10gR1-12cR2IMU- failed to get a private strand1282412863545
10gR1-12cR2IPC CPU used by this session324247517299
12cR1-12cR2KTFB alloc myinst128637674164
12cR1-12cR2KTFB alloc req1283506976771
12cR1-12cR2KTFB alloc search FFB1281572111054
12cR1-12cR2KTFB alloc space (block)128254882839
12cR1-12cR2KTFB alloc steal1283819194715
12cR1-12cR2KTFB alloc time (ms)128573758863
12cR1-12cR2KTFB apply req1282829590811
12cR1-12cR2KTFB apply time (ms)1281827629900
12cR1-12cR2KTFB commit req1282268695636
12cR1-12cR2KTFB commit time (ms)1283807444826
12cR1-12cR2KTFB free req1281286187813
12cR1-12cR2KTFB free space (block)1281243401580
12cR1-12cR2KTFB free time (ms)128408510199
11gR1-12cR2LOB table id lookup cache misses1281983401898
10gR1-12cR2Misses for writing mapping1282725329757
11gR2-12cR2No. of Decrypt ops11118476298
11gR2-12cR2No. of Encrypt ops13364959674
11gR2-12cR2No. of Namespaces Created11052652127
11gR2-12cR2No. of Principal Cache Misses11497811853
11gR2-12cR2No. of Principal Invalidations11130152043
11gR2-12cR2No. of Roles Enabled or Disabled11422657893
11gR2-12cR2No. of User Callbacks Executed12910344476
11gR2-12cR2No. of XS Sessions Attached11249145894
11gR2-12cR2No. of XS Sessions Created184820840
12cR1-12cR2Number of FORMAT_PRESERVING redactions12739332778
12cR1-12cR2Number of FULL redactions14021003316
12cR1-12cR2Number of NONE redactions12910416594
12cR2-12cR2Number of NULLIFY redactions13061010477
12cR1-12cR2Number of PARTIAL redactions12340397149
12cR1-12cR2Number of RANDOM redactions12308447938
12cR1-12cR2Number of REGEXP redactions13081010860
12cR2-12cR2Number of REGEXP_WIDTH redactions1169601117
11gR1-12cR2Number of read IOs issued83882100521
12cR1-12cR2OLAP Aggregate Function Calc643109348342
12cR1-12cR2OLAP Aggregate Function Logical NA642269374713
12cR1-12cR2OLAP Aggregate Function Precompute64352609299
12cR1-12cR2OLAP Custom Member Limit643030144806
12cR1-12cR2OLAP Engine Calls644076583183
12cR1-12cR2OLAP Fast Limit64283242358
12cR1-12cR2OLAP Full Limit642189109011
12cR1-12cR2OLAP GID Limit641120107350
12cR1-12cR2OLAP INHIER Limit642844959843
12cR1-12cR2OLAP Import Rows Loaded642782483173
12cR1-12cR2OLAP Import Rows Pushed643846608240
12cR1-12cR2OLAP Limit Time642592657924
12cR1-12cR2OLAP Paging Manager Cache Changed Page642200669834
12cR1-12cR2OLAP Paging Manager Cache Hit64249788237
12cR1-12cR2OLAP Paging Manager Cache Miss642631123639
12cR1-12cR2OLAP Paging Manager Cache Write642077400790
12cR1-12cR2OLAP Paging Manager New Page641639856938
12cR1-12cR2OLAP Paging Manager Pool Size643621573995
12cR1-12cR2OLAP Perm LOB Read642809117898
12cR1-12cR2OLAP Row Id Limit643437716459
12cR1-12cR2OLAP Row Load Time64953132701
12cR1-12cR2OLAP Row Source Rows Processed641032576542
12cR1-12cR2OLAP Session Cache Hit643766195924
12cR1-12cR2OLAP Session Cache Miss641569481295
12cR1-12cR2OLAP Temp Segment Read641927042645
12cR1-12cR2OLAP Temp Segments643547622716
12cR1-12cR2OLAP Unique Key Attribute Limit643812252850
11gR2-12cR2OS CPU Qt wait time1576270482
9i-12cR2OTC commit optimization attempts1282480822770
9i-12cR2OTC commit optimization failure - setup1283633344886
9i-12cR2OTC commit optimization hits1284064864054
8i-12cR2PX local messages recv'd321437798390
8i-12cR2PX local messages sent32506655048
8i-12cR2PX remote messages recv'd322537140420
8i-12cR2PX remote messages sent322567415317
8i-12cR2Parallel operations downgraded 1 to 25 pct323721245209
8i-12cR2Parallel operations downgraded 25 to 50 pct323330456527
8i-12cR2Parallel operations downgraded 50 to 75 pct323281923117
8i-12cR2Parallel operations downgraded 75 to 99 pct32322858058
8i-12cR2Parallel operations downgraded to serial324286011915
8i-12cR2Parallel operations not downgraded322410168744
12cR1-12cR2Requests to/from client13982115148
10gR2-12cR2RowCR - resume1282583359573
9i-12cR2RowCR - row contention1281175104080
9i-12cR2RowCR attempts1282297882326
9i-12cR2RowCR hits1283455911385
12cR2-12cR2SCN increments due to another database1281695580596
10gR2-12cR2SMON posted for dropping temp segment1283600495721
10gR2-12cR2SMON posted for instance recovery1284003178738
10gR2-10gR2SMON posted for supplemental logging cleanup1281356155743
10gR2-12cR2SMON posted for txn recovery for other instances1281263842513
10gR2-12cR2SMON posted for undo segment recovery1282117898593
10gR2-12cR2SMON posted for undo segment shrink128579492169
8i-12cR2SQL*Net roundtrips to/from client1159846526
8i-12cR2SQL*Net roundtrips to/from dblink12420448902
12cR1-12cR2SecureFiles Copy from DBFS Link1283313150606
12cR1-12cR2SecureFiles DBFS Link Operations128408804124
12cR1-12cR2SecureFiles DBFS Link Overwrites1283546571658
12cR1-12cR2SecureFiles DBFS Link streaming reads1282291010287
12cR1-12cR2SecureFiles Get DBFS Link Reference1283776855272
12cR1-12cR2SecureFiles Implicit Copy from DBFS Link1282864160252
12cR1-12cR2SecureFiles Move to DBFS Link1282159528439
12cR1-12cR2SecureFiles Put DBFS Link Reference1281020980477
12cR1-12cR2Streaming No-Stall Reap22378677367
12cR1-12cR2Streaming Stall Reap23489516369
11gR2-12cR2TBS Extension: bytes extended12820854933
11gR1-12cR2TBS Extension: files extended12887307875
11gR1-12cR2TBS Extension: tasks created1281488217152
11gR1-12cR2TBS Extension: tasks executed1281936615790
8i-10gR1Unnecesary process cleanup for SCN batching321207572951
12cR2-12cR2Workload Capture: PL/SQL dbtime13679472207
12cR2-12cR2Workload Capture: PL/SQL subcall size of recording1205580667
12cR2-12cR2Workload Capture: PL/SQL user calls1201766284
12cR2-12cR2Workload Capture: PL/SQL user subcalls12366239577
10gR2-12cR2Workload Capture: dbtime13533966785
10gR2-12cR2Workload Capture: errors11278172735
10gR2-12cR2Workload Capture: size (in bytes) of recording12146126248
10gR2-12cR2Workload Capture: unreplayable user calls13283547595
10gR2-12cR2Workload Capture: unsupported user calls12224534227
10gR2-12cR2Workload Capture: user calls11228651202
10gR2-12cR2Workload Capture: user calls flushed12236307043
10gR2-12cR2Workload Capture: user logins11296083012
10gR2-12cR2Workload Capture: user txns13034767909
12cR2-12cR2Workload Replay: PL/SQL dbtime13655931077
12cR2-12cR2Workload Replay: PL/SQL user calls1601400516
12cR2-12cR2Workload Replay: PL/SQL user subcalls11580770612
11gR1-12cR2Workload Replay: dbtime1443726121
11gR1-12cR2Workload Replay: deadlocks resolved12446501167
11gR1-12cR2Workload Replay: network time12824611432
11gR1-12cR2Workload Replay: think time14246044927
11gR1-12cR2Workload Replay: time gain1849876091
11gR1-12cR2Workload Replay: time loss12223483653
11gR1-12cR2Workload Replay: user calls1626148611
9i-12cR2active txn count during cleanout1283378035478
10gR1-12cR2application wait time11099569955
10gR2-12cR2auto extends on undo tablespace1283140365462
8i-12cR2background checkpoints completed82450922463
8i-12cR2background checkpoints started83048007007
8i-12cR2background timeouts128961017212
12cR2-12cR2backup compressed data written locally12313665365
12cR2-12cR2backup compressed data written remotely12395089680
12cR2-12cR2backup data compressed locally1282823453
12cR2-12cR2backup data compressed remotely14225505555
12cR2-12cR2backup piece local processing time13500314089
12cR2-12cR2backup piece remote processing time13223073610
12cR2-12cR2backup pieces compressed locally11331983628
12cR2-12cR2backup pieces compressed remotely13039408077
12cR2-12cR2blocks cleaned out using minact1282560617234
12cR1-12cR2blocks decrypted8559990478
12cR1-12cR2blocks encrypted8584993340
8i-12cR2branch node splits128399027615
8i-12cR2buffer is not pinned count722670431739
8i-12cR2buffer is pinned count721300470380
8i-12cR2bytes received via SQL*Net from client1161936656
8i-12cR2bytes received via SQL*Net from dblink11983609624
8i-12cR2bytes sent via SQL*Net to client12967415760
8i-12cR2bytes sent via SQL*Net to dblink11622773540
11gR1-12cR2bytes via SQL*Net vector from client12635744375
11gR1-12cR2bytes via SQL*Net vector from dblink13412995477
11gR1-12cR2bytes via SQL*Net vector to client1763712542
11gR1-12cR2bytes via SQL*Net vector to dblink1242642371
8i-12cR2calls to get snapshot scn: kcmgss323128650623
8i-12cR2calls to kcmgas1284072914524
8i-12cR2calls to kcmgcs1282775936802
8i-12cR2calls to kcmgrs1284210206824
11gR2-12cR1cell CUs processed for compressed641206883245
11gR2-12cR1cell CUs processed for uncompressed6494451592
11gR2-12cR1cell CUs sent compressed642900571431
11gR2-12cR1cell CUs sent head piece643911874465
11gR2-12cR1cell CUs sent uncompressed644129223001
11gR2-12cR2cell IO uncompressed bytes641129546621
12cR2-12cR2cell XT granule IO bytes saved by storage index1283238760850
12cR2-12cR2cell XT granule bytes requested for predicate offload1283244007383
12cR2-12cR2cell XT granule predicate offload retries128352394726
12cR2-12cR2cell XT granules requested for predicate offload1282430620424
11gR1-12cR2cell blocks helped by commit cache642220928368
11gR1-12cR2cell blocks helped by minscn optimization64721268882
12cR2-12cR2cell blocks pivoted64645412450
11gR1-12cR2cell blocks processed by cache layer1281264058236
11gR1-12cR2cell blocks processed by data layer128250025093
11gR1-12cR2cell blocks processed by index layer128412699774
11gR1-12cR2cell blocks processed by txn layer1283280964634
12cR2-12cR2cell blocks sent642672021367
11gR1-11gR2cell blocks skipped due to chained rows641370215149
12cR2-12cR2cell chained row pieces fetched641626476671
12cR2-12cR2cell chained rows processed643544768070
12cR2-12cR2cell chained rows rejected641383989782
12cR2-12cR2cell chained rows skipped64936433864
11gR1-12cR2cell commit cache queries641111035140
12cR2-12cR2cell filtered blocks failed block check1281588870839
11gR2-12cR2cell flash cache read hits82923827453
12cR2-12cR2cell flash cache read hits for controlfile reads81348240986
12cR2-12cR2cell flash cache read hits for smart IO81258600030
11gR2-12cR2cell index scans643427136437
12cR2-12cR2cell interconnect bytes returned by XT smart scan1281455843511
12cR2-12cR2cell logical write IO requests14025232521
12cR2-12cR2cell logical write IO requests eligible for offload12775643079
12cR2-12cR2cell num block IOs due to a file instant restore in progress64602499525
12cR2-12cR2cell num bytes in block IO during predicate offload642361529515
12cR2-12cR2cell num bytes in passthru due to quarantine81057071675
12cR2-12cR2cell num bytes in passthru during predicate offload64699537822
12cR1-12cR2cell num bytes of IO reissued due to relocation643754903472
12cR1-12cR2cell num fast response sessions643241490781
12cR1-12cR2cell num fast response sessions continuing to smart scan643693748667
12cR2-12cR2cell num map elem cancellation1284095160207
11gR2-12cR2cell num smart IO sessions in rdbms block IO due to big payload64256540314
12cR1-12cR2cell num smart IO sessions in rdbms block IO due to no cell mem641205851429
12cR1-12cR2cell num smart IO sessions in rdbms block IO due to open fail641611570469
11gR2-12cR2cell num smart IO sessions in rdbms block IO due to user64753394329
11gR2-12cR2cell num smart IO sessions using passthru mode due to cellsrv64636424788
11gR2-12cR2cell num smart IO sessions using passthru mode due to timezone641573034705
11gR2-12cR2cell num smart IO sessions using passthru mode due to user641852329605
11gR2-12cR2cell num smart file creation sessions using rdbms block IO mode642647020488
12cR1-12cR2cell num smartio automem buffer allocation attempts64145506540
12cR1-12cR2cell num smartio automem buffer allocation failures64727055891
12cR1-12cR2cell num smartio permanent cell failures64299072157
12cR1-12cR2cell num smartio transient cell failures642276204331
12cR2-12cR2cell overwrites in flash cache82368027758
12cR2-12cR2cell partial writes in flash cache81870362912
11gR1-12cR2cell physical IO bytes eligible for predicate offload643064960568
12cR2-12cR2cell physical IO bytes eligible for smart IOs83443470089
12cR2-12cR2cell physical IO bytes saved by columnar cache81421244249
11gR2-12cR2cell physical IO bytes saved by storage index82245892488
11gR1-12cR2cell physical IO bytes saved during optimized RMAN file restore641445035119
11gR1-12cR2cell physical IO bytes saved during optimized file creation64372652547
12cR1-12cR2cell physical IO bytes sent directly to DB node to balance CPU643163467121
11gR1-12cR2cell physical IO interconnect bytes642957355214
11gR2-12cR2cell physical IO interconnect bytes returned by smart scan643279818867
12cR2-12cR2cell physical write IO bytes eligible for offload11970500930
12cR2-12cR2cell physical write IO host network bytes written during offloa13560981718
12cR2-12cR2cell physical write bytes saved by smart file initialization82935092621
12cR2-12cR2cell scan CUs pcode aggregation pushdown1283147495929
12cR2-12cR2cell scan CUs pcode pred evaled1283065145583
12cR2-12cR2cell scan CUs pcode pred evaled using rowsets1281130304094
12cR2-12cR2cell scan CUs pcode selective done1281896566797
12cR2-12cR2cell scan rows pcode aggregated128141492054
11gR1-12cR2cell scans641117153474
11gR2-11gR2cell session smart scan efficiency64173384451
11gR1-12cR2cell simulated physical IO bytes eligible for predicate offload1923792766660
11gR1-12cR2cell simulated physical IO bytes returned by predicate offload1922052798177
11gR2-11gR2cell simulated session smart scan efficiency1923381744771
11gR2-12cR2cell smart IO session cache hard misses643263815706
11gR2-12cR2cell smart IO session cache hits64398350085
11gR2-12cR2cell smart IO session cache hwm643006068088
11gR2-12cR2cell smart IO session cache lookups6422520694
11gR2-12cR2cell smart IO session cache soft misses642892599795
12cR1-12cR2cell statistics spare1643007761105
12cR1-12cR2cell statistics spare2643735886817
12cR1-12cR2cell statistics spare3641761517293
12cR1-12cR2cell statistics spare4643075070261
12cR1-12cR2cell statistics spare564339741456
12cR1-12cR2cell statistics spare6641614816238
11gR1-12cR2cell transactions found in commit cache64266637754
12cR2-12cR2cell writes to flash cache8337656778
12cR2-12cR2cellmemory IM load CUs for capacity1283147123188
12cR2-12cR2cellmemory IM load CUs for query128357990614
12cR2-12cR2cellmemory IM load CUs no memcompress1283456953324
12cR2-12cR2cellmemory IM scan CUs processed for capacity1283332413411
12cR2-12cR2cellmemory IM scan CUs processed for query1283010803913
12cR2-12cR2cellmemory IM scan CUs processed no memcompress1283292384892
12cR2-12cR2cellmemory IM scan CUs rejected for capacity1282823957692
12cR2-12cR2cellmemory IM scan CUs rejected for query1283839586365
12cR2-12cR2cellmemory IM scan CUs rejected no memcompress1283097142781
12cR2-12cR2cellmemory IM scan stat 11282818220566
12cR2-12cR2cellmemory IM scan stat 21281360995708
12cR2-12cR2cellmemory IM scan stat 31282845748910
12cR2-12cR2cellmemory IM scan stat 41281006674745
12cR2-12cR2cellmemory IM scan stat 51284091869325
12cR1-12cR1chained rows processed by cell641170574055
12cR1-12cR1chained rows rejected by cell64959925020
12cR1-12cR1chained rows skipped by cell643337164797
8i-12cR2change write time82838938797
12cR1-12cR2checkpoint clones created for ADG recovery8128034341
9i-12cR2cleanout - number of ktugct calls1282577316246
8i-12cR2cleanouts and rollbacks - consistent read gets1281083903169
8i-12cR2cleanouts only - consistent read gets1282904875805
8i-12cR2cluster key scan block gets642006808371
8i-12cR2cluster key scans643566804345
10gR1-12cR2cluster wait time12432034337
8i-12cR2cold recycle reads8657271764
10gR2-12cR2commit batch performed11391516579
10gR2-12cR2commit batch requested12338940602
10gR2-12cR2commit batch/immediate performed13711642721
10gR2-12cR2commit batch/immediate requested1640321576
8i-12cR2commit cleanout failures: block lost8781179189
8i-12cR2commit cleanout failures: buffer being written81626141486
8i-12cR2commit cleanout failures: callback failure83086716748
8i-12cR2commit cleanout failures: cannot pin8176423721
12cR2-12cR2commit cleanout failures: delayed log82326690827
12cR2-12cR2commit cleanout failures: flashback8733836872
8i-12cR2commit cleanout failures: hot backup in progress82500023621
8i-12cR2commit cleanout failures: write disabled82063165199
8i-12cR2commit cleanouts82934869719
8i-12cR2commit cleanouts successfully completed83554314084
10gR2-12cR2commit immediate performed13494177237
10gR2-12cR2commit immediate requested1796663742
10gR2-12cR2commit nowait performed1485928497
10gR2-12cR2commit nowait requested13697788123
9i-12cR2commit txn count during cleanout1281405359431
10gR2-12cR2commit wait performed18047752
10gR2-12cR2commit wait requested12843300285
10gR2-12cR2commit wait/nowait performed11541239326
10gR2-12cR2commit wait/nowait requested13800399491
10gR1-12cR2concurrency wait time13868577743
8i-12cR2consistent changes83876379665
8i-12cR2consistent gets84162191256
9i-11gR2consistent gets - examination81701530557
10gR1-12cR2consistent gets direct8420374750
12cR1-12cR2consistent gets examination81966540185
12cR1-12cR2consistent gets examination (fastpath)81990445227
10gR1-12cR2consistent gets from cache82839918855
11gR1-11gR2consistent gets from cache (fastpath)82173751438
12cR1-12cR2consistent gets pin81168838199
12cR1-12cR2consistent gets pin (fastpath)82910712465
8i-12cR2current blocks converted for CR83142330676
8i-12cR2cursor authentications1284069981174
12cR2-12cR2cursor reload failures64555125076
12cR1-12cR1cvmap unavailable23849353583
8i-12cR2data blocks consistent reads - undo records applied1282915445793
12cR1-12cR2data warehousing cooling action82905230597
12cR1-12cR2data warehousing evicted objects81827708704
12cR1-12cR2data warehousing evicted objects - cooling81769197766
12cR1-12cR2data warehousing evicted objects - replace8547725926
12cR2-12cR2data warehousing scanned blocks84236314459
12cR2-12cR2data warehousing scanned blocks - disk81303746952
12cR2-12cR2data warehousing scanned blocks - flash83145439762
12cR2-12cR2data warehousing scanned blocks - memory8401834628
12cR2-12cR2data warehousing scanned blocks - offload83530138688
12cR1-12cR1data warehousing scanned chunks83880771368
12cR1-12cR1data warehousing scanned chunks - disk81684884558
12cR1-12cR1data warehousing scanned chunks - flash83811273611
12cR1-12cR1data warehousing scanned chunks - memory81765983694
12cR1-12cR2data warehousing scanned objects8247471814
8i-12cR2db block changes8916801489
8i-12cR2db block gets81480709069
10gR1-12cR2db block gets direct895128520
10gR1-12cR2db block gets from cache84017839461
11gR1-12cR2db block gets from cache (fastpath)8954629132
11gR1-12cR2db corrupt blocks detected81064154723
11gR1-12cR2db corrupt blocks recovered83806790612
8i-12cR2deferred (CURRENT) block cleanout applications1283388736327
9i-12cR2deferred CUR cleanouts (index blocks)1283827443394
8i-12cR2dirty buffers inspected81344569897
10gR1-12cR2doubling up with imu segment128723921798
12cR2-12cR2dram clean buffers available and above threshold83375698921
12cR2-12cR2dram clean buffers available and is requested84106617744
10gR2-12cR2drop segment calls in space pressure1281500291109
8i-12cR2enqueue conversions457745673
8i-12cR2enqueue deadlocks4472183780
8i-12cR2enqueue releases42553146675
8i-12cR2enqueue requests42440542518
8i-12cR2enqueue timeouts42425496215
8i-12cR2enqueue waits42307006529
12cR2-12cR2error count cleared by cell642551769229
8i-12cR2exchange deadlocks814632483
8i-12cR2execute count642453370665
9i-12cR2failed probes on index block reclamation1282687444660
12cR1-12cR2fastpath consistent get quota limit40560973176
12cR1-12cR2fbda woken up128138331311
11gR2-12cR2file io service time13999659096
11gR2-12cR2file io wait time11292757183
11gR2-12cR2flash cache eviction: aged out83307935113
11gR2-12cR2flash cache eviction: buffer pinned83134415242
11gR2-12cR2flash cache eviction: invalidated83647825193
11gR2-12cR2flash cache insert skip: DBWR overloaded83504558414
11gR2-12cR2flash cache insert skip: corrupt82560222967
11gR2-12cR2flash cache insert skip: exists83291155557
11gR2-12cR2flash cache insert skip: modification84128442906
11gR2-12cR2flash cache insert skip: not current81693383402
11gR2-12cR2flash cache insert skip: not useful83620030478
11gR2-12cR2flash cache inserts82941771786
12cR1-12cR2flashback cache read optimizations for block new8756677055
12cR1-12cR2flashback direct read optimizations for block new81277968430
11gR2-12cR2flashback log write bytes2973553265
10gR1-12cR2flashback log writes23123176560
12cR1-12cR2flashback securefile cache read optimizations for block new8955255216
12cR1-12cR2flashback securefile direct read optimizations for block new8963322245
12cR1-12cR2foreground propagated tracked transactions1282081753160
10gR1-12cR2frame signature mismatch64959148951
8i-12cR2free buffer inspected8941676439
8i-12cR2free buffer requested83411924934
12cR2-12cR2gc BPS array full40400702646
10gR1-12cR2gc CPU used by this session404093034494
12cR2-12cR2gc IM blocks invalidated401829178228
12cR2-12cR2gc IM expands403039832063
12cR2-12cR2gc IM grants402777375100
12cR2-12cR2gc IM shrinks404118357580
11gR2-12cR2gc blocks compressed403506108623
10gR1-12cR2gc blocks corrupt402288508531
10gR1-12cR2gc blocks lost40500461751
10gR1-12cR2gc claim blocks lost401966230523
12cR1-12cR2gc cleanout applied401976898865
12cR1-12cR2gc cleanout no space40522936568
12cR1-12cR2gc cleanout saved404119317321
12cR2-12cR2gc cluster flash cache reads failure402550397799
12cR2-12cR2gc cluster flash cache reads received402647107641
12cR2-12cR2gc cluster flash cache reads served401720798763
12cR2-12cR2gc cluster flash cache received read time403856584072
12cR2-12cR2gc cr anti locks created402643421570
12cR2-12cR2gc cr anti locks expanded403766445441
12cR2-12cR2gc cr anti locks shrunk402687291967
10gR1-12cR2gc cr block build time40467525985
10gR1-12cR2gc cr block flush time40552470873
11gR2-11gR2gc cr block read wait time404285841541
10gR1-12cR2gc cr block receive time401759426133
10gR1-12cR1gc cr block send time402395315974
12cR2-12cR2gc cr blocks built402529642460
12cR2-12cR2gc cr blocks flushed403373456150
10gR1-12cR2gc cr blocks received402877738702
12cR1-12cR2gc cr blocks received with BPS403270643842
10gR1-12cR2gc cr blocks served401075941831
12cR1-12cR2gc cr blocks served with BPS401600220233
12cR2-12cR2gc cr bypass requests40344376121
12cR2-12cR2gc cr multiblock grant time403067278120
12cR2-12cR2gc cr multiblock grants received401735278367
10gR1-12cR2gc current block flush time404091964965
10gR1-12cR2gc current block pin time40324533635
10gR1-12cR2gc current block receive time401388758753
10gR1-12cR1gc current block send time402750158241
12cR2-12cR2gc current blocks flushed403556808008
12cR2-12cR2gc current blocks pinned403694253813
10gR1-12cR2gc current blocks received40326482564
12cR1-12cR2gc current blocks received with BPS40301773697
10gR1-12cR2gc current blocks served4042062110
12cR1-12cR2gc current blocks served with BPS401004484383
12cR2-12cR2gc flash cache reads served40276717689
12cR2-12cR2gc flash cache served read time402407022947
12cR2-12cR2gc flashback wait402265811729
12cR1-12cR1gc force cr disk read401058102273
12cR2-12cR2gc force cr read cr402082907652
12cR2-12cR2gc force cr read current401419283682
12cR2-12cR2gc index split slot collisions4052638072
12cR2-12cR2gc index split too many segments40518003134
12cR2-12cR2gc index split too many slots403416616208
12cR2-12cR2gc index split wait timeouts40449007442
12cR1-12cR2gc ka grant receive time403746639269
12cR1-12cR2gc ka grants received40912334553
11gR2-12cR2gc kbytes saved401823613081
11gR2-12cR2gc kbytes sent403351517689
10gR2-12cR2gc local grants403656029643
12cR2-12cR2gc merge pi bg401671021813
12cR2-12cR2gc merge pi fg404172504930
12cR2-12cR2gc read time waited401590923267
12cR1-12cR2gc read wait failures40141128223
12cR1-12cR1gc read wait time403266024004
12cR1-12cR2gc read wait timeouts401278481093
12cR1-12cR2gc read waits4060245462
11gR1-12cR2gc reader bypass grants403930867231
12cR1-12cR2gc reader bypass waits401120557156
10gR2-12cR2gc remote grants401406613639
12cR2-12cR2gc send failures40603980360
12cR2-12cR2gc status messages received402073426637
12cR2-12cR2gc status messages sent403754099578
12cR2-12cR2gcs affinity lock failures1284130974900
12cR2-12cR2gcs affinity lock grants1282532277440
12cR2-12cR2gcs anti-locks created1281151941947
9i-12cR2gcs messages sent322765451804
12cR2-12cR2gcs read-mostly lock failures1281286343901
12cR2-12cR2gcs read-mostly lock grants1283797682824
9i-12cR2ges messages sent321145425433
8i-9iglobal cache blocks corrupt40
9i-9iglobal cache blocks lost40
9i-9iglobal cache claim blocks lost40
8i-9iglobal cache convert time40
8i-9iglobal cache convert timeouts40
8i-9iglobal cache converts40
8i-9iglobal cache cr block build time40
8i-9iglobal cache cr block flush time40
8i-9iglobal cache cr block receive time40
8i-9iglobal cache cr block send time40
8i-9iglobal cache cr blocks received40
8i-9iglobal cache cr blocks served40
8i-8iglobal cache cr requests blocked40
8i-8iglobal cache cr timeouts40
9i-9iglobal cache current block flush time40
9i-9iglobal cache current block pin time40
9i-9iglobal cache current block receive time40
9i-9iglobal cache current block send time40
9i-9iglobal cache current blocks received40
9i-9iglobal cache current blocks served40
8i-9iglobal cache defers40
8i-9iglobal cache freelist waits40
8i-9iglobal cache get time40
8i-9iglobal cache gets40
8i-9iglobal cache prepare failures40
8i-8iglobal cache read buffer block build time40
8i-8iglobal cache read buffer block receive time40
8i-8iglobal cache read buffer block send time40
8i-8iglobal cache read buffer block timeouts40
8i-8iglobal cache read buffer blocks received40
8i-8iglobal cache read buffer blocks served40
8i-8iglobal cache read buffer lock timeouts40
9i-9iglobal cache skip prepare failures40
10gR1-12cR2global enqueue CPU used by this session323469911798
10gR1-12cR2global enqueue get time323744090840
10gR1-12cR2global enqueue gets async322892637759
10gR1-12cR2global enqueue gets sync321338475854
10gR1-12cR2global enqueue releases321516404026
8i-9iglobal lock async converts32
8i-9iglobal lock async gets32
8i-9iglobal lock convert time32
8i-9iglobal lock get time32
8i-9iglobal lock releases32
8i-9iglobal lock sync converts32
8i-9iglobal lock sync gets32
10gR2-12cR2global undo segment hints helped1281791494885
10gR2-12cR2global undo segment hints were stale1283309048233
10gR1-12cR2heap block compress642326757257
8i-12cR2hot buffers moved to head of LRU82030212224
8i-12cR2immediate (CR) block cleanout applications1283318186802
8i-12cR2immediate (CURRENT) block cleanout applications1282668233561
9i-12cR2immediate CR cleanouts (index blocks)12879013953
12cR1-12cR2in call idle wait time13723717570
12cR2-12cR2index cmph cu、 uncomp sentinels1283380039564
12cR2-12cR2index cmph dm、 cu lock expand1283996407476
12cR2-12cR2index cmph dm、 cu migrate row128413154110
12cR2-12cR2index cmph dm、 insert unpurge CU row12854675999
12cR2-12cR2index cmph dm、 purge dummy CU1283226283126
12cR2-12cR2index cmph dm、 split for cu lock expand1281326196981
12cR2-12cR2index cmph dm、 split for cu migrate row1282801497323
12cR1-12cR1index cmph gencu、 uncomp sentinals1283972713215
12cR1-12cR2index cmph ld、 CU fit128312995821
12cR1-12cR2index cmph ld、 CU fit、 add rows1283074245919
12cR1-12cR2index cmph ld、 CU negative comp128747638515
12cR1-12cR2index cmph ld、 CU over-est1283287792462
12cR1-12cR2index cmph ld、 CU under-est1283487869306
12cR2-12cR2index cmph ld、 infinite loop1283643455270
12cR1-12cR2index cmph ld、 lf blks flushed1283933169485
12cR1-12cR2index cmph ld、 lf blks w/ und CU128500852118
12cR1-12cR2index cmph ld、 lf blks w/o CU1282058955770
12cR1-12cR2index cmph ld、 lf blks w/o unc r1281877031790
12cR1-12cR2index cmph ld、 retry in over-est1282794871331
12cR1-12cR2index cmph ld、 rows compressed1282461980696
12cR1-12cR2index cmph ld、 rows uncompressed1281487477542
12cR2-12cR2index cmph sc、 ffs decomp buffers1283764562737
12cR2-12cR2index cmph sc、 ffs decomp buffers released and found valid1283841851165
12cR2-12cR2index cmph sc、 ffs decomp buffers rows avail1283898736337
12cR2-12cR2index cmph sc、 ffs decomp buffers rows used1281026251726
12cR2-12cR2index cmph sc、 ffs decomp failures1284052448893
12cR2-12cR2index cmph sp、 leaf 90_10 failed1281365949434
12cR2-12cR2index cmph sp、 leaf norecomp limit1283617407403
12cR2-12cR2index cmph sp、 leaf norecomp negcomp128577319720
12cR2-12cR2index cmph sp、 leaf norecomp nospace128129533673
12cR2-12cR2index cmph sp、 leaf norecomp notry128245781488
12cR2-12cR2index cmph sp、 leaf norecomp oversize1284043311150
12cR2-12cR2index cmph sp、 leaf norecomp zerocur128962228885
12cR2-12cR2index cmph sp、 leaf recomp fewer ucs1284097763078
12cR2-12cR2index cmph sp、 leaf recomp zero ucs128523426221
12cR2-12cR2index cmph sp、 leaf recompress1282383430334
12cR2-12cR2index cmph sp、 recomp buf01283752126430
12cR2-12cR2index cmph sp、 recomp buf1128522817910
12cR2-12cR2index cmph sp、 recomp buf2128695785276
12cR2-12cR2index cmph sp、 recomp buf31281676841818
12cR2-12cR2index cmph sp、 recomp buf41283440255673
12cR2-12cR2index cmph sp、 recomp buf51283968419544
12cR2-12cR2index cmph sp、 recomp localmem012851260542
12cR2-12cR2index cmph sp、 recomp localmem11282731753004
12cR2-12cR2index cmph sp、 recomp localmem21283365820210
12cR2-12cR2index cmph sp、 recomp localmem31283360346532
12cR2-12cR2index cmph sp、 recomp localmem41283532280856
12cR2-12cR2index cmph sp、 recomp localmem51283132673741
12cR2-12cR2index cmpl co、 prefix mismatch1282802719175
12cR2-12cR2index cmpl ro、 blocks not compressed128949590645
12cR2-12cR2index cmpl ro、 prefix change at block128596539847
12cR2-12cR2index cmpl ro、 prefix no change at block128338819647
12cR2-12cR2index cmpl ro、 reorg avoid load new block128570434575
12cR2-12cR2index cmpl ro、 reorg avoid split1283221347544
12cR1-12cR1index compression (ADVANCED HIGH) leaf block 90_10 splits faile1283445701516
12cR1-12cR1index compression (ADVANCED HIGH) leaf block splits avoided128228768206
12cR1-12cR1index compression (ADVANCED LOW) blocks not compressed1283703793538
12cR1-12cR1index compression (ADVANCED LOW) prefix change at block1281089998764
12cR1-12cR1index compression (ADVANCED LOW) prefix no change at block1282879842113
12cR1-12cR1index compression (ADVANCED LOW) reorg avoid split1282501129012
9i-12cR2index crx upgrade (found)641444049043
9i-12cR2index crx upgrade (positioned)642632952759
9i-12cR2index crx upgrade (prefetch)641907142657
8i-12cR2index fast full scans (direct read)641635662180
8i-12cR2index fast full scans (full)6412081473
8i-12cR2index fast full scans (rowid ranges)641555464060
9i-12cR2index fetch by key1282808364230
11gR2-12cR2index reclamation/extension switch128469799102
9i-12cR2index scans kdiixs11283589793292
12cR2-12cR2index split cancel op set1281820332445
12cR2-12cR2index split cancel wait clean1282192759271
12cR2-12cR2index split cancel wait noclean1283708470706
8i-10gR2instance recovery database freeze count323674920298
10gR1-12cR2java call heap collected bytes13585877838
10gR1-12cR2java call heap collected count12510746206
10gR1-12cR2java call heap gc count12284697213
10gR1-12cR2java call heap live object count1632577394
10gR1-12cR2java call heap live object count max12964139762
10gR1-12cR2java call heap live size12431389341
10gR1-12cR2java call heap live size max11298432410
10gR1-12cR2java call heap object count13472185722
10gR1-12cR2java call heap object count max11862536587
10gR1-12cR2java call heap total size11649812842
10gR1-12cR2java call heap total size max1580075922
10gR1-12cR2java call heap used size1187277223
10gR1-12cR2java call heap used size max1625960724
10gR1-12cR2java session heap collected bytes13976434298
10gR1-12cR2java session heap collected count13795934475
10gR1-12cR2java session heap gc count13363147808
10gR1-12cR2java session heap live object count1225051972
10gR1-12cR2java session heap live object count max13755633366
10gR1-12cR2java session heap live size12257986540
10gR1-12cR2java session heap live size max11960804148
10gR1-12cR2java session heap object count14072938679
10gR1-12cR2java session heap object count max1469647992
10gR1-12cR2java session heap used size11661140639
10gR1-12cR2java session heap used size max11726629032
12cR1-12cR2ka grants received322310418695
12cR2-12cR2ka local message waits324132238737
12cR2-12cR2ka local messages received32376885234
12cR1-12cR2ka messages sent324222258831
12cR2-12cR2ka wait calls attempted32792148509
12cR2-12cR2ka wait calls for invalid kga324009665418
12cR2-12cR2ka wait calls other322615088794
12cR2-12cR2ka wait calls suppressed322119284616
12cR2-12cR2ka wait due to timeout322581979821
12cR2-12cR2ka wait due to trigger322390630999
8i-10gR1kcmccs called get current scn32348415325
8i-8ikcmgss read scn without going to DLM32
9i-10gR1kcmgss read scn without going to GES322618312705
8i-10gR1kcmgss waited for batching322524438629
12cR2-12cR2key vector CU codes processed641858071616
12cR2-12cR2key vector CUs filtered643010306214
12cR2-12cR2key vector CUs min/max filtered64422801927
12cR2-12cR2key vector CUs processed using cached packed numbers641187458158
12cR2-12cR2key vector cas merge abort641700664493
12cR2-12cR2key vector cas merge locking retrial643068660196
12cR2-12cR2key vector cas merge operations642077527660
12cR2-12cR2key vector dgk batch parcels643759097739
12cR2-12cR2key vector dgk range parcels641233669540
12cR2-12cR2key vector filtered on cell643846940000
12cR2-12cR2key vector non cas merge operations644047236676
12cR2-12cR2key vector probed on cell642486464991
12cR2-12cR2key vector queries647667259
12cR2-12cR2key vector rows filtered643175190356
12cR2-12cR2key vector rows processed by code642277275530
12cR2-12cR2key vector rows processed by value643327007917
12cR2-12cR2key vector serializations for cell643383477670
12cR2-12cR2key vector serializations in lite mode for cell641309246126
12cR2-12cR2key vector stubs created641788856211
12cR2-12cR2key vectors bypassed642778641285
12cR2-12cR2key vectors created64617787087
12cR2-12cR2key vectors created (2 byte wide)643564717623
12cR2-12cR2key vectors created (4 byte wide)643041613220
12cR2-12cR2key vectors created (bit wide)641069931112
12cR2-12cR2key vectors created (byte wide)643144997025
12cR2-12cR2key vectors created (doubly indirect layout)642305423837
12cR2-12cR2key vectors created (hash layout)643179008572
12cR2-12cR2key vectors created (indirect layout)641787972551
12cR2-12cR2key vectors created (nibble wide)643029331844
12cR2-12cR2key vectors created (offset layout)643385277635
12cR2-12cR2key vectors created (simple layout)64262027123
12cR2-12cR2key vectors sent to cell641240750815
12cR2-12cR2key vectors sent to cell in lite mode due to layout643431598359
12cR2-12cR2key vectors sent to cell in lite mode due to quota643938196824
12cR1-12cR2large tracked transactions1281755433832
9i-12cR2leaf node 90-10 splits1281285138251
8i-12cR2leaf node splits1281417124053
10gR2-12cR2lob reads83626914479
10gR2-12cR2lob writes82682192071
10gR2-12cR2lob writes unaligned84224694283
10gR2-12cR2local undo segment hints helped1281047863356
10gR2-12cR2local undo segment hints were stale1282070200837
12cR1-12cR2logical read bytes from cache81994463594
8i-12cR2logons cumulative12666645286
8i-12cR2logons current13080465522
11gR2-12cR2max cf enq hold time41032301310
8i-12cR2messages received1281396153242
8i-12cR2messages sent1282486045308
11gR2-12cR2min active SCN optimization applied on CR1282847404927
11gR1-11gR1min active SCN optimization applied to CR1282155481870
8i-11gR2native hash arithmetic execute64321852432
8i-11gR2native hash arithmetic fail641937851790
8i-8inext scns gotten without going to DLM32
9i-10gR1next scns gotten without going to GES324016878853
8i-12cR2no buffer to keep pinned count723528454686
8i-12cR2no work - consistent read gets1282814375799
11gR2-12cR2non-idle wait count145066233
11gR2-12cR2non-idle wait time12498191658
9i-10gR1number of auto extends on undo tablespace1283698879664
9i-10gR1number of drop segment calls under space pressure1283288741566
9i-12cR1number of map misses83618703100
9i-12cR1number of map operations8337177656
10gR1-10gR1number of steps of tune down retentions in space pressure128194322784
10gR1-10gR1number of times space was found by tune down128190625295
10gR1-10gR1number of times space was not found by tune down128583360797
10gR1-10gR1number of tune down retentions under space pressure128286876046
8i-12cR2opened cursors cumulative185052502
8i-12cR2opened cursors current12301954928
8i-9iopens of replaced files8
8i-9iopens requiring cache replacement8
11gR1-12cR2parse count (describe)64469016317
9i-12cR2parse count (failures)641118776443
8i-12cR2parse count (hard)64143509059
8i-12cR2parse count (total)6463887964
8i-12cR2parse time cpu64206905303
8i-12cR2parse time elapsed641431595225
11gR1-11gR1physical IO disk bytes643277619920
10gR1-12cR2physical read IO requests8789768877
10gR2-12cR2physical read bytes8523531786
11gR2-12cR2physical read flash cache hits81672054092
12cR1-12cR2physical read partial requests8286702467
11gR2-12cR2physical read requests optimized82481818206
12cR2-12cR2physical read snap IO requests base84118200466
12cR2-12cR2physical read snap IO requests copy83453710105
12cR2-12cR2physical read snap IO requests no data81808643430
12cR2-12cR2physical read snap bytes base81958632267
12cR2-12cR2physical read snap bytes copy82778423151
10gR2-12cR2physical read total IO requests83343375620
10gR2-12cR2physical read total bytes82572010804
12cR1-12cR2physical read total bytes optimized82290009573
10gR2-12cR2physical read total multi block requests82007302071
8i-12cR2physical reads82263124246
10gR1-12cR2physical reads cache84171507801
12cR1-12cR2physical reads cache for securefile flashback block new82429466467
10gR1-12cR2physical reads cache prefetch8297908839
8i-12cR2physical reads direct82589616721
8i-12cR2physical reads direct (lob)82564935310
12cR1-12cR2physical reads direct for securefile flashback block new83121545084
10gR1-12cR2physical reads direct temporary tablespace82663793346
12cR2-12cR2physical reads for data transfer84191273642
10gR1-12cR2physical reads for flashback new8473165409
10gR1-12cR2physical reads prefetch warmup83102888545
10gR1-12cR2physical reads retry corrupt8531193461
10gR1-12cR2physical write IO requests82904164198
10gR2-12cR2physical write bytes83131337131
12cR1-12cR1physical write partial requests81535615968
12cR1-12cR1physical write request redirties84146911311
12cR1-12cR2physical write requests optimized82483607112
12cR2-12cR2physical write snap IO requests new allocations82241659730
10gR2-12cR2physical write total IO requests81315894329
10gR2-12cR2physical write total bytes82495644835
12cR1-12cR2physical write total bytes optimized84085960041
10gR2-12cR2physical write total multi block requests83540174003
8i-12cR2physical writes81190468109
8i-12cR2physical writes direct82699895516
8i-12cR2physical writes direct (lob)83308932835
10gR1-12cR2physical writes direct temporary tablespace8996415569
10gR1-12cR2physical writes from cache8163083034
8i-12cR2physical writes non checkpoint82602029796
8i-12cR2pinned buffers inspected8833456521
11gR2-12cR2pinned cursors current12771133180
9i-12cR2prefetch clients - 16k8792304463
9i-12cR2prefetch clients - 2k8396625644
9i-12cR2prefetch clients - 32k82351177679
9i-12cR2prefetch clients - 4k83252900252
9i-12cR2prefetch clients - 8k81402775714
9i-12cR2prefetch clients - default81612053064
9i-12cR2prefetch clients - keep8574469659
9i-12cR2prefetch clients - recycle84053781837
10gR1-12cR2prefetch warmup blocks aged out before use83250306695
10gR1-12cR2prefetch warmup blocks flushed out before use82218846789
8i-9iprefetched blocks8
8i-12cR2prefetched blocks aged out before use81457461390
8i-12cR2process last non-idle time1282049556447
8i-12cR2queries parallelized323315614405
10gR1-12cR2queue flush1283150060076
10gR1-12cR2queue ocp pages1283899522644
10gR1-12cR2queue position update1282568542507
10gR1-12cR2queue qno pages1282998782417
10gR1-12cR2queue single row1282713404457
10gR1-12cR2queue splits1281168925905
10gR1-12cR2queue update without cp update128528828405
12cR1-12cR2read-only violation count1935461917
12cR1-12cR1recieve buffer unavailable23480097050
8i-12cR2recovery array read time82996696667
8i-12cR2recovery array reads82617845348
11gR1-12cR2recovery block gets from cache83434735488
8i-12cR2recovery blocks read83327333035
11gR1-12cR2recovery blocks read for lost write detection82677324291
11gR1-12cR2recovery blocks skipped lost write checks8680578166
12cR2-12cR2recovery cvmap unavailable22564609481
12cR2-12cR2recovery local buffer freed22806729990
12cR2-12cR2recovery local buffer unavailable2973726422
12cR2-12cR2recovery logmerger catchup21314025271
12cR1-12cR2recovery marker22982845773
12cR2-12cR2recovery recieve buffer unavailable2614597403
12cR2-12cR2recovery remote buffer received2835002209
12cR2-12cR2recovery remote buffer sent2180498708
9i-12cR2recursive aborts on index block reclamation1283075437189
8i-12cR2recursive calls12656001462
8i-12cR2recursive cpu usage14009879262
11gR2-12cR2recursive system API invocations128728936273
12cR1-12cR2redo KB read2872961605
12cR1-12cR2redo KB read (memory)22883054278
12cR1-12cR2redo KB read (memory) for transport23933783006
12cR1-12cR2redo KB read for transport23093608311
11gR1-12cR2redo blocks checksummed by FG (exclusive)2352875884
11gR1-12cR2redo blocks checksummed by LGWR21917648704
10gR2-12cR2redo blocks read for recovery22679943069
8i-12cR2redo blocks written22391431605
12cR1-12cR2redo blocks written (group 0)22520028696
12cR1-12cR2redo blocks written (group 1)23244346714
12cR1-12cR2redo blocks written (group 2)21273391004
12cR1-12cR2redo blocks written (group 3)21050845280
12cR1-12cR2redo blocks written (group 4)22795831152
12cR1-12cR2redo blocks written (group 5)2615604096
12cR1-12cR2redo blocks written (group 6)2764128333
12cR1-12cR2redo blocks written (group 7)2435637049
8i-12cR2redo buffer allocation retries21446958922
8i-12cR2redo entries23488821837
11gR1-12cR2redo entries for lost write detection22194106845
11gR1-11gR2redo k-bytes read (memory)2399143205
11gR1-11gR2redo k-bytes read (memory) by LNS23857180019
11gR2-12cR2redo k-bytes read for recovery2359782962
11gR2-12cR2redo k-bytes read for terminal recovery22068376826
11gR1-11gR2redo k-bytes read total23114884375
11gR1-11gR2redo k-bytes read total by LNS21948686150
8i-12cR2redo log space requests21985754937
8i-12cR2redo log space wait time2252430928
8i-10gR2redo log switch interrupts2674283274
12cR2-12cR2redo non-durable records skipped342748956499
8i-12cR2redo ordering marks22104561012
8i-12cR2redo size21236385760
11gR1-12cR2redo size for direct writes2726277760
11gR1-12cR2redo size for lost write detection23835726666
10gR1-12cR2redo subscn max counts2449106517
12cR1-12cR2redo synch long waits1282758571193
12cR1-12cR2redo synch poll writes23841621897
12cR1-12cR2redo synch polls23455043432
8i-12cR2redo synch time84215815172
12cR1-12cR2redo synch time (usec)128957243500
12cR1-12cR2redo synch time overhead (usec)1283961087021
12cR1-12cR2redo synch time overhead count ( 2ms)1281771370497
12cR1-12cR2redo synch time overhead count ( 8ms)1282324186582
12cR1-12cR2redo synch time overhead count ( 32ms)1282882285036
12cR1-12cR2redo synch time overhead count (128ms)1281234629759
12cR1-12cR2redo synch time overhead count (inf)1282239006192
8i-12cR2redo synch writes81439995281
8i-12cR2redo wastage23462806146
12cR2-12cR2redo write active strands23016518124
11gR2-12cR2redo write broadcast ack count22144781638
11gR1-12cR2redo write broadcast ack time21201950653
12cR1-12cR2redo write broadcast lgwr post count24012338899
12cR2-12cR2redo write finish time1282589185385
12cR2-12cR2redo write gather time1283956079622
12cR1-12cR2redo write info find23584739253
12cR1-12cR2redo write info find fail2553778103
12cR2-12cR2redo write issue time1283898925317
12cR2-12cR2redo write schedule time1282569852492
12cR1-12cR2redo write size count ( 4KB)24206847440
12cR1-12cR2redo write size count ( 8KB)23604386338
12cR1-12cR2redo write size count ( 16KB)21937637258
12cR1-12cR2redo write size count ( 32KB)22689404784
12cR1-12cR2redo write size count ( 64KB)23887142398
12cR1-12cR2redo write size count ( 128KB)22998280397
12cR1-12cR2redo write size count ( 256KB)22120393820
12cR1-12cR2redo write size count ( 512KB)23912524051
12cR1-12cR2redo write size count (1024KB)2395882065
12cR1-12cR2redo write size count (inf)24145578355
8i-12cR2redo write time23094453259
12cR2-12cR2redo write time (usec)1282728940043
12cR2-12cR2redo write total time1283504430304
12cR2-12cR2redo write worker delay (usec)21551572440
12cR2-12cR2redo write worker delay count2119657744
8i-11gR1redo writer latching time22166056472
8i-12cR2redo writes21948353376
12cR1-12cR2redo writes (group 0)22952991530
12cR1-12cR2redo writes (group 1)21083730459
12cR1-12cR2redo writes (group 2)22759403975
12cR1-12cR2redo writes (group 3)23475566097
12cR1-12cR2redo writes (group 4)21807859197
12cR1-12cR2redo writes (group 5)21792560815
12cR1-12cR2redo writes (group 6)21695728381
12cR1-12cR2redo writes (group 7)21074957749
12cR1-12cR2redo writes adaptive all23061077218
12cR1-12cR2redo writes adaptive worker23220418890
11gR2-12cR2remote Oradebug requests1282605999124
8i-9iremote instance undo block writes40
8i-9iremote instance undo header writes40
8i-12cR2rollback changes - undo records applied1283616249137
8i-12cR2rollbacks only - consistent read gets1283133064500
11gR2-12cR2root node splits128708722985
8i-12cR2rows fetched via callback643299365556
12cR2-12cR2saved cleanout failures: buffer being written8334499835
12cR2-12cR2saved cleanout failures: callback failure83463019376
12cR2-12cR2saved cleanout failures: cannot pin84018523192
12cR2-12cR2saved cleanout failures: delayed log81661850400
12cR2-12cR2saved cleanout failures: flashback83883557393
12cR2-12cR2saved cleanout failures: hot backup in progress83240055392
12cR2-12cR2saved cleanout failures: write disabled8184445895
12cR2-12cR2saved cleanouts83273916993
12cR2-12cR2saved cleanouts successfully completed83643498529
11gR2-12cR2scheduler wait time12260360067
11gR1-12cR2securefile add dedupd lob to set128417001337
11gR1-12cR2securefile allocation bytes1283597129675
11gR1-12cR2securefile allocation chunks1282011127012
11gR1-12cR2securefile bytes cleartext1283732194274
11gR1-12cR2securefile bytes deduplicated1283725763856
11gR1-12cR2securefile bytes encrypted1282777111815
11gR1-12cR2securefile bytes non-transformed1283951297587
11gR1-12cR2securefile compressed bytes128155601069
11gR1-12cR2securefile create dedup set128315944074
11gR1-12cR2securefile dedup callback oper final1283751127546
11gR1-12cR2securefile dedup fits inline128811020833
11gR1-12cR2securefile dedup flush too low1282538132497
11gR1-12cR2securefile dedup hash collision128474756722
11gR1-12cR2securefile dedup prefix hash match12845267420
12cR1-12cR2securefile dedup wapp cache miss1281383329268
11gR1-12cR2securefile destroy dedup set1281033064527
11gR1-12cR2securefile direct read bytes128716648152
11gR1-12cR2securefile direct read ops1283240523075
11gR1-12cR2securefile direct write bytes1283429235578
11gR1-12cR2securefile direct write ops1281150219561
11gR1-12cR2securefile inode ioreap time1283735572547
12cR2-12cR2securefile inode itree redo1284151586524
12cR2-12cR2securefile inode lhb redo1282900928661
11gR1-12cR2securefile inode read time1284019396886
11gR1-12cR2securefile inode write time1282268799257
11gR1-12cR2securefile number of flushes128695283106
11gR1-12cR2securefile number of non-transformed flushes1284098565707
11gR1-12cR2securefile reject deduplication1282469868456
11gR1-12cR2securefile rmv from dedup set128260212603
11gR1-12cR2securefile uncompressed bytes1283014741102
11gR2-11gR2segemnt dispenser load empty1283106306090
11gR2-12cR2segment cfs allocations1284048061961
11gR2-12cR1segment chunks allocation from disepnser1282015432847
12cR2-12cR2segment chunks allocation from dispenser1281221208561
11gR2-12cR2segment dispenser allocations1282993245266
12cR1-12cR2segment dispenser load empty1281005466722
11gR2-12cR2segment dispenser load tasks1282847264083
11gR2-12cR2segment prealloc bytes128183929521
11gR2-12cR2segment prealloc ops128189611734
11gR2-12cR2segment prealloc tasks1283177356408
11gR2-12cR2segment prealloc time (ms)128219198613
11gR2-12cR2segment prealloc ufs2cfs bytes128409018059
11gR2-12cR2segment total chunk allocation128322556951
8i-12cR2serializable aborts11793250745
8i-12cR2session connect time11678473874
8i-12cR2session cursor cache count64568260813
8i-12cR2session cursor cache hits643678609077
8i-12cR2session logical reads13143187968
12cR2-12cR2session logical reads - IM1282202601719
12cR1-12cR2session logical reads in local numa group11564026751
12cR1-12cR2session logical reads in remote numa group13011877906
8i-12cR2session pga memory14148600571
8i-12cR2session pga memory max1507777907
12cR2-12cR2session referenced a buffer on dram83096839672
12cR2-12cR2session referenced a buffer on xmem81965536741
8i-12cR2session stored procedure space1895486831
8i-12cR2session uga memory11856888586
8i-12cR2session uga memory max13840343119
9i-12cR2shared hash latch upgrades - no wait82488550671
9i-12cR2shared hash latch upgrades - wait83380476499
11gR1-12cR2shared io pool buffer get failure1281112447278
11gR1-12cR2shared io pool buffer get success1282964900499
12cR1-12cR2slave propagated tracked transactions128275867045
8i-12cR2sorts (disk)642533123502
8i-12cR2sorts (memory)642091983730
8i-12cR2sorts (rows)643757672740
10gR2-12cR2space was found by tune down128342698422
10gR2-12cR2space was not found by tune down128849561940
11gR1-12cR2spare statistic 1128230898549
12cR2-12cR2spare statistic 101282725405211
12cR2-12cR2spare statistic 111284060660491
12cR2-12cR2spare statistic 121283657305617
12cR2-12cR2spare statistic 131283358717624
12cR2-12cR2spare statistic 141283461305022
12cR2-12cR2spare statistic 151281274449082
12cR2-12cR2spare statistic 161283298124910
12cR2-12cR2spare statistic 171283771731969
12cR2-12cR2spare statistic 181282322829245
12cR2-12cR2spare statistic 19128932346061
11gR1-12cR2spare statistic 21283818030889
12cR2-12cR2spare statistic 20128143093989
12cR2-12cR2spare statistic 211282717768595
12cR2-12cR2spare statistic 221281141965965
12cR2-12cR2spare statistic 231282877314243
12cR2-12cR2spare statistic 241283451147931
12cR2-12cR2spare statistic 251283291427211
12cR2-12cR2spare statistic 261281142769635
12cR2-12cR2spare statistic 271282534880401
12cR2-12cR2spare statistic 281282850185948
12cR2-12cR2spare statistic 29128386779712
11gR1-12cR2spare statistic 3128686628667
12cR2-12cR2spare statistic 301282568592980
12cR2-12cR2spare statistic 311281985037514
12cR2-12cR2spare statistic 321283630247422
12cR2-12cR2spare statistic 331282413258443
12cR2-12cR2spare statistic 34128877373488
12cR2-12cR2spare statistic 351283547801550
12cR2-12cR2spare statistic 36128670648973
12cR2-12cR2spare statistic 371281368081081
12cR2-12cR2spare statistic 381281862709517
12cR2-12cR2spare statistic 391282664161905
11gR1-12cR2spare statistic 41283494279544
12cR2-12cR2spare statistic 40128172085752
12cR2-12cR2spare statistic 51283046028945
12cR2-12cR2spare statistic 61282726000180
12cR2-12cR2spare statistic 71281847379793
12cR2-12cR2spare statistic 81283361404483
12cR2-12cR2spare statistic 9128237095764
10gR2-12cR2sql area evicted643224599022
10gR2-12cR2sql area purged642763387941
10gR2-12cR2steps of tune down ret. in space pressure1283986010614
12cR1-12cR1storage index soft misses in bytes82809906174
8i-12cR2summed dirty queue length81683565474
12cR2-12cR2switch current caused by our pin82616315487
8i-12cR2switch current to new buffer81312802324
8i-12cR2table fetch by rowid64681815839
8i-12cR2table fetch continued row641413702393
9i-11gR1table lookup prefetch client count81926456670
8i-12cR2table scan blocks gotten643741388076
12cR2-12cR2table scan disk IMC fallback64267278812
12cR2-12cR2table scan disk non-IMC rows gotten642963572642
8i-12cR2table scan rows gotten641400824662
12cR2-12cR2table scan rs164157262974
12cR2-12cR2table scan rs2641680192750
12cR2-12cR2table scans (IM)642125263990
8i-12cR2table scans (cache partitions)64133545664
8i-12cR2table scans (direct read)643355423586
8i-12cR2table scans (long tables)641042655239
8i-12cR2table scans (rowid ranges)641303412790
8i-12cR2table scans (short tables)64345141973
11gR2-12cR2temp space allocated (bytes)1280471097
11gR2-12cR2total cf enq hold time43653899408
8i-9itotal file opens8
11gR2-12cR2total number of cf enq holders4174183174
9i-12cR2total number of slots82223809671
10gR2-12cR2total number of times SMON posted128399827284
9i-12cR2total number of undo segments dropped1283623640507
12cR1-12cR2tracked rows128943642878
12cR1-12cR2tracked transactions1284230695614
8i-12cR2transaction lock background get time1283492664117
8i-12cR2transaction lock background gets1283977359732
8i-12cR2transaction lock foreground requests128185785666
8i-12cR2transaction lock foreground wait time1284033661655
8i-12cR2transaction rollbacks1283988650402
8i-12cR2transaction tables consistent read rollbacks1281396293204
8i-12cR2transaction tables consistent reads - undo records applied1281054055970
10gR2-12cR2tune down retentions in space pressure128142917891
12cR2-12cR2txn cache init usn exceeds max1282139787937
12cR2-12cR2txn cache init usn slot mismatch1281370368016
12cR2-12cR2txn cache local ac read misses1281897730502
12cR2-12cR2txn cache local empty slot misses1283516871482
12cR2-12cR2txn cache local loscn read misses1283838946357
12cR2-12cR2txn cache local preset misses1283394035143
12cR2-12cR2txn cache local proc misses1283790466319
12cR2-12cR2txn cache local read hits1283538983810
12cR2-12cR2txn cache local read misses1283442324575
12cR2-12cR2txn cache local seq num misses1282456232786
12cR2-12cR2txn cache local slot misses128749230270
12cR2-12cR2txn cache local sync commit scn misses1284003030326
12cR2-12cR2txn cache local usn hash read misses1283084519646
12cR2-12cR2txn cache local usn hash write misses1283204754903
12cR2-12cR2txn cache local writes128240148011
12cR2-12cR2txn cache lookup conflicting write exact1284105187717
12cR2-12cR2txn cache lookup conflicting write uppper1283762032773
12cR2-12cR2txn cache lookup fail read even version1281543533922
12cR2-12cR2txn cache lookup slot exceeds max1283014412569
12cR2-12cR2txn cache lookup usn exceeds max1281689562124
12cR2-12cR2txn cache redo sync reads1281692584092
12cR2-12cR2txn cache remote active read misses128379631372
12cR2-12cR2txn cache remote copy hits128521472013
12cR2-12cR2txn cache remote copy misses1283287741352
12cR2-12cR2txn cache remote empty slot misses1282528650911
12cR2-12cR2txn cache remote fetch double pass1281984018994
12cR2-12cR2txn cache remote loscn read misses1282613311394
12cR2-12cR2txn cache remote prefetch count1284140396065
12cR2-12cR2txn cache remote proc misses128863195183
12cR2-12cR2txn cache remote read hits1282240912367
12cR2-12cR2txn cache remote read misses128214504032
12cR2-12cR2txn cache remote read msg sent1281665545341
12cR2-12cR2txn cache remote seq num misses1283164390170
12cR2-12cR2txn cache remote slot misses128940584993
12cR2-12cR2txn cache remote sync commit scn misses1284268022132
12cR2-12cR2txn cache remote ts/inst mismatch1283071901891
12cR2-12cR2txn cache remote usn hash read misses1282189490732
12cR2-12cR2txn cache remote writes1283045875736
12cR2-12cR2txn cache upper bound misses1281973974869
12cR2-12cR2txn cache write slot mismatch1283953220426
12cR2-12cR2txn cache write usn exceeds max1282141702496
12cR2-12cR2undo block recovery disk reads skipped402407236247
10gR1-12cR2undo change vector size1281465971540
10gR2-12cR2undo segment header was pinned128248401831
10gR1-12cR2user I/O wait time13332107451
8i-12cR2user calls12882015696
8i-12cR2user commits1582481098
12cR2-12cR2user logons cumulative12061877149
12cR2-12cR2user logouts cumulative1371319593
8i-12cR2user rollbacks13671147913
12cR2-12cR2vector encoded arithmetic exceptions642824672853
12cR2-12cR2vector encoded row operations642588759213
12cR2-12cR2vector encoded rows64719002554
12cR2-12cR2vector encoded rows decoded642289712210
12cR2-12cR2vector encoded rowset operations642281122747
12cR2-12cR2vector encoded rowsets644131670214
12cR2-12cR2vector encoded rowsets decoded64874412893
12cR2-12cR2vector group by accumspace cardinality643548813222
12cR2-12cR2vector group by accumspace size643676294238
12cR2-12cR2vector group by operations not sent to cell due to cardinality642526398601
12cR2-12cR2vector group by operations not sent to cell due to key vector641772342795
12cR2-12cR2vector group by operations sent to cell641744758432
12cR2-12cR2vector group by out of line rows643699875524
12cR2-12cR2vector group by out of line size643351096054
12cR2-12cR2vector group by rows processed on cell64552666362
12cR2-12cR2vector group by rows returned by cell641732810390
12cR2-12cR2vector group by rowsets processed on cell64203088979
12cR2-12cR2vector group by rowsources adapted641296757490
12cR2-12cR2vector group by string allocations642572734848
12cR2-12cR2vector group by string allocations size644094491842
12cR2-12cR2vector group by string resizes64711324272
12cR2-12cR2vector group by used643078893797
12cR1-12cR2very large tracked transactions1284033000846
9i-12cR2workarea executions - multipass643804491469
9i-12cR2workarea executions - onepass64798730793
9i-12cR2workarea executions - optimal643211650785
9i-12cR2workarea memory allocated642433935387
10gR1-12cR2write clones created for recovery84053425429
8i-12cR2write clones created in background82988965544
8i-12cR2write clones created in foreground84237693830
12cR2-12cR2xmem buffer switch needed but no free dram buffer81667929741
12cR2-12cR2xmem clean buffers available and used8720246230
12cR2-12cR2xmem clean buffers not available so switch to main82403185728
12cR2-12cR2xmem: dram enforced but no free buffer81963681848
★ORACLE案件承ります