AWRRPT 报告生成

sqlplus / as sysdba
SQL/>


SQL> @?/rdbms/admin/awrrpt

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

   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
3771717691 PMES                2 pmes2


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:

Type Specified:  html


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

   DB Id     Inst Num DB Name      Instance     Host
------------ -------- ------------ ------------ ------------
* 3771717691        2 PMES         pmes2        htrac102
  3771717691        1 PMES         pmes1        htrac101
  3771717691        3 PMES         pmes3        htrac103

Using 3771717691 for database Id
Using          2 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: 8

Listing the last 8 days of Completed Snapshots

                                                        Snap
Instance     DB Name        Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
pmes2        PMES              1228 27 Mar 2012 00:00      1
                               1229 27 Mar 2012 01:00      1
                               1230 27 Mar 2012 02:00      1
                               1231 27 Mar 2012 03:00      1
                               1232 27 Mar 2012 04:00      1
                               1233 27 Mar 2012 05:00      1
                               1234 27 Mar 2012 06:00      1
                               1235 27 Mar 2012 07:00      1
                               1236 27 Mar 2012 08:00      1
                               1237 27 Mar 2012 09:00      1
                               1238 27 Mar 2012 10:00      1
                               1239 27 Mar 2012 11:00      1
                               1240 27 Mar 2012 12:00      1
                               1241 27 Mar 2012 13:00      1
                               1242 27 Mar 2012 14:00      1
                               1243 27 Mar 2012 15:00      1
                               1244 27 Mar 2012 16:00      1
                               1245 27 Mar 2012 17:00      1
                               1246 27 Mar 2012 18:00      1
                               1247 27 Mar 2012 19:00      1
                               1248 27 Mar 2012 20:00      1
                               1249 27 Mar 2012 21:00      1
                               1250 27 Mar 2012 22:00      1
                               1251 27 Mar 2012 23:00      1
                               1252 28 Mar 2012 00:00      1
                               1253 28 Mar 2012 01:00      1
                               1254 28 Mar 2012 02:00      1
                               1255 28 Mar 2012 03:00      1
                               1256 28 Mar 2012 04:00      1
                               1257 28 Mar 2012 05:00      1
                               1258 28 Mar 2012 06:00      1
                               1259 28 Mar 2012 07:00      1
                               1260 28 Mar 2012 08:00      1
                               1261 28 Mar 2012 09:00      1
                               1262 28 Mar 2012 10:00      1
                               1263 28 Mar 2012 11:00      1
                               1264 28 Mar 2012 12:00      1
                               1265 28 Mar 2012 13:00      1
                               1266 28 Mar 2012 14:00      1
                               1267 28 Mar 2012 15:00      1
                               1268 28 Mar 2012 16:00      1
                               1269 28 Mar 2012 17:00      1
                               1270 28 Mar 2012 18:00      1
                               1271 28 Mar 2012 19:00      1
                               1272 28 Mar 2012 20:00      1
                               1273 28 Mar 2012 21:00      1
                               1274 28 Mar 2012 22:00      1
                               1275 28 Mar 2012 23:00      1
                               1276 29 Mar 2012 00:00      1
                               1277 29 Mar 2012 01:00      1

                               1278 29 Mar 2012 02:00      1
                               1279 29 Mar 2012 03:00      1
                               1280 29 Mar 2012 04:00      1
                               1281 29 Mar 2012 05:00      1
                               1282 29 Mar 2012 06:00      1

                                                        Snap
Instance     DB Name        Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
pmes2        PMES              1283 29 Mar 2012 07:00      1
                               1284 29 Mar 2012 08:00      1
                               1285 29 Mar 2012 09:00      1
                               1286 29 Mar 2012 10:00      1
                               1287 29 Mar 2012 11:00      1
                               1288 29 Mar 2012 12:00      1
                               1289 29 Mar 2012 13:00      1
                               1290 29 Mar 2012 14:00      1
                               1291 29 Mar 2012 15:00      1
                               1292 29 Mar 2012 16:00      1
                               1293 29 Mar 2012 17:00      1
                               1294 29 Mar 2012 18:00      1
                               1295 29 Mar 2012 19:00      1
                               1296 29 Mar 2012 20:00      1
                               1297 29 Mar 2012 21:00      1
                               1298 29 Mar 2012 22:00      1
                               1299 29 Mar 2012 23:00      1
                               1300 30 Mar 2012 00:00      1
                               1301 30 Mar 2012 01:00      1
                               1302 30 Mar 2012 02:00      1
                               1303 30 Mar 2012 03:00      1
                               1304 30 Mar 2012 04:00      1
                               1305 30 Mar 2012 05:00      1
                               1306 30 Mar 2012 06:00      1
                               1307 30 Mar 2012 07:00      1
                               1308 30 Mar 2012 08:00      1
                               1309 30 Mar 2012 09:00      1
                               1310 30 Mar 2012 10:00      1
                               1311 30 Mar 2012 11:00      1
                               1312 30 Mar 2012 12:00      1
                               1313 30 Mar 2012 13:00      1
                               1314 30 Mar 2012 14:00      1
                               1315 30 Mar 2012 15:00      1
                               1316 30 Mar 2012 16:00      1
                               1317 30 Mar 2012 17:00      1
                               1318 30 Mar 2012 18:00      1
                               1319 30 Mar 2012 19:00      1
                               1320 30 Mar 2012 20:00      1
                               1321 30 Mar 2012 21:00      1
                               1322 30 Mar 2012 22:00      1
                               1323 30 Mar 2012 23:00      1
                               1324 31 Mar 2012 00:00      1
                               1325 31 Mar 2012 01:00      1
                               1326 31 Mar 2012 02:00      1
                               1327 31 Mar 2012 03:00      1
                               1328 31 Mar 2012 04:00      1
                               1329 31 Mar 2012 05:00      1
                               1330 31 Mar 2012 06:00      1
                               1331 31 Mar 2012 07:00      1
                               1332 31 Mar 2012 08:00      1
                               1333 31 Mar 2012 09:00      1
                               1334 31 Mar 2012 10:00      1
                               1335 31 Mar 2012 11:00      1
                               1336 31 Mar 2012 12:00      1
                               1337 31 Mar 2012 13:00      1
                               1338 31 Mar 2012 14:00      1

                                                        Snap
