Oracle 10g的AWR便于DBA对系统进行实时监控、事后分析。AWR对资料的集中管理也提供了工具。以下操作均使用SYS登录。
1,从生产库导出：
define dbid = '';
define num_days = 0;
define begin_snap = 0;
define end_snap = 10000000;
define directory_name = 'DATA_PUMP_DIR'
define file_name = 'awrdat.dmp'
@?/rdbms/admin/awrextr.sql
日志见附录1，是一个expdp过程，从中可以看到主要导出了SYS.WRH$与SYS.WRM$表的数据。
2,导入到测试库：
define directory_name = 'DATA_PUMP_DIR'
define file_name = 'awrdat'
define schema_name = 'AWR_STAGE'
define default_tablespace = ''
define temporary_tablespace = ''
@?/rdbms/admin/awrload.sql
日志见附录2，过程如下：
*创建用户AWR_STAGE
*impdp过程，导入数据到AWR_STAGE模式
*将数据从AWR_STAGE模式导入SYS.WRH$与SYS.WRM$表
*删除用户AWR_STAGE
3,生成报表
由于需要生成的报表dbid不是缺省dbid,需要使用变量设置。
3.1生成awr报告：
define inst_num = 1;
define num_days = 1;
define inst_name = 'Instance';
define db_name = 'Database';
define dbid = 3367547043;
define begin_snap = 1443;
define end_snap = 1446;
define report_type = 'html';
define report_name = awr_report_1443_1446.html
@?/rdbms/admin/awrrpti.sql
3.2生成awr比较报告：
define inst_num = 1;
define num_days = 1;
define inst_name = 'Instance';
define db_name = 'Database';
define dbid = 3367547043;
define begin_snap = 1443;
define end_snap = 1444;
define inst_num2 = 1;
define num_days2 = 1;
define dbid2 = 3367547043;
define begin_snap2 = 1445;
define end_snap2 = 1446;
define report_type = 'html';
define report_name = awr_dd_report_1443_1444_1445_1446.html
@?/rdbms/admin/awrddrpi.sql
3.3生成addm报告：
define dbid = 3367547043;
define inst_num = 1;
define num_days = 3;
define begin_snap = 1445;
define end_snap = 1446;
define report_name = addm_report_1445_1446.txt
@?/rdbms/admin/addmrpti.sql
--------------------------------------------------------
附录1
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: 64.5 MB
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/CONSTRAINT/REF_CONSTRAINT
. . exported "SYS"."WRH$_SQLTEXT" 770.5 KB 842 rows
. . exported "SYS"."WRH$_SQL_PLAN" 5.232 MB 14898 rows
. . exported "SYS"."WRH$_SYSMETRIC_SUMMARY" 48.46 KB 540 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3367547043_1428" 2.266 MB 12025 rows
. . exported "SYS"."WRH$_SEG_STAT_OBJ" 88.89 KB 854 rows
. . exported "SYS"."WRH$_ENQUEUE_STAT" 24.15 KB 308 rows
. . exported "SYS"."WRH$_SQL_BIND_METADATA" 240.1 KB 3955 rows
. . exported "SYS"."WRH$_BG_EVENT_SUMMARY" 11.88 KB 137 rows
. . exported "SYS"."WRH$_SHARED_POOL_ADVICE" 11.32 KB 52 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3367547043_1380" 9.476 KB 0 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3367547043_1404" 9.476 KB 0 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3367547043_1428" 90.16 KB 1552 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3367547043_1404" 7.070 KB 0 rows
. . exported "SYS"."WRH$_PGASTAT" 9.382 KB 68 rows
. . exported "SYS"."WRH$_PGA_TARGET_ADVICE" 10.67 KB 56 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3367547043_1380" 23.03 KB 0 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3367547043_1404" 23.03 KB 0 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3367547043_1380" 16.37 KB 0 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3367547043_1380" 7.070 KB 0 rows
. . exported "SYS"."WRH$_LIBRARYCACHE" 11.70 KB 44 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3367547043_1428" 123.2 KB 397 rows
. . exported "SYS"."WRH$_SQL_WORKAREA_HISTOGRAM" 10.27 KB 68 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3367547043_1404" 16.37 KB 0 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3367547043_1428" 73.44 KB 1076 rows
. . exported "SYS"."WRH$_UNDOSTAT" 15.17 KB 25 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3367547043_1380" 6.75 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3367547043_1404" 6.75 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3367547043_1380" 16.61 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3367547043_1404" 16.61 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3367547043_1380" 6.125 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3367547043_1404" 6.125 KB 0 rows
. . exported "SYS"."WRH$_TABLESPACE_SPACE_USAGE" 8.656 KB 36 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3367547043_1428" 49.59 KB 1060 rows
. . exported "SYS"."WRH$_PROCESS_MEMORY_SUMMARY" 9.164 KB 16 rows
. . exported "SYS"."WRH$_RESOURCE_LIMIT" 8.296 KB 20 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3367547043_1428" 63.25 KB 414 rows
. . exported "SYS"."WRH$_SGA_TARGET_ADVICE" 7.937 KB 32 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3367547043_1428" 48.29 KB 1484 rows
. . exported "SYS"."WRH$_LOG" 9.023 KB 12 rows
. . exported "SYS"."WRH$_STREAMS_POOL_ADVICE" 9.945 KB 80 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3367547043_1380" 6.757 KB 0 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3367547043_1404" 6.757 KB 0 rows
. . exported "SYS"."WRH$_BUFFER_POOL_STATISTICS" 12.21 KB 4 rows
. . exported "SYS"."WRH$_EVENT_NAME" 68.24 KB 878 rows
. . exported "SYS"."WRH$_INSTANCE_RECOVERY" 11.52 KB 4 rows
. . exported "SYS"."WRH$_JAVA_POOL_ADVICE" 8.703 KB 8 rows
. . exported "SYS"."WRH$_PARAMETER_NAME" 62.52 KB 1440 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3367547043_1380" 9.507 KB 0 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3367547043_1404" 9.507 KB 0 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3367547043_1428" 20.85 KB 184 rows
. . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3367547043_1380" 6.437 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3367547043_1404" 6.437 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3367547043_1428" 22.24 KB 448 rows
. . exported "SYS"."WRH$_SGA" 6.718 KB 16 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3367547043_1428" 27.25 KB 546 rows
. . exported "SYS"."WRH$_TEMPSTATXS" 9.5 KB 4 rows
. . exported "SYS"."WRM$_SNAPSHOT" 8.679 KB 4 rows
. . exported "SYS"."WRH$_DATAFILE" 7.648 KB 11 rows
. . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_3367547043_1380" 8.625 KB 0 rows
. . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_3367547043_1404" 8.625 KB 0 rows
. . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_3367547043_1428" 14.23 KB 84 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3367547043_1380" 9.187 KB 0 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3367547043_1404" 9.187 KB 0 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3367547043_1428" 12.45 KB 44 rows
. . exported "SYS"."WRH$_LATCH_NAME" 22.53 KB 388 rows
. . exported "SYS"."WRH$_METRIC_NAME" 24.89 KB 212 rows
. . exported "SYS"."WRH$_OPTIMIZER_ENV" 6.945 KB 7 rows
. . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_3367547043_1380" 6.125 KB 0 rows
. . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_3367547043_1404" 6.125 KB 0 rows
. . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_3367547043_1428" 7.984 KB 72 rows
. . exported "SYS"."WRH$_OSSTAT_NAME" 6 KB 18 rows
. . exported "SYS"."WRH$_RULE_SET" 8.515 KB 4 rows
. . exported "SYS"."WRH$_SERVICE_NAME" 5.968 KB 4 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3367547043_1380" 7.070 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3367547043_1404" 7.070 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3367547043_1428" 12.35 KB 104 rows
. . exported "SYS"."WRH$_SESS_TIME_STATS" 7.476 KB 8 rows
. . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_3367547043_1380" 6.421 KB 0 rows
. . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_3367547043_1404" 6.421 KB 0 rows
. . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_3367547043_1428" 10.10 KB 81 rows
. . exported "SYS"."WRH$_SQL_SUMMARY" 6.914 KB 4 rows
. . exported "SYS"."WRH$_STAT_NAME" 22.54 KB 388 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3367547043_1380" 6.132 KB 0 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3367547043_1404" 6.132 KB 0 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3367547043_1428" 8.468 KB 76 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3367547043_1380" 7.679 KB 0 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3367547043_1404" 7.679 KB 0 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3367547043_1428" 9.648 KB 32 rows
. . exported "SYS"."WRH$_TEMPFILE" 7.093 KB 1 rows
. . exported "SYS"."WRH$_THREAD" 7.531 KB 4 rows
. . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_3367547043_1380" 6.429 KB 0 rows
. . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_3367547043_1404" 6.429 KB 0 rows
. . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_3367547043_1428" 9.085 KB 72 rows
. . exported "SYS"."WRM$_DATABASE_INSTANCE" 7.453 KB 1 rows
. . exported "SYS"."WRM$_WR_CONTROL" 10.14 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$_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_3367547043_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$_FILESTATXS_BL" 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_3367547043_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_BL" 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__3367547043_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_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":"WRH$_LATCH__3367547043_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$_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$_SESSMETRIC_HISTORY" 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$_SYSMETRIC_HISTORY" 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$_WAITCLASSMETRIC_HISTORY" 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$_SNAP_ERROR" 0 KB 0 rows
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/bbb/awrdat_1443_1446.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at 15:08:42
附录2
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01":
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "AWR_STAGE"."WRH$_SQLTEXT" 770.5 KB 842 rows
. . imported "AWR_STAGE"."WRH$_SQL_PLAN" 5.232 MB 14898 rows
. . imported "AWR_STAGE"."WRH$_SYSMETRIC_SUMMARY" 48.46 KB 540 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3367547043_1428" 2.266 MB 12025 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT_OBJ" 88.89 KB 854 rows
. . imported "AWR_STAGE"."WRH$_ENQUEUE_STAT" 24.15 KB 308 rows
. . imported "AWR_STAGE"."WRH$_SQL_BIND_METADATA" 240.1 KB 3955 rows
. . imported "AWR_STAGE"."WRH$_BG_EVENT_SUMMARY" 11.88 KB 137 rows
. . imported "AWR_STAGE"."WRH$_SHARED_POOL_ADVICE" 11.32 KB 52 rows
. . imported "AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_3367547043_1380" 9.476 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_3367547043_1404" 9.476 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_3367547043_1428" 90.16 KB 1552 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3367547043_1404" 7.070 KB 0 rows
. . imported "AWR_STAGE"."WRH$_PGASTAT" 9.382 KB 68 rows
. . imported "AWR_STAGE"."WRH$_PGA_TARGET_ADVICE" 10.67 KB 56 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_3367547043_1380" 23.03 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_3367547043_1404" 23.03 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3367547043_1380" 16.37 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3367547043_1380" 7.070 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LIBRARYCACHE" 11.70 KB 44 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_3367547043_1428" 123.2 KB 397 rows
. . imported "AWR_STAGE"."WRH$_SQL_WORKAREA_HISTOGRAM" 10.27 KB 68 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3367547043_1404" 16.37 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3367547043_1428" 73.44 KB 1076 rows
. . imported "AWR_STAGE"."WRH$_UNDOSTAT" 15.17 KB 25 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_3367547043_1380" 6.75 KB 0 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_3367547043_1404" 6.75 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_3367547043_1380" 16.61 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_3367547043_1404" 16.61 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_3367547043_1380" 6.125 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_3367547043_1404" 6.125 KB 0 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_SPACE_USAGE" 8.656 KB 36 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_3367547043_1428" 49.59 KB 1060 rows
. . imported "AWR_STAGE"."WRH$_PROCESS_MEMORY_SUMMARY" 9.164 KB 16 rows
. . imported "AWR_STAGE"."WRH$_RESOURCE_LIMIT" 8.296 KB 20 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_3367547043_1428" 63.25 KB 414 rows
. . imported "AWR_STAGE"."WRH$_SGA_TARGET_ADVICE" 7.937 KB 32 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_3367547043_1428" 48.29 KB 1484 rows
. . imported "AWR_STAGE"."WRH$_LOG" 9.023 KB 12 rows
. . imported "AWR_STAGE"."WRH$_STREAMS_POOL_ADVICE" 9.945 KB 80 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3367547043_1380" 6.757 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3367547043_1404" 6.757 KB 0 rows
. . imported "AWR_STAGE"."WRH$_BUFFER_POOL_STATISTICS" 12.21 KB 4 rows
. . imported "AWR_STAGE"."WRH$_EVENT_NAME" 68.24 KB 878 rows
. . imported "AWR_STAGE"."WRH$_INSTANCE_RECOVERY" 11.52 KB 4 rows
. . imported "AWR_STAGE"."WRH$_JAVA_POOL_ADVICE" 8.703 KB 8 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER_NAME" 62.52 KB 1440 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3367547043_1380" 9.507 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3367547043_1404" 9.507 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3367547043_1428" 20.85 KB 184 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3367547043_1380" 6.437 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3367547043_1404" 6.437 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3367547043_1428" 22.24 KB 448 rows
. . imported "AWR_STAGE"."WRH$_SGA" 6.718 KB 16 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3367547043_1428" 27.25 KB 546 rows
. . imported "AWR_STAGE"."WRH$_TEMPSTATXS" 9.5 KB 4 rows
. . imported "AWR_STAGE"."WRM$_SNAPSHOT" 8.679 KB 4 rows
. . imported "AWR_STAGE"."WRH$_DATAFILE" 7.648 KB 11 rows
. . imported "AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_3367547043_1380" 8.625 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_3367547043_1404" 8.625 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_3367547043_1428" 14.23 KB 84 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_3367547043_1380" 9.187 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_3367547043_1404" 9.187 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_3367547043_1428" 12.45 KB 44 rows
. . imported "AWR_STAGE"."WRH$_LATCH_NAME" 22.53 KB 388 rows
. . imported "AWR_STAGE"."WRH$_METRIC_NAME" 24.89 KB 212 rows
. . imported "AWR_STAGE"."WRH$_OPTIMIZER_ENV" 6.945 KB 7 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_3367547043_1380" 6.125 KB 0 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_3367547043_1404" 6.125 KB 0 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_3367547043_1428" 7.984 KB 72 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT_NAME" 6 KB 18 rows
. . imported "AWR_STAGE"."WRH$_RULE_SET" 8.515 KB 4 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_NAME" 5.968 KB 4 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3367547043_1380" 7.070 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3367547043_1404" 7.070 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3367547043_1428" 12.35 KB 104 rows
. . imported "AWR_STAGE"."WRH$_SESS_TIME_STATS" 7.476 KB 8 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_3367547043_1380" 6.421 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_3367547043_1404" 6.421 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_3367547043_1428" 10.10 KB 81 rows
. . imported "AWR_STAGE"."WRH$_SQL_SUMMARY" 6.914 KB 4 rows
. . imported "AWR_STAGE"."WRH$_STAT_NAME" 22.54 KB 388 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3367547043_1380" 6.132 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3367547043_1404" 6.132 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3367547043_1428" 8.468 KB 76 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3367547043_1380" 7.679 KB 0 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3367547043_1404" 7.679 KB 0 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3367547043_1428" 9.648 KB 32 rows
. . imported "AWR_STAGE"."WRH$_TEMPFILE" 7.093 KB 1 rows
. . imported "AWR_STAGE"."WRH$_THREAD" 7.531 KB 4 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_3367547043_1380" 6.429 KB 0 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_3367547043_1404" 6.429 KB 0 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_3367547043_1428" 9.085 KB 72 rows
. . imported "AWR_STAGE"."WRM$_DATABASE_INSTANCE" 7.453 KB 1 rows
. . imported "AWR_STAGE"."WRM$_WR_CONTROL" 10.14 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$_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_3367547043_0" 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$_FILESTATXS":"WRH$_FILESTATXS_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS_BL" 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_3367547043_0" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_INST_CACHE_TRANSFER_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":"WRH$_LATCH__3367547043_0" 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":"WRH$_LATCH__3367547043_0" 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$_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$_SESSMETRIC_HISTORY" 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$_SYSMETRIC_HISTORY" 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$_WAITCLASSMETRIC_HISTORY" 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$_SNAP_ERROR" 0 KB 0 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Job "SYS"."SYS_IMPORT_FULL_01" successfully completed at 10:20:44
Register the DBID: 3367547043
Append Data for AWR_STAGE.WRM$_DATABASE_INSTANCE.
Append Data for AWR_STAGE.WRM$_SNAPSHOT.
Append Data for AWR_STAGE.WRH$_STAT_NAME.
Append Data for AWR_STAGE.WRH$_PARAMETER_NAME.
Append Data for AWR_STAGE.WRH$_EVENT_NAME.
Append Data for AWR_STAGE.WRH$_LATCH_NAME.
Append Data for AWR_STAGE.WRH$_FILESTATXS.
Append Data for AWR_STAGE.WRH$_FILESTATXS_BL.
Append Data for AWR_STAGE.WRH$_TEMPSTATXS.
Append Data for AWR_STAGE.WRH$_DATAFILE.
Append Data for AWR_STAGE.WRH$_TEMPFILE.
Append Data for AWR_STAGE.WRH$_SQLSTAT.
Append Data for AWR_STAGE.WRH$_SQLSTAT_BL.
Append Data for AWR_STAGE.WRH$_SQLTEXT.
Append Data for AWR_STAGE.WRH$_SQL_SUMMARY.
Append Data for AWR_STAGE.WRH$_SQL_PLAN.
Append Data for AWR_STAGE.WRH$_SYSTEM_EVENT.
Append Data for AWR_STAGE.WRH$_SYSTEM_EVENT_BL.
Append Data for AWR_STAGE.WRH$_BG_EVENT_SUMMARY.
Append Data for AWR_STAGE.WRH$_WAITSTAT.
Append Data for AWR_STAGE.WRH$_WAITSTAT_BL.
Append Data for AWR_STAGE.WRH$_ENQUEUE_STAT.
Append Data for AWR_STAGE.WRH$_LATCH.
Append Data for AWR_STAGE.WRH$_LATCH_BL.
Append Data for AWR_STAGE.WRH$_LATCH_CHILDREN.
Append Data for AWR_STAGE.WRH$_LATCH_CHILDREN_BL.
Append Data for AWR_STAGE.WRH$_LATCH_PARENT.
Append Data for AWR_STAGE.WRH$_LATCH_PARENT_BL.
Append Data for AWR_STAGE.WRH$_LATCH_MISSES_SUMMARY.
Append Data for AWR_STAGE.WRH$_LATCH_MISSES_SUMMARY_BL.
Append Data for AWR_STAGE.WRH$_LIBRARYCACHE.
Append Data for AWR_STAGE.WRH$_DB_CACHE_ADVICE.
Append Data for AWR_STAGE.WRH$_DB_CACHE_ADVICE_BL.
Append Data for AWR_STAGE.WRH$_BUFFER_POOL_STATISTICS.
Append Data for AWR_STAGE.WRH$_ROWCACHE_SUMMARY.
Append Data for AWR_STAGE.WRH$_ROWCACHE_SUMMARY_BL.
Append Data for AWR_STAGE.WRH$_SGA.
Append Data for AWR_STAGE.WRH$_SGASTAT.
Append Data for AWR_STAGE.WRH$_SGASTAT_BL.
Append Data for AWR_STAGE.WRH$_PGASTAT.
Append Data for AWR_STAGE.WRH$_PROCESS_MEMORY_SUMMARY.
Append Data for AWR_STAGE.WRH$_RESOURCE_LIMIT.
Append Data for AWR_STAGE.WRH$_SHARED_POOL_ADVICE.
Append Data for AWR_STAGE.WRH$_SQL_WORKAREA_HISTOGRAM.
Append Data for AWR_STAGE.WRH$_PGA_TARGET_ADVICE.
Append Data for AWR_STAGE.WRH$_INSTANCE_RECOVERY.
Append Data for AWR_STAGE.WRH$_SYSSTAT.
Append Data for AWR_STAGE.WRH$_SYSSTAT_BL.
Append Data for AWR_STAGE.WRH$_PARAMETER.
Append Data for AWR_STAGE.WRH$_PARAMETER_BL.
Append Data for AWR_STAGE.WRH$_UNDOSTAT.
Append Data for AWR_STAGE.WRH$_SEG_STAT.
Append Data for AWR_STAGE.WRH$_SEG_STAT_BL.
Append Data for AWR_STAGE.WRH$_SEG_STAT_OBJ.
Append Data for AWR_STAGE.WRH$_DLM_MISC.
Append Data for AWR_STAGE.WRH$_DLM_MISC_BL.
Append Data for AWR_STAGE.WRH$_SERVICE_NAME.
Append Data for AWR_STAGE.WRH$_SERVICE_STAT.
Append Data for AWR_STAGE.WRH$_SERVICE_STAT_BL.
Append Data for AWR_STAGE.WRH$_SYSMETRIC_HISTORY.
Append Data for AWR_STAGE.WRH$_FILEMETRIC_HISTORY.
Append Data for AWR_STAGE.WRH$_WAITCLASSMETRIC_HISTORY.
Append Data for AWR_STAGE.WRH$_TABLESPACE_STAT.
Append Data for AWR_STAGE.WRH$_TABLESPACE_STAT_BL.
Append Data for AWR_STAGE.WRH$_LOG.
Append Data for AWR_STAGE.WRH$_MTTR_TARGET_ADVICE.
Append Data for AWR_STAGE.WRH$_TABLESPACE_SPACE_USAGE.
Append Data for AWR_STAGE.WRH$_METRIC_NAME.
Append Data for AWR_STAGE.WRH$_SYSMETRIC_SUMMARY.
Append Data for AWR_STAGE.WRH$_SQL_BIND_METADATA.
Append Data for AWR_STAGE.WRH$_JAVA_POOL_ADVICE.
Append Data for AWR_STAGE.WRH$_THREAD.
Append Data for AWR_STAGE.WRH$_SESSMETRIC_HISTORY.
Append Data for AWR_STAGE.WRH$_OSSTAT.
Append Data for AWR_STAGE.WRH$_OSSTAT_BL.
Append Data for AWR_STAGE.WRH$_OSSTAT_NAME.
Append Data for AWR_STAGE.WRH$_SYS_TIME_MODEL.
Append Data for AWR_STAGE.WRH$_SYS_TIME_MODEL_BL.
Append Data for AWR_STAGE.WRH$_OPTIMIZER_ENV.
Append Data for AWR_STAGE.WRH$_SERVICE_WAIT_CLASS.
Append Data for AWR_STAGE.WRH$_SERVICE_WAIT_CLASS_BL.
Append Data for AWR_STAGE.WRH$_CR_BLOCK_SERVER.
Append Data for AWR_STAGE.WRH$_CURRENT_BLOCK_SERVER.
Append Data for AWR_STAGE.WRH$_INST_CACHE_TRANSFER.
Append Data for AWR_STAGE.WRH$_INST_CACHE_TRANSFER_BL.
Append Data for AWR_STAGE.WRH$_STREAMS_POOL_ADVICE.
Append Data for AWR_STAGE.WRH$_COMP_IOSTAT.
Append Data for AWR_STAGE.WRH$_SGA_TARGET_ADVICE.
Append Data for AWR_STAGE.WRH$_SESS_TIME_STATS.
Append Data for AWR_STAGE.WRH$_STREAMS_CAPTURE.
Append Data for AWR_STAGE.WRH$_STREAMS_APPLY_SUM.
Append Data for AWR_STAGE.WRH$_BUFFERED_QUEUES.
Append Data for AWR_STAGE.WRH$_BUFFERED_SUBSCRIBERS.
Append Data for AWR_STAGE.WRH$_RULE_SET.
Append Data for AWR_STAGE.WRH$_ACTIVE_SESSION_HISTORY.
Append Data for AWR_STAGE.WRH$_ACTIVE_SESSION_HISTORY_BL.
Append Data for AWR_STAGE.WRM$_SNAP_ERROR.
Finished MOVE_TO_AWR procedure
... Dropping AWR_STAGE user
End of AWR Load
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/18922393/viewspace-700146/ ，如需转载，请注明出处，否则将追究法律责任。
