-
Notifications
You must be signed in to change notification settings - Fork 18
/
connping.html
208 lines (147 loc) · 6.37 KB
/
connping.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
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
<!-- Creator : groff version 1.22.3 -->
<!-- CreationDate: Mon Mar 18 08:51:12 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>connping</title>
</head>
<body>
<h1 align="center">connping</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="#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">connping
− Find logon and ping rates over a database
connection</p>
<h2>SYNOPSIS
<a name="SYNOPSIS"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em"><b>connping -u
-l u/p@c [--no-timestamp] [--csvoutput=file] [--interval=N]
[--period=N] [--flush-output] [--flush-csv] [--unixepoch]
[--utctime] [--utcformat=fmt] [--csvexcel]</b></p>
<p style="margin-left:11%; margin-top: 1em">The connping
utility executes something similar to ping showing the times
to establish a connection, and to do a round-trip over that
connection respectively using OCIPing and a simple query
against dual. You can use <a href="ociping.html">ociping(2rwl)</a> to only show the
time for OCIPing.</p>
<h2>OPTIONS
<a name="OPTIONS"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em"><b>-l u/p <br>
-l u/p@c</b></p>
<p style="margin-left:17%;">Compulsory option to provide
the username, password, and potentially connect string for a
database connection. If you omit /p, rwloadsim will prompt
for the password.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--interval=N</b></p>
<p style="margin-left:17%;">The interval (in seconds)
between each ping; default 1s.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--period=N</b></p>
<p style="margin-left:17%;">The period in seconds to run
ping; default 60s.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--no-timestamp</b></p>
<p style="margin-left:17%;">Do not include time-stamps (in
seconds) in output.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--csvoutput=file</b></p>
<p style="margin-left:17%;">Output timestamp (unless
--no-timestamp) and the five values separated by space to
the named file.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--flush-output
<br>
--flush-csv</b></p>
<p style="margin-left:17%;">These will flush respectively
stdout and the csv file after each line. This is e.g. useful
if you send stdout to a pipeline using the tee command, or
if you are running tail -f of the csvfile.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--unixepoch</b></p>
<p style="margin-left:17%;">Timestamps will be output in
seconds since the UNIX epoch.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--utctime</b></p>
<p style="margin-left:17%;">Timestamps will be output as
UTC time in format YYYY.MM.DD.HH24:MI:SS.FF2 unless the next
option is also provided.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--utcformat=formatstring</b></p>
<p style="margin-left:17%;">If --utctime is in effect, use
an alternative format string, which musts comply with the
requirements of the Oracle TO_CHAR function.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--csvexcel</b></p>
<p style="margin-left:17%;">If a csv file is being
generated, the header line will not have an initial
’#’, the field separator will be ’;’
and the file will have CRLF line terminators. It it
suggested to also use --utctime
--utcformat=’YYYY/MM/DD HH24:MI:SS’.</p>
<h2>USAGE
<a name="USAGE"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">When executing,
it will show the three times mentioned in addition to
session id and instance number until the run period is over
and at the end, show averages, standard deviation, min and
max values. The time output is in ms. You can kill execution
prematurely by typing ctrl-c.</p>
<h2>EXAMPLE
<a name="EXAMPLE"></a>
</h2>
<pre style="margin-left:11%; margin-top: 1em">connping --no-timestamp --period=10 -ul username/{password}
RWP*Load Simulator Release 3.0.2.4 Development on Wed, 10 Aug 2022 10:06:06 UTC
Connected default database with reconnect to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
connect:42.75 ms, ociping:0.045 ms, dualping:0.102 ms, sid=379, inst#=1
connect:31.58 ms, ociping:0.025 ms, dualping:0.056 ms, sid=379, inst#=1
connect:26.30 ms, ociping:0.037 ms, dualping:0.073 ms, sid=379, inst#=1
connect:26.35 ms, ociping:0.423 ms, dualping:0.286 ms, sid=379, inst#=1
connect:29.95 ms, ociping:0.038 ms, dualping:0.049 ms, sid=379, inst#=1
connect:29.43 ms, ociping:0.034 ms, dualping:0.055 ms, sid=379, inst#=1
connect:28.98 ms, ociping:0.038 ms, dualping:0.063 ms, sid=379, inst#=1
connect:28.46 ms, ociping:0.031 ms, dualping:0.048 ms, sid=379, inst#=1
connect:29.07 ms, ociping:0.032 ms, dualping:0.055 ms, sid=379, inst#=1
connect mean=30.32, stddev=4.67, min=29.07, max=42.75
ociping mean=0.08, stddev=0.12, min=0.03, max=0.42
dualping mean=0.09, stddev=0.07, min=0.05, max=0.29</pre>
<h2>NOTES
<a name="NOTES"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">If you are
using the full distribution of rwloadsim, connping is an
executable shell script in the bin directory that calls
rwloadsim with the -u option getting connping.rwl from the
public directory. As a stand alone binary distribution,
connping is an executable with the connping.rwl code
embedded.</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="rwloadsim.html">rwloadsim(1rwl)</a>,
<a href="ociping.html">ociping(2rwl)</a>, <a href="utilities.html">utilities(2rwl)</a></p>
<hr>
</body>
</html>