AWR - Script execution's For non and RAC Database AWR report

 

Script execution's For non and RAC Database AWR report 

Example Below for 2 node RAC .

SQL> @d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN

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

SMRRAC    smrrac1          smrrac                         READ WRITE           PRIMARY          YES                0

• Execute statement example awrgrpti.sql

SQL> @?/rdbms/admin/awrgrpti.sql

Specify the Report Type

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

AWR reports can be generated in the following formats.  Please enter the

name of the format at the prompt.  Default value is 'html'.

'html'          HTML format (default)

'text'          Text format

'active-html'   Includes Performance Hub active report

Enter value for report_type:

Type Specified:  html

Instances in this Workload Repository schema

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

   DB Id      INSTT_NUM DB Name      INSTT_NAME       Host

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

* 4255065810          2 SMRRAC       smrrac2          s01

* 4255065810          1 SMRRAC       smrrac1          s02

Enter value for dbid: 4255065810

Header Details: