ITPub博客

首页 > 数据库 > Oracle > 探究AWR 第一篇

探究AWR 第一篇

Oracle 作者:jianghaifuyun1987 时间:2014-03-21 14:45:44 0 删除 编辑
statspack相比awr算是比较通用,而且免费,可以在标准版,企业版中使用,awr是新企业版本中才有的,算是statspack的一个升级版,而且代码不公开。但是实现的功能和数据的采集要更丰富。
awr算是dba工作的必备工具。自己总结了一下,大概由以下几个方面来说明一下。
1.snapshot的管理
2.基线的管理
3.
所需空间开销和设置
4.awr数据的迁移
5.生成awr相关的报告
6.awr相关的视图和基表


1.snapshot的管理
先来看看snapshot,这是列出近几天的snapshot,可以看出如果数据库重启过,在两个snap的交集处会有一个分隔的回车。                                                        

Instance     DB Name        Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
TEST01       TEST01            15 13 Mar 2014 17:51      1

                                         16 15 Mar 2014 04:01      1
                                         17 15 Mar 2014 05:00      1
                                         18 15 Mar 2014 07:03      1
                                         19 15 Mar 2014 08:00      1
                                         20 16 Mar 2014 19:41      1
SQL> select to_char(startup_time,'yyyy-mm-dd hh24:mi:ss')from gv$instance;
TO_CHAR(STARTUP_TIM
-------------------
2014-03-15 03:50:27

要生成快照。可以直接用对应的Pl/sql包来实现。
SQL> exec dbms_workload_repository.create_snapshot;
PL/SQL procedure successfully completed.
可以看到,生成了一个新的快照。21:00的时候刚自动创建了一个快照,在一分钟之后手工创建了一个快照。
Instance     DB Name        Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
TEST01       TEST01              16 15 Mar 2014 04:01      1
                                 17 15 Mar 2014 05:00      1
                                 18 15 Mar 2014 07:03      1
                                 19 15 Mar 2014 08:00      1
                                 20 16 Mar 2014 19:41      1
                                 21 16 Mar 2014 21:00      1
                                 22 16 Mar 2014 21:01      1

要删除快照可以使用如下的存储过程
PROCEDURE DROP_SNAPSHOT_RANGE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 LOW_SNAP_ID                    NUMBER                  IN
 HIGH_SNAP_ID                    NUMBER                  IN
 DBID                                  NUMBER                  IN     DEFAULT

这样会删除两个快照,21和22.
SQL> exec dbms_workload_repository.drop_snapshot_range(low_snap_id=>21,high_snap_id=>22);
PL/SQL procedure successfully completed.
重新创建一个快照,快照会从23开始。
SQL> exec dbms_workload_repository.create_snapshot;
PL/SQL procedure successfully completed.
Instance     DB Name        Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
                                。。。。
                                 20 16 Mar 2014 19:41      1
                                 23 16 Mar 2014 21:06      1
2.基线
baseline(基线)的设置也是一个亮点,比如设定一个基准,然后隔了几个月之后,比如数据库突然出现了一些问题,然后领导肯定会问之前为什么好好的,这时候可以拿出之前的基准数据,比如这几个月数据量增长了多少,增长的情况,系统负载的增长,都可以很数字化的体现出来,会更有说服力。
基线的设定,可以使用如下的存储过程。

PROCEDURE CREATE_BASELINE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 START_SNAP_ID                  NUMBER                  IN
 END_SNAP_ID                      NUMBER                  IN
 BASELINE_NAME                  VARCHAR2                IN
 DBID                                  NUMBER                  IN     DEFAULT
 EXPIRATION                        NUMBER                  IN     DEFAULT
SQL> exec dbms_workload_repository.create_baseline( START_SNAP_ID=>17,end_snap_id=>23,baseline_name=>'test_baseline');
PL/SQL procedure successfully completed.

3.所需空间开销和设置

awr采集的数据和指标对于排查问题还是很有帮助的,根据Oracle的描述,默认保留7天的awr数据来算。并发10个session需要大概200-300M的空间,对于一些性能敏感的系统,建议还是保留awr的时间要长一些。
默认awr的保留时间是8天,每一个小时生成一个快照。
SQL> col snap_interval for a20
SQL> col retention format a20
SQL> l
  1* select *from dba_hist_wr_control
SQL> /
      DBID             SNAP_INTERVAL        RETENTION            TOPNSQL
---------- -------------------- -------------------- ----------
3645037571 +00000 01:00:00.0    +00008 00:00:00.0    DEFAULT

比如修改为30分钟采样一次,数据保留31天,可以这样设置
exec dbms_workload_repository.modify_snapshot_settings(interval=>30,retention=>31*24*60);

4.awr数据的迁移
可以把awr的数据迁移到别的库中做相关的诊断。迁移可以基本分为两部分。
1)数据的导出。

