Saturday, June 13, 2009

Transfer AWR data

We can transfer AWR information to another database:

  1. The script @$ORACLE_HOME/rdbms/admin/awrextr.sql lets you extract AWR information.
  2. Copy the dump file to the destination server where you want to import the AWR data.
  3. Import the AWR data executing the @$ORACLE_HOME/rdbms/admin/awrload.sql in the destination database.

0 comments: