oracle12c rac生成awr,Oracle 11G RAC 生成AWR报告

1.生成单实例 AWR 报告：

@$ORACLE_HOME/rdbms/admin/awrrpt.sql

2.生成 Oracle RAC AWR 报告：

@$ORACLE_HOME/rdbms/admin/awrgrpt.sql

Current Database

~~~~~~~~~~~~~~~~

DB Id DB Name

----------- ------------

1562959129 HJYRACDB

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 INSTT_NUM DB Name INSTT_NAME Host

------------ ---------- ------------ ---------------- ------------

* 1562959129 5 HJYRACDB hjyracdb5 ahhjydb5

* 1562959129 4 HJYRACDB hjyracdb4 ahhjydb4

* 1562959129 3 HJYRACDB hjyracdb3 ahhjydb3

* 1562959129 6 HJYRACDB hjyracdb6 ahhjydb6

* 1562959129 2 HJYRACDB hjyracdb2 ahhjydb2

* 1562959129 1 HJYRACDB hjyracdb1 ahhjydb1

Using 1562959129 for database Id

Using instances ALL (default 'ALL')

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 without

specifying a number lists all completed snapshots.

Enter value for num_days: 10

Listing the last 10 days of Completed Snapshots

Snap

DB Name Snap Id Snap Started Level

------------ --------- ------------------ -----

HJYRACDB 3758 15 Jun 2020 09:00 1

3759 15 Jun 2020 10:00 1

3760 15 Jun 2020 11:00 1

3761 15 Jun 2020 12:00 1

3762 15 Jun 2020 13:00 1

3763 15 Jun 2020 14:00 1