匯入和匯出AWR的資料
原文地址：
https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF94198
5.3.4 Transporting Automatic Workload Repository Data
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:
-- 匯出AWR的資訊。按照提示操作即可。
@$ORACLE_HOME/rdbms/admin/awrextr.sql-- 匯出過程
^C[root@test dump]# more awrdat_246_357.log
Starting "SYS"."SYS_EXPORT_TABLE_01":
Startup took 3 seconds
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Estimated 222 TABLE_DATA objects in 2 seconds
Total estimation using BLOCKS method: 186.6 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Completed 133 TABLE objects in 17 seconds
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Completed 125 CONSTRAINT objects in 2 seconds
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Completed 1 REF_CONSTRAINT objects in 2 seconds
. . exported "SYS"."WRH$_LATCH_CHILDREN":"WRH$_LATCH__2261741601_179" 18.95 MB 376847 rows
. . exported "SYS"."WRH$_LATCH_CHILDREN":"WRH$_LATCH__2261741601_308" 15.28 MB 303636 rows
. . exported "SYS"."WRH$_SQL_PLAN" 11.01 MB 28985 rows
. . exported "SYS"."WRH$_SYSMETRIC_HISTORY" 6.238 MB 123320 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_2261741601_179" 3.699 MB 14113 rows
. . exported "SYS"."WRH$_SQLTEXT" 2.692 MB 2079 rows
. . exported "SYS"."WRH$_LATCH_CHILDREN":"WRH$_LATCH__2261741601_0" 10.99 KB 0 rows
. . exported "SYS"."WRH$_LATCH_PARENT":"WRH$_LATCH__2261741601_179" 1.747 MB 36084 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_2261741601_179" 1.752 MB 36084 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_2261741601_179" 291.2 KB 952 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_2261741601_179" 912.3 KB 21886 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_2261741601_179" 1.062 MB 9185 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_2261741601_308" 2.775 MB 10525 rows
. . exported "SYS"."WRH$_SYSMETRIC_SUMMARY" 1.355 MB 17696 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_2261741601_179" 1.116 MB 42098 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_2261741601_115" 33.06 KB 0 rows
. . exported "SYS"."WRH$_EVENT_HISTOGRAM":"WRH$_EVENT__2261741601_179" 705.1 KB 22593 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_2261741601_143" 10.98 KB 0 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_2261741601_308" 1.416 MB 29100 rows
. . exported "SYS"."WRH$_LATCH_PARENT":"WRH$_LATCH__2261741601_308" 1.411 MB 29100 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_2261741601_308" 972.6 KB 8167 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_2261741601_143" 36.64 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_2261741601_308" 924.0 KB 33950 rows
. . exported "SYS"."WRH$_WAITCLASSMETRIC_HISTORY" 482.1 KB 6397 rows
. . exported "SYS"."WRH$_ENQUEUE_STAT" 435.2 KB 8493 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_2261741601_115" 10.98 KB 0 rows
. . exported "SYS"."WRM$_SNAPSHOT_DETAILS" 727.9 KB 16381 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_2261741601_308" 737.1 KB 17650 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_2261741601_115" 36.64 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_2261741601_143" 6.585 KB 0 rows
. . exported "SYS"."WRH$_EVENT_HISTOGRAM":"WRH$_EVENT__2261741601_308" 513.2 KB 16374 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_2261741601_143" 7.406 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_2261741601_115" 6.585 KB 0 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_2261741601_179" 227.8 KB 3534 rows
. . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_2261741601_179" 243.1 KB 6944 rows
. . exported "SYS"."WRH$_BG_EVENT_SUMMARY" 218.1 KB 5944 rows
. . exported "SYS"."WRH$_LATCH_PARENT":"WRH$_LATCH__2261741601_0" 10.99 KB 0 rows
. . exported "SYS"."WRH$_MVPARAMETER":"WRH$_MVPARA_2261741601_179" 212.8 KB 4464 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_2261741601_115" 7.406 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_2261741601_143" 22.76 KB 0 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_2261741601_143" 33.06 KB 0 rows
. . exported "SYS"."WRH$_EVENT_HISTOGRAM":"WRH$_EVENT__2261741601_143" 7.007 KB 0 rows
. . exported "SYS"."WRH$_SHARED_POOL_ADVICE" 187.7 KB 3376 rows
. . exported "SYS"."WRH$_SQL_BIND_METADATA" 270.4 KB 4642 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_2261741601_179" 198.5 KB 4347 rows
. . exported "SYS"."WRH$_EVENT_HISTOGRAM":"WRH$_EVENT__2261741601_115" 7.007 KB 0 rows
. . exported "SYS"."WRH$_LIBRARYCACHE" 129.4 KB 2164 rows
. . exported "SYS"."WRH$_MEM_DYNAMIC_COMP" 129.4 KB 1792 rows
. . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_2261741601_179" 93.70 KB 1298 rows
. . exported "SYS"."WRH$_IOSTAT_DETAIL" 84.52 KB 1466 rows
. . exported "SYS"."WRH$_IOSTAT_FILETYPE" 89.75 KB 1344 rows
. . exported "SYS"."WRH$_MVPARAMETER":"WRH$_MVPARA_2261741601_308" 173.2 KB 3600 rows
. . exported "SYS"."WRH$_PGASTAT" 81.28 KB 1627 rows
. . exported "SYS"."WRH$_PGA_TARGET_ADVICE" 86.18 KB 1568 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_2261741601_308" 186.5 KB 2850 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_2261741601_115" 22.76 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_2261741601_308" 198.6 KB 5600 rows
. . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_2261741601_179" 87.35 KB 1693 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_2261741601_308" 170.8 KB 507 rows
. . exported "SYS"."WRH$_EVENT_NAME" 104.0 KB 1367 rows
. . exported "SYS"."WRH$_IOSTAT_FUNCTION" 80.66 KB 1568 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__2261741601_179" 79.97 KB 1217 rows
. . exported "SYS"."WRH$_MVPARAMETER":"WRH$_MVPARA_2261741601_143" 7.796 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER_NAME" 124.6 KB 2920 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_2261741601_143" 11.01 KB 0 rows
. . exported "SYS"."WRH$_RSRC_CONSUMER_GROUP" 70.74 KB 390 rows
. . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_2261741601_115" 7 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_2261741601_143" 7 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_2261741601_179" 58.91 KB 1065 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_2261741601_143" 8.632 KB 0 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_2261741601_308" 154.8 KB 3357 rows
. . exported "SYS"."WRH$_TABLESPACE_SPACE_USAGE" 56.34 KB 950 rows
. . exported "SYS"."WRH$_UNDOSTAT" 76.02 KB 617 rows
. . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_2261741601_143" 10.26 KB 0 rows
. . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_2261741601_308" 77.67 KB 1050 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_2261741601_179" 38.18 KB 488 rows
. . exported "SYS"."WRH$_JAVA_POOL_ADVICE" 52.24 KB 1120 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__2261741601_143" 7.820 KB 0 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__2261741601_308" 69.67 KB 1088 rows
. . exported "SYS"."WRH$_LOG" 36.71 KB 448 rows
. . exported "SYS"."WRH$_MVPARAMETER":"WRH$_MVPARA_2261741601_115" 7.796 KB 0 rows
. . exported "SYS"."WRH$_OPTIMIZER_ENV" 21.72 KB 66 rows
. . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_2261741601_179" 42.80 KB 1426 rows
. . exported "SYS"."WRH$_PROCESS_MEMORY_SUMMARY" 40.28 KB 448 rows
. . exported "SYS"."WRH$_RESOURCE_LIMIT" 34.75 KB 460 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_2261741601_115" 11.01 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT_OBJ" 57.92 KB 545 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_2261741601_308" 53.57 KB 957 rows
. . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_2261741601_115" 6.984 KB 0 rows
. . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_2261741601_143" 6.984 KB 0 rows
. . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_2261741601_308" 72.12 KB 1373 rows
. . exported "SYS"."WRH$_SGA_TARGET_ADVICE" 34 KB 821 rows
. . exported "SYS"."WRH$_SQL_WORKAREA_HISTOGRAM" 41.53 KB 863 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_2261741601_115" 8.632 KB 0 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_2261741601_179" 41.03 KB 1178 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_2261741601_179" 38.51 KB 488 rows
. . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_2261741601_179" 46.44 KB 1116 rows
. . exported "SYS"."WRH$_BUFFER_POOL_STATISTICS" 24.64 KB 112 rows
. . exported "SYS"."WRH$_DATAFILE" 8.484 KB 9 rows
. . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_2261741601_115" 10.26 KB 0 rows
. . exported "SYS"."WRH$_DISPATCHER" 12.96 KB 112 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_2261741601_115" 10.60 KB 0 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_2261741601_143" 10.60 KB 0 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_2261741601_308" 30.35 KB 350 rows
. . exported "SYS"."WRH$_INSTANCE_RECOVERY" 20.59 KB 112 rows
. . exported "SYS"."WRH$_IOSTAT_FILETYPE_NAME" 6.156 KB 12 rows
. . exported "SYS"."WRH$_IOSTAT_FUNCTION_NAME" 6.148 KB 14 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__2261741601_115" 7.820 KB 0 rows
. . exported "SYS"."WRH$_LATCH_NAME" 31.67 KB 582 rows
. . exported "SYS"."WRH$_MEMORY_RESIZE_OPS" 13.67 KB 36 rows
. . exported "SYS"."WRH$_MEMORY_TARGET_ADVICE" 7.820 KB 0 rows
. . exported "SYS"."WRH$_METRIC_NAME" 31.39 KB 283 rows
. . exported "SYS"."WRH$_MUTEX_SLEEP" 19.67 KB 236 rows
. . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_2261741601_115" 6.585 KB 0 rows
. . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_2261741601_143" 6.585 KB 0 rows
. . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_2261741601_308" 35.62 KB 1150 rows
. . exported "SYS"."WRH$_OSSTAT_NAME" 6.476 KB 23 rows
. . exported "SYS"."WRH$_PERSISTENT_QMN_CACHE" 15.76 KB 0 rows
. . exported "SYS"."WRH$_PERSISTENT_QUEUES" 16.53 KB 0 rows
. . exported "SYS"."WRH$_PERSISTENT_SUBSCRIBERS" 13.61 KB 0 rows
. . exported "SYS"."WRH$_PLAN_OPERATION_NAME" 9.632 KB 131 rows
. . exported "SYS"."WRH$_PLAN_OPTION_NAME" 11.28 KB 188 rows
. . exported "SYS"."WRH$_RSRC_PLAN" 11.29 KB 39 rows
. . exported "SYS"."WRH$_RULE_SET" 9.414 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_NAME" 6.335 KB 4 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_2261741601_115" 7.820 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_2261741601_143" 7.820 KB 0 rows
. . exported "SYS"."WRH$_SESSMETRIC_HISTORY" 8.992 KB 0 rows
. . exported "SYS"."WRH$_SESS_TIME_STATS" 7.820 KB 0 rows
. . exported "SYS"."WRH$_SGA" 23.32 KB 448 rows
. . exported "SYS"."WRH$_SHARED_SERVER_SUMMARY" 20.11 KB 112 rows
. . exported "SYS"."WRH$_SQLCOMMAND_NAME" 10.57 KB 165 rows
. . exported "SYS"."WRH$_SQL_SUMMARY" 11.57 KB 112 rows
. . exported "SYS"."WRH$_STAT_NAME" 37.74 KB 696 rows
. . exported "SYS"."WRH$_STREAMS_POOL_ADVICE" 8.234 KB 0 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_2261741601_115" 6.593 KB 0 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_2261741601_143" 6.593 KB 0 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_2261741601_308" 34.36 KB 950 rows
. . exported "SYS"."WRH$_TABLESPACE" 7.828 KB 9 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_2261741601_115" 8.617 KB 0 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_2261741601_143" 8.617 KB 0 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_2261741601_308" 29.90 KB 350 rows
. . exported "SYS"."WRH$_TEMPFILE" 7.859 KB 1 rows
. . exported "SYS"."WRH$_TEMPSTATXS" 16.42 KB 112 rows
. . exported "SYS"."WRH$_THREAD" 13.00 KB 112 rows
. . exported "SYS"."WRH$_TOPLEVELCALL_NAME" 9.867 KB 151 rows
. . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_2261741601_115" 6.992 KB 0 rows
. . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_2261741601_143" 6.992 KB 0 rows
. . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_2261741601_308" 38.75 KB 900 rows
. . exported "SYS"."WRM$_DATABASE_INSTANCE" 9.421 KB 9 rows
. . exported "SYS"."WRM$_SNAPSHOT" 19.24 KB 112 rows
. . exported "SYS"."WRM$_WR_CONTROL" 12.15 KB 1 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_SES_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_BUFFERED_QUEUES" 0 KB 0 rows
. . exported "SYS"."WRH$_BUFFERED_SUBSCRIBERS" 0 KB 0 rows
. . exported "SYS"."WRH$_CLUSTER_INTERCON" 0 KB 0 rows
. . exported "SYS"."WRH$_COMP_IOSTAT" 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$_DB_CACHE_ADVICE_BL" 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_2261741601_0" 0 KB 0 rows
. . exported "SYS"."WRH$_DLM_MISC_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_DYN_REMASTER_STATS" 0 KB 0 rows
. . exported "SYS"."WRH$_EVENT_HISTOGRAM":"WRH$_EVENT_HISTO_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_EVENT_HISTOGRAM_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$_FILESTATXS_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_IC_CLIENT_STATS" 0 KB 0 rows
. . exported "SYS"."WRH$_IC_DEVICE_STATS" 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_2261741601_0" 0 KB 0 rows
. . exported "SYS"."WRH$_INST_CACHE_TRANSFER_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_INTERCONNECT_PINGS":"WRH$_IC_PINGS_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_INTERCONNECT_PINGS":"WRH$_INTERC_2261741601_0" 0 KB 0 rows
. . exported "SYS"."WRH$_INTERCONNECT_PINGS_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_CHILDREN":"WRH$_LATCH_CHILD_MXDB_MXSN" 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_MISSES_SUMMARY_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_PARENT":"WRH$_LATCH_PAREN_MXDB_MXSN" 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$_MVPARAMETER":"WRH$_MVPARAMETER_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_MVPARAMETER_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_OSSTAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAMETER_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCACHE_SU_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_STAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVICE_STAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_STAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVICE_WAIT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SGASTAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SQLSTAT_BL" 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$_SYSSTAT":"WRH$_SYSSTAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_EVEN_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TIME_MO_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLESPACE_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITSTAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_WAITSTAT_BL" 0 KB 0 rows
. . exported "SYS"."WRM$_BASELINE_DETAILS" 0 KB 0 rows
. . exported "SYS"."WRM$_BASELINE_TEMPLATE" 0 KB 0 rows
. . exported "SYS"."WRM$_COLORED_SQL" 0 KB 0 rows
. . exported "SYS"."WRM$_SNAP_ERROR" 0 KB 0 rows
Completed 222 TABLE_EXPORT/TABLE/TABLE_DATA objects in 60 seconds
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/u01/dump/awrdat_246_357.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at Sun Jun 10 11:04:28 2018 elapsed 0 00:01:29
[root@test dump]#匯入AWR資訊，按照提示操作即可。
-- 匯入的SQL語句
@$ORACLE_HOME/rdbms/admin/awrload.sql-- 匯入過程
[root@test dump]# more awrdat_246_357.log
Startup took 1 seconds
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01":
Processing object type TABLE_EXPORT/TABLE/TABLE
Completed 133 TABLE objects in 11 seconds
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "AWR_STAGE"."WRH$_LATCH_CHILDREN":"WRH$_LATCH__2261741601_179" 18.95 MB 376847 rows
. . imported "AWR_STAGE"."WRH$_LATCH_CHILDREN":"WRH$_LATCH__2261741601_308" 15.28 MB 303636 rows
. . imported "AWR_STAGE"."WRH$_SQL_PLAN" 11.01 MB 28985 rows
. . imported "AWR_STAGE"."WRH$_SYSMETRIC_HISTORY" 6.238 MB 123320 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_2261741601_179" 3.699 MB 14113 rows
. . imported "AWR_STAGE"."WRH$_SQLTEXT" 2.692 MB 2079 rows
. . imported "AWR_STAGE"."WRH$_LATCH_CHILDREN":"WRH$_LATCH__2261741601_0" 10.99 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_PARENT":"WRH$_LATCH__2261741601_179" 1.747 MB 36084 rows
. . imported "AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_2261741601_179" 1.752 MB 36084 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_2261741601_179" 291.2 KB 952 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_2261741601_179" 912.3 KB 21886 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_2261741601_179" 1.062 MB 9185 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_2261741601_308" 2.775 MB 10525 rows
. . imported "AWR_STAGE"."WRH$_SYSMETRIC_SUMMARY" 1.355 MB 17696 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_2261741601_179" 1.116 MB 42098 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_2261741601_115" 33.06 KB 0 rows
. . imported "AWR_STAGE"."WRH$_EVENT_HISTOGRAM":"WRH$_EVENT__2261741601_179" 705.1 KB 22593 rows
. . imported "AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_2261741601_143" 10.98 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_2261741601_308" 1.416 MB 29100 rows
. . imported "AWR_STAGE"."WRH$_LATCH_PARENT":"WRH$_LATCH__2261741601_308" 1.411 MB 29100 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_2261741601_308" 972.6 KB 8167 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_2261741601_143" 36.64 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_2261741601_308" 924.0 KB 33950 rows
. . imported "AWR_STAGE"."WRH$_WAITCLASSMETRIC_HISTORY" 482.1 KB 6397 rows
. . imported "AWR_STAGE"."WRH$_ENQUEUE_STAT" 435.2 KB 8493 rows
. . imported "AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_2261741601_115" 10.98 KB 0 rows
. . imported "AWR_STAGE"."WRM$_SNAPSHOT_DETAILS" 727.9 KB 16381 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_2261741601_308" 737.1 KB 17650 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_2261741601_115" 36.64 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_2261741601_143" 6.585 KB 0 rows
. . imported "AWR_STAGE"."WRH$_EVENT_HISTOGRAM":"WRH$_EVENT__2261741601_308" 513.2 KB 16374 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_2261741601_143" 7.406 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_2261741601_115" 6.585 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_2261741601_179" 227.8 KB 3534 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_2261741601_179" 243.1 KB 6944 rows
. . imported "AWR_STAGE"."WRH$_BG_EVENT_SUMMARY" 218.1 KB 5944 rows
. . imported "AWR_STAGE"."WRH$_LATCH_PARENT":"WRH$_LATCH__2261741601_0" 10.99 KB 0 rows
. . imported "AWR_STAGE"."WRH$_MVPARAMETER":"WRH$_MVPARA_2261741601_179" 212.8 KB 4464 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_2261741601_115" 7.406 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_2261741601_143" 22.76 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_2261741601_143" 33.06 KB 0 rows
. . imported "AWR_STAGE"."WRH$_EVENT_HISTOGRAM":"WRH$_EVENT__2261741601_143" 7.007 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SHARED_POOL_ADVICE" 187.7 KB 3376 rows
. . imported "AWR_STAGE"."WRH$_SQL_BIND_METADATA" 270.4 KB 4642 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_2261741601_179" 198.5 KB 4347 rows
. . imported "AWR_STAGE"."WRH$_EVENT_HISTOGRAM":"WRH$_EVENT__2261741601_115" 7.007 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LIBRARYCACHE" 129.4 KB 2164 rows
. . imported "AWR_STAGE"."WRH$_MEM_DYNAMIC_COMP" 129.4 KB 1792 rows
. . imported "AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_2261741601_179" 93.70 KB 1298 rows
. . imported "AWR_STAGE"."WRH$_IOSTAT_DETAIL" 84.52 KB 1466 rows
. . imported "AWR_STAGE"."WRH$_IOSTAT_FILETYPE" 89.75 KB 1344 rows
. . imported "AWR_STAGE"."WRH$_MVPARAMETER":"WRH$_MVPARA_2261741601_308" 173.2 KB 3600 rows
. . imported "AWR_STAGE"."WRH$_PGASTAT" 81.28 KB 1627 rows
. . imported "AWR_STAGE"."WRH$_PGA_TARGET_ADVICE" 86.18 KB 1568 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_2261741601_308" 186.5 KB 2850 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_2261741601_115" 22.76 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_2261741601_308" 198.6 KB 5600 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_2261741601_179" 87.35 KB 1693 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_2261741601_308" 170.8 KB 507 rows
. . imported "AWR_STAGE"."WRH$_EVENT_NAME" 104.0 KB 1367 rows
. . imported "AWR_STAGE"."WRH$_IOSTAT_FUNCTION" 80.66 KB 1568 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__2261741601_179" 79.97 KB 1217 rows
. . imported "AWR_STAGE"."WRH$_MVPARAMETER":"WRH$_MVPARA_2261741601_143" 7.796 KB 0 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER_NAME" 124.6 KB 2920 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_2261741601_143" 11.01 KB 0 rows
. . imported "AWR_STAGE"."WRH$_RSRC_CONSUMER_GROUP" 70.74 KB 390 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_2261741601_115" 7 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_2261741601_143" 7 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_2261741601_179" 58.91 KB 1065 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_2261741601_143" 8.632 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_2261741601_308" 154.8 KB 3357 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_SPACE_USAGE" 56.34 KB 950 rows
. . imported "AWR_STAGE"."WRH$_UNDOSTAT" 76.02 KB 617 rows
. . imported "AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_2261741601_143" 10.26 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_2261741601_308" 77.67 KB 1050 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_2261741601_179" 38.18 KB 488 rows
. . imported "AWR_STAGE"."WRH$_JAVA_POOL_ADVICE" 52.24 KB 1120 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__2261741601_143" 7.820 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__2261741601_308" 69.67 KB 1088 rows
. . imported "AWR_STAGE"."WRH$_LOG" 36.71 KB 448 rows
. . imported "AWR_STAGE"."WRH$_MVPARAMETER":"WRH$_MVPARA_2261741601_115" 7.796 KB 0 rows
. . imported "AWR_STAGE"."WRH$_OPTIMIZER_ENV" 21.72 KB 66 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_2261741601_179" 42.80 KB 1426 rows
. . imported "AWR_STAGE"."WRH$_PROCESS_MEMORY_SUMMARY" 40.28 KB 448 rows
. . imported "AWR_STAGE"."WRH$_RESOURCE_LIMIT" 34.75 KB 460 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_2261741601_115" 11.01 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT_OBJ" 57.92 KB 545 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_2261741601_308" 53.57 KB 957 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_2261741601_115" 6.984 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_2261741601_143" 6.984 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_2261741601_308" 72.12 KB 1373 rows
. . imported "AWR_STAGE"."WRH$_SGA_TARGET_ADVICE" 34 KB 821 rows
. . imported "AWR_STAGE"."WRH$_SQL_WORKAREA_HISTOGRAM" 41.53 KB 863 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_2261741601_115" 8.632 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_2261741601_179" 41.03 KB 1178 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_2261741601_179" 38.51 KB 488 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_2261741601_179" 46.44 KB 1116 rows
. . imported "AWR_STAGE"."WRH$_BUFFER_POOL_STATISTICS" 24.64 KB 112 rows
. . imported "AWR_STAGE"."WRH$_DATAFILE" 8.484 KB 9 rows
. . imported "AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_2261741601_115" 10.26 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DISPATCHER" 12.96 KB 112 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_2261741601_115" 10.60 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_2261741601_143" 10.60 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_2261741601_308" 30.35 KB 350 rows
. . imported "AWR_STAGE"."WRH$_INSTANCE_RECOVERY" 20.59 KB 112 rows
. . imported "AWR_STAGE"."WRH$_IOSTAT_FILETYPE_NAME" 6.156 KB 12 rows
. . imported "AWR_STAGE"."WRH$_IOSTAT_FUNCTION_NAME" 6.148 KB 14 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__2261741601_115" 7.820 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_NAME" 31.67 KB 582 rows
. . imported "AWR_STAGE"."WRH$_MEMORY_RESIZE_OPS" 13.67 KB 36 rows
. . imported "AWR_STAGE"."WRH$_MEMORY_TARGET_ADVICE" 7.820 KB 0 rows
. . imported "AWR_STAGE"."WRH$_METRIC_NAME" 31.39 KB 283 rows
. . imported "AWR_STAGE"."WRH$_MUTEX_SLEEP" 19.67 KB 236 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_2261741601_115" 6.585 KB 0 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_2261741601_143" 6.585 KB 0 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_2261741601_308" 35.62 KB 1150 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT_NAME" 6.476 KB 23 rows
. . imported "AWR_STAGE"."WRH$_PERSISTENT_QMN_CACHE" 15.76 KB 0 rows
. . imported "AWR_STAGE"."WRH$_PERSISTENT_QUEUES" 16.53 KB 0 rows
. . imported "AWR_STAGE"."WRH$_PERSISTENT_SUBSCRIBERS" 13.61 KB 0 rows
. . imported "AWR_STAGE"."WRH$_PLAN_OPERATION_NAME" 9.632 KB 131 rows
. . imported "AWR_STAGE"."WRH$_PLAN_OPTION_NAME" 11.28 KB 188 rows
. . imported "AWR_STAGE"."WRH$_RSRC_PLAN" 11.29 KB 39 rows
. . imported "AWR_STAGE"."WRH$_RULE_SET" 9.414 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_NAME" 6.335 KB 4 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_2261741601_115" 7.820 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_2261741601_143" 7.820 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SESSMETRIC_HISTORY" 8.992 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SESS_TIME_STATS" 7.820 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SGA" 23.32 KB 448 rows
. . imported "AWR_STAGE"."WRH$_SHARED_SERVER_SUMMARY" 20.11 KB 112 rows
. . imported "AWR_STAGE"."WRH$_SQLCOMMAND_NAME" 10.57 KB 165 rows
. . imported "AWR_STAGE"."WRH$_SQL_SUMMARY" 11.57 KB 112 rows
. . imported "AWR_STAGE"."WRH$_STAT_NAME" 37.74 KB 696 rows
. . imported "AWR_STAGE"."WRH$_STREAMS_POOL_ADVICE" 8.234 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_2261741601_115" 6.593 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_2261741601_143" 6.593 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_2261741601_308" 34.36 KB 950 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE" 7.828 KB 9 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_2261741601_115" 8.617 KB 0 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_2261741601_143" 8.617 KB 0 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_2261741601_308" 29.90 KB 350 rows
. . imported "AWR_STAGE"."WRH$_TEMPFILE" 7.859 KB 1 rows
. . imported "AWR_STAGE"."WRH$_TEMPSTATXS" 16.42 KB 112 rows
. . imported "AWR_STAGE"."WRH$_THREAD" 13.00 KB 112 rows
. . imported "AWR_STAGE"."WRH$_TOPLEVELCALL_NAME" 9.867 KB 151 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_2261741601_115" 6.992 KB 0 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_2261741601_143" 6.992 KB 0 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_2261741601_308" 38.75 KB 900 rows
. . imported "AWR_STAGE"."WRM$_DATABASE_INSTANCE" 9.421 KB 9 rows
. . imported "AWR_STAGE"."WRM$_SNAPSHOT" 19.24 KB 112 rows
. . imported "AWR_STAGE"."WRM$_WR_CONTROL" 12.15 KB 1 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_SES_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_BUFFERED_QUEUES" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_BUFFERED_SUBSCRIBERS" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_CLUSTER_INTERCON" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_COMP_IOSTAT" 0 KB 0 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$_DB_CACHE_ADVICE":"WRH$_DB_CACHE_AD_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DB_CACHE_ADVICE_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DLM_MISC":"WRH$_DLM_MISC_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DLM_MISC":"WRH$_DLM_MI_2261741601_0" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DLM_MISC_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DYN_REMASTER_STATS" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_EVENT_HISTOGRAM":"WRH$_EVENT_HISTO_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_EVENT_HISTOGRAM_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILEMETRIC_HISTORY" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILESTATXS_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_IC_CLIENT_STATS" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_IC_DEVICE_STATS" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_INST_CACHE_TRANSFER":"WRH$_INST_CACHE_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_INST_CACHE_TRANSFER":"WRH$_INST_C_2261741601_0" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_INST_CACHE_TRANSFER_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_INTERCONNECT_PINGS":"WRH$_IC_PINGS_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_INTERCONNECT_PINGS":"WRH$_INTERC_2261741601_0" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_INTERCONNECT_PINGS_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_CHILDREN":"WRH$_LATCH_CHILD_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_CHILDREN_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH_MISSE_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_PARENT":"WRH$_LATCH_PAREN_MXDB_MXSN" 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$_MVPARAMETER":"WRH$_MVPARAMETER_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_MVPARAMETER_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAMETER_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCACHE_SU_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_STAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVICE_STAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVICE_WAIT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT_BL" 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$_SYSSTAT":"WRH$_SYSSTAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_EVEN_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TIME_MO_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLESPACE_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITSTAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRM$_BASELINE_DETAILS" 0 KB 0 rows
. . imported "AWR_STAGE"."WRM$_BASELINE_TEMPLATE" 0 KB 0 rows
. . imported "AWR_STAGE"."WRM$_COLORED_SQL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRM$_SNAP_ERROR" 0 KB 0 rows
Completed 222 TABLE_EXPORT/TABLE/TABLE_DATA objects in 34 seconds
Job "SYS"."SYS_IMPORT_FULL_01" successfully completed at Sun Jun 10 11:11:28 2018 elapsed 0 00:00:50
[root@test dump]#相關文章
- AWR資料的匯出與匯入
- AWR資料的匯出和匯入全過程
- Oracle AWR 資料匯入/匯出的步驟Oracle
- BCP 資料的匯入和匯出
- NDS的資料匯入和匯出
- postgresql 資料匯入和匯出SQL
- AWR跨庫匯出與匯入
- SQL資料庫的匯入和匯出SQL資料庫
- Oracle資料泵的匯入和匯出Oracle
- MySQL入門--匯出和匯入資料MySql
- 【mysql】資料庫匯出和匯入MySql資料庫
- Oracle資料庫匯入匯出。imp匯入命令和exp匯出命令Oracle資料庫
- Oracle資料庫的匯入和匯出命令Oracle資料庫
- SQL SERVER 和EXCEL的資料匯入匯出SQLServerExcel
- 資料庫的匯入匯出資料庫
- 資料泵的匯入匯出
- ClickHouse 資料表匯出和匯入（qbit）
- 資料泵取匯出和匯入（一）
- oracle10g匯出與匯入awrOracle
- 資料泵匯出匯入
- Oracle 資料匯入匯出Oracle
- mysql資料匯入匯出MySql
- mysql資料匯出匯入MySql
- Oracle資料匯入匯出Oracle
- 使用Dbeaver 進行資料的匯入和匯出
- ASP.NET EXCEL資料的匯出和匯入ASP.NETExcel
- MySQL資料庫結構和資料的匯出和匯入 (轉)MySql資料庫
- Mongodb資料的匯出與匯入MongoDB
- EasyPoi, Excel資料的匯入匯出Excel
- ITDS資料匯入匯出的方法
- Progress資料表的匯入匯出
- 資料庫 MySQL 資料匯入匯出資料庫MySql
- sqoop資料匯入匯出OOP
- 資料匯入匯出EXP/IMP
- MongoDB資料匯入與匯出MongoDB
- mysqldump匯入匯出表資料MySql
- exp/imp匯出匯入資料
- mysql 資料庫匯入匯出MySql資料庫