awr导出导入分析.docVIP

awr导出/导入/分析 很多时候我们直接在客户机器上分析awr不太方便,需要通过收集客户awr信息到另一台机器上进行分析数据库性能等.这种情况下,就需要对客户的awr数据进行导出,然后导入到其他机器上,再进行深入分析.导出awr数据 SQL @?/rdbms/admin/awrextr.sql ~~~~~~~~~~~~~ AWR EXTRACT ~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~ This script will extract the AWR data for a range of snapshots ~ ~ into a dump file. The script will prompt users for the ~ ~ following information: ~ ~ (1) database id ~ ~ (2) snapshot range to extract ~ ~ (3) name of directory object ~ ~ (4) name of dump file ~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Databases in this Workload Repository schema ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id DB Name Host ------------ ------------ ------------ * 1393262699 XIFENFEI XIFENFEI-PC 3753332923 FDJDB ora1 3753332923 FDJDB ora2 The default database id is the local one: 1393262699. To use this database id, press return to continue, otherwise enter an alternative. 输入 dbid 的值: 3753332923 --需要输入 Using 3753332923 for Database ID Specify the number of days of snapshots to choose from ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Entering the number of days (n) will result in the most recent (n) days of snapshots being listed. Pressing return without specifying a number lists all completed snapshots. 输入 num_days 的值: 1 --需要输入 Listing the last days Completed Snapshots DB Name Snap Id Snap Started ------------ --------- ------------------ FDJDB 906 23 4月 2012 00:00 907 23 4月 2012 01:00 908 23 4月 2012 02:00 909 23 4月 2012 03:00 910 23 4月 2012 04:00 911 23 4月 2012 05:00