SQL> @?/rdbms/admin/awrextr.sql
~~~~~~~~~~~~~
AWR EXTRACT
~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~  This script will extract the AWR data for a range of snapshots  ~
~  into a dump file.  The script will prompt users for the         ~
~  following information:                                          ~
~     (1) database id                                              ~
~     (2) snapshot range to extract                                ~
~     (3) name of directory object                                 ~
~     (4) name of dump file                                        ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Databases in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   DB Id     DB Name      Host
------------ ------------ ------------
* 3645037571 TEST01       rac1
The default database id is the local one: '3645037571'.  To use this
database id, press to continue, otherwise enter an alternative.
Enter value for dbid: 
Using 3645037571 for Database ID

Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed.  Pressing without
specifying a number lists all completed snapshots.

Enter value for num_days: 5
Listing the last 5 days of Completed Snapshots
DB Name        Snap Id    Snap Started
------------ --------- ------------------
TEST01            15 13 Mar 2014 17:51
                    16 15 Mar 2014 04:01
                    17 15 Mar 2014 05:00
                    18 15 Mar 2014 07:03
                    19 15 Mar 2014 08:00
                    20 16 Mar 2014 19:41
                    23 16 Mar 2014 21:06
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 15
Begin Snapshot Id specified: 15
Enter value for end_snap: 23
End   Snapshot Id specified: 23

Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~
Directory Name                 Directory Path
------------------------------ -------------------------------------------------
DATA_PUMP_DIR                  /u03/ora11g/product/11.2.0/dbhome_1/rdbms/log/
ORACLE_OCM_CONFIG_DIR          /u03/ora11g/product/11.2.0/dbhome_1/ccr/state

Choose a Directory Name from the above list (case-sensitive).

Enter value for directory_name: DATA_PUMP_DIR

Using the dump directory: DATA_PUMP_DIR

Specify the Name of the Extract Dump File
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The prefix for the default dump file name is awrdat_15_23.
To use this name, press to continue, otherwise enter
an alternative.

Enter value for file_name: awrextr_TEST01_RECENT_5DAYS.dmp

Using the dump file prefix: awrextr_TEST01_RECENT_5DAYS.dmp
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|  The AWR extract dump file will be located
|  in the following directory/file:
|   /u03/ora11g/product/11.2.0/dbhome_1/rdbms/log/
|   awrextr_TEST01_RECENT_5DAYS.dm.dmp
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|  *** AWR Extract Started ...
|
|  This operation will take a few moments. The
|  progress of the AWR extract operation can be
|  monitored in the following directory/file:
|   /u03/ora11g/product/11.2.0/dbhome_1/rdbms/log/
|   awrextr_TEST01_RECENT_5DAYS.dm.log
|

End of AWR Extract
-------------------------------------


数据加载

