[Oracle]-performance optimization tool (4)-AWRDD

AWRDD is used to compare two AWR snapshots for different periods of performance.

Run the following statement to obtain AWRDD:

@? /Rdbms/admin/awrddrpt. sql2025 23 February 20 14 12026 23 February 20 14 12027 23 February 20 14 12028 23 February 20 14 12029 23 February 20 14 12030 23 February 20 14 23 February 20 14 23 February 20 14 23 12033 23 August 14 31 12034 23 August 14 12035 23 August 14 August 23 August 14 August 14 August 23 August 14 August 14 August 14 August 12036 12037 1 Specify The First Pair of Begin and End Snapshot Ids ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~ Enter the begin_snap value: 2025 First Begin Snapshot Id specified: 2025 enter the end_snap value: 2034 Specify the Second Pair of Begin and End Snapshot Ids ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~ Enter the value of begin_snap2: 2035 Second Begin Snapshot Id specified: 2035 enter the value of end_snap2: 2040