Instance     DB Name        Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
pmes2        PMES              1339 31 Mar 2012 14:55      1
                               1340 31 Mar 2012 14:56      1
                               1341 31 Mar 2012 15:05      1
                               1342 31 Mar 2012 15:11      1
                               1343 31 Mar 2012 15:20      1

                               1344 31 Mar 2012 16:10      1

                               1345 31 Mar 2012 17:00      1

                               1346 31 Mar 2012 18:12      1

                               1347 31 Mar 2012 19:00      1
                               1348 31 Mar 2012 20:00      1
                               1349 31 Mar 2012 21:00      1
                               1350 31 Mar 2012 22:00      1
                               1351 31 Mar 2012 23:00      1
                               1352 01 Apr 2012 00:00      1
                               1353 01 Apr 2012 01:00      1
                               1354 01 Apr 2012 02:00      1
                               1355 01 Apr 2012 03:00      1
                               1356 01 Apr 2012 04:00      1
                               1357 01 Apr 2012 05:00      1
                               1358 01 Apr 2012 06:00      1
                               1359 01 Apr 2012 07:00      1
                               1360 01 Apr 2012 08:00      1
                               1361 01 Apr 2012 09:00      1
                               1362 01 Apr 2012 10:00      1

                               1363 01 Apr 2012 11:27      1
                               1364 01 Apr 2012 12:00      1
                               1365 01 Apr 2012 13:00      1
                               1366 01 Apr 2012 14:00      1
                               1367 01 Apr 2012 15:00      1
                               1368 01 Apr 2012 16:00      1

                               1369 01 Apr 2012 17:00      1
                               1370 01 Apr 2012 18:00      1
                               1371 01 Apr 2012 19:00      1
                               1372 01 Apr 2012 20:00      1
                               1373 01 Apr 2012 21:00      1
                               1374 01 Apr 2012 22:00      1
                               1375 01 Apr 2012 23:00      1
                               1376 02 Apr 2012 00:00      1
                               1377 02 Apr 2012 01:00      1
                               1378 02 Apr 2012 02:00      1
                               1379 02 Apr 2012 03:00      1
                               1380 02 Apr 2012 04:00      1
                               1381 02 Apr 2012 05:00      1
                               1382 02 Apr 2012 06:00      1
                               1383 02 Apr 2012 07:00      1
                               1384 02 Apr 2012 08:00      1
                               1385 02 Apr 2012 09:00      1
                               1386 02 Apr 2012 10:00      1
                               1387 02 Apr 2012 11:00      1
                               1388 02 Apr 2012 12:00      1

                                                        Snap
Instance     DB Name        Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
pmes2        PMES              1389 02 Apr 2012 13:00      1
                               1390 02 Apr 2012 14:00      1
                               1391 02 Apr 2012 15:00      1
                               1392 02 Apr 2012 16:00      1
                               1393 02 Apr 2012 17:00      1
                               1394 02 Apr 2012 18:00      1
                               1395 02 Apr 2012 19:00      1
                               1396 02 Apr 2012 20:00      1
                               1397 02 Apr 2012 21:00      1
                               1398 02 Apr 2012 22:00      1
                               1399 02 Apr 2012 23:00      1
                               1400 03 Apr 2012 00:00      1
                               1401 03 Apr 2012 01:00      1
                               1402 03 Apr 2012 02:00      1
                               1403 03 Apr 2012 03:00      1
                               1404 03 Apr 2012 04:00      1
                               1405 03 Apr 2012 05:00      1
                               1406 03 Apr 2012 06:00      1
                               1407 03 Apr 2012 07:00      1
                               1408 03 Apr 2012 08:00      1
                               1409 03 Apr 2012 09:00      1
                               1410 03 Apr 2012 10:00      1
                               1411 03 Apr 2012 11:00      1
                               1412 03 Apr 2012 12:00      1
                               1413 03 Apr 2012 13:00      1
                               1414 03 Apr 2012 14:00      1
                               1415 03 Apr 2012 15:00      1



Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 1276
Begin Snapshot Id specified: 1276

Enter value for end_snap: 1277
End   Snapshot Id specified: 1277



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

Enter value for report_name:             

Using the report name awrrpt_2_1276_1277.html


<html .........

SQL/> exit