Generate AWR Reports


[oracle@BAKUAMLPRDDB dpdump]$ sqlplus “/ as sysdba”;

SQL*Plus: Release 11.2.0.3.0 Production on Sun Nov 10 19:57:46 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL> select name from v$database;
NAME
---------
AMLPROD
SQL> @?/rdbms/admin/awrrpt

Current Instance
~~~~~~~~~~~~~~~~

DB Id DB Name Inst Num Instance
———– ———— ——– ————
4040405938 AMLPROD 1 AMLPROD

Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter ‘html’ for an HTML report, or ‘text’ for plain text
Defaults to ‘html’
Enter value for report_type: html

Type Specified: html

Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DB Id Inst Num DB Name Instance Host
———— ——– ———— ———— ————
* 4040405938 1 AMLPROD AMLPROD BAKUAMLPRDDB

Using 4040405938 for database Id
Using 1 for instance number

Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing <return> without
specifying a number lists all completed snapshots.

Enter value for num_days:

Listing all Completed Snapshots

Snap
Instance DB Name Snap Id Snap Started Level
———— ———— ——— —————— —–
AMLPROD AMLPROD 64 02 Nov 2013 05:00 1
65 02 Nov 2013 06:00 1
66 02 Nov 2013 07:00 1
67 02 Nov 2013 08:00 1
68 02 Nov 2013 09:00 1
69 02 Nov 2013 10:00 1
70 02 Nov 2013 11:00 1
71 02 Nov 2013 12:00 1
72 02 Nov 2013 13:00 1
73 02 Nov 2013 14:00 1
74 02 Nov 2013 15:00 1
75 02 Nov 2013 16:00 1
76 02 Nov 2013 17:00 1
77 02 Nov 2013 18:00 1
78 02 Nov 2013 19:00 1
79 02 Nov 2013 20:00 1
80 02 Nov 2013 21:00 1
81 02 Nov 2013 22:00 1
82 02 Nov 2013 23:00 1
83 03 Nov 2013 00:00 1
84 03 Nov 2013 01:00 1
85 03 Nov 2013 02:00 1
86 03 Nov 2013 03:00 1
87 03 Nov 2013 04:00 1
88 03 Nov 2013 05:00 1
89 03 Nov 2013 06:00 1
90 03 Nov 2013 07:00 1
91 03 Nov 2013 08:00 1
92 03 Nov 2013 09:00 1
93 03 Nov 2013 10:00 1
94 03 Nov 2013 11:00 1
95 03 Nov 2013 12:00 1
96 03 Nov 2013 13:00 1
97 03 Nov 2013 14:00 1
98 03 Nov 2013 15:00 1
99 03 Nov 2013 16:00 1
100 03 Nov 2013 17:00 1
101 03 Nov 2013 18:00 1
102 03 Nov 2013 19:00 1
103 03 Nov 2013 20:00 1
104 03 Nov 2013 21:00 1
105 03 Nov 2013 22:00 1
106 03 Nov 2013 23:00 1
107 04 Nov 2013 00:00 1
108 04 Nov 2013 01:00 1
109 04 Nov 2013 02:00 1
110 04 Nov 2013 03:00 1
111 04 Nov 2013 04:00 1
112 04 Nov 2013 05:00 1
113 04 Nov 2013 06:00 1
114 04 Nov 2013 07:00 1
115 04 Nov 2013 08:00 1
116 04 Nov 2013 09:00 1
117 04 Nov 2013 10:00 1
118 04 Nov 2013 11:00 1
119 04 Nov 2013 12:00 1

Snap
Instance DB Name Snap Id Snap Started Level
———— ———— ——— —————— —–
AMLPROD AMLPROD 120 04 Nov 2013 13:00 1
121 04 Nov 2013 14:00 1
122 04 Nov 2013 15:00 1
123 04 Nov 2013 16:00 1
124 04 Nov 2013 17:00 1
125 04 Nov 2013 18:00 1
126 04 Nov 2013 19:00 1
127 04 Nov 2013 20:00 1
128 04 Nov 2013 21:00 1
129 04 Nov 2013 22:00 1
130 04 Nov 2013 23:00 1
131 05 Nov 2013 00:00 1
132 05 Nov 2013 01:00 1
133 05 Nov 2013 02:00 1
134 05 Nov 2013 03:00 1
135 05 Nov 2013 04:00 1
136 05 Nov 2013 05:00 1
137 05 Nov 2013 06:00 1
138 05 Nov 2013 07:00 1
139 05 Nov 2013 08:00 1
140 05 Nov 2013 09:00 1
141 05 Nov 2013 10:00 1
142 05 Nov 2013 11:00 1
143 05 Nov 2013 12:00 1
144 05 Nov 2013 13:00 1
145 05 Nov 2013 14:00 1
146 05 Nov 2013 15:00 1
147 05 Nov 2013 16:00 1
148 05 Nov 2013 17:00 1
149 05 Nov 2013 18:00 1
150 05 Nov 2013 19:00 1
151 05 Nov 2013 20:00 1
152 05 Nov 2013 21:00 1
153 05 Nov 2013 22:00 1
154 05 Nov 2013 23:00 1
155 06 Nov 2013 00:00 1
156 06 Nov 2013 01:00 1
157 06 Nov 2013 02:01 1
158 06 Nov 2013 03:00 1
159 06 Nov 2013 04:00 1
160 06 Nov 2013 05:00 1
161 06 Nov 2013 06:00 1
162 06 Nov 2013 07:00 1
163 06 Nov 2013 08:00 1
164 06 Nov 2013 09:00 1
165 06 Nov 2013 10:00 1
166 06 Nov 2013 11:00 1
167 06 Nov 2013 12:00 1
168 06 Nov 2013 13:00 1
169 06 Nov 2013 14:00 1
170 06 Nov 2013 15:00 1
171 06 Nov 2013 16:00 1
172 06 Nov 2013 17:00 1
173 06 Nov 2013 18:00 1
174 06 Nov 2013 19:00 1
175 06 Nov 2013 20:00 1

