一、上传awrcrt.sql脚本
下载链接:https://download.csdn.net/download/Ruishine/20321701
本例中,将awrcrt.sql脚本放在/home/oracle/目录下。
二、执行脚本
$ sqlplus / as sysdba
SYS@ test >@/home/oracle/awrcrt.sql --执行脚本(路径根据实际情况自行替换)
Current Instance
~~~~~~~~~~~~~~~~
DBID DB_NAME INST_NUM INST_NAME
---------- --------- ---------- ----------------
2541626938 TEST 1 test
Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for 0: 30 --输入要显示的snap区间(单位:天),此例为30天
old 3: and a.begin_interval_time > sysdate-&days
new 3: and a.begin_interval_time > sysdate-30
SNAP_ID SNAP_TIME
---------- -------------------
6327 2021-07-08 00:00:18
6328 2021-07-08 01:00:29
6329 2021-07-08 02:00:45
6330 2021-07-08 03:00:56
6331 2021-07-08 04:00:06
6332 2021-07-08 05:00:17
6333 2021-07-08 06:00:27
6334 2021-07-08 07:00:38
6335 2021-07-08 08:00:49
6336 2021-07-08 09:00:59
6337 2021-07-08 10:00:12
6338 2021-07-08 11:00:23
6339 2021-07-08 12:00:34
6340 2021-07-08 13:00:45
6341 2021-07-08 14:00:56
6342 2021-07-08 15:00:07
6343 2021-07-08 16:00:19
6344 2021-07-08 17:00:33
6345 2021-07-08 18:00:45
6346 2021-07-08 19:00:56
6347 2021-07-08 20:00:07
6348 2021-07-08 21:00:19
6349 2021-07-08 22:00:30
6350 2021-07-08 23:00:44
6351 2021-07-09 00:00:56
6352 2021-07-09 01:00:07
6353 2021-07-09 02:00:22
6354 2021-07-09 03:00:33
6355 2021-07-09 04:00:45
6356 2021-07-09 05:00:57
6357 2021-07-09 06:00:08
6358 2021-07-09 07:00:20
6359 2021-07-09 08:00:33
6360 2021-07-09 09:00:45
6361 2021-07-09 10:00:59
6362 2021-07-09 11:00:12
6363 2021-07-09 12:00:25
6364 2021-07-09 13:00:37
6365 2021-07-09 14:00:52
6366 2021-07-09 15:00:04
6367 2021-07-09 16:00:18
6368 2021-07-09 17:00:31
6369 2021-07-09 18:00:44
6370 2021-07-09 19:00:56
6371 2021-07-09 20:00:10
6372 2021-07-09 21:00:22
6373 2021-07-09 22:00:36
6374 2021-07-09 23:00:51
6375 2021-07-10 00:00:03
6376 2021-07-10 01:00:15
6377 2021-07-10 02:00:37
6378 2021-07-10 03:00:49
6379 2021-07-10 04:00:01
6380 2021-07-10 05:00:13
6381 2021-07-10 06:00:25
6382 2021-07-10 07:00:40
6383 2021-07-10 08:00:53
6384 2021-07-10 09:00:06
6385 2021-07-10 10:00:19
6386 2021-07-10 11:00:32
6387 2021-07-10 12:00:44
6388 2021-07-10 13:00:57
6389 2021-07-10 14:00:11
6390 2021-07-10 15:00:24
6391 2021-07-10 16:00:37
6392 2021-07-10 17:00:50
6393 2021-07-10 18:00:02
6394 2021-07-10 19:00:14
6395 2021-07-10 20:00:27
6396 2021-07-10 21:00:40
6397 2021-07-10 22:00:53
6398 2021-07-10 23:00:05
6399 2021-07-11 00:00:17
6400 2021-07-11 01:00:30
6401 2021-07-11 02:00:49
6402 2021-07-11 03:00:02
6403 2021-07-11 04:00:14
6404 2021-07-11 05:00:27
6405 2021-07-11 06:00:39
6406 2021-07-11 07:00:52
6407 2021-07-11 08:00:05
6408 2021-07-11 09:00:18
6409 2021-07-11 10:00:31
6410 2021-07-11 11:00:44
6411 2021-07-11 12:00:57
6412 2021-07-11 13:00:10
6413 2021-07-11 14:00:22
6414 2021-07-11 15:00:35
6415 2021-07-11 16:00:48
6416 2021-07-11 17:00:02
6417 2021-07-11 18:00:15
6418 2021-07-11 19:00:28
6419 2021-07-11 20:00:40
6420 2021-07-11 21:00:54
6421 2021-07-11 22:00:07
6422 2021-07-11 23:00:20
6423 2021-07-12 00:00:34
6424 2021-07-12 01:00:46
6425 2021-07-12 02:00:09
6426 2021-07-12 03:00:22
6427 2021-07-12 04:00:35
6428 2021-07-12 05:00:47
6429 2021-07-12 06:01:00
6430 2021-07-12 07:00:12
6431 2021-07-12 08:00:25
6432 2021-07-12 09:00:38
6433 2021-07-12 10:00:51
6434 2021-07-12 11:00:05
6435 2021-07-12 12:00:18
6436 2021-07-12 13:00:30
6437 2021-07-12 14:00:44
6438 2021-07-12 15:00:59
6439 2021-07-12 16:00:13
6440 2021-07-12 17:00:27
6441 2021-07-12 18:00:40
6442 2021-07-12 19:00:53
6443 2021-07-12 20:00:06
6444 2021-07-12 21:00:19
6445 2021-07-12 22:00:34
6446 2021-07-12 23:00:51
6447 2021-07-13 00:00:04
6448 2021-07-13 01:00:17
6449 2021-07-13 02:00:40
6450 2021-07-13 03:00:54
6451 2021-07-13 04:00:06
6452 2021-07-13 05:00:18
6453 2021-07-13 06:00:31
6454 2021-07-13 07:00:43
6455 2021-07-13 08:00:55
6456 2021-07-13 09:00:07
6457 2021-07-13 10:00:22
6458 2021-07-13 11:00:35
6459 2021-07-13 12:00:49
6460 2021-07-13 13:00:02
6461 2021-07-13 14:00:16
6462 2021-07-13 15:00:30
6463 2021-07-13 16:00:44
6464 2021-07-13 17:00:57
6465 2021-07-13 18:00:10
6466 2021-07-13 19:00:24
6467 2021-07-13 20:00:37
6468 2021-07-13 21:00:51
6469 2021-07-13 22:00:03
6470 2021-07-13 23:00:18
6471 2021-07-14 00:00:32
6472 2021-07-14 01:00:45
6473 2021-07-14 02:00:05
6474 2021-07-14 03:00:18
6475 2021-07-14 04:00:30
6476 2021-07-14 05:00:43
6477 2021-07-14 06:00:56
6478 2021-07-14 07:00:08
6479 2021-07-14 08:00:21
6480 2021-07-14 09:00:34
6481 2021-07-14 10:00:49
6482 2021-07-14 11:00:04
6483 2021-07-14 12:00:18
6484 2021-07-14 13:00:32
6485 2021-07-14 14:00:46
6486 2021-07-14 15:00:00
6487 2021-07-14 16:00:14
6488 2021-07-14 17:00:29
6489 2021-07-14 18:00:43
6490 2021-07-14 19:00:56
6491 2021-07-14 20:00:11
6492 2021-07-14 21:00:25
6493 2021-07-14 22:00:40
6494 2021-07-14 23:00:56
6495 2021-07-15 00:00:12
6496 2021-07-15 01:00:25
6497 2021-07-15 02:00:48
6498 2021-07-15 03:00:05
6499 2021-07-15 04:00:21
6500 2021-07-15 05:00:36
6501 2021-07-15 06:00:50
6502 2021-07-15 07:00:04
6503 2021-07-15 08:00:17
6504 2021-07-15 09:00:32
6505 2021-07-15 10:00:57
6506 2021-07-15 11:00:30
6507 2021-07-15 12:00:49
6508 2021-07-15 13:00:11
6509 2021-07-15 14:00:24
6510 2021-07-15 15:00:38
6511 2021-07-15 16:00:51
6512 2021-07-15 17:00:05
6513 2021-07-15 18:00:20
6514 2021-07-15 19:00:36
6515 2021-07-15 20:00:52
6516 2021-07-15 21:00:05
6517 2021-07-15 22:00:19
6518 2021-07-15 23:00:36
6519 2021-07-16 00:00:51
6520 2021-07-16 01:00:05
6521 2021-07-16 02:00:30
6522 2021-07-16 03:00:43
6523 2021-07-16 04:00:56
6524 2021-07-16 05:00:09
6525 2021-07-16 06:00:22
6526 2021-07-16 07:00:35
6527 2021-07-16 08:00:48
6528 2021-07-16 09:00:01
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
begin snap id is
Enter value for 1: 6327 --输入开始snap id
end snap id is
Enter value for 2: 6528 --输入结束snap id
instance number is
Enter value for 3: 1 --输入instance_number
report wrote to awrcrt_TEST_1_6327_6528.html --生成报告
SYS@ test >
此时报告已经生成,文件名为awrcrt_TEST_1_6327_6528.html,存放在/home/oracle下。
下载到本地服务器后,就可以查看了。