ITPub博客

首页 > Linux操作系统 > Linux操作系统 > AWR集中管理

AWR集中管理

原创 Linux操作系统 作者:redhouser 时间:2011-06-17 16:48:44 0 删除 编辑

   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博客 ” ,链接:http://blog.itpub.net/18922393/viewspace-700146/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-05-26

  • 博文量
    211
  • 访问量
    812551