Snap
Instance DB Name Snap Id Snap Started Level
———— ———— ——— —————— —–
AMLPROD AMLPROD 176 06 Nov 2013 21:00 1
177 06 Nov 2013 22:00 1
178 06 Nov 2013 23:00 1
179 07 Nov 2013 00:00 1
180 07 Nov 2013 01:00 1
181 07 Nov 2013 02:00 1
182 07 Nov 2013 03:00 1
183 07 Nov 2013 04:00 1
184 07 Nov 2013 05:00 1
185 07 Nov 2013 06:00 1
186 07 Nov 2013 07:00 1
187 07 Nov 2013 08:00 1
188 07 Nov 2013 09:00 1
189 07 Nov 2013 10:00 1
190 07 Nov 2013 11:00 1
191 07 Nov 2013 12:00 1
192 07 Nov 2013 13:00 1
193 07 Nov 2013 14:00 1
194 07 Nov 2013 15:00 1
195 07 Nov 2013 16:00 1
196 07 Nov 2013 17:00 1
197 07 Nov 2013 18:00 1
198 07 Nov 2013 19:00 1
199 07 Nov 2013 20:00 1
200 07 Nov 2013 21:00 1
201 07 Nov 2013 22:00 1
202 07 Nov 2013 23:00 1
203 08 Nov 2013 00:00 1
204 08 Nov 2013 01:00 1
205 08 Nov 2013 02:00 1
206 08 Nov 2013 03:00 1
207 08 Nov 2013 04:00 1
208 08 Nov 2013 05:00 1
209 08 Nov 2013 06:00 1
210 08 Nov 2013 07:00 1
211 08 Nov 2013 08:00 1
212 08 Nov 2013 09:00 1
213 08 Nov 2013 10:00 1
214 08 Nov 2013 11:00 1
215 08 Nov 2013 12:00 1
216 08 Nov 2013 13:00 1
217 08 Nov 2013 14:00 1
218 08 Nov 2013 15:00 1
219 08 Nov 2013 16:00 1
220 08 Nov 2013 17:00 1
221 08 Nov 2013 18:00 1
222 08 Nov 2013 19:00 1
223 08 Nov 2013 20:00 1
224 08 Nov 2013 21:00 1
225 08 Nov 2013 22:00 1
226 08 Nov 2013 23:00 1
227 09 Nov 2013 00:00 1
228 09 Nov 2013 01:00 1
229 09 Nov 2013 02:00 1
230 09 Nov 2013 03:00 1
231 09 Nov 2013 04:00 1

Snap
Instance DB Name Snap Id Snap Started Level
———— ———— ——— —————— —–
AMLPROD AMLPROD 232 09 Nov 2013 05:00 1
233 09 Nov 2013 06:00 1
234 09 Nov 2013 07:00 1
235 09 Nov 2013 08:00 1
236 09 Nov 2013 09:00 1
237 09 Nov 2013 10:00 1
238 09 Nov 2013 11:00 1
239 09 Nov 2013 12:00 1
240 09 Nov 2013 13:00 1
241 09 Nov 2013 14:00 1
242 09 Nov 2013 15:00 1
243 09 Nov 2013 16:00 1
244 09 Nov 2013 17:00 1
245 09 Nov 2013 18:00 1
246 09 Nov 2013 19:00 1
247 09 Nov 2013 20:00 1
248 09 Nov 2013 21:00 1
249 09 Nov 2013 22:00 1
250 09 Nov 2013 23:00 1
251 10 Nov 2013 00:00 1
252 10 Nov 2013 01:00 1
253 10 Nov 2013 02:00 1
254 10 Nov 2013 03:00 1
255 10 Nov 2013 04:00 1
256 10 Nov 2013 05:00 1
257 10 Nov 2013 06:00 1
258 10 Nov 2013 07:00 1
259 10 Nov 2013 08:00 1
260 10 Nov 2013 09:00 1
261 10 Nov 2013 10:00 1
262 10 Nov 2013 11:00 1
263 10 Nov 2013 12:00 1
264 10 Nov 2013 13:00 1
265 10 Nov 2013 14:00 1
266 10 Nov 2013 15:00 1
267 10 Nov 2013 16:00 1
268 10 Nov 2013 17:00 1
269 10 Nov 2013 18:00 1
270 10 Nov 2013 19:00 1
271 10 Nov 2013 20:00 1

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 268
Begin Snapshot Id specified: 268
Enter value for end_snap: 271
End Snapshot Id specified: 271

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_268_271.html. To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name: /home/oracle/awrrpt_11102013.html

Go to  /home/oracle/ location and open awrrpt_11102013.html. Then Analyze the AWR results 🙂

awr

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: