	concepts:

	Oracle Database enables you to transport AWR data between systems. This is useful in cases where you want to use a separate system to perform analysis of the AWR data. To transport AWR data, you must first extract the AWR snapshot data from the database on the source system, then load the data into the database on the target system, as described in the following sections:

	■ Extracting AWR Data

	■ Loading AWR Data

	methods:

	Extracting AWR Data

	執行指令碼@$ORACLE_HOME/rdbms/admin/awrextr.sql，根據提示做相應操作

	Loading AWR Data

	執行指令碼@$ORACLE_HOME/rdbms/admin/awrload.sql，根據提示做相應操作

	匯入完成後，檢視dba_hist_snapshot檢視匯入的情況

AWR快照資料遷移（Transporting Automatic Workload Repository Data）

相關文章