匯入和匯出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跨庫匯出與匯入
- SQL資料庫的匯入和匯出SQL資料庫
- Oracle資料泵的匯入和匯出Oracle
- MySQL入門--匯出和匯入資料MySql
- Oracle資料庫匯入匯出。imp匯入命令和exp匯出命令Oracle資料庫
- ClickHouse 資料表匯出和匯入（qbit）
- 使用Dbeaver 進行資料的匯入和匯出
- sqoop資料匯入匯出OOP
- Oracle 資料匯入匯出Oracle
- 資料泵匯出匯入
- Oracle資料匯入匯出Oracle
- phpMyAdmin匯入/匯出資料PHP
- Mongodb資料的匯出與匯入MongoDB
- EasyPoi, Excel資料的匯入匯出Excel
- 資料庫 MySQL 資料匯入匯出資料庫MySql
- [Docker核心之容器、資料庫檔案的匯入匯出、容器映象的匯入匯出]Docker資料庫
- php讀取excel檔案資料的匯入和匯出PHPExcel
- oracle資料匯出匯入（exp/imp）Oracle
- Mysql 資料庫匯入與匯出MySql資料庫
- 關於EasyExcel的資料匯入和單sheet和多sheet匯出Excel
- 資料搬運元件：基於Sqoop管理資料匯入和匯出元件OOP
- Oracle資料泵匯出匯入（expdp/impdp）Oracle
- 【最佳實踐】MongoDB匯出匯入資料MongoDB
- 複雜「場景」資料匯入匯出
- QZpython匯入匯出redis資料的實現deuPythonRedis
- MongoDB--Mongodb 中資料匯出與匯入MongoDB
- kxcel, 方便匯入和匯出 ExcelExcel
- MYSQL資料匯出備份、匯入的幾種方式MySql
- 使用csv批量匯入、匯出資料的需求處理
- ES模組化的匯入和匯出
- PHP大資料xlswriter匯入匯出(最優資料化)PHP大資料
- NPOI匯出和匯入Excel,Word和PDFExcel
- SQLServer匯出匯入資料到MySQLServerMySql
- mongodb使用自帶命令工具匯出匯入資料MongoDB
- 使用VUE+SpringBoot+EasyExcel 整合匯入匯出資料VueSpring BootExcel
- sqoop用法之mysql與hive資料匯入匯出OOPMySqlHive
- DB2 匯入和匯出 命令列和客戶端匯出DB2命令列客戶端
- 【MySQL】白話說MySQL(五)，資料的匯出與匯入MySql