AWR report creation?

AWR stands for automatic workload repository.It consists of system performance statistics owned by the sys user.It contains the information about cache sizes(buffer cache and shared pool size),instance efficiency percentages(buffer nowait%,buffer hit%,library hit%),memory statistics(sga%,pga%),fore ground wait events,background wait events,instance activity statistics,tablespace statistics,check point activity and so on.

There is no need to connect using sysdba we can connect using system  user and password.

SQL> show user;
USER is "SYSTEM"

Here we are manually creating the snapshot of awr.

sql>exec dbms_workload_repository.create_snapshot;
           pl/sql procedure sucessfully completed.

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

Current Instance

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

   DB Id    DB Name      Inst Num       Instance

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

 1007941435 SUBBU2              1        subbu2

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: text

Type Specified:  text

Instances in this Workload Repository schema

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

   DB Id     Inst Num DB Name      Instance     Host

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

* 1007941435        1 SUBBU2       subbu2       subbu2.erp.com

Using 1007941435 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

                                                        

Instance     DB Name        Snap Id    Snap      Started    Level

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

subbu2       SUBBU2               8 23 Sep 2016   15:20      1

                                                9 23 Sep 2016    16:30      1

Specify the Begin and End Snapshot Ids

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

Enter value for begin_snap: 8

Begin Snapshot Id specified: 8

Enter value for end_snap: 9

End   Snapshot Id specified: 9

report will be in the default location i.e /home/oracle1/awrrpt_1_8_9.html

Please download the below sample file for your reference.

https://drive.google.com/file/d/0B2TY8bOhYJjFS1NuSml6V29MVnM/view?usp=sharing