-
Notifications
You must be signed in to change notification settings - Fork 18
/
oerstats.html
146 lines (101 loc) · 3.8 KB
/
oerstats.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
<!-- Creator : groff version 1.22.3 -->
<!-- CreationDate: Mon Mar 18 08:51:05 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>oerstats</title>
</head>
<body>
<h1 align="center">oerstats</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="#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">oerstats
− RWP*Load Simulator oerstats table</p>
<h2>DESCRIPTION
<a name="DESCRIPTION"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">Whenever an
rwloadsim program receives an ORA- error, the error will be
output to stderr, but execution will by default continue. If
running with the --oerstats option, the occurrence of the
error will additionally by saved in the oerstats table in
the repository database.</p>
<h2>DECLARATION
<a name="DECLARATION"></a>
</h2>
<pre style="margin-left:11%; margin-top: 1em">create table oerstats
( runnumber number not null
, procno number not null
, oer number not null
, second number(*,6) not null
, oertxt varchar2(70)
, sname varchar2(30)
, oeseq number not null
, oerinst varchar2(16)
, constraint oerstats_pk primary key(runnumber, procno, oeseq)
)</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, it is retrieved from a sequence
number for each run that saves statistics.</p>
<p style="margin-left:11%; margin-top: 1em"><b>oer</b></p>
<p style="margin-left:17%;">The Oracle error number.</p>
<p style="margin-left:11%; margin-top: 1em"><b>second</b></p>
<p style="margin-left:17%;">The time-stamp when the Oracle
error was received in seconds since the common start
time.</p>
<p style="margin-left:11%; margin-top: 1em"><b>oertxt</b></p>
<p style="margin-left:17%;">The error text truncated to 70
characters.</p>
<p style="margin-left:11%; margin-top: 1em"><b>sname</b></p>
<p style="margin-left:17%;">If available, the variable name
of the sql causing the error, otherwise the name of the
procedure or function.</p>
<p style="margin-left:11%; margin-top: 1em"><b>oeseq</b></p>
<p style="margin-left:17%;">A number without any particular
meaning; it only exists to allow this table to have a
primary key.</p>
<p style="margin-left:11%; margin-top: 1em"><b>oerinst</b></p>
<p style="margin-left:17%;">The name of the instance that
the session was connected to; this is also found in
v$instance.instance_name. It is retrieved as the
OCI_ATTR_INSTNAME of the service context and it will be save
as NULL if it does not exist, which could be the case in
case of connection errors.</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="directive.html">directive(1rwl)</a></p>
<hr>
</body>
</html>