Oracle table scan performance metrics & CPU counters by Tanel Poder
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Constants:
Cache Line Size (bytes)
Number of rows in test table
2
6469,642,625
3
4
Metric
INDEX BUFCACHE BAD CF
INDEX BUFCACHE GOOD CF
TABLE BUFCACHE
TABLE INMEMORY PRED
TABLE INMEMORY NO PRED
TABLE BUFCACHE HCC
5
task-clock-ms123,44038,80827,3741,5784774,897
6
cycles 391,579,324,969121,801,871,71886,428,653,0404,573,793,7241,387,831,99415,001,366,058
7
instructions 288,941,288,284151,255,447,17232,115,412,8777,080,326,2422,999,496,67721,298,907,978
8
branches 58,376,159,85230,293,259,2307,386,220,210940,579,984416,320,8164,354,197,461
9
branch-misses 175,115,32549,678,23022,056,3974,637,2431,734,73458,231,834
10
stalled-cycles-frontend292,420,163,88174,585,632,12176,697,049,4202,251,325,295341,458,2566,700,565,245
11
stalled-cycles-backend 203,595,215,08444,415,389,63458,627,393,3951,328,333,827229,309,5954,930,717,330
12
cache-references 1,538,720,017328,576,324256,440,38411,507,915799,09148,367,880
13
cache-misses 1,231,807,162245,481,047222,036,9817,316,366175,38215,253,634
14
LLC-loads 1,314,782,881284,245,214234,361,1899,712,269259,84022,233,999
15
LLC-load-misses 1,117,647,753241,085,971218,570,2947,272,805157,11313,804,662
16
LLC-stores 428,372,37333,948,50218,493,5821,697,666413,95014,738,894
17
LLC-store-misses 112,819,5933,964,4633,233,23127,7976,5081,368,665
18
L1-dcache-loads 88,635,191,68243,834,061,2967,324,946,0421,069,917,316415,639,0794,491,195,871
19
L1-dcache-load-misses
2,381,219,491515,048,945305,276,34185,368,1599,117,936227,727,782
20
L1-dcache-prefetches
124,654,97973,912,22836,890,30225,169,2538,209,43144,843,477
21
Instructions-per-cycle0.741.240.371.552.161.42
22
LLC-read-estimated-bytes
84,146,104,38418,191,693,69614,999,116,096621,585,21616,629,7601,422,975,936
23
LLC-miss-estimated-bytes
71,529,456,19215,429,502,14413,988,498,816465,459,52010,055,232883,498,368
24
LLC-store-estimated-bytes
27,415,831,8722,172,704,1281,183,589,248108,650,62426,492,800943,289,216
25
task-clock-us123,439,52138,808,29927,373,8201,577,838476,9154,897,167
26
logical-reads64,245,09310,224,4461,611,8741,611,7961,611,7961,266,446
27
instructions-per-row4149217246110243306
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Data
Cycles-Instructions
Chart-Cache-Memory
Chart-Cache-Memory MB
Pivot
LIOs