-
Notifications
You must be signed in to change notification settings - Fork 18
/
sqlmonitor.html
163 lines (112 loc) · 4.65 KB
/
sqlmonitor.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
<!-- Creator : groff version 1.22.3 -->
<!-- CreationDate: Wed Jun 19 10:20:57 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>sqlmonitor</title>
</head>
<body>
<h1 align="center">sqlmonitor</h1>
<a href="#NAME">NAME</a><br>
<a href="#SYNOPSIS">SYNOPSIS</a><br>
<a href="#OPTIONS">OPTIONS</a><br>
<a href="#EXAMPLE">EXAMPLE</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">sqlmonitor
− Create sql monitor from gv$sql views</p>
<h2>SYNOPSIS
<a name="SYNOPSIS"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em"><b>sqlmonitor
[options] -l u/p@c sqlid</b></p>
<p style="margin-left:11%; margin-top: 1em">For the
provided sqlid, the sqlmonitor utility creates a sql monitor
from the shared pool of the database using
dbms_sql_monitor.report_sql_monitor. The output is written
to a file named with the sqlid and a suffix of .html unless
the --output-file option is provided. Use --output-directory
to write the output in a different directory than the
current.</p>
<p style="margin-left:11%; margin-top: 1em">The
dbms_sql_monitor.report_sql_monitor has several ways to
provide information about which of potentially many sql
monitors to output and some of these are available as
options to sqlmonitor.</p>
<h2>OPTIONS
<a name="OPTIONS"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em"><b>-l
u/p</b></p>
<p style="margin-left:11%; margin-top: 1em"><b>-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 gv$sql and dba_hist_sqltext. If you omit /p,
rwloadsim will prompt for the password.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--output-file=<filename></b></p>
<p style="margin-left:17%;">By default, the output is
written to a file named as the sqlid with a suffix of .html.
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>--sql-plan-hash-value=value</b></p>
<p style="margin-left:17%;">Provide a value for the
sql_plan_hash_value argument to
dbms_sql_monitor.report_sql_monitor.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--sql-exec-id=value</b></p>
<p style="margin-left:17%;">Provide a value for the
sql_exec_id argument to
dbms_sql_monitor.report_sql_monitor.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--sql-exec-start=value</b></p>
<p style="margin-left:17%;">Provide a value which must be a
date in the exact format YYYY.MM.DDTHH24:MI:SS with a
literal T to separate the date part from the time part for
the sql_exec_start argument to
dbms_sql_monitor.report_sql_monitor.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--con-name=value</b></p>
<p style="margin-left:17%;">Provide a value for the
con_name argument to
dbms_sql_monitor.report_sql_monitor.</p>
<p style="margin-left:11%; margin-top: 1em"><b>sqlid</b></p>
<p style="margin-left:17%; margin-top: 1em">Exactly one
sqlid must be provided.</p>
<h2>EXAMPLE
<a name="EXAMPLE"></a>
</h2>
<pre style="margin-left:11%; margin-top: 1em">sqlmonitor -l system/{password} 07rw9znc8g7aj</pre>
<p style="margin-left:11%; margin-top: 1em">will create a
file named 07rw9znc8g7aj.html containing the sql monitor of
the sql with sqlid 07rw9znc8g7aj.</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="sqlreport.html">sqlreport(2rwl)</a>, <a href="sqlmonitorawr.html">sqlmonitorawr(2rwl)</a>, <a href="utilities.html">utilities(2rwl)</a></p>
<hr>
</body>
</html>