AWR report

 ps -ef|grep pmon

sqlplus / as sysdba

select * from v$version;

SQL> show parameter control_management_pack_access;

NAME                                 TYPE        VALUE

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

control_management_pack_access       string      DIAGNOSTIC+TUNING

exit;

[oracle@ifsrepdb ~]$ cd $ORACLE_HOME/rdbms/admin/@awrrpt.sql

/*

[oracle@ifsrepdb ~]$ cd $ORACLE_HOME/

[oracle@ifsrepdb dbhome_1]$ cd 

[oracle@ifsrepdb admin] ls -lrt

[oracle@ifsrepdb admin]$ ls -lrt awrrpt*

*/

[oracle@ifsrepdb admin]$ sqlplus / as sysdba

SQL> @awrrpt.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: html

Enter value for num_days: 2

Enter value for snapshot start: 100

Enter value for snapshot end: 102

Enter report format name: awrreportdb.html

exit

ls -lrt 

pwd 

/u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin

go to WinSip