Statistic | Total | per Second | per Trans |
Batched IO (bound) vector count | 15,467,365 | 429.32 | 42.34 |
Batched IO (full) vector count | 2,021,095 | 56.10 | 5.53 |
Batched IO (space) vector count | 0 | 0.00 | 0.00 |
Batched IO block miss count | 75,512,292 | 2,095.95 | 206.71 |
Batched IO buffer defrag count | 943,703 | 26.19 | 2.58 |
Batched IO double miss count | 4,671,906 | 129.68 | 12.79 |
Batched IO same unit count | 44,118,265 | 1,224.56 | 120.77 |
Batched IO single block count | 10,311,852 | 286.22 | 28.23 |
Batched IO slow jump count | 112,450 | 3.12 | 0.31 |
Batched IO vector block count | 23,588,116 | 654.72 | 64.57 |
Batched IO vector read count | 7,317,225 | 203.10 | 20.03 |
Block Cleanout Optim referenced | 205,621 | 5.71 | 0.56 |
CCursor + sql area evicted | 4,827 | 0.13 | 0.01 |
CLI BG ENQ | 12,008 | 0.33 | 0.03 |
CLI BG attempt Flush | 12,008 | 0.33 | 0.03 |
CLI Flstask create | 12,008 | 0.33 | 0.03 |
CLI Flush | 12,008 | 0.33 | 0.03 |
CLI Imm Wrt | 1 | 0.00 | 0.00 |
CPU used by this session | 19,849,566 | 550.95 | 54.34 |
CPU used when call started | 12,596,110 | 349.62 | 34.48 |
CR blocks created | 221,253 | 6.14 | 0.61 |
Cached Commit SCN referenced | 27,345,957 | 759.02 | 74.86 |
Commit SCN cached | 11,539,438 | 320.29 | 31.59 |
DBWR checkpoint buffers written | 10,337,534 | 286.93 | 28.30 |
DBWR checkpoints | 212 | 0.01 | 0.00 |
DBWR object drop buffers written | 28,266 | 0.78 | 0.08 |
DBWR parallel query checkpoint buffers written | 970 | 0.03 | 0.00 |
DBWR revisited being-written buffer | 8,696 | 0.24 | 0.02 |
DBWR tablespace checkpoint buffers written | 156,514 | 4.34 | 0.43 |
DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR transaction table writes | 28,843 | 0.80 | 0.08 |
DBWR undo block writes | 8,435,160 | 234.13 | 23.09 |
Effective IO time | 1,355,398,254 | 37,620.95 | 3,710.30 |
HSC Heap Segment Block Changes | 139,381,253 | 3,868.72 | 381.55 |
HSC IDL Compressed Blocks | 5,884 | 0.16 | 0.02 |
Heap Segment Array Inserts | 7,812,933 | 216.86 | 21.39 |
Heatmap BlkLevel Flushed | 51,207 | 1.42 | 0.14 |
Heatmap BlkLevel Flushed to BF | 51,207 | 1.42 | 0.14 |
Heatmap BlkLevel Ranges Flushed | 213 | 0.01 | 0.00 |
Heatmap Blklevel Flush Task Count | 10 | 0.00 | 0.00 |
KTFB alloc req | 16,887 | 0.47 | 0.05 |
KTFB alloc space (block) | 710,785,105,920 | 19,728,823.63 | 1,945,719.92 |
KTFB alloc time (ms) | 269,318,948 | 7,475.32 | 737.24 |
KTFB apply req | 10,416 | 0.29 | 0.03 |
KTFB apply time (ms) | 464,317 | 12.89 | 1.27 |
KTFB commit req | 348 | 0.01 | 0.00 |
KTFB commit time (ms) | 303,356 | 8.42 | 0.83 |
KTFB free req | 8,386 | 0.23 | 0.02 |
KTFB free space (block) | 9,227,378 | 256.12 | 25.26 |
KTFB free time (ms) | 54,325 | 1.51 | 0.15 |
LOB table id lookup cache misses | 4 | 0.00 | 0.00 |
Number of read IOs issued | 9,002,669 | 249.88 | 24.64 |
OS Block input operations | 0 | 0.00 | 0.00 |
OS Block output operations | 0 | 0.00 | 0.00 |
OS Involuntary context switches | 0 | 0.00 | 0.00 |
OS Maximum resident set size | 0 | 0.00 | 0.00 |
OS Page faults | 0 | 0.00 | 0.00 |
OS Page reclaims | 0 | 0.00 | 0.00 |
OS System time used | 0 | 0.00 | 0.00 |
OS User time used | 0 | 0.00 | 0.00 |
OS Voluntary context switches | 0 | 0.00 | 0.00 |
Parallel operations downgraded to serial | 0 | 0.00 | 0.00 |
Requests to/from client | 17,721,576 | 491.89 | 48.51 |
RowCR - row contention | 9,066 | 0.25 | 0.02 |
RowCR attempts | 363,119 | 10.08 | 0.99 |
RowCR hits | 355,890 | 9.88 | 0.97 |
SMON posted for undo segment shrink | 962 | 0.03 | 0.00 |
SQL*Net roundtrips to/from client | 17,727,089 | 492.04 | 48.53 |
TBS Extension: bytes extended | 0 | 0.00 | 0.00 |
TBS Extension: files extended | 0 | 0.00 | 0.00 |
TBS Extension: tasks created | 212 | 0.01 | 0.00 |
TBS Extension: tasks executed | 0 | 0.00 | 0.00 |
active txn count during cleanout | 24,423,150 | 677.90 | 66.86 |
background checkpoints completed | 73 | 0.00 | 0.00 |
background checkpoints started | 72 | 0.00 | 0.00 |
background timeouts | 251,713 | 6.99 | 0.69 |
branch node splits | 313 | 0.01 | 0.00 |
buffer is not pinned count | 11,117,962,030 | 308,594.41 | 30,434.57 |
buffer is pinned count | 7,000,363,804 | 194,304.78 | 19,162.96 |
bytes received via SQL*Net from client | 470,393,906,015 | 13,056,433.42 | 1,287,667.38 |
bytes sent via SQL*Net to client | 578,887,102,351 | 16,067,812.13 | 1,584,659.21 |
bytes via SQL*Net vector to client | 3,482,422 | 96.66 | 9.53 |
calls to get snapshot scn: kcmgss | 346,648,709 | 9,621.71 | 948.92 |
calls to kcmgas | 8,433,373 | 234.08 | 23.09 |
calls to kcmgcs | 109,784,235 | 3,047.21 | 300.53 |
cell physical IO interconnect bytes | 87,839,085,069,824 | 2,438,095,287.88 | 240,452,783.74 |
change write time | 3,398,073 | 94.32 | 9.30 |
cleanout - number of ktugct calls | 35,351,269 | 981.22 | 96.77 |
cleanouts and rollbacks - consistent read gets | 101,837 | 2.83 | 0.28 |
cleanouts only - consistent read gets | 1,885,955 | 52.35 | 5.16 |
cluster key scan block gets | 535,120,699 | 14,853.02 | 1,464.85 |
cluster key scans | 529,468,217 | 14,696.12 | 1,449.38 |
commit batch performed | 0 | 0.00 | 0.00 |
commit batch requested | 0 | 0.00 | 0.00 |
commit batch/immediate performed | 23,987 | 0.67 | 0.07 |
commit batch/immediate requested | 23,987 | 0.67 | 0.07 |
commit cleanout failures: block lost | 37,611,276 | 1,043.95 | 102.96 |
commit cleanout failures: buffer being written | 708,158 | 19.66 | 1.94 |
commit cleanout failures: cannot pin | 21,033 | 0.58 | 0.06 |
commit cleanouts | 127,774,724 | 3,546.56 | 349.77 |
commit immediate performed | 23,987 | 0.67 | 0.07 |
commit immediate requested | 23,987 | 0.67 | 0.07 |
commit txn count during cleanout | 95,388,598 | 2,647.64 | 261.12 |
consistent changes | 3,466,733 | 96.22 | 9.49 |
consistent gets | 15,052,273,775 | 417,796.68 | 41,204.45 |
consistent gets direct | 8,421,237,010 | 233,743.08 | 23,052.49 |
consistent gets examination | 1,939,763,492 | 53,840.82 | 5,309.95 |
consistent gets examination (fastpath) | 1,938,317,364 | 53,800.68 | 5,306.00 |
consistent gets from cache | 6,631,036,784 | 184,053.60 | 18,151.96 |
consistent gets pin | 4,691,273,318 | 130,212.78 | 12,842.00 |
consistent gets pin (fastpath) | 4,476,967,199 | 124,264.42 | 12,255.36 |
cursor authentications | 786 | 0.02 | 0.00 |
cursor reload failures | 44 | 0.00 | 0.00 |
data blocks consistent reads - undo records applied | 5,672,661 | 157.45 | 15.53 |
db block changes | 918,347,056 | 25,489.99 | 2,513.90 |
db block gets | 1,441,016,733 | 39,997.41 | 3,944.67 |
db block gets direct | 1,498,292 | 41.59 | 4.10 |
db block gets from cache | 1,439,518,441 | 39,955.83 | 3,940.57 |
db block gets from cache (fastpath) | 877,686,693 | 24,361.41 | 2,402.60 |
deferred (CURRENT) block cleanout applications | 12,943,028 | 359.25 | 35.43 |
dirty buffers inspected | 114,297,538 | 3,172.49 | 312.88 |
enqueue conversions | 677,719 | 18.81 | 1.86 |
enqueue releases | 21,676,574 | 601.66 | 59.34 |
enqueue requests | 21,678,045 | 601.70 | 59.34 |
enqueue timeouts | 1,436 | 0.04 | 0.00 |
enqueue waits | 235,450 | 6.54 | 0.64 |
exchange deadlocks | 80,528 | 2.24 | 0.22 |
execute count | 321,316,420 | 8,918.58 | 879.58 |
failed probes on index block reclamation | 79 | 0.00 | 0.00 |
fastpath consistent get quota limit | 147,900,314 | 4,105.18 | 404.87 |
file io service time | 111,039,704 | 3,082.06 | 303.96 |
flashback cache read optimizations for block new | 1,227,443 | 34.07 | 3.36 |
flashback direct read optimizations for block new | 0 | 0.00 | 0.00 |
flashback log write bytes | 1,096,865,095,680 | 30,445,007.70 | 3,002,584.39 |
flashback log writes | 2,535,054 | 70.36 | 6.94 |
frame signature mismatch | 0 | 0.00 | 0.00 |
free buffer inspected | 851,662,050 | 23,639.06 | 2,331.36 |
free buffer requested | 1,371,329,890 | 38,063.16 | 3,753.91 |
heap block compress | 164,233 | 4.56 | 0.45 |
hot buffers moved to head of LRU | 3,128,678 | 86.84 | 8.56 |
immediate (CR) block cleanout applications | 1,987,792 | 55.17 | 5.44 |
immediate (CURRENT) block cleanout applications | 2,438,203 | 67.68 | 6.67 |
index crx upgrade (positioned) | 516 | 0.01 | 0.00 |
index crx upgrade (prefetch) | 5,612 | 0.16 | 0.02 |
index fast full scans (full) | 296,161 | 8.22 | 0.81 |
index fetch by key | 2,360,859,636 | 65,528.92 | 6,462.67 |
index scans kdiixs1 | 401,146,984 | 11,134.39 | 1,098.11 |
leaf node 90-10 splits | 25,975 | 0.72 | 0.07 |
leaf node splits | 329,752 | 9.15 | 0.90 |
lob reads | 229,193 | 6.36 | 0.63 |
lob writes | 234,181 | 6.50 | 0.64 |
lob writes unaligned | 234,144 | 6.50 | 0.64 |
logical read bytes from cache | 142,706,015,461,376 | 3,961,002,822.06 | 390,646,813.40 |
logons cumulative | 6,595 | 0.18 | 0.02 |
max cf enq hold time | 12,270 | 0.34 | 0.03 |
messages received | 18,512,417 | 513.84 | 50.68 |
messages sent | 18,512,385 | 513.84 | 50.68 |
min active SCN optimization applied on CR | 10,038,081 | 278.62 | 27.48 |
no buffer to keep pinned count | 491 | 0.01 | 0.00 |
no work - consistent read gets | 13,041,880,263 | 361,995.42 | 35,701.15 |
non-idle wait count | 351,596,674 | 9,759.05 | 962.47 |
opened cursors cumulative | 319,692,005 | 8,873.49 | 875.13 |
parse count (describe) | 0 | 0.00 | 0.00 |
parse count (failures) | 162 | 0.00 | 0.00 |
parse count (hard) | 5,489 | 0.15 | 0.02 |
parse count (total) | 2,586,749 | 71.80 | 7.08 |
parse time cpu | 14,491 | 0.40 | 0.04 |
parse time elapsed | 22,482 | 0.62 | 0.06 |
physical read IO requests | 380,456,786 | 10,560.10 | 1,041.47 |
physical read bytes | 67,183,322,669,056 | 1,864,766,035.45 | 183,909,212.44 |
physical read total IO requests | 230,868,337 | 6,408.07 | 631.98 |
physical read total bytes | 74,371,577,815,040 | 2,064,285,998.41 | 203,586,511.66 |
physical read total multi block requests | 61,343,033 | 1,702.66 | 167.92 |
physical reads | 2,066,667,384 | 57,363.21 | 5,657.34 |
physical reads cache | 843,393,870 | 23,409.56 | 2,308.73 |
physical reads cache prefetch | 669,829,251 | 18,592.04 | 1,833.61 |
physical reads direct | 1,223,273,514 | 33,953.65 | 3,348.62 |
physical reads direct (lob) | 1,133 | 0.03 | 0.00 |
physical reads direct temporary tablespace | 16,474,961 | 457.29 | 45.10 |
physical reads for flashback new | 23,373,939 | 648.78 | 63.98 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical reads retry corrupt | 0 | 0.00 | 0.00 |
physical write IO requests | 103,845,190 | 2,882.37 | 284.27 |
physical write bytes | 4,536,756,723,712 | 125,923,957.22 | 12,419,024.89 |
physical write total IO requests | 117,183,786 | 3,252.60 | 320.78 |
physical write total bytes | 13,467,507,254,784 | 373,809,289.47 | 36,866,272.08 |
physical write total multi block requests | 16,927,276 | 469.84 | 46.34 |
physical writes | 159,551,333 | 4,428.57 | 436.76 |
physical writes direct | 18,124,802 | 503.08 | 49.62 |
physical writes direct (lob) | 9,937 | 0.28 | 0.03 |
physical writes direct temporary tablespace | 17,927,327 | 497.60 | 49.07 |
physical writes from cache | 141,426,531 | 3,925.49 | 387.14 |
physical writes non checkpoint | 138,731,627 | 3,850.69 | 379.77 |
pinned buffers inspected | 109,101 | 3.03 | 0.30 |
pinned cursors current | 0 | 0.00 | 0.00 |
prefetch clients - 32k | 0 | 0.00 | 0.00 |
prefetch clients - default | 0 | 0.00 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetch warmup blocks flushed out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 13,835,760 | 384.03 | 37.87 |
process last non-idle time | 36,000 | 1.00 | 0.10 |
recovery blocks read | 0 | 0.00 | 0.00 |
recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
recursive calls | 329,643,942 | 9,149.72 | 902.38 |
recursive cpu usage | 4,441,340 | 123.28 | 12.16 |
redo KB read | 1,297,169,813 | 36,004.74 | 3,550.90 |
redo KB read (memory) | 647,992,724 | 17,985.93 | 1,773.83 |
redo blocks checksummed by FG (exclusive) | 983,350,052 | 27,294.24 | 2,691.85 |
redo blocks read for recovery | 0 | 0.00 | 0.00 |
redo blocks written | 1,303,310,160 | 36,175.18 | 3,567.71 |
redo blocks written (group 0) | 1,259,298,670 | 34,953.58 | 3,447.23 |
redo blocks written (group 1) | 43,881,929 | 1,218.00 | 120.12 |
redo buffer allocation retries | 4,391 | 0.12 | 0.01 |
redo entries | 623,597,846 | 17,308.82 | 1,707.05 |
redo entries for lost write detection | 111,639,980 | 3,098.72 | 305.61 |
redo k-bytes read for recovery | 0 | 0.00 | 0.00 |
redo log space requests | 2,562 | 0.07 | 0.01 |
redo ordering marks | 240,578 | 6.68 | 0.66 |
redo size | 645,683,822,080 | 17,921,847.46 | 1,767,510.13 |
redo size for direct writes | 578,075,468 | 16,045.28 | 1,582.44 |
redo size for lost write detection | 13,071,205,608 | 362,809.39 | 35,781.43 |
redo subscn max counts | 2,603,449 | 72.26 | 7.13 |
redo synch long waits | 5 | 0.00 | 0.00 |
redo synch time | 276,754 | 7.68 | 0.76 |
redo synch time (usec) | 2,766,574,908 | 76,790.11 | 7,573.29 |
redo synch time overhead (usec) | 3,487,284,409 | 96,794.40 | 9,546.17 |
redo synch time overhead count ( 2ms) | 351,039 | 9.74 | 0.96 |
redo synch time overhead count ( 8ms) | 16,636 | 0.46 | 0.05 |
redo synch time overhead count ( 32ms) | 13,866 | 0.38 | 0.04 |
redo synch time overhead count (128ms) | 10,007 | 0.28 | 0.03 |
redo synch time overhead count (inf) | 5,472 | 0.15 | 0.01 |
redo synch writes | 444,512 | 12.34 | 1.22 |
redo wastage | 464,630,776 | 12,896.47 | 1,271.89 |
redo write finish time | 9,571,805,978 | 265,678.71 | 26,202.09 |
redo write gather time | 225,097,225 | 6,247.88 | 616.19 |
redo write info find | 397,028 | 11.02 | 1.09 |
redo write info find fail | 8 | 0.00 | 0.00 |
redo write schedule time | 227,892,363 | 6,325.47 | 623.84 |
redo write size count ( 4KB) | 2,435 | 0.07 | 0.01 |
redo write size count ( 8KB) | 3,503 | 0.10 | 0.01 |
redo write size count ( 16KB) | 8,857 | 0.25 | 0.02 |
redo write size count ( 32KB) | 19,021 | 0.53 | 0.05 |
redo write size count ( 128KB) | 129,761 | 3.60 | 0.36 |
redo write size count ( 256KB) | 152,181 | 4.22 | 0.42 |
redo write size count ( 512KB) | 190,463 | 5.29 | 0.52 |
redo write size count (1024KB) | 192,780 | 5.35 | 0.53 |
redo write size count (inf) | 252,407 | 7.01 | 0.69 |
redo write time | 957,352 | 26.57 | 2.62 |
redo write time (usec) | 9,573,523,109 | 265,726.37 | 26,206.79 |
redo write total time | 9,637,183,618 | 267,493.36 | 26,381.05 |
redo write worker delay (usec) | 43,784,052 | 1,215.29 | 119.86 |
redo writes | 951,408 | 26.41 | 2.60 |
redo writes (group 0) | 901,305 | 25.02 | 2.47 |
redo writes (group 1) | 50,031 | 1.39 | 0.14 |
redo writes adaptive all | 951,408 | 26.41 | 2.60 |
redo writes adaptive worker | 951,336 | 26.41 | 2.60 |
remote Oradebug requests | 0 | 0.00 | 0.00 |
rollback changes - undo records applied | 87,337 | 2.42 | 0.24 |
rollbacks only - consistent read gets | 190,229 | 5.28 | 0.52 |
root node splits | 18 | 0.00 | 0.00 |
rows fetched via callback | 40,736,157 | 1,130.69 | 111.51 |
securefile allocation bytes | 313,745,408 | 8,708.44 | 858.85 |
securefile allocation chunks | 9,847 | 0.27 | 0.03 |
securefile bytes non-transformed | 276,387,815 | 7,671.53 | 756.59 |
securefile direct read bytes | 37,126,144 | 1,030.49 | 101.63 |
securefile direct read ops | 1,133 | 0.03 | 0.00 |
securefile direct write bytes | 313,745,408 | 8,708.44 | 858.85 |
securefile direct write ops | 9,847 | 0.27 | 0.03 |
securefile number of non-transformed flushes | 89,956 | 2.50 | 0.25 |
segment cfs allocations | 0 | 0.00 | 0.00 |
segment chunks allocation from disepnser | 9,847 | 0.27 | 0.03 |
segment dispenser allocations | 9,846 | 0.27 | 0.03 |
segment dispenser load empty | 0 | 0.00 | 0.00 |
segment dispenser load tasks | 7 | 0.00 | 0.00 |
segment prealloc bytes | 4,194,304 | 116.42 | 11.48 |
segment prealloc ops | 2,661 | 0.07 | 0.01 |
segment prealloc tasks | 2,509 | 0.07 | 0.01 |
segment prealloc time (ms) | 2,480,244 | 68.84 | 6.79 |
segment prealloc ufs2cfs bytes | 70,877,184 | 1,967.29 | 194.02 |
segment total chunk allocation | 0 | 0.00 | 0.00 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 378,969 | 10.52 | 1.04 |
session logical reads | 16,493,289,466 | 457,794.06 | 45,149.12 |
shared hash latch upgrades - no wait | 87,179,587 | 2,419.79 | 238.65 |
shared hash latch upgrades - wait | 2,706,088 | 75.11 | 7.41 |
shared io pool buffer get success | 10,946 | 0.30 | 0.03 |
sorts (disk) | 40 | 0.00 | 0.00 |
sorts (memory) | 2,382,679 | 66.13 | 6.52 |
sorts (rows) | 3,976,403,644 | 110,370.58 | 10,885.10 |
sql area evicted | 2,091 | 0.06 | 0.01 |
sql area purged | 769 | 0.02 | 0.00 |
summed dirty queue length | 892,366,472 | 24,768.87 | 2,442.79 |
switch current to new buffer | 440,791 | 12.23 | 1.21 |
table fetch by rowid | 4,512,471,883 | 125,249.90 | 12,352.55 |
table fetch continued row | 1,201,300,494 | 33,343.76 | 3,288.47 |
table scan blocks gotten | 2,325,337,706 | 64,542.96 | 6,365.43 |
table scan disk non-IMC rows gotten | 86,770,157,554 | 2,408,425.73 | 237,526.68 |
table scan rows gotten | 86,770,813,125 | 2,408,443.92 | 237,528.47 |
table scans (direct read) | 3,434 | 0.10 | 0.01 |
table scans (long tables) | 3,492 | 0.10 | 0.01 |
table scans (short tables) | 2,227,905 | 61.84 | 6.10 |
temp space allocated (bytes) | 262,144,000 | 7,276.17 | 717.60 |
total cf enq hold time | 1,029,160 | 28.57 | 2.82 |
total number of cf enq holders | 93,771 | 2.60 | 0.26 |
total number of times SMON posted | 18,550 | 0.51 | 0.05 |
transaction rollbacks | 22,896 | 0.64 | 0.06 |
transaction tables consistent read rollbacks | 1,649 | 0.05 | 0.00 |
transaction tables consistent reads - undo records applied | 153,533 | 4.26 | 0.42 |
undo change vector size | 64,184,255,416 | 1,781,522.78 | 175,699.49 |
user calls | 19,918,749 | 552.87 | 54.53 |
user commits | 356,616 | 9.90 | 0.98 |
user logons cumulative | 4,193 | 0.12 | 0.01 |
user logouts cumulative | 4,143 | 0.11 | 0.01 |
user rollbacks | 8,691 | 0.24 | 0.02 |
workarea executions - multipass | 0 | 0.00 | 0.00 |
workarea executions - onepass | 76 | 0.00 | 0.00 |
workarea executions - optimal | 2,983,582 | 82.81 | 8.17 |
write clones created in background | 1,686 | 0.05 | 0.00 |
write clones created in foreground | 564,962 | 15.68 | 1.55 |