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