-
Notifications
You must be signed in to change notification settings - Fork 18
/
histogram.html
166 lines (117 loc) · 4.12 KB
/
histogram.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
<!-- Creator : groff version 1.22.3 -->
<!-- CreationDate: Mon Mar 18 08:51:04 2024 -->
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta name="generator" content="groff -Thtml, see www.gnu.org">
<meta http-equiv="Content-Type" content="text/html; charset=US-ASCII">
<meta name="Content-Style" content="text/css">
<style type="text/css">
p { margin-top: 0; margin-bottom: 0; vertical-align: top }
pre { margin-top: 0; margin-bottom: 0; vertical-align: top }
table { margin-top: 0; margin-bottom: 0; vertical-align: top }
h1 { text-align: center }
</style>
<title>histogram</title>
</head>
<body>
<h1 align="center">histogram</h1>
<a href="#NAME">NAME</a><br>
<a href="#DECLARATION">DECLARATION</a><br>
<a href="#COLUMNS">COLUMNS</a><br>
<a href="#COPYRIGHT">COPYRIGHT</a><br>
<a href="#SEE ALSO">SEE ALSO</a><br>
<hr>
<h2>NAME
<a name="NAME"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">histogram
− RWP*Load Simulator histogram table and histogram_a,
fractiles views</p>
<h2>DECLARATION
<a name="DECLARATION"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">The
<b>histogram</b> table and associated views show the
distribution of total execution time, which is the sum of
the time spent waiting for a session and the time spent
execution the actual code of the procedure, over a series of
"buckets", each being twice is wide as the
previous one.</p>
<pre style="margin-left:11%; margin-top: 1em">create table histogram
( runnumber number not null
, procno number not null
, vname varchar2(30) not null
, buckno number not null
, bucktim number as (power(2.0,(buckno-19))) virtual
, bcount number
, ttime number (*,6)
, constraint histogram_pk primary key(runnumber, procno, vname, buckno)
)
create view histogram_a
( runnumber
, pcount
, vname
, buckno
, bucktim
, bcount
, ttime
, atime
)
create view fractiles
( runnumber
, vname
, bucktim
, bcount
, fractile
)</pre>
<h2>COLUMNS
<a name="COLUMNS"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em"><b>runnumber</b></p>
<p style="margin-left:17%;">This is the number that
uniquely identifies a run.</p>
<p style="margin-left:11%; margin-top: 1em"><b>procno
pcount</b></p>
<p style="margin-left:17%;">In single process runs, procno
is zero, in multi-process runs, it gets its value from the
Operating System process number or from the -p option to
rwloadsim. In the aggregate view, histogram_a, the total
process count is in the pcount column.</p>
<p style="margin-left:11%; margin-top: 1em"><b>vname</b></p>
<p style="margin-left:17%;">This is the name of the
procedure being executed.</p>
<p style="margin-left:11%; margin-top: 1em"><b>buckno</b></p>
<p style="margin-left:17%;">The number of this bucket.</p>
<p style="margin-left:11%; margin-top: 1em"><b>bucktim</b></p>
<p style="margin-left:17%;">This bucket covers the range
from 0.5*bucktim until bucktim, except the first bucket that
covers all positive number until bucktim.</p>
<p style="margin-left:11%; margin-top: 1em"><b>bcount</b></p>
<p style="margin-left:17%;">Number of executions that has a
time within the range of this bucket.</p>
<p style="margin-left:11%; margin-top: 1em"><b>ttime</b></p>
<p style="margin-left:17%;">Total time of all executions
that are within the range of this bucket.</p>
<p style="margin-left:11%; margin-top: 1em"><b>atime</b></p>
<p style="margin-left:17%;">Average time of all executions
that are within the range of this bucket.</p>
<p style="margin-left:11%; margin-top: 1em"><b>fractile</b></p>
<p style="margin-left:17%;">The percentage of executions
that are at least as fast as bucktim.</p>
<h2>COPYRIGHT
<a name="COPYRIGHT"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">Copyright
© 2023 Oracle Corporation</p>
<p style="margin-left:11%; margin-top: 1em">Licensed under
the Universal Permissive License v 1.0 as shown at
https://oss.oracle.com/licenses/upl</p>
<h2>SEE ALSO
<a name="SEE ALSO"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em"><a href="statistics.html">statistics(1rwl)</a></p>
<hr>
</body>
</html>