[root@dbtest ~]# su - oracle

-bash-4.1$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 24 10:35:58 2021


Copyright (c) 1982, 2013, Oracle.  All rights reserved.



Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options


SYS@DB>@?/rdbms/admin/awrrpt.sql


Current Instance

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


  DB Id    DB Name  Inst Num Instance

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

1610004672 ORCL  1 orcl



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     Inst Num DB Name    Instance Host

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

* 1610004672     1 ORCL    orcl  hisdbtest

 1566278406     1 ORCL    orcl  hisdbtest


Using 1610004672 for database Id

Using        1 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: 1


Listing the last day's Completed Snapshots


      Snap

Instance     DB Name     Snap Id    Snap Started    Level

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

orcl      ORCL  513 24 Sep 2021 00:00    1

   514 24 Sep 2021 01:00    1

   515 24 Sep 2021 02:00    1

   516 24 Sep 2021 03:00    1

   517 24 Sep 2021 04:00    1

   518 24 Sep 2021 05:00    1

   519 24 Sep 2021 06:00    1

   520 24 Sep 2021 07:00    1

   521 24 Sep 2021 08:00    1

   522 24 Sep 2021 09:00    1

   523 24 Sep 2021 10:00    1




Specify the Begin and End Snapshot Ids

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

Enter value for begin_snap: 513

Begin Snapshot Id specified: 513


Enter value for end_snap: 523

End   Snapshot Id specified: 523




Specify the Report Name

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

The default report file name is awrrpt_1_513_523.html. To use this name,

press <return> to continue, otherwise enter an alternative.


Enter value for report_name: 0924.html


Using the report name 0924.html