-
Notifications
You must be signed in to change notification settings - Fork 18
/
sysres.html
172 lines (128 loc) · 4.78 KB
/
sysres.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
167
168
169
170
171
172
<!-- Creator : groff version 1.22.3 -->
<!-- CreationDate: Wed Apr 24 12:34:37 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>sysres</title>
</head>
<body>
<h1 align="center">sysres</h1>
<a href="#NAME">NAME</a><br>
<a href="#DESCRIPTION">DESCRIPTION</a><br>
<a href="#DECLARATION">DECLARATION</a><br>
<a href="#COLUMNS">COLUMNS</a><br>
<a href="#EXAMPLE">EXAMPLE</a><br>
<a href="#NOTES">NOTES</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">sysres −
RWP*Load Simulator sysres table</p>
<h2>DESCRIPTION
<a name="DESCRIPTION"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">The sysres
table is not being used by rwloadsim itself; the user is
supposed to arrange for values to be inserted into the
table. To use this table, your rwl program or one of your
rwl programs in a multi-process run must include a thread
that every second executes queries against e.g. gv$ views of
your database being tested. The values should be inserted
into this table. The table is prepared to contain values
from several independent queries, which is done via
different values for the resname column.</p>
<p style="margin-left:11%; margin-top: 1em">The table is
being used in several standard workloads.</p>
<h2>DECLARATION
<a name="DECLARATION"></a>
</h2>
<pre style="margin-left:11%; margin-top: 1em">create table sysres
( runnumber number not null
, second number not null
, resname varchar2(10) not null
, constraint sysres_pk primary key(runnumber, resname, second)
, val1 number
, val2 number
, val3 number
, val4 number
, val5 number
, val6 number
, val7 number
, val8 number
, val9 number
)</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%;">You must arrange for your
rwloadsim program to insert the value of the runnumber
variable into this column.</p>
<p style="margin-left:11%; margin-top: 1em"><b>second</b></p>
<p style="margin-left:17%;">You must arrange for your
rwloadsim program to insert the value returned by
runseconds() into this column.</p>
<p style="margin-left:11%; margin-top: 1em"><b>resname</b></p>
<p style="margin-left:17%;">You must arrange for your
rwloadsim program to insert a text into this column that can
be used to identify the type of results inserted into the
valN columns.</p>
<p style="margin-left:11%; margin-top: 1em"><b>val1 val2
...</b></p>
<p style="margin-left:17%;">The usage is fully user
dependent, they should e.g. be based on appropriate queries
against gv$ views.</p>
<h2>EXAMPLE
<a name="EXAMPLE"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">You can arrange
for your rwloadsim program (only one in case of a
multi-process run) to query gv$sys_time_model once per
second for the values of ’DB time’ and ’DB
CPU’, and insert those values into the sysres table
with the text "TIM" for resname and using val1 and
val2 for the two values retrieved from
gv$sys_time_model.</p>
<p style="margin-left:11%; margin-top: 1em">After execution
you can subsequently execute a query against the sysres
table and e.g. use the results for graphing purposes.</p>
<h2>NOTES
<a name="NOTES"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">When running
queries for reporting there are rounding effects, and you
<i>cannot</i> join the column named second in the sysres
table to the same column in other tables or views that have
a second column. If used for graphing, your graphing tool
should however align graphs properly assuming the values of
the second columns from different tables or views are shown
against the same axis.</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>,
<a href="identifier.html">identifier(1rwl)</a>, <a href="statement.html">statement(1rwl)</a>, <a href="oltp.html">oltp(2rwl)</a></p>
<hr>
</body>
</html>