Generation of AWR

Generation of AWR in text format.
------------------------------------------

SQL> select 
                   output 
           from
                   TABLE 
                      (dbms_workload_repository.awr_report_text
                        (dbid, instance number, begin snapid, end snapid)
                      );


example :

select 
                   output 
           from
                   TABLE 
                      (dbms_workload_repository.awr_report_text
                        (45687812, 1, 3154,3164)
                      );

OUTPUT

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

WORKLOAD REPOSITORY report for

 

DB Name       DB Id    Instance  Inst Num Release     Cluster Host

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

DBDABR        45687812   test_db     1       10.1.0.2.0  NO      Host1

 

              Snap Id      Snap Time      Sessions Curs/Sess

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

Begin Snap:      3154 28-Aug-15 11:00:29        18       5.2

  End Snap:      3164 28-Aug-15 22:00:16        18       4.6

   Elapsed:              659.78 (mins)

   DB Time:               10.08 (mins)

 

Cache Sizes (end)

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

            Buffer Cache:        48M      Std Block Size:         8K

        Shared Pool Size:        56M          Log Buffer:       256K

 

Load Profile

~~~~                            Per Second       Per Transaction

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

                  Redo size:      1,766.20             18,526.31

              Logical reads:         39.21                411.30

              Block changes:         11.11                116.54

             Physical reads:          0.38                  3.95

            Physical writes:          0.38                  3.96

                 User calls:          0.06                  0.64

                     Parses:          2.04                 21.37

                Hard parses:          0.14                  1.45

                      Sorts:          1.02                 10.72

                     Logons:          0.02                  0.21

                   Executes:          4.19                 43.91