Steps for Comparing 2 AWR reports from different databases

Firstly there is no direct way/option of comparing 2 complete different oracle databases but however there are certain steps need to perform to achieve this.

To transport AWR data from one system to another, first export the AWR data from the database on the source system, and then import it into the database on the target system so that you have both awr info in single DB to compare

High Level Steps

Extract the AWR data from the SOURCE database (@?/rdbms/admin/awrextr.sql ) Transfer the data dumps to TARGET machine/server Load the AWR data to TARGET DATABASE (using @?/rdbms/admin/awrload.sql) generate an AWR Compare Periods report (using @?/rdbms/admin/awrddrpt.sql )

Step 1: Prepare Directory

Create a directory or use the existing one with write permissions to it

Step 2: Export AWR Data from Source Database

@$ORACLE_HOME/rdbms/admin/awrextr.sql

You will be prompted for:
(1) database id
(2) snapshot range to extract
(3) name of directory object
(4) name of dump file
(5) export sql monitor data or not

Step 3: Transfer Export Dump File to Target Server

Copy .dmp file to target server/ location

Step 4: Prepare Directory Object in Target Database
Create a directory or use the existing one where you need to place the source dump

Step 5: Import AWR Data into Target Database
Run the “awrload.sql” script as SYS in the target database to load the data, if you are using PDB then set container to that PDB and run the script below

@$ORACLE_HOME/rdbms/admin/awrload.sql

Step 6: Generate Compare Period Report in Target Database

@$ORACLE_HOME/rdbms/admin/awrddrpt.sql

• All Options are all Self explanatory