-
Notifications
You must be signed in to change notification settings - Fork 18
/
awrreport.html
274 lines (191 loc) · 8.8 KB
/
awrreport.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
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
<!-- 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>awrreport</title>
</head>
<body>
<h1 align="center">awrreport</h1>
<a href="#NAME">NAME</a><br>
<a href="#SYNOPSIS">SYNOPSIS</a><br>
<a href="#OPTIONS">OPTIONS</a><br>
<a href="#EXAMPLES">EXAMPLES</a><br>
<a href="#NOTES">NOTES</a><br>
<a href="#BUG">BUG</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">awrreport
− Create an awr or ash report</p>
<h2>SYNOPSIS
<a name="SYNOPSIS"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em"><b>awrreport -l
u/p@c [options]</b></p>
<p style="margin-left:11%; margin-top: 1em">List available
awr repositories or create an actual awr or ash report. You
normally start with only the -l option to identify the
database, instance and snapshot ranges available. After
having identified this, you can user other options to
actually generate an awr or ash report.</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 that provides access to a login with
access to various the dba_ views containing the awr
repository. If you omit /p, rwloadsim will prompt for the
password.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--dbid=<dbid></b></p>
<p style="margin-left:17%;">Without this option, provide a
list of all available databases with the dbid in the awr
repository. The list will indicate if the database is a root
of a cdb, a pdb, or an imported awr dump. With this option,
list snapshots available in the database with the chosen
dbid. This option is required to generate awr or ash
report.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--instance=<instance></b></p>
<p style="margin-left:17%;">Limit the list of available
snapshots to one particular instance or provide an instance
for awr/ash generation.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--fromtime=YYYY.MM.DDTHH24:MI
<br>
--totime=YYYY.MM.DDTHH24:MI</b></p>
<p style="margin-left:17%;">Limit the list of snapshot to a
date range; either or both options can be provided. Note
that dates must be in the exact format shown, which is also
the format used when outputting lists of snapshots. You can
omit the : and MI or the T and the entire time part.</p>
<p style="margin-left:17%; margin-top: 1em">These options
are also required when generating an ash report.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--no-headings</b></p>
<p style="margin-left:17%;">In the various lists, do not
output headings.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--output-text</b></p>
<p style="margin-left:17%;">If generating an awr or ash,
the output will be in text (ASCII) format. The default is
html format.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--output-file=<filename></b></p>
<p style="margin-left:17%;">If generating an awr or ash,
the output is written to a file with default name based on
the input. Use this option to specify a different
filename.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--output-directory=<directory></b></p>
<p style="margin-left:17%;">By default, the output is
written in your current directory. Use this option to
specify a different directory.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--begin-snap=N
<br>
--end-snap=N</b></p>
<p style="margin-left:17%; margin-top: 1em">If the
--begin-snap option is provided an awr report will be
created with that begin snapshot and and end snapshot 1
higher, unless the --end-snap option is used to specify a
different end snapshot. If --instance is provided, an
instance specific awr report is created, otherwise a global
awr report is created. The --dbid option is required.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--ash-slot-width</b></p>
<p style="margin-left:17%; margin-top: 1em">Generate an ash
report using the slot width (in seconds). All of --dbid,
--instance, --fromtime, --totime a are needed as well.</p>
<h2>EXAMPLES
<a name="EXAMPLES"></a>
</h2>
<pre style="margin-left:11%; margin-top: 1em">awrreport -l system/{password}</pre>
<p style="margin-left:11%; margin-top: 1em">which may
generate an output like:</p>
<pre style="margin-left:11%; margin-top: 1em"> dbid con snap cnt instance list
----------- --- -------- -------------
607296874 / 408 1,2
4001460110 12321 1,2,3,4,5,6,7,8</pre>
<p style="margin-left:11%; margin-top: 1em">This tells that
there is data from two databases available in the
repository. The first one is a root in a container with a
total of 408 snapshots available for instances 1 and 2. The
second database is from an imported awr dump with 12321
snapshots available from instances 1 until 8.</p>
<p style="margin-left:11%; margin-top: 1em">The next step
would be to provide a dbid such as:</p>
<pre style="margin-left:11%; margin-top: 1em">awrreport --dbid=607296874 -l system/{password}</pre>
<p style="margin-left:11%; margin-top: 1em">which may
generate an output like this:</p>
<pre style="margin-left:11%; margin-top: 1em">i# losnap hisnap snaps losnap_end hisnap_end
-- ------- ------- ------ ---------------- ---------------
1 6688 6891 204 2022.04.04T20:00 2022.04.13T07:00
2 6688 6891 204 2022.04.04T20:00 2022.04.13T07:00</pre>
<p style="margin-left:11%; margin-top: 1em">To see all
available snapshots in some specific time range, you could
then do</p>
<pre style="margin-left:11%; margin-top: 1em">awrreport --fromtime=2022.04.05T08:00 --totime=2022.04.05T18:00 --dbid 607296874 -l system/{password}
i# snap snap_end_time instance_start
-- ------- ---------------- ----------------
1 6700 2022.04.05T08:00 2021.12.09T08:25
1 6701 2022.04.05T09:00 2021.12.09T08:25
1 6702 2022.04.05T10:00 2021.12.09T08:25
1 6703 2022.04.05T11:00 2021.12.09T08:25
1 6704 2022.04.05T12:00 2021.12.09T08:25
...
2 6707 2022.04.05T15:00 2021.12.09T08:31
2 6708 2022.04.05T16:00 2021.12.09T08:31
2 6709 2022.04.05T17:00 2021.12.09T08:31
2 6710 2022.04.05T18:00 2021.12.09T08:31</pre>
<p style="margin-left:11%; margin-top: 1em">You can finally
create an instance specific awr report as a html file in the
/var/www/html/awrs directory by doing something like:</p>
<pre style="margin-left:11%; margin-top: 1em">awrreport --output-directory=/var/www/html/awrs --instance=1 --dbid=607296874 -l system/{password} --begin-snap=6702</pre>
<p style="margin-left:11%; margin-top: 1em">If the
--instance=1 option was not included, a global awr report
would have been created.</p>
<p style="margin-left:11%; margin-top: 1em">An example of
how to generate an ash report as a text file is:</p>
<pre style="margin-left:11%; margin-top: 1em">awrreport --output-text --instance=3 --output-file=ash.txt --dbid 4001460110 -l system/{password} --fromtime=2022.04.02T22:20 -totime=2022.04.02T22:30 --ash-slot-width=30</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, awrreport is an
executable shell script in the bin directory that calls
rwloadsim with the -u option getting awrreport.rwl from the
public directory. As a stand alone binary distribution,
awrreport is an executable with the awrreport.rwl code
embedded.</p>
<p style="margin-left:11%; margin-top: 1em">The name,
awreport, was used previously, but the missing
’r’ was causing confusion.</p>
<h2>BUG
<a name="BUG"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">The ash reports
cannot be created globally, i.e. for all instances.</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="ashplot.html">ashplot(2rwl)</a>, <a href="utilities.html">utilities(2rwl)</a>, <a href="awrdump.html">awrdump(2rwl)</a></p>
<hr>
</body>
</html>