[Oracle]-Performance optimization tool (4)-Awrdd

The Awrdd is used to compare two awr snapshots for different periods of performance.

Execute the following statement to get AWRDD:

@?/rdbms/admin/awrddrpt.sql2025 23 February  07:12     12026 23 February     12027 23 February     All 12028 23 February  10:00am     12029 23 February     11:24 12030 23 February     12031 23 February  2014 11:26     12032 23 February  11:31     12033 23 February  11:31     12034 23 February  11:41     12035 23 February 
   
    2014 13:00     12036 23 February     12037 23 February  15:00     12038 23 February  15:55     12039 23 February  15:56     12040 23 February  15:56 1Specify The first Pair of Begin and     End Snapshot ids~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ input Begin_snap value:  2025First begin Snapshot Id specified:2025 input Value of End_snap:  2034Specify the Second Pair of Begin and End Snapshot ids~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~ input BEGIN_SNAP2 value:  2035Second begin Snapshot Id specified:2035 input end_snap2 value:  2040