Instance Activity Statistics

Back to Top

Key Instance Activity Stats

StatisticTotalper Secondper Trans
db block changes918,347,05625,489.992,513.90
execute count321,316,4208,918.58879.58
logons cumulative6,5950.180.02
opened cursors cumulative319,692,0058,873.49875.13
parse count (total)2,586,74971.807.08
parse time elapsed22,4820.620.06
physical reads2,066,667,38457,363.215,657.34
physical writes159,551,3334,428.57436.76
redo size645,683,822,08017,921,847.461,767,510.13
session cursor cache hits378,96910.521.04
session logical reads16,493,289,466457,794.0645,149.12
user calls19,918,749552.8754.53
user commits356,6169.900.98
user rollbacks8,6910.240.02
workarea executions - multipass00.000.00
workarea executions - onepass760.000.00
workarea executions - optimal2,983,58282.818.17


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count15,467,365429.3242.34
Batched IO (full) vector count2,021,09556.105.53
Batched IO (space) vector count00.000.00
Batched IO block miss count75,512,2922,095.95206.71
Batched IO buffer defrag count943,70326.192.58
Batched IO double miss count4,671,906129.6812.79
Batched IO same unit count44,118,2651,224.56120.77
Batched IO single block count10,311,852286.2228.23
Batched IO slow jump count112,4503.120.31
Batched IO vector block count23,588,116654.7264.57
Batched IO vector read count7,317,225203.1020.03
Block Cleanout Optim referenced205,6215.710.56
CCursor + sql area evicted4,8270.130.01
CLI BG ENQ12,0080.330.03
CLI BG attempt Flush12,0080.330.03
CLI Flstask create12,0080.330.03
CLI Flush12,0080.330.03
CLI Imm Wrt10.000.00
CPU used by this session19,849,566550.9554.34
CPU used when call started12,596,110349.6234.48
CR blocks created221,2536.140.61
Cached Commit SCN referenced27,345,957759.0274.86
Commit SCN cached11,539,438320.2931.59
DBWR checkpoint buffers written10,337,534286.9328.30
DBWR checkpoints2120.010.00
DBWR object drop buffers written28,2660.780.08
DBWR parallel query checkpoint buffers written9700.030.00
DBWR revisited being-written buffer8,6960.240.02
DBWR tablespace checkpoint buffers written156,5144.340.43
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes28,8430.800.08
DBWR undo block writes8,435,160234.1323.09
Effective IO time1,355,398,25437,620.953,710.30
HSC Heap Segment Block Changes139,381,2533,868.72381.55
HSC IDL Compressed Blocks5,8840.160.02
Heap Segment Array Inserts7,812,933216.8621.39
Heatmap BlkLevel Flushed51,2071.420.14
Heatmap BlkLevel Flushed to BF51,2071.420.14
Heatmap BlkLevel Ranges Flushed2130.010.00
Heatmap Blklevel Flush Task Count100.000.00
KTFB alloc req16,8870.470.05
KTFB alloc space (block)710,785,105,92019,728,823.631,945,719.92
KTFB alloc time (ms)269,318,9487,475.32737.24
KTFB apply req10,4160.290.03
KTFB apply time (ms)464,31712.891.27
KTFB commit req3480.010.00
KTFB commit time (ms)303,3568.420.83
KTFB free req8,3860.230.02
KTFB free space (block)9,227,378256.1225.26
KTFB free time (ms)54,3251.510.15
LOB table id lookup cache misses40.000.00
Number of read IOs issued9,002,669249.8824.64
OS Block input operations00.000.00
OS Block output operations00.000.00
OS Involuntary context switches00.000.00
OS Maximum resident set size00.000.00
OS Page faults00.000.00
OS Page reclaims00.000.00
OS System time used00.000.00
OS User time used00.000.00
OS Voluntary context switches00.000.00
Parallel operations downgraded to serial00.000.00
Requests to/from client17,721,576491.8948.51
RowCR - row contention9,0660.250.02
RowCR attempts363,11910.080.99
RowCR hits355,8909.880.97
SMON posted for undo segment shrink9620.030.00
SQL*Net roundtrips to/from client17,727,089492.0448.53
TBS Extension: bytes extended00.000.00
TBS Extension: files extended00.000.00
TBS Extension: tasks created2120.010.00
TBS Extension: tasks executed00.000.00
active txn count during cleanout24,423,150677.9066.86
background checkpoints completed730.000.00
background checkpoints started720.000.00
background timeouts251,7136.990.69
branch node splits3130.010.00
buffer is not pinned count11,117,962,030308,594.4130,434.57
buffer is pinned count7,000,363,804194,304.7819,162.96
bytes received via SQL*Net from client470,393,906,01513,056,433.421,287,667.38
bytes sent via SQL*Net to client578,887,102,35116,067,812.131,584,659.21
bytes via SQL*Net vector to client3,482,42296.669.53
calls to get snapshot scn: kcmgss346,648,7099,621.71948.92
calls to kcmgas8,433,373234.0823.09
calls to kcmgcs109,784,2353,047.21300.53
cell physical IO interconnect bytes87,839,085,069,8242,438,095,287.88240,452,783.74
change write time3,398,07394.329.30
cleanout - number of ktugct calls35,351,269981.2296.77
cleanouts and rollbacks - consistent read gets101,8372.830.28
cleanouts only - consistent read gets1,885,95552.355.16
cluster key scan block gets535,120,69914,853.021,464.85
cluster key scans529,468,21714,696.121,449.38
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed23,9870.670.07
commit batch/immediate requested23,9870.670.07
commit cleanout failures: block lost37,611,2761,043.95102.96
commit cleanout failures: buffer being written708,15819.661.94
commit cleanout failures: cannot pin21,0330.580.06
commit cleanouts127,774,7243,546.56349.77
commit immediate performed23,9870.670.07
commit immediate requested23,9870.670.07
commit txn count during cleanout95,388,5982,647.64261.12
consistent changes3,466,73396.229.49
consistent gets15,052,273,775417,796.6841,204.45
consistent gets direct8,421,237,010233,743.0823,052.49
consistent gets examination1,939,763,49253,840.825,309.95
consistent gets examination (fastpath)1,938,317,36453,800.685,306.00
consistent gets from cache6,631,036,784184,053.6018,151.96
consistent gets pin4,691,273,318130,212.7812,842.00
consistent gets pin (fastpath)4,476,967,199124,264.4212,255.36
cursor authentications7860.020.00
cursor reload failures440.000.00
data blocks consistent reads - undo records applied5,672,661157.4515.53
db block changes918,347,05625,489.992,513.90
db block gets1,441,016,73339,997.413,944.67
db block gets direct1,498,29241.594.10
db block gets from cache1,439,518,44139,955.833,940.57
db block gets from cache (fastpath)877,686,69324,361.412,402.60
deferred (CURRENT) block cleanout applications12,943,028359.2535.43
dirty buffers inspected114,297,5383,172.49312.88
enqueue conversions677,71918.811.86
enqueue releases21,676,574601.6659.34
enqueue requests21,678,045601.7059.34
enqueue timeouts1,4360.040.00
enqueue waits235,4506.540.64
exchange deadlocks80,5282.240.22
execute count321,316,4208,918.58879.58
failed probes on index block reclamation790.000.00
fastpath consistent get quota limit147,900,3144,105.18404.87
file io service time111,039,7043,082.06303.96
flashback cache read optimizations for block new1,227,44334.073.36
flashback direct read optimizations for block new00.000.00
flashback log write bytes1,096,865,095,68030,445,007.703,002,584.39
flashback log writes2,535,05470.366.94
frame signature mismatch00.000.00
free buffer inspected851,662,05023,639.062,331.36
free buffer requested1,371,329,89038,063.163,753.91
heap block compress164,2334.560.45
hot buffers moved to head of LRU3,128,67886.848.56
immediate (CR) block cleanout applications1,987,79255.175.44
immediate (CURRENT) block cleanout applications2,438,20367.686.67
index crx upgrade (positioned)5160.010.00
index crx upgrade (prefetch)5,6120.160.02
index fast full scans (full)296,1618.220.81
index fetch by key2,360,859,63665,528.926,462.67
index scans kdiixs1401,146,98411,134.391,098.11
leaf node 90-10 splits25,9750.720.07
leaf node splits329,7529.150.90
lob reads229,1936.360.63
lob writes234,1816.500.64
lob writes unaligned234,1446.500.64
logical read bytes from cache142,706,015,461,3763,961,002,822.06390,646,813.40
logons cumulative6,5950.180.02
max cf enq hold time12,2700.340.03
messages received18,512,417513.8450.68
messages sent18,512,385513.8450.68
min active SCN optimization applied on CR10,038,081278.6227.48
no buffer to keep pinned count4910.010.00
no work - consistent read gets13,041,880,263361,995.4235,701.15
non-idle wait count351,596,6749,759.05962.47
opened cursors cumulative319,692,0058,873.49875.13
parse count (describe)00.000.00
parse count (failures)1620.000.00
parse count (hard)5,4890.150.02
parse count (total)2,586,74971.807.08
parse time cpu14,4910.400.04
parse time elapsed22,4820.620.06
physical read IO requests380,456,78610,560.101,041.47
physical read bytes67,183,322,669,0561,864,766,035.45183,909,212.44
physical read total IO requests230,868,3376,408.07631.98
physical read total bytes74,371,577,815,0402,064,285,998.41203,586,511.66
physical read total multi block requests61,343,0331,702.66167.92
physical reads2,066,667,38457,363.215,657.34
physical reads cache843,393,87023,409.562,308.73
physical reads cache prefetch669,829,25118,592.041,833.61
physical reads direct1,223,273,51433,953.653,348.62
physical reads direct (lob)1,1330.030.00
physical reads direct temporary tablespace16,474,961457.2945.10
physical reads for flashback new23,373,939648.7863.98
physical reads prefetch warmup00.000.00
physical reads retry corrupt00.000.00
physical write IO requests103,845,1902,882.37284.27
physical write bytes4,536,756,723,712125,923,957.2212,419,024.89
physical write total IO requests117,183,7863,252.60320.78
physical write total bytes13,467,507,254,784373,809,289.4736,866,272.08
physical write total multi block requests16,927,276469.8446.34
physical writes159,551,3334,428.57436.76
physical writes direct18,124,802503.0849.62
physical writes direct (lob)9,9370.280.03
physical writes direct temporary tablespace17,927,327497.6049.07
physical writes from cache141,426,5313,925.49387.14
physical writes non checkpoint138,731,6273,850.69379.77
pinned buffers inspected109,1013.030.30
pinned cursors current00.000.00
prefetch clients - 32k00.000.00
prefetch clients - default00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetch warmup blocks flushed out before use00.000.00
prefetched blocks aged out before use13,835,760384.0337.87
process last non-idle time36,0001.000.10
recovery blocks read00.000.00
recursive aborts on index block reclamation00.000.00
recursive calls329,643,9429,149.72902.38
recursive cpu usage4,441,340123.2812.16
redo KB read1,297,169,81336,004.743,550.90
redo KB read (memory)647,992,72417,985.931,773.83
redo blocks checksummed by FG (exclusive)983,350,05227,294.242,691.85
redo blocks read for recovery00.000.00
redo blocks written1,303,310,16036,175.183,567.71
redo blocks written (group 0)1,259,298,67034,953.583,447.23
redo blocks written (group 1)43,881,9291,218.00120.12
redo buffer allocation retries4,3910.120.01
redo entries623,597,84617,308.821,707.05
redo entries for lost write detection111,639,9803,098.72305.61
redo k-bytes read for recovery00.000.00
redo log space requests2,5620.070.01
redo ordering marks240,5786.680.66
redo size645,683,822,08017,921,847.461,767,510.13
redo size for direct writes578,075,46816,045.281,582.44
redo size for lost write detection13,071,205,608362,809.3935,781.43
redo subscn max counts2,603,44972.267.13
redo synch long waits50.000.00
redo synch time276,7547.680.76
redo synch time (usec)2,766,574,90876,790.117,573.29
redo synch time overhead (usec)3,487,284,40996,794.409,546.17
redo synch time overhead count ( 2ms)351,0399.740.96
redo synch time overhead count ( 8ms)16,6360.460.05
redo synch time overhead count ( 32ms)13,8660.380.04
redo synch time overhead count (128ms)10,0070.280.03
redo synch time overhead count (inf)5,4720.150.01
redo synch writes444,51212.341.22
redo wastage464,630,77612,896.471,271.89
redo write finish time9,571,805,978265,678.7126,202.09
redo write gather time225,097,2256,247.88616.19
redo write info find397,02811.021.09
redo write info find fail80.000.00
redo write schedule time227,892,3636,325.47623.84
redo write size count ( 4KB)2,4350.070.01
redo write size count ( 8KB)3,5030.100.01
redo write size count ( 16KB)8,8570.250.02
redo write size count ( 32KB)19,0210.530.05
redo write size count ( 128KB)129,7613.600.36
redo write size count ( 256KB)152,1814.220.42
redo write size count ( 512KB)190,4635.290.52
redo write size count (1024KB)192,7805.350.53
redo write size count (inf)252,4077.010.69
redo write time957,35226.572.62
redo write time (usec)9,573,523,109265,726.3726,206.79
redo write total time9,637,183,618267,493.3626,381.05
redo write worker delay (usec)43,784,0521,215.29119.86
redo writes951,40826.412.60
redo writes (group 0)901,30525.022.47
redo writes (group 1)50,0311.390.14
redo writes adaptive all951,40826.412.60
redo writes adaptive worker951,33626.412.60
remote Oradebug requests00.000.00
rollback changes - undo records applied87,3372.420.24
rollbacks only - consistent read gets190,2295.280.52
root node splits180.000.00
rows fetched via callback40,736,1571,130.69111.51
securefile allocation bytes313,745,4088,708.44858.85
securefile allocation chunks9,8470.270.03
securefile bytes non-transformed276,387,8157,671.53756.59
securefile direct read bytes37,126,1441,030.49101.63
securefile direct read ops1,1330.030.00
securefile direct write bytes313,745,4088,708.44858.85
securefile direct write ops9,8470.270.03
securefile number of non-transformed flushes89,9562.500.25
segment cfs allocations00.000.00
segment chunks allocation from disepnser9,8470.270.03
segment dispenser allocations9,8460.270.03
segment dispenser load empty00.000.00
segment dispenser load tasks70.000.00
segment prealloc bytes4,194,304116.4211.48
segment prealloc ops2,6610.070.01
segment prealloc tasks2,5090.070.01
segment prealloc time (ms)2,480,24468.846.79
segment prealloc ufs2cfs bytes70,877,1841,967.29194.02
segment total chunk allocation00.000.00
session connect time00.000.00
session cursor cache hits378,96910.521.04
session logical reads16,493,289,466457,794.0645,149.12
shared hash latch upgrades - no wait87,179,5872,419.79238.65
shared hash latch upgrades - wait2,706,08875.117.41
shared io pool buffer get success10,9460.300.03
sorts (disk)400.000.00
sorts (memory)2,382,67966.136.52
sorts (rows)3,976,403,644110,370.5810,885.10
sql area evicted2,0910.060.01
sql area purged7690.020.00
summed dirty queue length892,366,47224,768.872,442.79
switch current to new buffer440,79112.231.21
table fetch by rowid4,512,471,883125,249.9012,352.55
table fetch continued row1,201,300,49433,343.763,288.47
table scan blocks gotten2,325,337,70664,542.966,365.43
table scan disk non-IMC rows gotten86,770,157,5542,408,425.73237,526.68
table scan rows gotten86,770,813,1252,408,443.92237,528.47
table scans (direct read)3,4340.100.01
table scans (long tables)3,4920.100.01
table scans (short tables)2,227,90561.846.10
temp space allocated (bytes)262,144,0007,276.17717.60
total cf enq hold time1,029,16028.572.82
total number of cf enq holders93,7712.600.26
total number of times SMON posted18,5500.510.05
transaction rollbacks22,8960.640.06
transaction tables consistent read rollbacks1,6490.050.00
transaction tables consistent reads - undo records applied153,5334.260.42
undo change vector size64,184,255,4161,781,522.78175,699.49
user calls19,918,749552.8754.53
user commits356,6169.900.98
user logons cumulative4,1930.120.01
user logouts cumulative4,1430.110.01
user rollbacks8,6910.240.02
workarea executions - multipass00.000.00
workarea executions - onepass760.000.00
workarea executions - optimal2,983,58282.818.17
write clones created in background1,6860.050.00
write clones created in foreground564,96215.681.55


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current211262
opened cursors current9081,506
session cursor cache count13,730,70513,853,193
session pga memory3,284,524,6483,601,492,464
session pga memory max11,939,683,68812,092,974,000
session uga memory208,023,965,864209,473,952,688
session uga memory max3,450,791,221,2803,508,524,603,824
workarea memory allocated5,1365,650


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)727.19


Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Direct Reads35.4T373.861G1.6G0.82.046M2.3M0.39
Buffer Cache Reads25T4982.62728.028M0M0.000M171.6M0.94
RMAN5.8T337.21169.587M4.7T148.06136.346M722.4K0.59
DBWR17M0.030M4T2856.70116.036M10650.50
Others1.4T706.8440.217M2.2T112.6464.804M27.3M1.29
LGWR625M1.12.017M1.2T111.3535.326M40.6K0.49
Direct Writes6.2G0.99.175M137G22.463.893M642.09
Streams AQ4.2G4.42.119M0M0.000M155.4K0.43
TOTAL:67.6T6407.081.9G12.2T3252.03356.452M202.1M0.98


Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Data File64.3T6135.751.8G4T2861.37116.187M0.421.33
Data File Incremental Backup0M0.000M3.1T89.8589.853M  
Archive Log1.6T90.8746.299M1.2T35.0034.996M0.542.94
Log File619.7G21.6917.613M1.2T111.1535.317M0.091.12
Archive Log Backup0M0.000M1.6T46.3046.301M  
Flashback Log6M0.020M1021.2G70.3829.024M0.48 
Data File Backup936.5G26.6226.617M0M0.000M0.620.89
Temp File136.2G20.883.872M136.8G20.643.888M0.711.87
Control File127.2G106.083.615M8.3G14.40.235M0.070.97
Other1.6G5.80.045M2.1G2.46.06M0.28 
TOTAL:67.6T6407.701.9G12.2T3251.56355.861M0.411.41


Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Direct Reads 35.4T373.841G1.6G0.82.046M2.3M0.39
Direct Reads (Data File) 35.3T311.271G1.6G0.82.046M0 
Direct Reads (Control File) 70.7G62.572.01M0M0.000M2.3M0.39
Direct Reads (Flashback Log) 3M0.000M0M0.000M1021.17
Buffer Cache Reads 25T4982.25728.016M0M0.000M171.6M0.94
Buffer Cache Reads (Data File) 25T4982.25728.016M0M0.000M171.6M0.94
RMAN 5.8T333.55169.635M4.7T148.03136.341M586.8K0.59
RMAN (Data File) 3.3T200.3696.152M77M0.07.002M19.7K1.11
RMAN (Data File Incremental Backup) 0M0.000M3.1T89.8589.849M0 
RMAN (Archive Log) 1.6T90.8746.301M0M0.000M11400.98
RMAN (Archive Log Backup) 0M0.000M1.6T46.3046.3M0 
RMAN (Data File Backup) 936.5G26.6226.616M0M0.000M641.00
RMAN (Control File) 19.9G15.70.566M6.7G11.81.19M565.9K0.57
DBWR 17M0.030M4T2856.43116.023M10650.50
DBWR (Data File) 0M0.000M4T2856.43116.023M0 
DBWR (Control File) 17M0.030M0M0.000M10650.50
Others 1.4T704.7840.208M2.2T110.2164.744M27.2M1.29
Others (Archive Log) 0M0.000M1.2T35.0034.996M0 
Others (Flashback Log) 5M0.010M1021.2G70.3829.024M2.5M5.80
Others (Data File) 763.2G660.8221.693M24G2.43.681M23.8M0.84
Others (Log File) 615.6G17.5117.498M0M0.000M5380.35
Others (Control File) 35.8G26.431.017M1.5G2.40.043M952.4K0.43
LGWR 625M1.12.017M1.2T111.3435.32M40.6K0.49
LGWR (Log File) 0M0.010M1.2T111.1535.317M5761.39
LGWR (Control File) 625M1.11.017M106M0.19.003M40K0.48
Direct Writes 6.2G0.99.175M137G22.463.893M642.09
Direct Writes (Data File) 6.2G0.99.175M137G22.463.893M642.09
Streams AQ 4.2G4.42.119M0M0.000M155.4K0.43
Streams AQ (Log File) 4.1G4.17.116M0M0.000M146.4K0.41
Streams AQ (Control File) 138M0.25.004M0M0.000M88480.63
Streams AQ (Data File) 1M0.010M0M0.000M2020.63
TOTAL: 67.6T6400.971.9G12.2T3249.30356.368M201.8M0.98


Back to IO Stats
Back to Top