SQL> @?/rdbms/admin/awrload.sql
~~~~~~~~~~
AWR LOAD
~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~  This script will load the AWR data from a dump file. The   ~
~  script will prompt users for the following information:    ~
~     (1) name of directory object                            ~
~     (2) name of dump file                                   ~
~     (3) staging schema name to load AWR data into           ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~
Directory Name                 Directory Path
------------------------------ -------------------------------------------------
DATA_PUMP_DIR                  /u03/ora11g/product/11.2.0/dbhome_1/rdbms/log/
ORACLE_OCM_CONFIG_DIR          /u03/ora11g/product/11.2.0/dbhome_1/ccr/state
Choose a Directory Name from the list above (case-sensitive).
Enter value for directory_name: DATA_PUMP_DIR
Using the dump directory: DATA_PUMP_DIR
Specify the Name of the Dump File to Load
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please specify the prefix of the dump file (.dmp) to load:
Enter value for file_name: awrextr_TEST01_RECENT_5DAYS.dm.dmp
Loading from the file name: awrextr_TEST01_RECENT_5DAYS.dm.dmp.dmp
Staging Schema to Load AWR Snapshot Data
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The next step is to create the staging schema
where the AWR snapshot data will be loaded.
After loading the data into the staging schema,
the data will be transferred into the AWR tables
in the SYS schema.

The default staging schema name is AWR_STAGE.
To use this name, press to continue, otherwise enter
an alternative.

Enter value for schema_name:         

Using the staging schema name: AWR_STAGE

Choose the Default tablespace for the AWR_STAGE user
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Choose the AWR_STAGE users's default tablespace.  This is the
tablespace in which the AWR data will be staged.

TABLESPACE_NAME                CONTENTS  DEFAULT TABLESPACE
------------------------------ --------- ------------------
SYSAUX                         PERMANENT *
TEST_DATA1                     PERMANENT
TEST_DATA2                     PERMANENT

Pressing will result in the recommended default
tablespace (identified by *) being used.

Enter value for default_tablespace: 

Using tablespace SYSAUX as the default tablespace for the AWR_STAGE

Choose the Temporary tablespace for the AWR_STAGE user
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Choose the AWR_STAGE user's temporary tablespace.

TABLESPACE_NAME                CONTENTS  DEFAULT TEMP TABLESPACE
------------------------------ --------- -----------------------
TEMPTS1                        TEMPORARY *

Pressing will result in the database's default temporary
tablespace (identified by *) being used.
Enter value for temporary_tablespace: 
Using tablespace TEMPTS1 as the temporary tablespace for AWR_STAGE

... Creating AWR_STAGE user

|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|  Loading the AWR data from the following
|  directory/file:
|   /u03/ora11g/product/11.2.0/dbhome_1/rdbms/log/
|   awrextr_TEST01_RECENT_5DAYS.dm.dmp
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|  *** AWR Load Started ...
|
|  This operation will take a few moments. The
|  progress of the AWR load operation can be
|  monitored in the following directory/file:
|   /u03/ora11g/product/11.2.0/dbhome_1/rdbms/log/
|   awrextr_TEST01_RECENT_5DAYS.dm.log
|
它会创建一个临时的schema,把数据都放到那个schema下,然后再放入sys下面。完成后再删除临时的scema.

5.生成awr相关的报告

当然了以上只是基本的知识点,在实际中需要用awr来生成一些相关的报告。
@?/rdbms/admin/awrrpt.sql  --最常见的生成awr报告的方式
@?/rdbms/admin/awrsqrpt.sql  --生成awr报告中指定sql_id的执行计划
@?/rdbms/admin/awrddrpt.sql  --比较两个awr报告
@?/rdbms/admin/awrrpti.sql  --适用于rac环境等
6.awr相关的视图和基表

dba_hist_snapshot 显示历史的snapshot信息
dba_hist_sql_plan显示sql的执行计划
dba_hist_wr_control显示awr的一些基本信息
还有很多基表在$wrh开头的表中,里面还是有很多的关联。

如下是导出的日志。

