关于AWR的快照数据可以导出、导入，一直没有验证过。今天动手测试了一下如何导出、导入AWR数据，将AWR的数据从一测试服务器，导入到另外一台测试服务器。
SQL> @?/rdbms/admin/awrextr.sql ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Disclaimer: This SQL/Plus script should only be called under the guidance of Oracle Support. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~ 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 ------------ ------------ ------------ * 3990839260 SCM2 localhost .localhost.com The default database id is the local one: '3990839260'. To use this database id, press <return> to continue, otherwise enter an alternative. Enter value for dbid: Using 3990839260 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. Enter value for num_days: 2 Listing the last 2 days of Completed Snapshots DB Name Snap Id Snap Started ------------ --------- ------------------ SCM2 59907 19 Jul 2016 00:00 59908 19 Jul 2016 01:00 59909 19 Jul 2016 02:00 59910 19 Jul 2016 03:00 59911 19 Jul 2016 04:00 59912 19 Jul 2016 05:00 59913 19 Jul 2016 06:00 59914 19 Jul 2016 07:00 59915 19 Jul 2016 08:00 59916 19 Jul 2016 09:00 59917 19 Jul 2016 10:00 DB Name Snap Id Snap Started ------------ --------- ------------------ SCM2 59918 19 Jul 2016 11:00 59919 19 Jul 2016 12:00 59920 19 Jul 2016 13:00 59921 19 Jul 2016 14:00 59922 19 Jul 2016 15:00 59923 19 Jul 2016 16:00 59924 19 Jul 2016 17:00 59925 19 Jul 2016 18:00 59926 19 Jul 2016 19:00 59927 19 Jul 2016 20:00 59928 19 Jul 2016 21:00 DB Name Snap Id Snap Started ------------ --------- ------------------ SCM2 59929 19 Jul 2016 22:00 59930 19 Jul 2016 23:00 59931 20 Jul 2016 00:00 59932 20 Jul 2016 01:00 59933 20 Jul 2016 02:00 59934 20 Jul 2016 03:00 59935 20 Jul 2016 04:00 59936 20 Jul 2016 05:00 59937 20 Jul 2016 06:00 59938 20 Jul 2016 07:00 59939 20 Jul 2016 08:00 DB Name Snap Id Snap Started ------------ --------- ------------------ SCM2 59940 20 Jul 2016 09:01 59941 20 Jul 2016 10:00 59942 20 Jul 2016 11:00 59943 20 Jul 2016 12:00 59944 20 Jul 2016 13:00 59945 20 Jul 2016 14:00 Specify the Begin and End Snapshot Ids ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Enter value for begin_snap: 59940 Begin Snapshot Id specified: 59940 Enter value for end_snap: 59945 End Snapshot Id specified: 59945 Specify the Directory Name ~~~~~~~~~~~~~~~~~~~~~~~~~~ Directory Name Directory Path ------------------------------ ------------------------------------------------- ARCH_DATA /u01/app/oracle/dump DATAPUMP /u02/backup/datapump DATA_PUMP_DIR /u01/app/oracle/product/10.2.0/db_1/rdbms/log/ DUMPDIR /home/oraescm/dump DUMP_DIR /u05/dump PUMP_DIR /u02/dump4migrate WORK_DIR /ade/aime_10.2_lnx_push/oracle/work Choose a Directory Name from the above list (case-sensitive). Enter value for directory_name: DUMP_DIRDUMP_DIR Using the dump directory: DUMP_DIR Specify the Name of the Extract Dump File ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The prefix for the default dump file name is awrdat_59940_59945. To use this name, press <return> to continue, otherwise enter an alternative. Enter value for file_name: awr_out.dmp Using the dump file prefix: awr_out.dmp | | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | The AWR extract dump file will be located | in the following directory/file: | /u05/dump | awr_out.dmp.dmp | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | | *** AWR Extract Started ... | | This operation will take a few moments. The | progress of the AWR extract operation can be | monitored in the following directory/file: | /u05/dump | awr_out.dmp.log | WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1) Added filter [WHERE DBID = 3990839260] for table WRH$_STAT_NAME Added filter [WHERE DBID = 3990839260] for table WRH$_PARAMETER_NAME Added filter [WHERE DBID = 3990839260] for table WRH$_EVENT_NAME Added filter [WHERE DBID = 3990839260] for table WRH$_LATCH_NAME Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_FILESTATXS_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_FILESTATXS Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_TEMPSTATXS Added filter [WHERE DBID = 3990839260] for table WRH$_DATAFILE Added filter [WHERE DBID = 3990839260] for table WRH$_TEMPFILE Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_SQLSTAT_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_SQLSTAT Added filter [ WHERE (DBID, SQL_ID) IN (SELECT DBID, SQL_ID FROM SYS.WRH$_SQLSTAT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945)] for table WRH$_SQLTEXT Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SQL_SUMMARY Added filter [ WHERE (DBID, SQL_ID, PLAN_HASH_VALUE) IN (SELECT DBID, SQL_ID, PLAN_HASH_VALUE FROM SYS.WRH$_SQLSTAT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945)] for table WRH$_SQL_PLAN Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_SYSTEM_EVENT_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_SYSTEM_EVENT Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_BG_EVENT_SUMMARY Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_WAITSTAT_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_WAITSTAT Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_ENQUEUE_STAT Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_LATCH_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_LATCH Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_LATCH_CHILDREN_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_LATCH_CHILDREN Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_LATCH_PARENT_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_LATCH_PARENT Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_LATCH_MISSES_SUMMARY_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_LATCH_MISSES_SUMMARY Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_LIBRARYCACHE Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_DB_CACHE_ADVICE_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_DB_CACHE_ADVICE Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_BUFFER_POOL_STATISTICS Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_ROWCACHE_SUMMARY_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_ROWCACHE_SUMMARY Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SGA Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_SGASTAT_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_SGASTAT Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_PGASTAT Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_PROCESS_MEMORY_SUMMARY Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_RESOURCE_LIMIT Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SHARED_POOL_ADVICE Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SQL_WORKAREA_HISTOGRAM Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_PGA_TARGET_ADVICE Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_INSTANCE_RECOVERY Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_SYSSTAT_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_SYSSTAT Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_PARAMETER_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_PARAMETER Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_UNDOSTAT Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_SEG_STAT_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_SEG_STAT Added filter [WHERE DBID = 3990839260] for table WRH$_SEG_STAT_OBJ Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_DLM_MISC_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_DLM_MISC Added filter [WHERE DBID = 3990839260] for table WRH$_SERVICE_NAME Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_SERVICE_STAT_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_SERVICE_STAT Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SYSMETRIC_HISTORY Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_FILEMETRIC_HISTORY Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_WAITCLASSMETRIC_HISTORY Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_TABLESPACE_STAT_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_TABLESPACE_STAT Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_LOG Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_MTTR_TARGET_ADVICE Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_TABLESPACE_SPACE_USAGE Added filter [WHERE DBID = 3990839260] for table WRH$_METRIC_NAME Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SYSMETRIC_SUMMARY Added filter [WHERE DBID = 3990839260] for table WRH$_SQL_BIND_METADATA Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_JAVA_POOL_ADVICE Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_THREAD Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SESSMETRIC_HISTORY Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_OSSTAT_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_OSSTAT Added filter [WHERE DBID = 3990839260] for table WRH$_OSSTAT_NAME Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_SYS_TIME_MODEL_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_SYS_TIME_MODEL Added filter [WHERE DBID = 3990839260] for table WRH$_OPTIMIZER_ENV Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_SERVICE_WAIT_CLASS_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_SERVICE_WAIT_CLASS Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_CR_BLOCK_SERVER Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_CURRENT_BLOCK_SERVER Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_INST_CACHE_TRANSFER_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_INST_CACHE_TRANSFER Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_STREAMS_POOL_ADVICE Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_COMP_IOSTAT Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SGA_TARGET_ADVICE Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SESS_TIME_STATS Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_STREAMS_CAPTURE Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_STREAMS_APPLY_SUM Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_BUFFERED_QUEUES Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_BUFFERED_SUBSCRIBERS Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_RULE_SET Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_ACTIVE_SESSION_HISTORY_BL Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_ACTIVE_SESSION_HISTORY Starting "SYS"."SYS_EXPORT_TABLE_01": Estimate in progress using BLOCKS method... Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 17.66 GB Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type TABLE_EXPORT/TABLE/COMMENT Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT . . exported "SYS"."WRH$_SQL_PLAN" 4.294 MB 11010 rows . . exported "SYS"."WRH$_SQLTEXT" 2.090 MB 267 rows . . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY_BL" 17.58 KB 0 rows . . exported "SYS"."WRH$_SQL_BIND_METADATA" 28.31 MB 445685 rows . . exported "SYS"."WRH$_SQLSTAT_BL" 23.03 KB 0 rows . . exported "SYS"."WRH$_LATCH_BL" 9.468 KB 0 rows . . exported "SYS"."WRH$_SEG_STAT_OBJ" 16.81 MB 169106 rows . . exported "SYS"."WRH$_SEG_STAT_BL" 16.60 KB 0 rows . . exported "SYS"."WRH$_SYSMETRIC_SUMMARY" 70.07 KB 810 rows . . exported "SYS"."WRH$_PARAMETER_BL" 6.742 KB 0 rows . . exported "SYS"."WRH$_SYSSTAT_BL" 6.117 KB 0 rows . . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY_BL" 7.070 KB 0 rows . . exported "SYS"."WRH$_ENQUEUE_STAT" 30.50 KB 426 rows . . exported "SYS"."WRH$_SYSTEM_EVENT_BL" 6.75 KB 0 rows . . exported "SYS"."WRH$_FILESTATXS_BL" 9.179 KB 0 rows . . exported "SYS"."WRH$_SERVICE_STAT_BL" 6.429 KB 0 rows . . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59596" 17.57 KB 0 rows . . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59692" 17.57 KB 0 rows . . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59749" 17.57 KB 0 rows . . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59797" 17.57 KB 0 rows . . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59845" 17.57 KB 0 rows . . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59893" 45.37 KB 136 rows . . exported "SYS"."WRH$_ROWCACHE_SUMMARY_BL" 9.5 KB 0 rows . . exported "SYS"."WRH$_TABLESPACE_SPACE_USAGE" 17.85 KB 210 rows . . exported "SYS"."WRH$_TABLESPACE_STAT_BL" 7.671 KB 0 rows . . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59644" 17.57 KB 0 rows . . exported "SYS"."WRH$_BG_EVENT_SUMMARY" 14.00 KB 192 rows . . exported "SYS"."WRH$_DB_CACHE_ADVICE_BL" 8.617 KB 0 rows . . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3990839260_59596" 9.468 KB 0 rows . . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3990839260_59644" 9.468 KB 0 rows . . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3990839260_59692" 9.468 KB 0 rows . . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3990839260_59749" 9.468 KB 0 rows . . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3990839260_59797" 9.468 KB 0 rows . . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3990839260_59845" 9.468 KB 0 rows . . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3990839260_59893" 30.12 KB 395 rows . . exported "SYS"."WRH$_LIBRARYCACHE" 13.16 KB 66 rows . . exported "SYS"."WRH$_PGASTAT" 11.07 KB 102 rows . . exported "SYS"."WRH$_PGA_TARGET_ADVICE" 12.16 KB 84 rows . . exported "SYS"."WRH$_SERVICE_WAIT_CLASS_BL" 7.062 KB 0 rows . . exported "SYS"."WRH$_SHARED_POOL_ADVICE" 15.49 KB 111 rows . . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3990839260_59596" 23.02 KB 0 rows . . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3990839260_59644" 23.02 KB 0 rows . . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3990839260_59692" 23.02 KB 0 rows . . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3990839260_59749" 23.02 KB 0 rows . . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3990839260_59797" 23.02 KB 0 rows . . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3990839260_59845" 23.02 KB 0 rows . . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3990839260_59893" 54.11 KB 122 rows . . exported "SYS"."WRH$_SQL_WORKAREA_HISTOGRAM" 11.61 KB 96 rows . . exported "SYS"."WRH$_SGASTAT_BL" 6.421 KB 0 rows . . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3990839260_59692" 16.60 KB 0 rows . . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3990839260_59692" 7.062 KB 0 rows . . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3990839260_59596" 16.60 KB 0 rows . . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3990839260_59644" 16.60 KB 0 rows . . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3990839260_59749" 16.60 KB 0 rows . . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3990839260_59797" 16.60 KB 0 rows . . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3990839260_59893" 30.90 KB 124 rows . . exported "SYS"."WRH$_WAITSTAT_BL" 6.421 KB 0 rows . . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3990839260_59749" 7.062 KB 0 rows . . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3990839260_59797" 7.062 KB 0 rows . . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3990839260_59845" 7.062 KB 0 rows . . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3990839260_59893" 21.11 KB 227 rows . . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3990839260_59692" 6.742 KB 0 rows . . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3990839260_59845" 16.60 KB 0 rows . . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3990839260_59692" 6.117 KB 0 rows . . exported "SYS"."WRH$_SYS_TIME_MODEL_BL" 6.125 KB 0 rows . . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3990839260_59644" 7.062 KB 0 rows . . exported "SYS"."WRH$_STREAMS_POOL_ADVICE" 11.39 KB 120 rows . . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3990839260_59596" 7.062 KB 0 rows . . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3990839260_59596" 6.742 KB 0 rows . . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3990839260_59644" 6.742 KB 0 rows . . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3990839260_59749" 6.742 KB 0 rows . . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3990839260_59797" 6.742 KB 0 rows . . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3990839260_59845" 6.742 KB 0 rows . . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3990839260_59893" 18.04 KB 270 rows . . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3990839260_59596" 6.117 KB 0 rows . . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3990839260_59644" 6.117 KB 0 rows . . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3990839260_59749" 6.117 KB 0 rows . . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3990839260_59797" 6.117 KB 0 rows . . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3990839260_59845" 6.117 KB 0 rows . . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3990839260_59893" 17.52 KB 388 rows . . exported "SYS"."WRH$_LOG" 10.60 KB 36 rows . . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59941" 361.1 KB 1640 rows . . exported "SYS"."WRH$_PROCESS_MEMORY_SUMMARY" 9.75 KB 24 rows . . exported "SYS"."WRH$_RESOURCE_LIMIT" 8.914 KB 30 rows . . exported "SYS"."WRH$_SGA_TARGET_ADVICE" 8.179 KB 45 rows . . exported "SYS"."WRH$_TEMPSTATXS" 10.06 KB 12 rows . . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3990839260_59692" 9.171 KB 0 rows . . exported "SYS"."WRH$_OSSTAT_BL" 6.117 KB 0 rows . . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3990839260_59596" 9.171 KB 0 rows . . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3990839260_59644" 9.171 KB 0 rows . . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3990839260_59749" 9.171 KB 0 rows . . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3990839260_59797" 9.171 KB 0 rows . . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3990839260_59845" 9.171 KB 0 rows . . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3990839260_59893" 14.51 KB 72 rows . . exported "SYS"."WRH$_SGA" 7.039 KB 24 rows . . exported "SYS"."WRH$_BUFFER_POOL_STATISTICS" 12.45 KB 6 rows . . exported "SYS"."WRH$_JAVA_POOL_ADVICE" 8.867 KB 12 rows . . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3990839260_59692" 9.5 KB 0 rows . . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3990839260_59692" 6.429 KB 0 rows . . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3990839260_59941" 178.8 KB 590 rows . . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3990839260_59596" 6.742 KB 0 rows . . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3990839260_59644" 6.742 KB 0 rows . . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3990839260_59692" 6.742 KB 0 rows . . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3990839260_59749" 6.742 KB 0 rows . . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3990839260_59797" 6.742 KB 0 rows . . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3990839260_59845" 6.742 KB 0 rows . . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3990839260_59893" 10.51 KB 99 rows . . exported "SYS"."WRH$_INSTANCE_RECOVERY" 11.71 KB 6 rows . . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3990839260_59941" 112.7 KB 1975 rows . . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3990839260_59596" 9.5 KB 0 rows . . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3990839260_59644" 9.5 KB 0 rows . . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3990839260_59749" 9.5 KB 0 rows . . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3990839260_59797" 9.5 KB 0 rows . . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3990839260_59845" 9.5 KB 0 rows . . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3990839260_59893" 12.45 KB 47 rows . . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3990839260_59596" 6.429 KB 0 rows . . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3990839260_59644" 6.429 KB 0 rows . . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3990839260_59749" 6.429 KB 0 rows . . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3990839260_59797" 6.429 KB 0 rows . . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3990839260_59845" 6.429 KB 0 rows . . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3990839260_59893" 9.539 KB 84 rows . . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3990839260_59596" 7.671 KB 0 rows . . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3990839260_59644" 7.671 KB 0 rows . . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3990839260_59692" 7.671 KB 0 rows . . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3990839260_59749" 7.671 KB 0 rows . . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3990839260_59797" 7.671 KB 0 rows . . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3990839260_59845" 7.671 KB 0 rows . . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3990839260_59893" 9.976 KB 34 rows . . exported "SYS"."WRM$_SNAPSHOT" 8.820 KB 6 rows . . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_3990839260_59596" 8.617 KB 0 rows . . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_3990839260_59644" 8.617 KB 0 rows . . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_3990839260_59692" 8.617 KB 0 rows . . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_3990839260_59749" 8.617 KB 0 rows . . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_3990839260_59797" 8.617 KB 0 rows . . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_3990839260_59845" 8.617 KB 0 rows . . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_3990839260_59893" 9.820 KB 21 rows . . exported "SYS"."WRH$_EVENT_NAME" 70.96 KB 917 rows . . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3990839260_59941" 77.31 KB 1135 rows . . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3990839260_59941" 63.25 KB 1350 rows . . exported "SYS"."WRH$_PARAMETER_NAME" 70.03 KB 1623 rows . . exported "SYS"."WRH$_RULE_SET" 8.625 KB 6 rows . . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3990839260_59941" 100.0 KB 710 rows . . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3990839260_59596" 7.062 KB 0 rows . . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3990839260_59644" 7.062 KB 0 rows . . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3990839260_59692" 7.062 KB 0 rows . . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3990839260_59749" 7.062 KB 0 rows . . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3990839260_59797" 7.062 KB 0 rows . . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3990839260_59845" 7.062 KB 0 rows . . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3990839260_59893" 8.460 KB 27 rows . . exported "SYS"."WRH$_SESS_TIME_STATS" 7.671 KB 12 rows . . exported "SYS"."WRH$_SQL_SUMMARY" 7.007 KB 6 rows . . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3990839260_59941" 63.13 KB 1940 rows . . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3990839260_59692" 6.117 KB 0 rows . . exported "SYS"."WRH$_THREAD" 7.617 KB 6 rows . . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_3990839260_59692" 6.421 KB 0 rows . . exported "SYS"."WRH$_BUFFERED_QUEUES" 7.968 KB 0 rows . . exported "SYS"."WRH$_BUFFERED_SUBSCRIBERS" 8.632 KB 0 rows . . exported "SYS"."WRH$_COMP_IOSTAT" 7.695 KB 6 rows . . exported "SYS"."WRH$_DATAFILE" 13.37 KB 82 rows . . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_3990839260_59941" 14.61 KB 105 rows . . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3990839260_59941" 35.90 KB 360 rows . . exported "SYS"."WRH$_LATCH_NAME" 23.05 KB 400 rows . . exported "SYS"."WRH$_METRIC_NAME" 24.89 KB 212 rows . . exported "SYS"."WRH$_OPTIMIZER_ENV" 26.26 KB 127 rows . . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_3990839260_59596" 6.109 KB 0 rows . . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_3990839260_59644" 6.109 KB 0 rows . . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_3990839260_59692" 6.109 KB 0 rows . . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_3990839260_59749" 6.109 KB 0 rows . . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_3990839260_59797" 6.109 KB 0 rows . . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_3990839260_59845" 6.109 KB 0 rows . . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_3990839260_59893" 6.468 KB 13 rows . . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_3990839260_59941" 7.890 KB 65 rows . . exported "SYS"."WRH$_OSSTAT_NAME" 5.859 KB 13 rows . . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3990839260_59941" 24.27 KB 235 rows . . exported "SYS"."WRH$_SERVICE_NAME" 5.929 KB 3 rows . . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3990839260_59941" 21.98 KB 420 rows . . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3990839260_59941" 14.03 KB 135 rows . . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_3990839260_59596" 6.414 KB 0 rows . . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_3990839260_59644" 6.414 KB 0 rows . . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_3990839260_59692" 6.414 KB 0 rows . . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_3990839260_59749" 6.414 KB 0 rows . . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_3990839260_59797" 6.414 KB 0 rows . . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_3990839260_59845" 6.414 KB 0 rows . . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_3990839260_59893" 7.062 KB 14 rows . . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_3990839260_59941" 9.640 KB 70 rows . . exported "SYS"."WRH$_STAT_NAME" 23.33 KB 406 rows . . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3990839260_59941" 25.58 KB 495 rows . . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3990839260_59596" 6.117 KB 0 rows . . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3990839260_59644" 6.117 KB 0 rows . . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3990839260_59749" 6.117 KB 0 rows . . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3990839260_59797" 6.117 KB 0 rows . . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3990839260_59845" 6.117 KB 0 rows . . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3990839260_59893" 6.726 KB 19 rows . . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3990839260_59941" 9.156 KB 95 rows . . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3990839260_59941" 19.16 KB 170 rows . . exported "SYS"."WRH$_TEMPFILE" 7.546 KB 7 rows . . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_3990839260_59596" 6.421 KB 0 rows . . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_3990839260_59644" 6.421 KB 0 rows . . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_3990839260_59749" 6.421 KB 0 rows . . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_3990839260_59797" 6.421 KB 0 rows . . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_3990839260_59845" 6.421 KB 0 rows . . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_3990839260_59893" 7.093 KB 18 rows . . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_3990839260_59941" 9.757 KB 90 rows . . exported "SYS"."WRM$_DATABASE_INSTANCE" 7.460 KB 1 rows . . exported "SYS"."WRM$_WR_CONTROL" 10.13 KB 1 rows . . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_SES_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_CR_BLOCK_SERVER" 0 KB 0 rows . . exported "SYS"."WRH$_CURRENT_BLOCK_SERVER" 0 KB 0 rows . . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CACHE_AD_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_DLM_MISC":"WRH$_DLM_MISC_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_DLM_MISC":"WRH$_DLM_MI_3990839260_0" 0 KB 0 rows . . exported "SYS"."WRH$_DLM_MISC_BL" 0 KB 0 rows . . exported "SYS"."WRH$_FILEMETRIC_HISTORY" 0 KB 0 rows . . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILESTATXS_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_INST_CACHE_TRANSFER":"WRH$_INST_CACHE_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_INST_CACHE_TRANSFER":"WRH$_INST_C_3990839260_0" 0 KB 0 rows . . exported "SYS"."WRH$_INST_CACHE_TRANSFER_BL" 0 KB 0 rows . . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_LATCH_CHILDREN":"WRH$_LATCH_CHILD_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_LATCH_CHILDREN":"WRH$_LATCH__3990839260_0" 0 KB 0 rows . . exported "SYS"."WRH$_LATCH_CHILDREN_BL" 0 KB 0 rows . . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH_MISSE_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_LATCH_PARENT":"WRH$_LATCH_PAREN_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_LATCH_PARENT":"WRH$_LATCH__3990839260_0" 0 KB 0 rows . . exported "SYS"."WRH$_LATCH_PARENT_BL" 0 KB 0 rows . . exported "SYS"."WRH$_MTTR_TARGET_ADVICE" 0 KB 0 rows . . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAMETER_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCACHE_SU_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_STAT_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVICE_STAT_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVICE_WAIT_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_SESSMETRIC_HISTORY" 0 KB 0 rows . . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTAT_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTAT_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_STREAMS_APPLY_SUM" 0 KB 0 rows . . exported "SYS"."WRH$_STREAMS_CAPTURE" 0 KB 0 rows . . exported "SYS"."WRH$_SYSMETRIC_HISTORY" 0 KB 0 rows . . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTAT_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_EVEN_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TIME_MO_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLESPACE_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRH$_UNDOSTAT" 0 KB 0 rows . . exported "SYS"."WRH$_WAITCLASSMETRIC_HISTORY" 0 KB 0 rows . . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITSTAT_MXDB_MXSN" 0 KB 0 rows . . exported "SYS"."WRM$_SNAP_ERROR" 0 KB 0 rows . . exported "SYS"."WRR$_CAPTURES" 0 KB 0 rows . . exported "SYS"."WRR$_CAPTURE_STATS" 0 KB 0 rows . . exported "SYS"."WRR$_FILTERS" 0 KB 0 rows Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYS.SYS_EXPORT_TABLE_01 is: /u05/dump/awr_out.dmp.dmp Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at 14:09:24 SQL>
. 
如上所示，导出成功，在/u05/dump下生成了awr_out.dmp.dmp、awr_out.dmp.log文件，其实在指定文件名，只需要指定名称即可，不需要指定后缀名，否则就会生成像我这样，生成awr_out.dmp.dmp这样的文件。
AWR的数据导入，使用awrload.sql脚本导入，测试过程脚本如下所示，中间遇到ORA-39083 & ORA-00439这样的错误。这个是因为我测试的时候，使用是标准版的缘故（标准版不支持分区表）。企业版本不会遇到这个问题
SQL> @?/rdbms/admin/awrload.sql
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Disclaimer: This SQL/Plus script should only be called under
the guidance of Oracle Support.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~
AWR LOAD
~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ This script will load the AWR data from a dump file. The ~
~ script will prompt users for the following information: ~
~ (1) name of directory object ~
~ (2) name of dump file ~
~ (3) staging schema name to load AWR data into ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~
Directory Name Directory Path
------------------------------ -------------------------------------------------
ADMIN_DIR /ade/aime_10.2_lnx_push/oracle/md/admin
CUR_DUMP_DIR /mnt/nfs2/impdata_bak
DATA_IMP /u05/data
DATA_PUMP_DIR /u01/app/oracle/product/10.2.0/db_1/rdbms/log/
DUMPDIR /u05/dump_dir
DUMP_DIR /u01/app/oracle/expdpdump
DUMP_TMP_DIR /u03/flash_recovery_area/tmp
ORACLE_OCM_CONFIG_DIR /u01/app/oracle/product/10.2.0/db_1/ccr/state
WORK_DIR /ade/aime_10.2_lnx_push/oracle/work
X$ALERT_LOG$X /u01/app/oracle/admin/epps/bdump
Choose a Directory Name from the list above (case-sensitive).
Enter value for directory_name: DUMPDIR
Using the dump directory: DUMPDIR
Specify the Name of the Dump File to Load
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please specify the prefix of the dump file (.dmp) to load:
Enter value for file_name: awr_out.dmp
Loading from the file name: awr_out.dmp.dmp
Staging Schema to Load AWR Snapshot Data
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The next step is to create the staging schema
where the AWR snapshot data will be loaded.
After loading the data into the staging schema,
the data will be transferred into the AWR tables
in the SYS schema.
The default staging schema name is AWR_STAGE.
To use this name, press <return> to continue, otherwise enter
an alternative.
Enter value for schema_name: AWR_STAGE
Using the staging schema name: AWR_STAGE
Choose the Default tablespace for the AWR_STAGE user
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Choose the AWR_STAGE users's default tablespace. This is the
tablespace in which the AWR data will be staged.
TABLESPACE_NAME CONTENTS DEFAULT TABLESPACE
------------------------------ --------- ------------------
DATA PERMANENT
RMAN_DATA PERMANENT
SYSAUX PERMANENT
USERS PERMANENT
TEST PERMANENT
Pressing <return> will result in the recommended default
tablespace (identified by *) being used.
Enter value for default_tablespace: TEST
Using tablespace TEST as the default tablespace for the AWR_STAGE
Choose the Temporary tablespace for the AWR_STAGE user
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Choose the AWR_STAGE user's temporary tablespace.
TABLESPACE_NAME CONTENTS DEFAULT TEMP TABLESPACE
------------------------------ --------- -----------------------
TEMP TEMPORARY *
Pressing <return> will result in the database's default temporary
tablespace (identified by *) being used.
Enter value for temporary_tablespace:
Using tablespace TEMP as the temporary tablespace for AWR_STAGE
... Creating AWR_STAGE user
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Loading the AWR data from the following
| directory/file:
| /u05/dump_dir
| awr_out.dmp.dmp
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| *** AWR Load Started ...
|
| This operation will take a few moments. The
| progress of the AWR load operation can be
| monitored in the following directory/file:
| /u05/dump_dir
| awr_out.dmp.log
|
WHERE (DBID) NOT IN (SELECT DBID FROM AWR_STAGE.WRM$_WR_CONTROL)
WHERE (DBID, INSTANCE_NUMBER, STARTUP_TIME) NOT IN (SELECT DBID, INSTANCE_NUMBER, STARTUP_TIME FROM
AWR_STAGE.WRM$_DATABASE_INSTANCE)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRM$_SNAPSHOT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRM$_SNAP_ERROR)
WHERE (DBID, STAT_ID) NOT IN (SELECT DBID, STAT_ID FROM AWR_STAGE.WRH$_STAT_NAME)
WHERE (DBID, PARAMETER_HASH) NOT IN (SELECT DBID, PARAMETER_HASH FROM AWR_STAGE.WRH$_PARAMETER_NAME)
WHERE (DBID, EVENT_ID) NOT IN (SELECT DBID, EVENT_ID FROM AWR_STAGE.WRH$_EVENT_NAME)
WHERE (DBID, LATCH_HASH) NOT IN (SELECT DBID, LATCH_HASH FROM AWR_STAGE.WRH$_LATCH_NAME)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_FILESTATXS)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_FILESTATXS_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_TEMPSTATXS)
WHERE (DBID, FILE#, CREATION_CHANGE#) NOT IN (SELECT DBID, FILE#, CREATION_CHANGE# FROM
AWR_STAGE.WRH$_DATAFILE)
WHERE (DBID, FILE#, CREATION_CHANGE#) NOT IN (SELECT DBID, FILE#, CREATION_CHANGE# FROM
AWR_STAGE.WRH$_TEMPFILE)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SQLSTAT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SQLSTAT_BL)
WHERE (DBID, SQL_ID) NOT IN (SELECT DBID, SQL_ID FROM AWR_STAGE.WRH$_SQLTEXT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SQL_SUMMARY)
WHERE (DBID, SQL_ID, PLAN_HASH_VALUE, ID) NOT IN (SELECT DBID, SQL_ID, PLAN_HASH_VALUE, ID FROM
AWR_STAGE.WRH$_SQL_PLAN)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SYSTEM_EVENT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SYSTEM_EVENT_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_BG_EVENT_SUMMARY)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_WAITSTAT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_WAITSTAT_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_ENQUEUE_STAT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_LATCH)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_LATCH_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_LATCH_CHILDREN)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_LATCH_CHILDREN_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_LATCH_PARENT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_LATCH_PARENT_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_LATCH_MISSES_SUMMARY)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_LATCH_MISSES_SUMMARY_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_LIBRARYCACHE)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_DB_CACHE_ADVICE)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_DB_CACHE_ADVICE_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_BUFFER_POOL_STATISTICS)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_ROWCACHE_SUMMARY)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_ROWCACHE_SUMMARY_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SGA)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SGASTAT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SGASTAT_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_PGASTAT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_PROCESS_MEMORY_SUMMARY)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_RESOURCE_LIMIT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SHARED_POOL_ADVICE)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SQL_WORKAREA_HISTOGRAM)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_PGA_TARGET_ADVICE)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_INSTANCE_RECOVERY)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SYSSTAT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SYSSTAT_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_PARAMETER)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_PARAMETER_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_UNDOSTAT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SEG_STAT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SEG_STAT_BL)
WHERE (DBID, OBJ#, DATAOBJ#) NOT IN (SELECT DBID, OBJ#, DATAOBJ# FROM AWR_STAGE.WRH$_SEG_STAT_OBJ)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_DLM_MISC)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_DLM_MISC_BL)
WHERE (DBID, SERVICE_NAME_HASH) NOT IN (SELECT DBID, SERVICE_NAME_HASH FROM AWR_STAGE.WRH$_SERVICE_NAME)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SERVICE_STAT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SERVICE_STAT_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SYSMETRIC_HISTORY)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_FILEMETRIC_HISTORY)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_WAITCLASSMETRIC_HISTORY)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_TABLESPACE_STAT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_TABLESPACE_STAT_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_LOG)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_MTTR_TARGET_ADVICE)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_TABLESPACE_SPACE_USAGE)
WHERE (DBID, GROUP_ID, METRIC_ID) NOT IN (SELECT DBID, GROUP_ID, METRIC_ID FROM AWR_STAGE.WRH$_METRIC_NAME)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SYSMETRIC_SUMMARY)
WHERE (DBID, SQL_ID, POSITION) NOT IN (SELECT DBID, SQL_ID, POSITION FROM AWR_STAGE.WRH$_SQL_BIND_METADATA)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_JAVA_POOL_ADVICE)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_THREAD)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SESSMETRIC_HISTORY)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_OSSTAT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_OSSTAT_BL)
WHERE (DBID, STAT_ID) NOT IN (SELECT DBID, STAT_ID FROM AWR_STAGE.WRH$_OSSTAT_NAME)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SYS_TIME_MODEL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SYS_TIME_MODEL_BL)
WHERE (DBID, OPTIMIZER_ENV_HASH_VALUE) NOT IN (SELECT DBID, OPTIMIZER_ENV_HASH_VALUE FROM
AWR_STAGE.WRH$_OPTIMIZER_ENV)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SERVICE_WAIT_CLASS)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SERVICE_WAIT_CLASS_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_CR_BLOCK_SERVER)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_CURRENT_BLOCK_SERVER)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_INST_CACHE_TRANSFER)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_INST_CACHE_TRANSFER_BL)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_STREAMS_POOL_ADVICE)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_COMP_IOSTAT)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SGA_TARGET_ADVICE)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_SESS_TIME_STATS)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_STREAMS_CAPTURE)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_STREAMS_APPLY_SUM)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_BUFFERED_QUEUES)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_BUFFERED_SUBSCRIBERS)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_RULE_SET)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_ACTIVE_SESSION_HISTORY)
WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM AWR_STAGE.WRH$_ACTIVE_SESSION_HISTORY_BL)
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01":
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE failed to create with error:
ORA-00439: feature not enabled: Partitioning
Failing
sql is:
CREATE TABLE "AWR_STAGE"."WRH$_FILESTATXS" ("SNAP_ID" NUMBER NOT NULL ENABLE, "DBID" NUMBER NOT NULL
ENABLE, "INSTANCE_NUMBER" NUMBER NO
T NULL ENABLE, "FILE#" NUMBER NOT NULL ENABLE, "CREATION_CHANGE#" NUMBER NOT NULL ENABLE, "PHYRDS" NUMBER,
"PHYWRTS" NUMBER, "SINGLEBLKRDS" NUMBER, "READTIM" NUMBER, "WRITETIM" NUMBER, "SINGLEBLKRDTIM" NUMBER,
"PHYBLKRD" NUMBER, "PHYBLKWRT" NUMBER, "WAIT_
ORA-39083: Object type TABLE failed to create with error:
ORA-00439: feature not enabled: Partitioning
Failing
sql is:
CREATE TABLE "AWR_STAGE"."WRH$_SQLSTAT" ("SNAP_ID" NUMBER NOT NULL ENABLE, "DBID" NUMBER NOT NULL
ENABLE, "INSTANCE_NUMBER" NUMBER NOT N
ULL ENABLE, "SQL_ID" VARCHAR2(13) NOT NULL ENABLE, "PLAN_HASH_VALUE" NUMBER NOT NULL ENABLE, "OPTIMIZER_COST"
NUMBER, "OPTIMIZER_MODE" VARCHAR2(10), "OPTIMIZER_ENV_HASH_VALUE" NUMBER, "SHARABLE_MEM" NUMBER,
"LOADED_VERSIONS" NUMBER, "VERSION_COUNT" NUMBER
ORA-39083: Object type TABLE failed to create with error:
ORA-00439: feature not enabled: Partitioning
Failing
sql is:
CREATE TABLE "AWR_STAGE"."WRH$_SYSTEM_EVENT" ("SNAP_ID" NUMBER NOT NULL ENABLE, "DBID" NUMBER NOT NULL
ENABLE, "INSTANCE_NUMBER" NUMBER
NOT NULL ENABLE, "EVENT_ID" NUMBER NOT NULL ENABLE, "TOTAL_WAITS" NUMBER, "TOTAL_TIMEOUTS" NUMBER,
"TIME_WAITED_MICRO" NUMBER) PARTITION BY RANGE ("DBID","SNAP_ID") (PARTITION "WRH$_SYSTEM_3990839260_59596"
VALUES LESS THAN (3990839260, 59644) NOCOMPRE
ORA-39083: Object type TABLE failed to create with error:
ORA-00439: feature not enabled: Partitioning
Failing
sql is:
CREATE TABLE "AWR_STAGE"."WRH$_WAITSTAT" ("SNAP_ID" NUMBER NOT NULL ENABLE, "DBID" NUMBER NOT NULL
ENABLE, "INSTANCE_NUMBER" NUMBER NOT
NULL ENABLE, "CLASS" VARCHAR2(18), "WAIT_COUNT" NUMBER, "TIME" NUMBER) PARTITION BY RANGE ("DBID","SNAP_ID")
(PARTITION "WRH$_WAITST_3990839260_59596" VALUES LESS THAN (3990839260, 59644) NOCOMPRESS , PARTITION
"WRH$_WAITST_3990839260_59644" VALUES LE
ORA-39083: Object type TABLE failed to create with error:
ORA-00439: feature not enabled: Partitioning
Failing
sql is:
CREATE TABLE "AWR_STAGE"."WRH$_LATCH" ("SNAP_ID" NUMBER NOT NULL ENABLE, "DBID" NUMBER NOT NULL
ENABLE, "INSTANCE_NUMBER" NUMBER NOT NUL
L ENABLE, "LATCH_HASH" NUMBER NOT NULL ENABLE, "LEVEL#" NUMBER, "GETS" NUMBER, "MISSES" NUMBER, "SLEEPS"
NUMBER, "IMMEDIATE_GETS" NUMBER, "IMMEDIATE_MISSES" NUMBER, "SPIN_GETS" NUMBER, "SLEEP1" NUMBER, "SLEEP2"
NUMBER, "SLEEP3" NUMBER, "SLEEP4" NUMBER, "W
ORA-39083: Object type TABLE failed to create with error:
ORA-00439: feature not enabled: Partitioning
Failing
sql is:
CREATE TABLE "AWR_STAGE"."WRH$_LATCH_CHILDREN" ("SNAP_ID" NUMBER NOT NULL ENABLE, "DBID" NUMBER NOT
NULL ENABLE, "INSTANCE_NUMBER" NUMBE
R NOT NULL ENABLE, "LATCH_HASH" NUMBER NOT NULL ENABLE, "CHILD#" NUMBER NOT NULL ENABLE, "GETS" NUMBER,
"MISSES" NUMBER, "SLEEPS" NUMBER, "IMMEDIATE_GETS" NUMBER, "IMMEDIATE_MISSES" NUMBER, "SPIN_GETS" NUMBER,
"SLEEP1" NUMBER, "SLEEP2" NUMBER, "SLEEP3" NU
ORA-39083: Object type TABLE failed to create with error:
ORA-00439: feature not enabled: Partitioning
Failing
sql is:
CREATE TABLE "AWR_STAGE"."WRH$_LATCH_PARENT" ("SNAP_ID" NUMBER NOT NULL ENABLE, "DBID" NUMBER NOT NULL
ENABLE, "INSTANCE_NUMBER" NUMBER
NOT NULL ENABLE, "LATCH_HASH" NUMBER NOT NULL ENABLE, "LEVEL#" NUMBER NOT NULL ENABLE, "GETS" NUMBER, "MISSES"
NUMBER, "SLEEPS" NUMBER, "IMMEDIATE_GETS" NUMBER, "IMMEDIATE_MISSES" NUMBER, "SPIN_GETS" NUMBER, "SLEEP1"
NUMBER, "SLEEP2" NUMBER, "SLEEP3" NUMB
ORA-39083: Object type TABLE failed to create with error:
ORA-00439: feature not enabled: Partitioning
Failing
sql is:
CREATE TABLE "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY" ("SNAP_ID" NUMBER NOT NULL ENABLE, "DBID" NUMBER
NOT NULL ENABLE, "INSTANCE_NUMBER"
NUMBER NOT NULL ENABLE, "PARENT_NAME" VARCHAR2(50), "WHERE_IN_CODE" VARCHAR2(64), "NWFAIL_COUNT" NUMBER,
"SLEEP_COUNT" NUMBER, "WTR_SLP_COUNT" NUMBER) PARTITION BY RANGE ("DBID","SNAP_ID") (PARTITION
"WRH$_LATCH__3990839260_59596" VALUES LESS THAN (39
ORA-39083: Object type TABLE failed to create with error:
ORA-00439: feature not enabled: Partitioning
.....................................................................................
.....................................................................................
sql is:
CREATE TABLE "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS" ("SNAP_ID" NUMBER NOT NULL ENABLE, "DBID" NUMBER
NOT NULL ENABLE, "INSTANCE_NUMBER" N
UMBER NOT NULL ENABLE, "SERVICE_NAME_HASH" NUMBER NOT NULL ENABLE, "WAIT_CLASS_ID" NUMBER NOT NULL ENABLE,
"WAIT_CLASS" VARCHAR2(64), "TOTAL_WAITS" NUMBER, "TIME_WAITED" NUMBER) PARTITION BY RANGE ("DBID","SNAP_ID")
(PARTITION "WRH$_SERVIC_3990839260_59
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "AWR_STAGE"."WRH$_SQL_PLAN" 4.294 MB 11010 rows
. . imported "AWR_STAGE"."WRH$_SQLTEXT" 2.090 MB 267 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY_BL" 17.58 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SQL_BIND_METADATA" 28.31 MB 445685 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT_BL" 23.03 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_BL" 9.468 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT_OBJ" 16.81 MB 169106 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT_BL" 16.60 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSMETRIC_SUMMARY" 70.07 KB 810 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER_BL" 6.742 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT_BL" 6.117 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY_BL" 7.070 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ENQUEUE_STAT" 30.50 KB 426 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT_BL" 6.75 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS_BL" 9.179 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT_BL" 6.429 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY_BL" 9.5 KB 0 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_SPACE_USAGE" 17.85 KB 210 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT_BL" 7.671 KB 0 rows
. . imported "AWR_STAGE"."WRH$_BG_EVENT_SUMMARY" 14.00 KB 192 rows
. . imported "AWR_STAGE"."WRH$_DB_CACHE_ADVICE_BL" 8.617 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LIBRARYCACHE" 13.16 KB 66 rows
. . imported "AWR_STAGE"."WRH$_PGASTAT" 11.07 KB 102 rows
. . imported "AWR_STAGE"."WRH$_PGA_TARGET_ADVICE" 12.16 KB 84 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS_BL" 7.062 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SHARED_POOL_ADVICE" 15.49 KB 111 rows
. . imported "AWR_STAGE"."WRH$_SQL_WORKAREA_HISTOGRAM" 11.61 KB 96 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT_BL" 6.421 KB 0 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT_BL" 6.421 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL_BL" 6.125 KB 0 rows
. . imported "AWR_STAGE"."WRH$_STREAMS_POOL_ADVICE" 11.39 KB 120 rows
. . imported "AWR_STAGE"."WRH$_LOG" 10.60 KB 36 rows
. . imported "AWR_STAGE"."WRH$_PROCESS_MEMORY_SUMMARY" 9.75 KB 24 rows
. . imported "AWR_STAGE"."WRH$_RESOURCE_LIMIT" 8.914 KB 30 rows
. . imported "AWR_STAGE"."WRH$_SGA_TARGET_ADVICE" 8.179 KB 45 rows
. . imported "AWR_STAGE"."WRH$_TEMPSTATXS" 10.06 KB 12 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT_BL" 6.117 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SGA" 7.039 KB 24 rows
. . imported "AWR_STAGE"."WRH$_BUFFER_POOL_STATISTICS" 12.45 KB 6 rows
. . imported "AWR_STAGE"."WRH$_JAVA_POOL_ADVICE" 8.867 KB 12 rows
. . imported "AWR_STAGE"."WRH$_INSTANCE_RECOVERY" 11.71 KB 6 rows
. . imported "AWR_STAGE"."WRM$_SNAPSHOT" 8.820 KB 6 rows
. . imported "AWR_STAGE"."WRH$_EVENT_NAME" 70.96 KB 917 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER_NAME" 70.03 KB 1623 rows
. . imported "AWR_STAGE"."WRH$_RULE_SET" 8.625 KB 6 rows
. . imported "AWR_STAGE"."WRH$_SESS_TIME_STATS" 7.671 KB 12 rows
. . imported "AWR_STAGE"."WRH$_SQL_SUMMARY" 7.007 KB 6 rows
. . imported "AWR_STAGE"."WRH$_THREAD" 7.617 KB 6 rows
. . imported "AWR_STAGE"."WRH$_BUFFERED_QUEUES" 7.968 KB 0 rows
. . imported "AWR_STAGE"."WRH$_BUFFERED_SUBSCRIBERS" 8.632 KB 0 rows
. . imported "AWR_STAGE"."WRH$_COMP_IOSTAT" 7.695 KB 6 rows
. . imported "AWR_STAGE"."WRH$_DATAFILE" 13.37 KB 82 rows
. . imported "AWR_STAGE"."WRH$_LATCH_NAME" 23.05 KB 400 rows
. . imported "AWR_STAGE"."WRH$_METRIC_NAME" 24.89 KB 212 rows
. . imported "AWR_STAGE"."WRH$_OPTIMIZER_ENV" 26.26 KB 127 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT_NAME" 5.859 KB 13 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_NAME" 5.929 KB 3 rows
. . imported "AWR_STAGE"."WRH$_STAT_NAME" 23.33 KB 406 rows
. . imported "AWR_STAGE"."WRH$_TEMPFILE" 7.546 KB 7 rows
. . imported "AWR_STAGE"."WRM$_DATABASE_INSTANCE" 7.460 KB 1 rows
. . imported "AWR_STAGE"."WRM$_WR_CONTROL" 10.13 KB 1 rows
. . imported "AWR_STAGE"."WRH$_CR_BLOCK_SERVER" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_CURRENT_BLOCK_SERVER" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DLM_MISC_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILEMETRIC_HISTORY" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_INST_CACHE_TRANSFER_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_CHILDREN_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_PARENT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_MTTR_TARGET_ADVICE" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SESSMETRIC_HISTORY" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_STREAMS_APPLY_SUM" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_STREAMS_CAPTURE" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSMETRIC_HISTORY" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_UNDOSTAT" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_WAITCLASSMETRIC_HISTORY" 0 KB 0 rows
. . imported "AWR_STAGE"."WRM$_SNAP_ERROR" 0 KB 0 rows
. . imported "AWR_STAGE"."WRR$_CAPTURES" 0 KB 0 rows
. . imported "AWR_STAGE"."WRR$_CAPTURE_STATS" 0 KB 0 rows
. . imported "AWR_STAGE"."WRR$_FILTERS" 0 KB 0 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
ORA-39112: Dependent object type INDEX:"AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY_PK" skipped, base object type
TABLE:"AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY" creation failed
ORA-39112: Dependent object type INDEX:"AWR_STAGE"."WRH$_DB_CACHE_ADVICE_PK" skipped, base object type
TABLE:"AWR_STAGE"."WRH$_DB_CACHE_ADVICE" creation failed
ORA-39112: Dependent object type INDEX:"AWR_STAGE"."WRH$_DLM_MISC_PK" skipped, base object type
TABLE:"AWR_STAGE"."WRH$_DLM_MISC" creation failed
ORA-39112: Dependent object type INDEX:"AWR_STAGE"."WRH$_FILESTATXS_PK" skipped, base object type
TABLE:"AWR_STAGE"."WRH$_FILESTATXS" creation failed
ORA-39112: Dependent object type INDEX:"AWR_STAGE"."WRH$_INST_CACHE_TRANSFER_PK" skipped, base object type
TABLE:"AWR_STAGE"."WRH$_INST_CACHE_TRANSFER" creation failed
ORA-39112: Dependent object type INDEX:"AWR_STAGE"."WRH$_LATCH_PK" skipped, base object type
TABLE:"AWR_STAGE"."WRH$_LATCH" creation failed
ORA-39112: Dependent object type INDEX:"AWR_STAGE"."WRH$_LATCH_CHILDREN_PK" skipped, base object type
TABLE:"AWR_STAGE"."WRH$_LATCH_CHILDREN" creation failed
ORA-39112: Dependent object type INDEX:"AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY_PK" skipped, base object type
TABLE:"AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY" creation failed
ORA-39112: Dependent object type INDEX:"AWR_STAGE"."WRH$_LATCH_PARENT_PK" skipped, base object type
TABLE:"AWR_STAGE"."WRH$_LATCH_PARENT" creation failed
ORA-39112: Dependent object type INDEX:"AWR_STAGE"."WRH$_OSSTAT_PK" skipped, base object type
TABLE:"AWR_STAGE"."WRH$_OSSTAT" creation failed
ORA-39112: Dependent object type INDEX:"AWR_STAGE"."WRH$_PARAMETER_PK" skipped, base object type
TABLE:"AWR_STAGE"."WRH$_PARAMETER" creation failed
ORA-39112: Dependent object type INDEX:"AWR_STAGE"."WRH$_ROWCACHE_SUMMARY_PK" skipped, base object type
......................................................................
......................................................................
......................................................................
ORA-39112: Dependent object type CONSTRAINT:"AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS_PK" skipped, base object type
TABLE:"AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS" creation failed
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Job "SYS"."SYS_IMPORT_FULL_01" completed with 67 error(s) at 16:51:30
Register the DBID: 3990839260
Append Data for AWR_STAGE.WRM$_DATABASE_INSTANCE.
INSERT /*+ APPEND */ INTO SYS.WRM$_DATABASE_INSTANCE (DBID, INSTANCE_NUMBER, STARTUP_TIME, PARALLEL, VERSION,
DB_NAME, INSTANCE_NAME, HOST_NAME, LAST_ASH_SAMPLE_ID) SELECT DBID, INSTANCE_NUMBER, STARTUP_TIME, PARALLEL,
VERSION, DB_NAME, INSTANCE_NAME, HOS
T_NAME, LAST_ASH_SAMPLE_ID FROM AWR_STAGE.WRM$_DATABASE_INSTANCE WHERE (DBID, INSTANCE_NUMBER, STARTUP_TIME)
NOT IN (SELECT DBID, INSTANCE_NUMBER, STARTUP_TIME FROM SYS.WRM$_DATABASE_INSTANCE)
Append Data for AWR_STAGE.WRM$_SNAPSHOT.
INSERT /*+ APPEND */ INTO SYS.WRM$_SNAPSHOT (SNAP_ID, DBID, INSTANCE_NUMBER, STARTUP_TIME,
BEGIN_INTERVAL_TIME, END_INTERVAL_TIME, FLUSH_ELAPSED, SNAP_LEVEL, STATUS, ERROR_COUNT, BL_MOVED, SNAP_FLAG)
SELECT SNAP_ID, DBID, INSTANCE_NUMBER, STARTUP_TIME, BE
GIN_INTERVAL_TIME, END_INTERVAL_TIME, FLUSH_ELAPSED, SNAP_LEVEL, 1, 0, 0, SNAP_FLAG + 2 FROM
AWR_STAGE.WRM$_SNAPSHOT WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM SYS.WRM$_SNAPSHOT)
Append Data for AWR_STAGE.WRH$_STAT_NAME.
INSERT /*+ APPEND */ INTO SYS.WRH$_STAT_NAME (DBID, STAT_ID, STAT_NAME) SELECT DBID, STAT_ID, STAT_NAME FROM
AWR_STAGE.WRH$_STAT_NAME WHERE (DBID, STAT_ID) NOT IN (SELECT DBID, STAT_ID FROM SYS.WRH$_STAT_NAME)
Append Data for AWR_STAGE.WRH$_PARAMETER_NAME.
INSERT /*+ APPEND */ INTO SYS.WRH$_PARAMETER_NAME (DBID, PARAMETER_HASH, PARAMETER_NAME) SELECT DBID,
PARAMETER_HASH, PARAMETER_NAME FROM AWR_STAGE.WRH$_PARAMETER_NAME WHERE (DBID, PARAMETER_HASH) NOT IN (SELECT
DBID, PARAMETER_HASH FROM SYS.WRH$_PARAMETE
R_NAME)
Append Data for AWR_STAGE.WRH$_EVENT_NAME.
INSERT /*+ APPEND */ INTO SYS.WRH$_EVENT_NAME (DBID, EVENT_ID, EVENT_NAME, PARAMETER1, PARAMETER2, PARAMETER3,
WAIT_CLASS_ID, WAIT_CLASS) SELECT DBID, EVENT_ID, EVENT_NAME, PARAMETER1, PARAMETER2, PARAMETER3,
WAIT_CLASS_ID, WAIT_CLASS FROM AWR_STAGE.WRH$_
EVENT_NAME WHERE (DBID, EVENT_ID) NOT IN (SELECT DBID, EVENT_ID FROM SYS.WRH$_EVENT_NAME)
Append Data for AWR_STAGE.WRH$_LATCH_NAME.
INSERT /*+ APPEND */ INTO SYS.WRH$_LATCH_NAME (DBID, LATCH_HASH, LATCH_NAME, LATCH#) SELECT DBID, LATCH_HASH,
LATCH_NAME, LATCH# FROM AWR_STAGE.WRH$_LATCH_NAME WHERE (DBID, LATCH_HASH) NOT IN (SELECT DBID, LATCH_HASH
FROM SYS.WRH$_LATCH_NAME)
Append Data for AWR_STAGE.WRH$_FILESTATXS.
INSERT /*+ APPEND */ INTO SYS.WRH$_FILESTATXS (SNAP_ID, DBID, INSTANCE_NUMBER, FILE#, CREATION_CHANGE#,
PHYRDS, PHYWRTS, SINGLEBLKRDS, READTIM, WRITETIM, SINGLEBLKRDTIM, PHYBLKRD, PHYBLKWRT, WAIT_COUNT, TIME)
SELECT SNAP_ID, DBID, INSTANCE_NUMBER, FILE#,
CREATION_CHANGE#, PHYRDS, PHYWRTS, SINGLEBLKRDS, READTIM, WRITETIM, SINGLEBLKRDTIM, PHYBLKRD, PHYBLKWRT,
WAIT_COUNT, TIME FROM AWR_STAGE.WRH$_FILESTATXS WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM
SYS.WRH$_FILESTATXS)
Failed append data for AWR_STAGE.WRH$_FILESTATXS
ORA-00942: table or view does not exist
INSERT INTO SYS.WRM$_SNAP_ERROR (dbid, snap_id, instance_number, table_name, error_number) SELECT dbid,
snap_id, instance_number, 'WRH$_FILESTATXS', 20109 FROM SYS.WRM$_SNAPSHOT WHERE status = 1 AND
BITAND(snap_flag, 2) != 0 AND (dbid, snap_id) IN (S
ELECT dbid, snap_id FROM AWR_STAGE.WRM$_SNAPSHOT)
Append Data for AWR_STAGE.WRH$_FILESTATXS_BL.
INSERT /*+ APPEND */ INTO SYS.WRH$_FILESTATXS (SNAP_ID, DBID, INSTANCE_NUMBER, FILE#, CREATION_CHANGE#,
PHYRDS, PHYWRTS, SINGLEBLKRDS, READTIM, WRITETIM, SINGLEBLKRDTIM, PHYBLKRD, PHYBLKWRT, WAIT_COUNT, TIME)
SELECT SNAP_ID, DBID, INSTANCE_NUMBER, FILE#,
CREATION_CHANGE#, PHYRDS, PHYWRTS, SINGLEBLKRDS, READTIM, WRITETIM, SINGLEBLKRDTIM, PHYBLKRD, PHYBLKWRT,
WAIT_COUNT, TIME FROM AWR_STAGE.WRH$_FILESTATXS_BL WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM
SYS.WRH$_FILESTATXS)
Append Data for AWR_STAGE.WRH$_TEMPSTATXS.
................................................................
................................................................
INSERT INTO SYS.WRM$_SNAP_ERROR (dbid, snap_id, instance_number, table_name, error_number) SELECT dbid,
snap_id, instance_number, 'WRH$_ACTIVE_SESSION_HISTORY', 20109 FROM SYS.WRM$_SNAPSHOT WHERE status = 1 AND
BITAND(snap_flag, 2) != 0 AND (dbid, sn
ap_id) IN (SELECT dbid, snap_id FROM AWR_STAGE.WRM$_SNAPSHOT)
Append Data for AWR_STAGE.WRH$_ACTIVE_SESSION_HISTORY_BL.
INSERT /*+ APPEND */ INTO SYS.WRH$_ACTIVE_SESSION_HISTORY (SNAP_ID, DBID, INSTANCE_NUMBER, SAMPLE_ID,
SAMPLE_TIME, SESSION_ID, SESSION_SERIAL#, USER_ID, SQL_ID, SQL_CHILD_NUMBER, SQL_PLAN_HASH_VALUE,
SERVICE_HASH, SESSION_TYPE, SQL_OPCODE, QC_SESSION_ID,
QC_INSTANCE_ID, CURRENT_OBJ#, CURRENT_FILE#, CURRENT_BLOCK#, SEQ#, EVENT_ID, P1, P2, P3, WAIT_TIME,
TIME_WAITED, PROGRAM, MODULE, ACTION, CLIENT_ID, FORCE_MATCHING_SIGNATURE, BLOCKING_SESSION,
BLOCKING_SESSION_SERIAL#, XID, PLSQL_ENTRY_OBJECT_ID, PLSQL_EN
TRY_SUBPROGRAM_ID, PLSQL_OBJECT_ID, PLSQL_SUBPROGRAM_ID, FLAGS) SELECT SNAP_ID, DBID, INSTANCE_NUMBER,
SAMPLE_ID, SAMPLE_TIME, SESSION_ID, SESSION_SERIAL#, USER_ID, SQL_ID, SQL_CHILD_NUMBER, SQL_PLAN_HASH_VALUE,
SERVICE_HASH, SESSION_TYPE, SQL_OPCODE, QC_
SESSION_ID, QC_INSTANCE_ID, CURRENT_OBJ#, CURRENT_FILE#, CURRENT_BLOCK#, SEQ#, EVENT_ID, P1, P2, P3,
WAIT_TIME, TIME_WAITED, PROGRAM, MODULE, ACTION, CLIENT_ID, FORCE_MATCHING_SIGNATURE, BLOCKING_SESSION,
BLOCKING_SESSION_SERIAL#, XID, PLSQL_ENTRY_OBJECT_
ID, PLSQL_ENTRY_SUBPROGRAM_ID, PLSQL_OBJECT_ID, PLSQL_SUBPROGRAM_ID, FLAGS FROM
AWR_STAGE.WRH$_ACTIVE_SESSION_HISTORY_BL WHERE (DBID, SNAP_ID) NOT IN (SELECT DBID, SNAP_ID FROM
SYS.WRH$_ACTIVE_SESSION_HISTORY)
Append Data for AWR_STAGE.WRM$_SNAP_ERROR.
INSERT /*+ APPEND */ INTO SYS.WRM$_SNAP_ERROR (SNAP_ID, DBID, INSTANCE_NUMBER, TABLE_NAME, ERROR_NUMBER)
SELECT SNAP_ID, DBID, INSTANCE_NUMBER, TABLE_NAME, ERROR_NUMBER FROM AWR_STAGE.WRM$_SNAP_ERROR WHERE (DBID,
SNAP_ID, INSTANCE_NUMBER, TABLE_NAME) NOT
IN (SELECT DBID, SNAP_ID, INSTANCE_NUMBER, TABLE_NAME FROM SYS.WRM$_SNAP_ERROR)
UPDATE SYS.WRM$_SNAPSHOT s1 SET status = 0, error_count = (SELECT count(*) FROM SYS.wrm$_snap_error s2 WHERE
s1.dbid = s2.dbid AND s1.snap_id = s2.snap_id AND s1.instance_number = s2.instance_number) WHERE status =
1 AND BITAND(snap_flag, 2) != 0
AND (dbid, snap_id) IN (SELECT dbid, snap_id FROM AWR_STAGE.WRM$_SNAPSHOT)
Finished MOVE_TO_AWR procedure
... Dropping AWR_STAGE user
End of AWR Load
SQL>
后面测试生成awr报告，发现由于导入出现错误，导致生成的awr报告出现部分内容缺失数据的情况。看来在标准版中，要用AWR的导入、导出功能还是有点麻烦。