システム統計一覧

12cR1までのシステム統計一覧です。
・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
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
11gR1-12cR1Batched IO (bound) vector count722669900039
11gR1-12cR1Batched IO (full) vector count723326798362
11gR1-12cR1Batched IO (space) vector count723732543888
11gR1-12cR1Batched IO block miss count72398227664
11gR1-12cR1Batched IO buffer defrag count723691310830
11gR1-12cR1Batched IO double miss count721818000820
11gR1-12cR1Batched IO same unit count721157040815
11gR1-12cR1Batched IO single block count723409550379
11gR1-12cR1Batched IO slow jump count72808096169
11gR1-12cR1Batched IO vector block count72779198283
11gR1-12cR1Batched IO vector read count723940039938
11gR1-12cR1Batched IO zero block count721754742469
11gR1-12cR1Block 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-12cR1CCursor + sql area evicted64938276153
12cR1-12cR1CLI BG ENQ1282537508108
12cR1-12cR1CLI BG Fls done1281898500432
12cR1-12cR1CLI BG attempt Flush1282751550570
12cR1-12cR1CLI Buf Wrt1281466815534
12cR1-12cR1CLI Client Flush1282418073855
12cR1-12cR1CLI Flstask create1284150293767
12cR1-12cR1CLI Flush128670819718
12cR1-12cR1CLI Imm Wrt12847996927
12cR1-12cR1CLI Prvtz Lob1281688196485
12cR1-12cR1CLI SGA Alloc1282076026298
12cR1-12cR1CLI Thru Wrt1282721289668
12cR1-12cR1CLI bytes fls to ext1282251457522
12cR1-12cR1CLI bytes fls to table128872375576
8i-12cR1CPU used by this session124469293
8i-12cR1CPU used when call started128572264820
8i-12cR1CR blocks created8516801181
8i-12cR1Cached Commit SCN referenced1282374582560
11gR1-12cR1Clusterwide global transactions334124661496
11gR1-12cR1Clusterwide global transactions spanning RAC nodes333534283427
8i-12cR1Commit SCN cached1282460709063
10gR1-12cR1DB time13649082374
8i-10gR1DBWR buffers scanned8105885844
8i-12cR1DBWR checkpoint buffers written81208600358
8i-12cR1DBWR checkpoints81732023165
8i-9iDBWR cross instance writes40
8i-10gR1DBWR free buffers found81360869216
9i-12cR1DBWR fusion writes402313150541
8i-12cR1DBWR lru scans82139101792
8i-10gR2DBWR make free requests81237874725
10gR1-12cR1DBWR object drop buffers written8658143835
10gR1-12cR1DBWR parallel query checkpoint buffers written81768645316
8i-12cR1DBWR revisited being-written buffer82773697723
8i-10gR1DBWR summed scan depth81586660302
10gR1-12cR1DBWR tablespace checkpoint buffers written82649259263
10gR1-12cR1DBWR thread checkpoint buffers written83905787588
8i-12cR1DBWR transaction table writes82146120386
8i-12cR1DBWR undo block writes8111270822
8i-12cR1DDL statements parallelized324115134636
8i-12cR1DFO trees parallelized322753131890
8i-12cR1DML statements parallelized323791923855
11gR1-12cR1DX/BB enqueue lock background get time1281423799991
11gR1-12cR1DX/BB enqueue lock background gets1282384348591
11gR1-12cR1DX/BB enqueue lock foreground requests128560233336
11gR1-12cR1DX/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-12cR1Effective IO time84166892036
11gR1-12cR1Forwarded 2PC commands across RAC nodes334274163731
11gR1-12cR1GTX processes spawned by autotune32719092076
11gR1-12cR1GTX processes stopped by autotune32457066669
11gR1-12cR1HSC Compressed Segment Block Changes64539480718
11gR1-12cR1HSC Heap Segment Block Changes64399567576
11gR1-12cR1HSC IDL Compressed Blocks642406770549
11gR1-12cR1HSC OLTP Compressed Blocks642175876847
11gR1-12cR1HSC OLTP Compression skipped rows1283456750894
12cR1-12cR1HSC OLTP Compression wide compressed row pieces128784760009
11gR1-12cR1HSC OLTP Drop Column128559591604
11gR1-12cR1HSC OLTP Non Compressible Blocks64262999502
11gR1-12cR1HSC OLTP Space Saving64841396643
11gR1-12cR1HSC OLTP compression block checked1282637393546
11gR1-12cR1HSC OLTP inline compression1282650019963
11gR1-12cR1HSC OLTP negative compression128269936937
11gR1-12cR1HSC OLTP positive compression1281017140011
11gR1-12cR1HSC OLTP recursive compression12857927558
11gR1-12cR1Heap Segment Array Inserts641532155417
11gR1-12cR1Heap Segment Array Updates642275749997
12cR1-12cR1Heatmap BlkLevel Flush Task Create1281236100146
12cR1-12cR1Heatmap BlkLevel Flushed1283201601810
12cR1-12cR1Heatmap BlkLevel Flushed to BF128329477246
12cR1-12cR1Heatmap BlkLevel Flushed to SYSAUX128153666168
12cR1-12cR1Heatmap BlkLevel Not Tracked - Memory1283244920981
12cR1-12cR1Heatmap BlkLevel Not Updated - Repeat1281235344528
12cR1-12cR1Heatmap BlkLevel Ranges Flushed1283869669302
12cR1-12cR1Heatmap BlkLevel Ranges Skipped128120128078
12cR1-12cR1Heatmap BlkLevel Tracked128417269865
12cR1-12cR1Heatmap Blklevel Flush Task Count1281887039906
12cR1-12cR1Heatmap SegLevel - Flush1283466367062
12cR1-12cR1Heatmap SegLevel - Full Table Scan1283635715785
12cR1-12cR1Heatmap SegLevel - IndexLookup1284088384827
12cR1-12cR1Heatmap SegLevel - Segments flushed1282885452372
12cR1-12cR1Heatmap SegLevel - TableLookup12826595750
12cR1-12cR1Heatmap SegLevel - Write1282305866014
10gR1-12cR1IMU CR rollbacks1282225124543
10gR1-12cR1IMU Flushes1282099506212
10gR1-12cR1IMU Redo allocation size1283945654623
10gR1-12cR1IMU bind flushes1282756376339
10gR1-12cR1IMU commits1281914489094
10gR1-12cR1IMU contention1282909373607
10gR1-12cR1IMU ktichg flush1281206609541
10gR1-12cR1IMU mbu flush1283723686946
10gR1-12cR1IMU pool not allocated128659017805
10gR1-12cR1IMU recursive-transaction flush1282591100633
10gR1-12cR1IMU undo allocation size128244193920
10gR1-12cR1IMU undo retention flush1282087226422
10gR1-12cR1IMU- failed to get a private strand1282412863545
10gR1-12cR1IPC CPU used by this session324247517299
12cR1-12cR1KTFB alloc myinst128637674164
12cR1-12cR1KTFB alloc req1283506976771
12cR1-12cR1KTFB alloc search FFB1281572111054
12cR1-12cR1KTFB alloc space (block)128254882839
12cR1-12cR1KTFB alloc steal1283819194715
12cR1-12cR1KTFB alloc time (ms)128573758863
12cR1-12cR1KTFB apply req1282829590811
12cR1-12cR1KTFB apply time (ms)1281827629900
12cR1-12cR1KTFB commit req1282268695636
12cR1-12cR1KTFB commit time (ms)1283807444826
12cR1-12cR1KTFB free req1281286187813
12cR1-12cR1KTFB free space (block)1281243401580
12cR1-12cR1KTFB free time (ms)128408510199
11gR1-12cR1LOB table id lookup cache misses1281983401898
10gR1-12cR1Misses for writing mapping1282725329757
11gR2-12cR1No. of Decrypt ops11118476298
11gR2-12cR1No. of Encrypt ops13364959674
11gR2-12cR1No. of Namespaces Created11052652127
11gR2-12cR1No. of Principal Cache Misses11497811853
11gR2-12cR1No. of Principal Invalidations11130152043
11gR2-12cR1No. of Roles Enabled or Disabled11422657893
11gR2-12cR1No. of User Callbacks Executed12910344476
11gR2-12cR1No. of XS Sessions Attached11249145894
11gR2-12cR1No. of XS Sessions Created184820840
12cR1-12cR1Number of FORMAT_PRESERVING redactions12739332778
12cR1-12cR1Number of FULL redactions14021003316
12cR1-12cR1Number of NONE redactions12910416594
12cR1-12cR1Number of PARTIAL redactions12340397149
12cR1-12cR1Number of RANDOM redactions12308447938
12cR1-12cR1Number of REGEXP redactions13081010860
11gR1-12cR1Number of read IOs issued83882100521
12cR1-12cR1OLAP Aggregate Function Calc643109348342
12cR1-12cR1OLAP Aggregate Function Logical NA642269374713
12cR1-12cR1OLAP Aggregate Function Precompute64352609299
12cR1-12cR1OLAP Custom Member Limit643030144806
12cR1-12cR1OLAP Engine Calls644076583183
12cR1-12cR1OLAP Fast Limit64283242358
12cR1-12cR1OLAP Full Limit642189109011
12cR1-12cR1OLAP GID Limit641120107350
12cR1-12cR1OLAP INHIER Limit642844959843
12cR1-12cR1OLAP Import Rows Loaded642782483173
12cR1-12cR1OLAP Import Rows Pushed643846608240
12cR1-12cR1OLAP Limit Time642592657924
12cR1-12cR1OLAP Paging Manager Cache Changed Page642200669834
12cR1-12cR1OLAP Paging Manager Cache Hit64249788237
12cR1-12cR1OLAP Paging Manager Cache Miss642631123639
12cR1-12cR1OLAP Paging Manager Cache Write642077400790
12cR1-12cR1OLAP Paging Manager New Page641639856938
12cR1-12cR1OLAP Paging Manager Pool Size643621573995
12cR1-12cR1OLAP Perm LOB Read642809117898
12cR1-12cR1OLAP Row Id Limit643437716459
12cR1-12cR1OLAP Row Load Time64953132701
12cR1-12cR1OLAP Row Source Rows Processed641032576542
12cR1-12cR1OLAP Session Cache Hit643766195924
12cR1-12cR1OLAP Session Cache Miss641569481295
12cR1-12cR1OLAP Temp Segment Read641927042645
12cR1-12cR1OLAP Temp Segments643547622716
12cR1-12cR1OLAP Unique Key Attribute Limit643812252850
11gR2-12cR1OS CPU Qt wait time1576270482
9i-12cR1OTC commit optimization attempts1282480822770
9i-12cR1OTC commit optimization failure - setup1283633344886
9i-12cR1OTC commit optimization hits1284064864054
8i-12cR1PX local messages recv'd321437798390
8i-12cR1PX local messages sent32506655048
8i-12cR1PX remote messages recv'd322537140420
8i-12cR1PX remote messages sent322567415317
8i-12cR1Parallel operations downgraded 1 to 25 pct323721245209
8i-12cR1Parallel operations downgraded 25 to 50 pct323330456527
8i-12cR1Parallel operations downgraded 50 to 75 pct323281923117
8i-12cR1Parallel operations downgraded 75 to 99 pct32322858058
8i-12cR1Parallel operations downgraded to serial324286011915
8i-12cR1Parallel operations not downgraded322410168744
12cR1-12cR1Requests to/from client13982115148
10gR2-12cR1RowCR - resume1282583359573
9i-12cR1RowCR - row contention1281175104080
9i-12cR1RowCR attempts1282297882326
9i-12cR1RowCR hits1283455911385
10gR2-12cR1SMON posted for dropping temp segment1283600495721
10gR2-12cR1SMON posted for instance recovery1284003178738
10gR2-10gR2SMON posted for supplemental logging cleanup1281356155743
10gR2-12cR1SMON posted for txn recovery for other instances1281263842513
10gR2-12cR1SMON posted for undo segment recovery1282117898593
10gR2-12cR1SMON posted for undo segment shrink128579492169
8i-12cR1SQL*Net roundtrips to/from client1159846526
8i-12cR1SQL*Net roundtrips to/from dblink12420448902
12cR1-12cR1SecureFiles Copy from DBFS Link1283313150606
12cR1-12cR1SecureFiles DBFS Link Operations128408804124
12cR1-12cR1SecureFiles DBFS Link Overwrites1283546571658
12cR1-12cR1SecureFiles DBFS Link streaming reads1282291010287
12cR1-12cR1SecureFiles Get DBFS Link Reference1283776855272
12cR1-12cR1SecureFiles Implicit Copy from DBFS Link1282864160252
12cR1-12cR1SecureFiles Move to DBFS Link1282159528439
12cR1-12cR1SecureFiles Put DBFS Link Reference1281020980477
12cR1-12cR1Streaming No-Stall Reap22378677367
12cR1-12cR1Streaming Stall Reap23489516369
11gR2-12cR1TBS Extension: bytes extended12820854933
11gR1-12cR1TBS Extension: files extended12887307875
11gR1-12cR1TBS Extension: tasks created1281488217152
11gR1-12cR1TBS Extension: tasks executed1281936615790
8i-10gR1Unnecesary process cleanup for SCN batching321207572951
10gR2-12cR1Workload Capture: dbtime13533966785
10gR2-12cR1Workload Capture: errors11278172735
10gR2-12cR1Workload Capture: size (in bytes) of recording12146126248
10gR2-12cR1Workload Capture: unreplayable user calls13283547595
10gR2-12cR1Workload Capture: unsupported user calls12224534227
10gR2-12cR1Workload Capture: user calls11228651202
10gR2-12cR1Workload Capture: user calls flushed12236307043
10gR2-12cR1Workload Capture: user logins11296083012
10gR2-12cR1Workload Capture: user txns13034767909
11gR1-12cR1Workload Replay: dbtime1443726121
11gR1-12cR1Workload Replay: deadlocks resolved12446501167
11gR1-12cR1Workload Replay: network time12824611432
11gR1-12cR1Workload Replay: think time14246044927
11gR1-12cR1Workload Replay: time gain1849876091
11gR1-12cR1Workload Replay: time loss12223483653
11gR1-12cR1Workload Replay: user calls1626148611
9i-12cR1active txn count during cleanout1283378035478
10gR1-12cR1application wait time11099569955
10gR2-12cR1auto extends on undo tablespace1283140365462
8i-12cR1background checkpoints completed82450922463
8i-12cR1background checkpoints started83048007007
8i-12cR1background timeouts128961017212
12cR1-12cR1blocks decrypted8559990478
12cR1-12cR1blocks encrypted8584993340
8i-12cR1branch node splits128399027615
8i-12cR1buffer is not pinned count722670431739
8i-12cR1buffer is pinned count721300470380
8i-12cR1bytes received via SQL*Net from client1161936656
8i-12cR1bytes received via SQL*Net from dblink11983609624
8i-12cR1bytes sent via SQL*Net to client12967415760
8i-12cR1bytes sent via SQL*Net to dblink11622773540
11gR1-12cR1bytes via SQL*Net vector from client12635744375
11gR1-12cR1bytes via SQL*Net vector from dblink13412995477
11gR1-12cR1bytes via SQL*Net vector to client1763712542
11gR1-12cR1bytes via SQL*Net vector to dblink1242642371
8i-12cR1calls to get snapshot scn: kcmgss323128650623
8i-12cR1calls to kcmgas1284072914524
8i-12cR1calls to kcmgcs1282775936802
8i-12cR1calls 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-12cR1cell IO uncompressed bytes641129546621
11gR1-12cR1cell blocks helped by commit cache642220928368
11gR1-12cR1cell blocks helped by minscn optimization64721268882
11gR1-12cR1cell blocks processed by cache layer1281264058236
11gR1-12cR1cell blocks processed by data layer128250025093
11gR1-12cR1cell blocks processed by index layer128412699774
11gR1-12cR1cell blocks processed by txn layer1283280964634
11gR1-11gR2cell blocks skipped due to chained rows641370215149
11gR1-12cR1cell commit cache queries641111035140
11gR2-12cR1cell flash cache read hits82923827453
11gR2-12cR1cell index scans643427136437
12cR1-12cR1cell num bytes of IO reissued due to relocation643754903472
12cR1-12cR1cell num fast response sessions643241490781
12cR1-12cR1cell num fast response sessions continuing to smart scan643693748667
11gR2-12cR1cell num smart IO sessions in rdbms block IO due to big payload64256540314
12cR1-12cR1cell num smart IO sessions in rdbms block IO due to no cell mem641205851429
12cR1-12cR1cell num smart IO sessions in rdbms block IO due to open fail641611570469
11gR2-12cR1cell num smart IO sessions in rdbms block IO due to user64753394329
11gR2-12cR1cell num smart IO sessions using passthru mode due to cellsrv64636424788
11gR2-12cR1cell num smart IO sessions using passthru mode due to timezone641573034705
11gR2-12cR1cell num smart IO sessions using passthru mode due to user641852329605
11gR2-12cR1cell num smart file creation sessions using rdbms block IO mode642647020488
12cR1-12cR1cell num smartio automem buffer allocation attempts64145506540
12cR1-12cR1cell num smartio automem buffer allocation failures64727055891
12cR1-12cR1cell num smartio permanent cell failures64299072157
12cR1-12cR1cell num smartio transient cell failures642276204331
11gR1-12cR1cell physical IO bytes eligible for predicate offload643064960568
11gR2-12cR1cell physical IO bytes saved by storage index82245892488
11gR1-12cR1cell physical IO bytes saved during optimized RMAN file restore641445035119
11gR1-12cR1cell physical IO bytes saved during optimized file creation64372652547
12cR1-12cR1cell physical IO bytes sent directly to DB node to balance CPU643163467121
11gR1-12cR1cell physical IO interconnect bytes642957355214
11gR2-12cR1cell physical IO interconnect bytes returned by smart scan643279818867
11gR1-12cR1cell scans641117153474
11gR2-11gR2cell session smart scan efficiency64173384451
11gR1-12cR1cell simulated physical IO bytes eligible for predicate offload1923792766660
11gR1-12cR1cell simulated physical IO bytes returned by predicate offload1922052798177
11gR2-11gR2cell simulated session smart scan efficiency1923381744771
11gR2-12cR1cell smart IO session cache hard misses643263815706
11gR2-12cR1cell smart IO session cache hits64398350085
11gR2-12cR1cell smart IO session cache hwm643006068088
11gR2-12cR1cell smart IO session cache lookups6422520694
11gR2-12cR1cell smart IO session cache soft misses642892599795
12cR1-12cR1cell statistics spare1643007761105
12cR1-12cR1cell statistics spare2643735886817
12cR1-12cR1cell statistics spare3641761517293
12cR1-12cR1cell statistics spare4643075070261
12cR1-12cR1cell statistics spare564339741456
12cR1-12cR1cell statistics spare6641614816238
11gR1-12cR1cell transactions found in commit cache64266637754
12cR1-12cR1chained rows processed by cell641170574055
12cR1-12cR1chained rows rejected by cell64959925020
12cR1-12cR1chained rows skipped by cell643337164797
8i-12cR1change write time82838938797
12cR1-12cR1checkpoint clones created for ADG recovery8128034341
9i-12cR1cleanout - number of ktugct calls1282577316246
8i-12cR1cleanouts and rollbacks - consistent read gets1281083903169
8i-12cR1cleanouts only - consistent read gets1282904875805
8i-12cR1cluster key scan block gets642006808371
8i-12cR1cluster key scans643566804345
10gR1-12cR1cluster wait time12432034337
8i-12cR1cold recycle reads8657271764
10gR2-12cR1commit batch performed11391516579
10gR2-12cR1commit batch requested12338940602
10gR2-12cR1commit batch/immediate performed13711642721
10gR2-12cR1commit batch/immediate requested1640321576
8i-12cR1commit cleanout failures: block lost8781179189
8i-12cR1commit cleanout failures: buffer being written81626141486
8i-12cR1commit cleanout failures: callback failure83086716748
8i-12cR1commit cleanout failures: cannot pin8176423721
8i-12cR1commit cleanout failures: hot backup in progress82500023621
8i-12cR1commit cleanout failures: write disabled82063165199
8i-12cR1commit cleanouts82934869719
8i-12cR1commit cleanouts successfully completed83554314084
10gR2-12cR1commit immediate performed13494177237
10gR2-12cR1commit immediate requested1796663742
10gR2-12cR1commit nowait performed1485928497
10gR2-12cR1commit nowait requested13697788123
9i-12cR1commit txn count during cleanout1281405359431
10gR2-12cR1commit wait performed18047752
10gR2-12cR1commit wait requested12843300285
10gR2-12cR1commit wait/nowait performed11541239326
10gR2-12cR1commit wait/nowait requested13800399491
10gR1-12cR1concurrency wait time13868577743
8i-12cR1consistent changes83876379665
8i-12cR1consistent gets84162191256
9i-11gR2consistent gets - examination81701530557
10gR1-12cR1consistent gets direct8420374750
12cR1-12cR1consistent gets examination81966540185
12cR1-12cR1consistent gets examination (fastpath)81990445227
10gR1-12cR1consistent gets from cache82839918855
11gR1-11gR2consistent gets from cache (fastpath)82173751438
12cR1-12cR1consistent gets pin81168838199
12cR1-12cR1consistent gets pin (fastpath)82910712465
8i-12cR1current blocks converted for CR83142330676
8i-12cR1cursor authentications1284069981174
12cR1-12cR1cvmap unavailable23849353583
8i-12cR1data blocks consistent reads - undo records applied1282915445793
12cR1-12cR1data warehousing cooling action82905230597
12cR1-12cR1data warehousing evicted objects81827708704
12cR1-12cR1data warehousing evicted objects - cooling81769197766
12cR1-12cR1data warehousing evicted objects - replace8547725926
12cR1-12cR1data warehousing scanned chunks83880771368
12cR1-12cR1data warehousing scanned chunks - disk81684884558
12cR1-12cR1data warehousing scanned chunks - flash83811273611
12cR1-12cR1data warehousing scanned chunks - memory81765983694
12cR1-12cR1data warehousing scanned objects8247471814
8i-12cR1db block changes8916801489
8i-12cR1db block gets81480709069
10gR1-12cR1db block gets direct895128520
10gR1-12cR1db block gets from cache84017839461
11gR1-12cR1db block gets from cache (fastpath)8954629132
11gR1-12cR1db corrupt blocks detected81064154723
11gR1-12cR1db corrupt blocks recovered83806790612
8i-12cR1deferred (CURRENT) block cleanout applications1283388736327
9i-12cR1deferred CUR cleanouts (index blocks)1283827443394
8i-12cR1dirty buffers inspected81344569897
10gR1-12cR1doubling up with imu segment128723921798
10gR2-12cR1drop segment calls in space pressure1281500291109
8i-12cR1enqueue conversions457745673
8i-12cR1enqueue deadlocks4472183780
8i-12cR1enqueue releases42553146675
8i-12cR1enqueue requests42440542518
8i-12cR1enqueue timeouts42425496215
8i-12cR1enqueue waits42307006529
8i-12cR1exchange deadlocks814632483
8i-12cR1execute count642453370665
9i-12cR1failed probes on index block reclamation1282687444660
12cR1-12cR1fastpath consistent get quota limit40560973176
12cR1-12cR1fbda woken up128138331311
11gR2-12cR1file io service time13999659096
11gR2-12cR1file io wait time11292757183
11gR2-12cR1flash cache eviction: aged out83307935113
11gR2-12cR1flash cache eviction: buffer pinned83134415242
11gR2-12cR1flash cache eviction: invalidated83647825193
11gR2-12cR1flash cache insert skip: DBWR overloaded83504558414
11gR2-12cR1flash cache insert skip: corrupt82560222967
11gR2-12cR1flash cache insert skip: exists83291155557
11gR2-12cR1flash cache insert skip: modification84128442906
11gR2-12cR1flash cache insert skip: not current81693383402
11gR2-12cR1flash cache insert skip: not useful83620030478
11gR2-12cR1flash cache inserts82941771786
12cR1-12cR1flashback cache read optimizations for block new8756677055
12cR1-12cR1flashback direct read optimizations for block new81277968430
11gR2-12cR1flashback log write bytes2973553265
10gR1-12cR1flashback log writes23123176560
12cR1-12cR1flashback securefile cache read optimizations for block new8955255216
12cR1-12cR1flashback securefile direct read optimizations for block new8963322245
12cR1-12cR1foreground propagated tracked transactions1282081753160
10gR1-12cR1frame signature mismatch64959148951
8i-12cR1free buffer inspected8941676439
8i-12cR1free buffer requested83411924934
10gR1-12cR1gc CPU used by this session404093034494
11gR2-12cR1gc blocks compressed403506108623
10gR1-12cR1gc blocks corrupt402288508531
10gR1-12cR1gc blocks lost40500461751
10gR1-12cR1gc claim blocks lost401966230523
12cR1-12cR1gc cleanout applied401976898865
12cR1-12cR1gc cleanout no space40522936568
12cR1-12cR1gc cleanout saved404119317321
10gR1-12cR1gc cr block build time40467525985
10gR1-12cR1gc cr block flush time40552470873
11gR2-11gR2gc cr block read wait time404285841541
10gR1-12cR1gc cr block receive time401759426133
10gR1-12cR1gc cr block send time402395315974
10gR1-12cR1gc cr blocks received402877738702
12cR1-12cR1gc cr blocks received with BPS403270643842
10gR1-12cR1gc cr blocks served401075941831
12cR1-12cR1gc cr blocks served with BPS401600220233
10gR1-12cR1gc current block flush time404091964965
10gR1-12cR1gc current block pin time40324533635
10gR1-12cR1gc current block receive time401388758753
10gR1-12cR1gc current block send time402750158241
10gR1-12cR1gc current blocks received40326482564
12cR1-12cR1gc current blocks received with BPS40301773697
10gR1-12cR1gc current blocks served4042062110
12cR1-12cR1gc current blocks served with BPS401004484383
12cR1-12cR1gc force cr disk read401058102273
12cR1-12cR1gc ka grant receive time403746639269
12cR1-12cR1gc ka grants received40912334553
11gR2-12cR1gc kbytes saved401823613081
11gR2-12cR1gc kbytes sent403351517689
10gR2-12cR1gc local grants403656029643
12cR1-12cR1gc read wait failures40141128223
12cR1-12cR1gc read wait time403266024004
12cR1-12cR1gc read wait timeouts401278481093
12cR1-12cR1gc read waits4060245462
11gR1-12cR1gc reader bypass grants403930867231
12cR1-12cR1gc reader bypass waits401120557156
10gR2-12cR1gc remote grants401406613639
9i-12cR1gcs messages sent322765451804
9i-12cR1ges 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-12cR1global enqueue CPU used by this session323469911798
10gR1-12cR1global enqueue get time323744090840
10gR1-12cR1global enqueue gets async322892637759
10gR1-12cR1global enqueue gets sync321338475854
10gR1-12cR1global 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-12cR1global undo segment hints helped1281791494885
10gR2-12cR1global undo segment hints were stale1283309048233
10gR1-12cR1heap block compress642326757257
8i-12cR1hot buffers moved to head of LRU82030212224
8i-12cR1immediate (CR) block cleanout applications1283318186802
8i-12cR1immediate (CURRENT) block cleanout applications1282668233561
9i-12cR1immediate CR cleanouts (index blocks)12879013953
12cR1-12cR1in call idle wait time13723717570
12cR1-12cR1index cmph gencu、 uncomp sentinals1283972713215
12cR1-12cR1index cmph ld、 CU fit128312995821
12cR1-12cR1index cmph ld、 CU fit、 add rows1283074245919
12cR1-12cR1index cmph ld、 CU negative comp128747638515
12cR1-12cR1index cmph ld、 CU over-est1283287792462
12cR1-12cR1index cmph ld、 CU under-est1283487869306
12cR1-12cR1index cmph ld、 lf blks flushed1283933169485
12cR1-12cR1index cmph ld、 lf blks w/ und CU128500852118
12cR1-12cR1index cmph ld、 lf blks w/o CU1282058955770
12cR1-12cR1index cmph ld、 lf blks w/o unc r1281877031790
12cR1-12cR1index cmph ld、 retry in over-est1282794871331
12cR1-12cR1index cmph ld、 rows compressed1282461980696
12cR1-12cR1index cmph ld、 rows uncompressed1281487477542
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-12cR1index crx upgrade (found)641444049043
9i-12cR1index crx upgrade (positioned)642632952759
9i-12cR1index crx upgrade (prefetch)641907142657
8i-12cR1index fast full scans (direct read)641635662180
8i-12cR1index fast full scans (full)6412081473
8i-12cR1index fast full scans (rowid ranges)641555464060
9i-12cR1index fetch by key1282808364230
11gR2-12cR1index reclamation/extension switch128469799102
9i-12cR1index scans kdiixs11283589793292
8i-10gR2instance recovery database freeze count323674920298
10gR1-12cR1java call heap collected bytes13585877838
10gR1-12cR1java call heap collected count12510746206
10gR1-12cR1java call heap gc count12284697213
10gR1-12cR1java call heap live object count1632577394
10gR1-12cR1java call heap live object count max12964139762
10gR1-12cR1java call heap live size12431389341
10gR1-12cR1java call heap live size max11298432410
10gR1-12cR1java call heap object count13472185722
10gR1-12cR1java call heap object count max11862536587
10gR1-12cR1java call heap total size11649812842
10gR1-12cR1java call heap total size max1580075922
10gR1-12cR1java call heap used size1187277223
10gR1-12cR1java call heap used size max1625960724
10gR1-12cR1java session heap collected bytes13976434298
10gR1-12cR1java session heap collected count13795934475
10gR1-12cR1java session heap gc count13363147808
10gR1-12cR1java session heap live object count1225051972
10gR1-12cR1java session heap live object count max13755633366
10gR1-12cR1java session heap live size12257986540
10gR1-12cR1java session heap live size max11960804148
10gR1-12cR1java session heap object count14072938679
10gR1-12cR1java session heap object count max1469647992
10gR1-12cR1java session heap used size11661140639
10gR1-12cR1java session heap used size max11726629032
12cR1-12cR1ka grants received322310418695
12cR1-12cR1ka messages sent324222258831
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
12cR1-12cR1large tracked transactions1281755433832
9i-12cR1leaf node 90-10 splits1281285138251
8i-12cR1leaf node splits1281417124053
10gR2-12cR1lob reads83626914479
10gR2-12cR1lob writes82682192071
10gR2-12cR1lob writes unaligned84224694283
10gR2-12cR1local undo segment hints helped1281047863356
10gR2-12cR1local undo segment hints were stale1282070200837
12cR1-12cR1logical read bytes from cache81994463594
8i-12cR1logons cumulative12666645286
8i-12cR1logons current13080465522
11gR2-12cR1max cf enq hold time41032301310
8i-12cR1messages received1281396153242
8i-12cR1messages sent1282486045308
11gR2-12cR1min 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-12cR1no buffer to keep pinned count723528454686
8i-12cR1no work - consistent read gets1282814375799
11gR2-12cR1non-idle wait count145066233
11gR2-12cR1non-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-12cR1opened cursors cumulative185052502
8i-12cR1opened cursors current12301954928
8i-9iopens of replaced files8
8i-9iopens requiring cache replacement8
11gR1-12cR1parse count (describe)64469016317
9i-12cR1parse count (failures)641118776443
8i-12cR1parse count (hard)64143509059
8i-12cR1parse count (total)6463887964
8i-12cR1parse time cpu64206905303
8i-12cR1parse time elapsed641431595225
11gR1-11gR1physical IO disk bytes643277619920
10gR1-12cR1physical read IO requests8789768877
10gR2-12cR1physical read bytes8523531786
11gR2-12cR1physical read flash cache hits81672054092
12cR1-12cR1physical read partial requests8286702467
11gR2-12cR1physical read requests optimized82481818206
10gR2-12cR1physical read total IO requests83343375620
10gR2-12cR1physical read total bytes82572010804
12cR1-12cR1physical read total bytes optimized82290009573
10gR2-12cR1physical read total multi block requests82007302071
8i-12cR1physical reads82263124246
10gR1-12cR1physical reads cache84171507801
12cR1-12cR1physical reads cache for securefile flashback block new82429466467
10gR1-12cR1physical reads cache prefetch8297908839
8i-12cR1physical reads direct82589616721
8i-12cR1physical reads direct (lob)82564935310
12cR1-12cR1physical reads direct for securefile flashback block new83121545084
10gR1-12cR1physical reads direct temporary tablespace82663793346
10gR1-12cR1physical reads for flashback new8473165409
10gR1-12cR1physical reads prefetch warmup83102888545
10gR1-12cR1physical reads retry corrupt8531193461
10gR1-12cR1physical write IO requests82904164198
10gR2-12cR1physical write bytes83131337131
12cR1-12cR1physical write partial requests81535615968
12cR1-12cR1physical write request redirties84146911311
12cR1-12cR1physical write requests optimized82483607112
10gR2-12cR1physical write total IO requests81315894329
10gR2-12cR1physical write total bytes82495644835
12cR1-12cR1physical write total bytes optimized84085960041
10gR2-12cR1physical write total multi block requests83540174003
8i-12cR1physical writes81190468109
8i-12cR1physical writes direct82699895516
8i-12cR1physical writes direct (lob)83308932835
10gR1-12cR1physical writes direct temporary tablespace8996415569
10gR1-12cR1physical writes from cache8163083034
8i-12cR1physical writes non checkpoint82602029796
8i-12cR1pinned buffers inspected8833456521
11gR2-12cR1pinned cursors current12771133180
9i-12cR1prefetch clients - 16k8792304463
9i-12cR1prefetch clients - 2k8396625644
9i-12cR1prefetch clients - 32k82351177679
9i-12cR1prefetch clients - 4k83252900252
9i-12cR1prefetch clients - 8k81402775714
9i-12cR1prefetch clients - default81612053064
9i-12cR1prefetch clients - keep8574469659
9i-12cR1prefetch clients - recycle84053781837
10gR1-12cR1prefetch warmup blocks aged out before use83250306695
10gR1-12cR1prefetch warmup blocks flushed out before use82218846789
8i-9iprefetched blocks8
8i-12cR1prefetched blocks aged out before use81457461390
8i-12cR1process last non-idle time1282049556447
8i-12cR1queries parallelized323315614405
10gR1-12cR1queue flush1283150060076
10gR1-12cR1queue ocp pages1283899522644
10gR1-12cR1queue position update1282568542507
10gR1-12cR1queue qno pages1282998782417
10gR1-12cR1queue single row1282713404457
10gR1-12cR1queue splits1281168925905
10gR1-12cR1queue update without cp update128528828405
12cR1-12cR1read-only violation count1935461917
12cR1-12cR1recieve buffer unavailable23480097050
8i-12cR1recovery array read time82996696667
8i-12cR1recovery array reads82617845348
11gR1-12cR1recovery block gets from cache83434735488
8i-12cR1recovery blocks read83327333035
11gR1-12cR1recovery blocks read for lost write detection82677324291
11gR1-12cR1recovery blocks skipped lost write checks8680578166
12cR1-12cR1recovery marker22982845773
9i-12cR1recursive aborts on index block reclamation1283075437189
8i-12cR1recursive calls12656001462
8i-12cR1recursive cpu usage14009879262
11gR2-12cR1recursive system API invocations128728936273
12cR1-12cR1redo KB read2872961605
12cR1-12cR1redo KB read (memory)22883054278
12cR1-12cR1redo KB read (memory) for transport23933783006
12cR1-12cR1redo KB read for transport23093608311
11gR1-12cR1redo blocks checksummed by FG (exclusive)2352875884
11gR1-12cR1redo blocks checksummed by LGWR21917648704
10gR2-12cR1redo blocks read for recovery22679943069
8i-12cR1redo blocks written22391431605
12cR1-12cR1redo blocks written (group 0)22520028696
12cR1-12cR1redo blocks written (group 1)23244346714
12cR1-12cR1redo blocks written (group 2)21273391004
12cR1-12cR1redo blocks written (group 3)21050845280
12cR1-12cR1redo blocks written (group 4)22795831152
12cR1-12cR1redo blocks written (group 5)2615604096
12cR1-12cR1redo blocks written (group 6)2764128333
12cR1-12cR1redo blocks written (group 7)2435637049
8i-12cR1redo buffer allocation retries21446958922
8i-12cR1redo entries23488821837
11gR1-12cR1redo entries for lost write detection22194106845
11gR1-11gR2redo k-bytes read (memory)2399143205
11gR1-11gR2redo k-bytes read (memory) by LNS23857180019
11gR2-12cR1redo k-bytes read for recovery2359782962
11gR2-12cR1redo k-bytes read for terminal recovery22068376826
11gR1-11gR2redo k-bytes read total23114884375
11gR1-11gR2redo k-bytes read total by LNS21948686150
8i-12cR1redo log space requests21985754937
8i-12cR1redo log space wait time2252430928
8i-10gR2redo log switch interrupts2674283274
8i-12cR1redo ordering marks22104561012
8i-12cR1redo size21236385760
11gR1-12cR1redo size for direct writes2726277760
11gR1-12cR1redo size for lost write detection23835726666
10gR1-12cR1redo subscn max counts2449106517
12cR1-12cR1redo synch long waits1282758571193
12cR1-12cR1redo synch poll writes23841621897
12cR1-12cR1redo synch polls23455043432
8i-12cR1redo synch time84215815172
12cR1-12cR1redo synch time (usec)128957243500
12cR1-12cR1redo synch time overhead (usec)1283961087021
12cR1-12cR1redo synch time overhead count ( 2ms)1281771370497
12cR1-12cR1redo synch time overhead count ( 8ms)1282324186582
12cR1-12cR1redo synch time overhead count ( 32ms)1282882285036
12cR1-12cR1redo synch time overhead count (128ms)1281234629759
12cR1-12cR1redo synch time overhead count (inf)1282239006192
8i-12cR1redo synch writes81439995281
8i-12cR1redo wastage23462806146
11gR2-12cR1redo write broadcast ack count22144781638
11gR1-12cR1redo write broadcast ack time21201950653
12cR1-12cR1redo write broadcast lgwr post count24012338899
12cR1-12cR1redo write info find23584739253
12cR1-12cR1redo write info find fail2553778103
12cR1-12cR1redo write size count ( 4KB)24206847440
12cR1-12cR1redo write size count ( 8KB)23604386338
12cR1-12cR1redo write size count ( 16KB)21937637258
12cR1-12cR1redo write size count ( 32KB)22689404784
12cR1-12cR1redo write size count ( 64KB)23887142398
12cR1-12cR1redo write size count ( 128KB)22998280397
12cR1-12cR1redo write size count ( 256KB)22120393820
12cR1-12cR1redo write size count ( 512KB)23912524051
12cR1-12cR1redo write size count (1024KB)2395882065
12cR1-12cR1redo write size count (inf)24145578355
8i-12cR1redo write time23094453259
8i-11gR1redo writer latching time22166056472
8i-12cR1redo writes21948353376
12cR1-12cR1redo writes (group 0)22952991530
12cR1-12cR1redo writes (group 1)21083730459
12cR1-12cR1redo writes (group 2)22759403975
12cR1-12cR1redo writes (group 3)23475566097
12cR1-12cR1redo writes (group 4)21807859197
12cR1-12cR1redo writes (group 5)21792560815
12cR1-12cR1redo writes (group 6)21695728381
12cR1-12cR1redo writes (group 7)21074957749
12cR1-12cR1redo writes adaptive all23061077218
12cR1-12cR1redo writes adaptive worker23220418890
11gR2-12cR1remote Oradebug requests1282605999124
8i-9iremote instance undo block writes40
8i-9iremote instance undo header writes40
8i-12cR1rollback changes - undo records applied1283616249137
8i-12cR1rollbacks only - consistent read gets1283133064500
11gR2-12cR1root node splits128708722985
8i-12cR1rows fetched via callback643299365556
11gR2-12cR1scheduler wait time12260360067
11gR1-12cR1securefile add dedupd lob to set128417001337
11gR1-12cR1securefile allocation bytes1283597129675
11gR1-12cR1securefile allocation chunks1282011127012
11gR1-12cR1securefile bytes cleartext1283732194274
11gR1-12cR1securefile bytes deduplicated1283725763856
11gR1-12cR1securefile bytes encrypted1282777111815
11gR1-12cR1securefile bytes non-transformed1283951297587
11gR1-12cR1securefile compressed bytes128155601069
11gR1-12cR1securefile create dedup set128315944074
11gR1-12cR1securefile dedup callback oper final1283751127546
11gR1-12cR1securefile dedup fits inline128811020833
11gR1-12cR1securefile dedup flush too low1282538132497
11gR1-12cR1securefile dedup hash collision128474756722
11gR1-12cR1securefile dedup prefix hash match12845267420
12cR1-12cR1securefile dedup wapp cache miss1281383329268
11gR1-12cR1securefile destroy dedup set1281033064527
11gR1-12cR1securefile direct read bytes128716648152
11gR1-12cR1securefile direct read ops1283240523075
11gR1-12cR1securefile direct write bytes1283429235578
11gR1-12cR1securefile direct write ops1281150219561
11gR1-12cR1securefile inode ioreap time1283735572547
11gR1-12cR1securefile inode read time1284019396886
11gR1-12cR1securefile inode write time1282268799257
11gR1-12cR1securefile number of flushes128695283106
11gR1-12cR1securefile number of non-transformed flushes1284098565707
11gR1-12cR1securefile reject deduplication1282469868456
11gR1-12cR1securefile rmv from dedup set128260212603
11gR1-12cR1securefile uncompressed bytes1283014741102
11gR2-11gR2segemnt dispenser load empty1283106306090
11gR2-12cR1segment cfs allocations1284048061961
11gR2-12cR1segment chunks allocation from disepnser1282015432847
11gR2-12cR1segment dispenser allocations1282993245266
12cR1-12cR1segment dispenser load empty1281005466722
11gR2-12cR1segment dispenser load tasks1282847264083
11gR2-12cR1segment prealloc bytes128183929521
11gR2-12cR1segment prealloc ops128189611734
11gR2-12cR1segment prealloc tasks1283177356408
11gR2-12cR1segment prealloc time (ms)128219198613
11gR2-12cR1segment prealloc ufs2cfs bytes128409018059
11gR2-12cR1segment total chunk allocation128322556951
8i-12cR1serializable aborts11793250745
8i-12cR1session connect time11678473874
8i-12cR1session cursor cache count64568260813
8i-12cR1session cursor cache hits643678609077
8i-12cR1session logical reads13143187968
12cR1-12cR1session logical reads in local numa group11564026751
12cR1-12cR1session logical reads in remote numa group13011877906
8i-12cR1session pga memory14148600571
8i-12cR1session pga memory max1507777907
8i-12cR1session stored procedure space1895486831
8i-12cR1session uga memory11856888586
8i-12cR1session uga memory max13840343119
9i-12cR1shared hash latch upgrades - no wait82488550671
9i-12cR1shared hash latch upgrades - wait83380476499
11gR1-12cR1shared io pool buffer get failure1281112447278
11gR1-12cR1shared io pool buffer get success1282964900499
12cR1-12cR1slave propagated tracked transactions128275867045
8i-12cR1sorts (disk)642533123502
8i-12cR1sorts (memory)642091983730
8i-12cR1sorts (rows)643757672740
10gR2-12cR1space was found by tune down128342698422
10gR2-12cR1space was not found by tune down128849561940
11gR1-12cR1spare statistic 1128230898549
11gR1-12cR1spare statistic 21283818030889
11gR1-12cR1spare statistic 3128686628667
11gR1-12cR1spare statistic 41283494279544
10gR2-12cR1sql area evicted643224599022
10gR2-12cR1sql area purged642763387941
10gR2-12cR1steps of tune down ret. in space pressure1283986010614
12cR1-12cR1storage index soft misses in bytes82809906174
8i-12cR1summed dirty queue length81683565474
8i-12cR1switch current to new buffer81312802324
8i-12cR1table fetch by rowid64681815839
8i-12cR1table fetch continued row641413702393
9i-11gR1table lookup prefetch client count81926456670
8i-12cR1table scan blocks gotten643741388076
8i-12cR1table scan rows gotten641400824662
8i-12cR1table scans (cache partitions)64133545664
8i-12cR1table scans (direct read)643355423586
8i-12cR1table scans (long tables)641042655239
8i-12cR1table scans (rowid ranges)641303412790
8i-12cR1table scans (short tables)64345141973
11gR2-12cR1temp space allocated (bytes)1280471097
11gR2-12cR1total cf enq hold time43653899408
8i-9itotal file opens8
11gR2-12cR1total number of cf enq holders4174183174
9i-12cR1total number of slots82223809671
10gR2-12cR1total number of times SMON posted128399827284
9i-12cR1total number of undo segments dropped1283623640507
12cR1-12cR1tracked rows128943642878
12cR1-12cR1tracked transactions1284230695614
8i-12cR1transaction lock background get time1283492664117
8i-12cR1transaction lock background gets1283977359732
8i-12cR1transaction lock foreground requests128185785666
8i-12cR1transaction lock foreground wait time1284033661655
8i-12cR1transaction rollbacks1283988650402
8i-12cR1transaction tables consistent read rollbacks1281396293204
8i-12cR1transaction tables consistent reads - undo records applied1281054055970
10gR2-12cR1tune down retentions in space pressure128142917891
10gR1-12cR1undo change vector size1281465971540
10gR2-12cR1undo segment header was pinned128248401831
10gR1-12cR1user I/O wait time13332107451
8i-12cR1user calls12882015696
8i-12cR1user commits1582481098
8i-12cR1user rollbacks13671147913
12cR1-12cR1very large tracked transactions1284033000846
9i-12cR1workarea executions - multipass643804491469
9i-12cR1workarea executions - onepass64798730793
9i-12cR1workarea executions - optimal643211650785
9i-12cR1workarea memory allocated642433935387
10gR1-12cR1write clones created for recovery84053425429
8i-12cR1write clones created in background82988965544
8i-12cR1write clones created in foreground84237693830
カスタム検索

★ORACLE案件承ります
▼ORACLE掲示板