. . exported "SYS"."WRH$_SQL_PLAN"                       432.1 KB    1089 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3645037571_0"  198.6 KB    3871 rows
. . exported "SYS"."WRH$_SYSMETRIC_HISTORY"              180.1 KB    3600 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3645037571_0"  174.3 KB     547 rows
. . exported "SYS"."WRH$_SQLTEXT"                        162.0 KB     202 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3645037571_0"  122.7 KB    4466 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3645037571_0"  105.4 KB    2504 rows
. . exported "SYS"."WRH$_EVENT_HISTOGRAM":"WRH$_EVENT__3645037571_0"  81.14 KB    2486 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3645037571_0"  71.64 KB     421 rows
. . exported "SYS"."WRH$_SYSMETRIC_SUMMARY"              93.66 KB    1106 rows
. . exported "SYS"."WRH$_PARAMETER_NAME"                 117.5 KB    2752 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3645037571_0"  51.77 KB      74 rows
. . exported "SYS"."WRH$_ENQUEUE_STAT"                   35.11 KB     531 rows
. . exported "SYS"."WRH$_EVENT_NAME"                     89.11 KB    1152 rows
. . exported "SYS"."WRH$_MVPARAMETER":"WRH$_MVPARA_3645037571_0"  26.92 KB     483 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3645037571_0"  35.02 KB     399 rows
. . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3645037571_0"  26.56 KB     588 rows
. . exported "SYS"."WRH$_SQL_BIND_METADATA"              69.32 KB    1108 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3645037571_0"  32.26 KB     554 rows
. . exported "SYS"."WRM$_SNAPSHOT_DETAILS"               79.82 KB    1691 rows
. . exported "SYS"."WRH$_BG_EVENT_SUMMARY"               20.27 KB     377 rows
. . exported "SYS"."WRH$_BUFFER_POOL_STATISTICS"         14.56 KB       7 rows
. . exported "SYS"."WRH$_DATAFILE"                       8.273 KB       7 rows
. . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_3645037571_0"  19.17 KB     145 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3645037571_0"  12.28 KB      30 rows
. . exported "SYS"."WRH$_INSTANCE_RECOVERY"              13.67 KB       7 rows
. . exported "SYS"."WRH$_IOSTAT_DETAIL"                  13.87 KB      65 rows
. . exported "SYS"."WRH$_IOSTAT_FILETYPE"                16.89 KB      84 rows
. . exported "SYS"."WRH$_IOSTAT_FILETYPE_NAME"           6.156 KB      12 rows
. . exported "SYS"."WRH$_IOSTAT_FUNCTION"                14.56 KB      98 rows
. . exported "SYS"."WRH$_IOSTAT_FUNCTION_NAME"           6.148 KB      14 rows
. . exported "SYS"."WRH$_JAVA_POOL_ADVICE"               12.10 KB      70 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3645037571_0"  15.89 KB     146 rows
. . exported "SYS"."WRH$_LATCH_NAME"                     30.16 KB     553 rows
. . exported "SYS"."WRH$_LIBRARYCACHE"                   17.21 KB     123 rows
. . exported "SYS"."WRH$_LOG"                            10.60 KB      21 rows
. . exported "SYS"."WRH$_MEMORY_RESIZE_OPS"              11.11 KB      12 rows
. . exported "SYS"."WRH$_MEM_DYNAMIC_COMP"               17.19 KB     112 rows
. . exported "SYS"."WRH$_METRIC_NAME"                    31.39 KB     283 rows
. . exported "SYS"."WRH$_MUTEX_SLEEP"                    10.94 KB      73 rows
. . exported "SYS"."WRH$_OPTIMIZER_ENV"                  12.80 KB      29 rows
. . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_3645037571_0"  10.36 KB     154 rows
. . exported "SYS"."WRH$_OSSTAT_NAME"                    6.453 KB      22 rows
. . exported "SYS"."WRH$_PGASTAT"                        11.47 KB     109 rows
. . exported "SYS"."WRH$_PGA_TARGET_ADVICE"              13.46 KB      91 rows
. . exported "SYS"."WRH$_PLAN_OPERATION_NAME"            9.601 KB     130 rows
. . exported "SYS"."WRH$_PLAN_OPTION_NAME"               10.48 KB     165 rows
. . exported "SYS"."WRH$_PROCESS_MEMORY_SUMMARY"         10.96 KB      28 rows
. . exported "SYS"."WRH$_RESOURCE_LIMIT"                 9.890 KB      35 rows
. . exported "SYS"."WRH$_RSRC_CONSUMER_GROUP"            28.62 KB      60 rows
. . exported "SYS"."WRH$_RSRC_PLAN"                      9.015 KB       6 rows
. . exported "SYS"."WRH$_SEG_STAT_OBJ"                   22.17 KB     139 rows
. . exported "SYS"."WRH$_SERVICE_NAME"                   6.304 KB       3 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3645037571_0"  13.46 KB     120 rows
. . exported "SYS"."WRH$_SGA"                            7.609 KB      28 rows
. . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_3645037571_0"  16.45 KB     198 rows
. . exported "SYS"."WRH$_SGA_TARGET_ADVICE"              8.843 KB      46 rows
. . exported "SYS"."WRH$_SHARED_POOL_ADVICE"             15.71 KB     119 rows
. . exported "SYS"."WRH$_SHARED_SERVER_SUMMARY"          13.08 KB       7 rows
. . exported "SYS"."WRH$_SQLCOMMAND_NAME"                10.57 KB     165 rows
. . exported "SYS"."WRH$_SQL_SUMMARY"                    7.656 KB       7 rows
. . exported "SYS"."WRH$_SQL_WORKAREA_HISTOGRAM"         10.07 KB      49 rows
. . exported "SYS"."WRH$_STAT_NAME"                      35.75 KB     655 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3645037571_0"  10.35 KB     133 rows
. . exported "SYS"."WRH$_TABLESPACE"                     7.734 KB       7 rows
. . exported "SYS"."WRH$_TABLESPACE_SPACE_USAGE"         9.460 KB      42 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3645037571_0"  10.42 KB      30 rows
. . exported "SYS"."WRH$_TEMPFILE"                       7.859 KB       1 rows
. . exported "SYS"."WRH$_TEMPSTATXS"                     10.93 KB       7 rows
. . exported "SYS"."WRH$_THREAD"                         8.484 KB       7 rows
. . exported "SYS"."WRH$_TOPLEVELCALL_NAME"              9.867 KB     151 rows
. . exported "SYS"."WRH$_UNDOSTAT"                       17.07 KB      21 rows
. . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_3645037571_0"  11.30 KB     126 rows
. . exported "SYS"."WRM$_BASELINE_DETAILS"               8.710 KB       1 rows
. . exported "SYS"."WRM$_DATABASE_INSTANCE"              8.804 KB       2 rows
. . exported "SYS"."WRM$_SNAPSHOT"                       10.54 KB       7 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$_DISPATCHER"                         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_3645037571_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_3645037571_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_3645037571_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":"WRH$_LATCH__3645037571_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__3645037571_0"      0 KB       0 rows
. . exported "SYS"."WRH$_LATCH_PARENT_BL"                    0 KB       0 rows
. . exported "SYS"."WRH$_MEMORY_TARGET_ADVICE"               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$_PERSISTENT_QMN_CACHE"               0 KB       0 rows
. . exported "SYS"."WRH$_PERSISTENT_QUEUES"                  0 KB       0 rows
. . exported "SYS"."WRH$_PERSISTENT_SUBSCRIBERS"             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$_RULE_SET"                           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$_SESS_TIME_STATS"                    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$_STREAMS_POOL_ADVICE"                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$_BASELINE_TEMPLATE"                  0 KB       0 rows
. . exported "SYS"."WRM$_COLORED_SQL"                        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:
  /u03/ora11g/product/11.2.0/dbhome_1/rdbms/log/awrextr_TEST01_RECENT_5DAYS.dm.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at 21:27:27

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14300593/viewspace-1126642/,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2014-03-07

  • 博文量
    75
  • 访问量
    74355