-
Notifications
You must be signed in to change notification settings - Fork 18
/
oltpscalereport.html
128 lines (88 loc) · 3.48 KB
/
oltpscalereport.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
<!-- Creator : groff version 1.22.3 -->
<!-- CreationDate: Thu Sep 28 15:49:45 2023 -->
<!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>oltpscalereport</title>
</head>
<body>
<h1 align="center">oltpscalereport</h1>
<a href="#NAME">NAME</a><br>
<a href="#SYNOPSIS">SYNOPSIS</a><br>
<a href="#OPTIONS">OPTIONS</a><br>
<a href="#USAGE">USAGE</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">oltpscalereport
− Create a scaling report</p>
<h2>SYNOPSIS
<a name="SYNOPSIS"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em"><b>oltpscalereport
[-H] [--xrange=[0:n] ] [--yrange=[0:n] ] [--y2range=[0:m] ]
key [report title]</b></p>
<p style="margin-left:11%; margin-top: 1em">Recreate the
scaling report that is created using <b>oltpscale</b></p>
<h2>OPTIONS
<a name="OPTIONS"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em"><b>-H|--help</b></p>
<p style="margin-left:17%;">Print command usage.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--xrange=’[0:n]’</b></p>
<p style="margin-left:17%;">Set the xrange specification
for gnuplot to plot process count.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--yrange=’[0:n]’</b></p>
<p style="margin-left:17%;">Set the yrange specification
for gnuplot to plot database CPU and time.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--y2range=’[0:n]’</b></p>
<p style="margin-left:17%;">Set the y2range specification
for gnuplot to plot throughput.</p>
<h2>USAGE
<a name="USAGE"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">By default,
gnuplot finds a suitable range for the x and y axes that are
set such that the actual data are well represented and no
data is out of range. If you make several executions of
<b>oltpscale</b> that you want to compare, you may therefore
have reports that have different left (yrange) and right
(y2range) y axes. The left y-axis shows the db CPU and db
time, the right shows the throughput.</p>
<p style="margin-left:11%; margin-top: 1em">You can
recreate the report for some key with new gnuplot settings
for these two axes.</p>
<p style="margin-left:11%; margin-top: 1em">You can
similarly make the plots include same range of processes by
setting the xrange.</p>
<p style="margin-left:11%; margin-top: 1em">The key is a
compulsory argument and you can provide addition text for
your graphs and html files if needed.</p>
<h2>COPYRIGHT
<a name="COPYRIGHT"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">Copyright
© 2023 Oracle Corporation <br>
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="oltp.html">oltp(2rwl)</a>,
<a href="oltpscale.html">oltpscale(2rwl)</a>, <a href="oltpcheckkey.html">oltpcheckkey(2rwl)</a></p>
<hr>
</body>
</html>