关闭

如何评估oracle AWR 的在oracle 中的存储情况

1251人阅读 评论(0) 收藏 举报
分类:


如何评估oracle AWR 的在oracle 中的存储情况

如果把awr保存时间从默认的7天修改为30天,采样时间从1小时修改到更短,修改之后如何预估空间占用?
------------------->用这个看下信息@$oracle_home/rdbms/admin/AWRINFO.sql


以下为样本信息:

SQL> @?/rdbms/admin/awrinfo

This script will report general AWR information
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Specify the Report File Name
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrinfo.txt.  To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name:

Using the report name awrinfo.txt
No errors.
No errors.
~~~~~~~~~~~~~~~
AWR INFO Report
~~~~~~~~~~~~~~~

Report generated at 06:54:12 on Dec 04, 2013 ( Wednesday ) in Timezone -05:00

Warning: Non Default AWR Setting!
--------------------------------------------------------------------------------
Snapshot interval is 60 minutes and Retention is 8 days


       DB_ID DB_NAME   HOST_PLATFORM                             INST STARTUP_TIME      LAST_ASH_SID PAR
------------ --------- ---------------------------------------- ----- ----------------- ------------ ---
* 239394037  MYNEWDB   oracle11g - Linux IA (32-bit)                1 08:17:27 (12/03)       1658805 NO

########################################################
(I) AWR Snapshots Information
########################################################

*****************************************************
(1a) SYSAUX usage - Schema breakdown (dba_segments)
*****************************************************
|
| Total SYSAUX size                        561.6 MB ( 2% of 32,768.0 MB MAX with AUTOEXTEND ON )
|
| Schema  SYS          occupies            208.5 MB (  37.1% )
| Schema  XDB          occupies            127.9 MB (  22.8% )
| Schema  APEX_030200  occupies             85.1 MB (  15.1% )
| Schema  MDSYS        occupies             53.1 MB (   9.4% )
| Schema  SYSMAN       occupies             46.6 MB (   8.3% )
| Schema  ORDDATA      occupies             12.8 MB (   2.3% )
| Schema  SYSTEM       occupies              9.3 MB (   1.7% )
| Schema  OLAPSYS      occupies              7.3 MB (   1.3% )
| Schema  EXFSYS       occupies              3.6 MB (   0.6% )
| Schema  CTXSYS       occupies              3.5 MB (   0.6% )
| Schema  WMSYS        occupies              3.1 MB (   0.5% )
| Schema  DBSNMP       occupies              0.6 MB (   0.1% )
| Schema  ORDSYS       occupies              0.4 MB (   0.1% )
|
********************************************************
(1b) SYSAUX occupants space usage (v$sysaux_occupants)
********************************************************
|
| Occupant Name        Schema Name               Space Usage
| -------------------- -------------------- ----------------
| XDB                  XDB                          127.9 MB
| SM/AWR               SYS                           93.1 MB
| SDO                  MDSYS                         53.1 MB
| EM                   SYSMAN                        46.6 MB
| SM/OPTSTAT           SYS                           37.8 MB
| AO                   SYS                           33.0 MB
| XSOQHIST             SYS                           33.0 MB
| SM/ADVISOR           SYS                           13.2 MB
| ORDIM/ORDDATA        ORDDATA                       12.8 MB
| LOGMNR               SYSTEM                         7.9 MB
| SM/OTHER             SYS                            7.5 MB
| XSAMD                OLAPSYS                        7.3 MB
| EXPRESSION_FILTER    EXFSYS                         3.6 MB
| TEXT                 CTXSYS                         3.5 MB
| SMON_SCN_TIME        SYS                            3.3 MB
| WM                   WMSYS                          3.1 MB
| SQL_MANAGEMENT_BASE  SYS                            1.7 MB
| PL/SCOPE             SYS                            1.6 MB
| LOGSTDBY             SYSTEM                         1.4 MB
| JOB_SCHEDULER        SYS                            1.1 MB
| STREAMS              SYS                            1.0 MB
| EM_MONITORING_USER   DBSNMP                         0.6 MB
| ORDIM                ORDSYS                         0.4 MB
| AUTO_TASK            SYS                            0.3 MB
| AUDIT_TABLES         SYS                            0.0 MB
| ORDIM/ORDPLUGINS     ORDPLUGINS                     0.0 MB
| ORDIM/SI_INFORMTN_SC SI_INFORMTN_SCHEMA             0.0 MB
| STATSPACK            PERFSTAT                       0.0 MB
| TSM                  TSMSYS                         0.0 MB
| ULTRASEARCH          WKSYS                          0.0 MB
| ULTRASEARCH_DEMO_USE WK_TEST                        0.0 MB
|
| Others (Unaccounted space)                         67.2 MB
|

******************************************
(1c) SYSAUX usage - Unregistered Schemas
******************************************

| This section displays schemas that are not registered
| in V$SYSAUX_OCCUPANTS
|
| Schema  APEX_030200  occupies             85.1 MB
|
| Total space                               85.1 MB
|

*************************************************************
(1d) SYSAUX usage - Unaccounted space in registered schemas
*************************************************************
|
| This section displays unaccounted space in the registered
| schemas of V$SYSAUX_OCCUPANTS.
|
| Unaccounted space in SYS/SYSTEM          -17.9 MB
|
| Total space                              -17.9 MB
|
*************************************
(2) Size estimates for AWR snapshots
*************************************
|
| Estimates based on 60 mins snapshot INTERVAL:
|    AWR size/day                           97.1 MB (4,143 K/snap * 24 snaps/day)
|    AWR size/wk                           679.8 MB (size_per_day * 7) per instance
|
| Estimates based on 4 snaps in past 24 hours:
|    AWR size/day                           16.2 MB (4,143 K/snap and 4 snaps in past 24 hours)
|    AWR size/wk                           113.3 MB (size_per_day * 7) per instance
|

**********************************
(3a) Space usage by AWR components (per database)
**********************************

COMPONENT        MB  % AWR  KB_PER_SNAP MB_PER_DAY MB_PER_WEEK TABLE% : INDEX%
--------- --------- ------ ------------ ---------- ----------- ----------------
FIXED          51.7   55.5        2,301        9.0        62.9    59% : 41%
SQLPLAN        11.0   11.8          490        1.9        13.4    73% : 27%
SQL             6.1    6.5          270        1.1         7.4    66% : 34%
EVENTS          4.6    4.9          203        0.8         5.6    51% : 49%
SPACE           4.1    4.4          181        0.7         4.9    58% : 42%
SQLTEXT         2.1    2.3           95        0.4         2.6    94% : 6%
SQLBIND         1.0    1.1           45        0.2         1.2    56% : 44%
ASH             0.8    0.9           36        0.1         1.0    62% : 38%
RAC             0.6    0.7           28        0.1         0.8    50% : 50%

**********************************
(3b) Space usage within AWR Components (> 500K)
**********************************


COMPONENT        MB SEGMENT_NAME - % SPACE_USED                                           SEGMENT_TYPE
--------- --------- --------------------------------------------------------------------- ---------------
FIXED           7.0 WRH$_LATCH_CHILDREN.WRH$_LATCH__239394037_521                 -  88%  TABLE PARTITION
FIXED           5.0 WRH$_SYSMETRIC_HISTORY                                        -  29%  TABLE
FIXED           4.0 WRH$_SYSMETRIC_HISTORY_INDEX                                  -  35%  INDEX
FIXED           4.0 WRH$_LATCH_CHILDREN_PK.WRH$_LATCH__239394037_521              -  97%  INDEX PARTITION
FIXED           2.0 WRH$_LATCH.WRH$_LATCH_239394037_521                           -  52%  TABLE PARTITION
FIXED           2.0 WRH$_LATCH_CHILDREN.WRH$_LATCH__239394037_559                 -  67%  TABLE PARTITION
FIXED           2.0 WRH$_LATCH_PARENT.WRH$_LATCH__239394037_521                   -  59%  TABLE PARTITION
FIXED           2.0 WRH$_SYSMETRIC_SUMMARY                                        -  17%  TABLE
FIXED           0.9 WRH$_LATCH_CHILDREN_PK.WRH$_LATCH__239394037_559              -  91%  INDEX PARTITION
FIXED           0.9 WRH$_PARAMETER.WRH$_PARAME_239394037_521                      -  88%  TABLE PARTITION
FIXED           0.8 WRH$_SYSSTAT_PK.WRH$_SYSSTA_239394037_521                     -  90%  INDEX PARTITION
FIXED           0.8 WRH$_SYSSTAT.WRH$_SYSSTA_239394037_521                        -  86%  TABLE PARTITION
FIXED           0.7 WRH$_LATCH_PK.WRH$_LATCH_239394037_521                        -  90%  INDEX PARTITION
FIXED           0.7 WRH$_LATCH_PARENT_PK.WRH$_LATCH__239394037_521                -  90%  INDEX PARTITION
FIXED           0.6 WRH$_PARAMETER_PK.WRH$_PARAME_239394037_521                   -  90%  INDEX PARTITION
FIXED           0.5 WRH$_SYSMETRIC_SUMMARY_INDEX                                  -  32%  INDEX
SQLPLAN         8.0 WRH$_SQL_PLAN                                                 -  58%  TABLE
SQLPLAN         3.0 WRH$_SQL_PLAN_PK                                              -  39%  INDEX
SQL             3.0 WRH$_SQLSTAT.WRH$_SQLSTA_239394037_521                        -  72%  TABLE PARTITION
SQL             0.7 WRH$_SQLSTAT_PK.WRH$_SQLSTA_239394037_521                     -  63%  INDEX PARTITION
SQL             0.6 WRH$_SQLSTAT.WRH$_SQLSTA_239394037_559                        -  88%  TABLE PARTITION
SQL             0.5 WRH$_SQLSTAT_INDEX.WRH$_SQLSTA_239394037_521                  -  66%  INDEX PARTITION
EVENTS          0.8 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__239394037_521             -  91%  INDEX PARTITION
EVENTS          0.7 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__239394037_521                -  89%  TABLE PARTITION
SPACE           0.9 WRH$_SEG_STAT.WRH$_SEG_ST_239394037_521                       -  85%  TABLE PARTITION
SQLTEXT         2.0 WRH$_SQLTEXT                                                  -  59%  TABLE
SQLBIND         0.6 WRH$_SQL_BIND_METADATA                                        -  47%  TABLE

**********************************
(4) Space usage by non-AWR components (> 500K)
**********************************

COMPONENT        MB SEGMENT_NAME                                                          SEGMENT_TYPE
--------- --------- --------------------------------------------------------------------- ---------------
NON_AWR        57.1 XDB.SYS_LOB0000056487C00025$$                                         LOBSEGMENT
NON_AWR        26.0 MDSYS.SYS_LOB0000062550C00006$$                                       LOBSEGMENT
NON_AWR        14.1 SYS.SYS_LOB0000064027C00004$$                                         LOBSEGMENT
NON_AWR        14.0 SYS.I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST                                    INDEX
NON_AWR         9.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY                                      TABLE
NON_AWR         8.0 SYS.SYS_LOB0000006213C00038$$                                         LOBSEGMENT
NON_AWR         7.2 SYS.SYS_LOB0000064012C00004$$                                         LOBSEGMENT
NON_AWR         7.0 MDSYS.SDO_CS_SRS                                                      TABLE
NON_AWR         6.0 XDB.XDB$RESOURCE                                                      TABLE
NON_AWR         6.0 SYS.I_WRI$_OPTSTAT_H_ST                                               INDEX
NON_AWR         6.0 APEX_030200.WWV_FLOW_PAGE_PLUGS                                       TABLE
NON_AWR         5.0 APEX_030200.WWV_FLOW_STEP_ITEMS                                       TABLE
NON_AWR         5.0 APEX_030200.WWV_FLOW_DICTIONARY$CAPED                                 INDEX
NON_AWR         4.0 APEX_030200.WWV_FLOW_DICTIONARY$                                      TABLE
NON_AWR         4.0 APEX_030200.SYS_LOB0000070584C00010$$                                 LOBSEGMENT
NON_AWR         3.1 SYS.SYS_LOB0000064007C00004$$                                         LOBSEGMENT
NON_AWR         3.1 SYS.SYS_LOB0000064017C00004$$                                         LOBSEGMENT
NON_AWR         3.0 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY                                     TABLE
NON_AWR         3.0 SYS.SYS_LOB0000006207C00004$$                                         LOBSEGMENT
NON_AWR         3.0 APEX_030200.WWV_FLOW_DICTIONARY$SOUNDEX                               INDEX
NON_AWR         3.0 APEX_030200.WWV_FLOW_DICTIONARY$WORDS                                 INDEX
NON_AWR         3.0 SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST                                     INDEX
NON_AWR         3.0 SYS.SMON_SCN_TO_TIME_AUX                                              CLUSTER
NON_AWR         3.0 APEX_030200.WWV_FLOW_STEP_PROCESSING                                  TABLE
NON_AWR         3.0 XDB.XDB$H_INDEX                                                       TABLE
NON_AWR         2.0 SYS.WRI$_ADV_SQLT_PLANS                                               TABLE
NON_AWR         2.0 APEX_030200.SYS_LOB0000070530C00009$$                                 LOBSEGMENT
NON_AWR         2.0 ORDDATA.SYS_LOB0000057828C00005$$                                     LOBSEGMENT
NON_AWR         2.0 SYS.SYS_LOB0000004976C00005$$                                         LOBSEGMENT
NON_AWR         2.0 APEX_030200.WWV_FLOW_DICTIONARY$_FKIDX                                INDEX
NON_AWR         2.0 APEX_030200.WWV_FLOW_REGION_REPORT_COLUMN                             TABLE
NON_AWR         2.0 APEX_030200.WWV_FLOW_STEP_ITEM_HELP                                   TABLE
NON_AWR         2.0 SYSMAN.MGMT_METRICS                                                   TABLE
NON_AWR         2.0 MDSYS.SDO_COORD_REF_SYS                                               TABLE
NON_AWR         2.0 XDB.XDB$ELEMENT                                                       TABLE
NON_AWR         1.2 SYS.SYS_LOB0000064032C00004$$                                         LOBSEGMENT
NON_AWR         1.1 SYS.SYS_LOB0000064022C00004$$                                         LOBSEGMENT
NON_AWR         1.0 SYS.WRI$_ADV_RATIONALE                                                TABLE
NON_AWR         1.0 SYS.SYS_LOB0000005778C00040$$                                         LOBSEGMENT
NON_AWR         1.0 XDB.XDB$H_LINK                                                        TABLE
NON_AWR         1.0 SYS.SYS$SERVICE_METRICS_TAB                                           TABLE
NON_AWR         0.9 SYSMAN.MGMT_METRICS_PK                                                INDEX
NON_AWR         0.9 SYSMAN.MGMT_METRICS_IDX_01                                            INDEX
NON_AWR         0.9 APEX_030200.WWV_FLOW_STEPS                                            TABLE
NON_AWR         0.9 SYSMAN.MGMT_METRICS_IDX_03                                            INDEX
NON_AWR         0.9 SYS.I_WRI$_OPTSTAT_HH_ST                                              INDEX
NON_AWR         0.8 APEX_030200.WWV_FLOW_STEP_VALIDATIONS                                 TABLE

COMPONENT        MB SEGMENT_NAME                                                          SEGMENT_TYPE
--------- --------- --------------------------------------------------------------------- ---------------
NON_AWR         0.8 XDB.XDB$RESOURCE_ACLOID_IDX                                           INDEX
NON_AWR         0.8 APEX_030200.WWV_FLOW_LIST_ITEMS                                       TABLE
NON_AWR         0.6 SYS.SCHEDULER$_EVENT_LOG                                              TABLE
NON_AWR         0.6 APEX_030200.WWV_FLOW_STEP_ITEMS_U_NAME                                INDEX
NON_AWR         0.6 XDB.XDB_PK_H_LINK                                                     INDEX
NON_AWR         0.6 APEX_030200.WWV_FLOW_STEP_BRANCHES                                    TABLE
NON_AWR         0.6 APEX_030200.WWV_FLOW_STEP_BUTTONS                                     TABLE
NON_AWR         0.6 SYSMAN.MGMT_IP_REPORT_ELEM_PARAMS                                     TABLE
NON_AWR         0.6 SYSMAN.MGMT_JOB_STEP_PARAMS                                           TABLE
NON_AWR         0.6 XDB.XDB$COMPLEX_TYPE                                                  TABLE
NON_AWR         0.6 SYSMAN.MGMT_POLICIES                                                  TABLE
NON_AWR         0.6 ORDDATA.SYS_LOB0000057976C00005$$                                     LOBSEGMENT
NON_AWR         0.6 SYSMAN.PK_MGMT_JOB_STEP_PARAMS                                        INDEX
NON_AWR         0.6 SYS.WRI$_ADV_PARAMETERS_PK                                            INDEX
NON_AWR         0.5 SYS.AW_OBJ$                                                           TABLE
NON_AWR         0.5 APEX_030200.WWV_FLOW_LIST_OF_VALUES_DATA                              TABLE
NON_AWR         0.5 SYSMAN.SYS_LOB0000067821C00004$$                                      LOBSEGMENT

**********************************
(5a) AWR snapshots - last 50
**********************************

Total snapshots in DB 239394037 Instance 1 = 23

      DBID    SNAP_ID  INST FLUSH_ELAPSED        ENDTM             STARTUP_TIME      STATUS ERRCNT
---------- ---------- ----- -------------------- ----------------- ----------------- ------ ------
 239394037        544     1 +00000 00:00:04.2    08:00:21 (11/25)  06:25:05 (11/21)       0      0
 239394037        545     1 +00000 00:00:04.2    09:00:31 (11/25)  06:25:05 (11/21)       0      0
 239394037        546     1 +00000 00:00:04.4    10:00:42 (11/25)  06:25:05 (11/21)       0      0
 239394037        547     1 +00000 00:00:18.4    00:50:45 (11/26)  00:39:23 (11/26)       0      0
 239394037        548     1 +00000 00:00:05.5    02:00:52 (11/26)  00:39:23 (11/26)       0      0
 239394037        549     1 +00000 00:00:04.7    03:00:57 (11/26)  00:39:23 (11/26)       0      0
 239394037        550     1 +00000 00:00:03.9    04:00:02 (11/26)  00:39:23 (11/26)       0      0
 239394037        551     1 +00000 00:00:04.9    05:00:30 (11/26)  00:39:23 (11/26)       0      0
 239394037        552     1 +00000 00:00:04.7    06:00:33 (11/26)  00:39:23 (11/26)       0      0
 239394037        553     1 +00000 00:00:05.5    07:00:40 (11/26)  00:39:23 (11/26)       0      0
 239394037        554     1 +00000 00:00:04.6    08:00:45 (11/26)  00:39:23 (11/26)       0      0
 239394037        555     1 +00000 00:00:04.3    09:00:51 (11/26)  00:39:23 (11/26)       0      0
 239394037        556     1 +00000 00:00:06.5    04:28:55 (11/29)  00:39:23 (11/26)       0      0
 239394037        557     1 +00000 00:00:09.4    05:00:01 (11/29)  00:39:23 (11/26)       0      0
 239394037        558     1 +00000 00:00:04.3    06:00:07 (11/29)  00:39:23 (11/26)       0      0
 239394037        559     1 +00000 00:00:03.1    07:00:11 (11/29)  00:39:23 (11/26)       0      0
 239394037        560     1 +00000 00:00:02.5    08:00:15 (11/29)  00:39:23 (11/26)       0      0
 239394037        561     1 +00000 00:00:02.8    09:00:19 (11/29)  00:39:23 (11/26)       0      0
 239394037        562     1 +00000 00:01:01.1    22:41:06 (12/01)  00:39:23 (11/26)       0      0
 239394037        563     1 +00000 00:00:22.1    07:10:16 (12/03)  00:39:23 (11/26)       0      0
 239394037        564     1 +00000 00:00:06.1    08:00:23 (12/03)  00:39:23 (11/26)       0      0
 239394037        565     1 +00000 00:00:20.7    09:00:57 (12/03)  08:17:27 (12/03)       0      0
 239394037        566     1 +00000 00:00:12.2    06:49:54 (12/04)  08:17:27 (12/03)       0      0

**********************************
(5b) AWR snapshots with errors or invalid
**********************************

no rows selected


**********************************
(5c) AWR snapshots -- OLDEST Non-Baselined snapshots
**********************************

      DBID  INST    SNAP_ID ENDTM             STATUS ERROR_COUNT
---------- ----- ---------- ----------------- ------ -----------
 239394037     1        544 08:00:21 (11/25)       0           0

**********************************
(6) AWR Control Settings - interval, retention
**********************************

       DBID  LSNAPID LSPLITID LSNAPTIME      LPURGETIME      FLAG INTERVAL          RETENTION         VRSN
----------- -------- -------- -------------- -------------- ----- ----------------- ----------------- ----
  239394037      566      556 12/04 06:50:07 12/03 07:32:00     2 +00000 01:00:00.0 +00008 00:00:00.0    4

**********************************
(7a) AWR Contents - row counts for each snapshots
**********************************

   SNAP_ID  INST        ASH        SQL      SQBND      FILES      SEGST     SYSEVT
---------- ----- ---------- ---------- ---------- ---------- ---------- ----------
       544     1          6        193        586          7        173         92
       545     1         13        203        620          7        173         92
       546     1         34        295        886          7        195         95
       547     1        120        316        864          7        121         75
       548     1         16        194        589          7        130         82
       549     1         10        194        594          7        125         82
       550     1          3        182        592          7        122         82
       551     1          6        178        566          7        120         82
       552     1          5        210        572          7        133         82
       553     1         14        175        546          7        126         83
       554     1         11        173        564          7        121         83
       555     1          9        204        593          7        133         83
       556     1         11        197        609          7        134         84
       557     1         17        263       1014          7        191         87
       558     1         10        203        610          7        187         87
       559     1          3        181        568          7        168         87
       560     1          4        179        593          7        149         87
       561     1          4        178        578          7        160         88
       562     1          7        271        802          7        157         88
       563     1        123        299        922          7        208         93
       564     1         13        236        798          7        193         93
       565     1         29        294        550          7        103         51
       566     1          4        207        573          7        129         61

**********************************
(7b) AWR Contents - average row counts per snapshot
**********************************

SNAP_COUNT  INST        ASH    SQLSTAT    SQLBIND      FILES    SEGSTAT   SYSEVENT
---------- ----- ---------- ---------- ---------- ---------- ---------- ----------
        23     1      20.52     218.48     660.39          7     150.04      83.43

**********************************
(7c) AWR total item counts - names, text, plans
**********************************

   SQLTEXT    SQLPLAN   SQLBMETA     SEGOBJ   DATAFILE   TEMPFILE
---------- ---------- ---------- ---------- ---------- ----------
      1464      13432       3541        562          7          1


########################################################
(II) Advisor Framework Info
########################################################

**********************************
(1) Advisor Tasks - Last 50
**********************************

OWNER/ADVISOR  TASK_ID/NAME                     CREATED          EXE_DURATN EXE_CREATN HOW_C STATUS
-------------- -------------------------------- ---------------- ---------- ---------- ----- ------------
SYS/SQL Tuning 1/SYS_AUTO_SQL_TUNING_TASK       23:06:18 (08/13)         69 ########## AUTO  COMPLETED
SYS/ADDM       760/ADDM:239394037_1_521         04:00:18 (11/22)          1          1 AUTO  COMPLETED
SYS/ADDM       761/ADDM:239394037_1_522         05:00:20 (11/22)          1          1 AUTO  COMPLETED
SYS/ADDM       762/ADDM:239394037_1_523         06:00:30 (11/22)          1          1 AUTO  COMPLETED
SYS/ADDM       763/ADDM:239394037_1_524         07:00:30 (11/22)          0          1 AUTO  COMPLETED
SYS/ADDM       764/ADDM:239394037_1_525         08:00:35 (11/22)          0          1 AUTO  COMPLETED
SYS/ADDM       765/ADDM:239394037_1_526         09:00:41 (11/22)          0          0 AUTO  COMPLETED
SYS/ADDM       766/ADDM:239394037_1_527         10:00:56 (11/22)          1          2 AUTO  COMPLETED
SYS/ADDM       767/ADDM:239394037_1_528         23:51:30 (11/22)          2          4 AUTO  COMPLETED
SYS/Segment Ad 768/SYS_AUTO_SPCADV_045223221120 23:52:12 (11/22)         31         34 CMD   FATAL ERROR
               13

SYS/ADDM       769/ADDM:239394037_1_529         01:01:05 (11/23)          4          4 AUTO  COMPLETED
SYS/ADDM       770/ADDM:239394037_1_530         02:00:19 (11/23)          1          1 AUTO  COMPLETED
SYS/ADDM       771/ADDM:239394037_1_531         03:00:28 (11/23)          1          1 AUTO  COMPLETED
SYS/ADDM       772/ADDM:239394037_1_532         04:00:34 (11/23)          1          1 AUTO  COMPLETED
SYS/ADDM       773/ADDM:239394037_1_533         05:00:49 (11/23)          0          0 AUTO  COMPLETED
SYS/Segment Ad 774/SYS_AUTO_SPCADV_340006231120 06:00:38 (11/23)         73         74 CMD   FATAL ERROR
               13

SYS/ADDM       775/ADDM:239394037_1_534         06:01:49 (11/23)          4          4 AUTO  COMPLETED
SYS/ADDM       776/ADDM:239394037_1_535         07:00:20 (11/23)          2          2 AUTO  COMPLETED
SYS/ADDM       777/ADDM:239394037_1_536         08:00:23 (11/23)          0          0 AUTO  COMPLETED
SYS/ADDM       778/ADDM:239394037_1_537         09:00:30 (11/23)          2          3 AUTO  COMPLETED
SYS/ADDM       779/ADDM:239394037_1_538         10:00:37 (11/23)          1          1 AUTO  COMPLETED
SYS/Segment Ad 780/SYS_AUTO_SPCADV_150910231120 10:09:16 (11/23)         25         25 CMD   FATAL ERROR
               13

SYS/ADDM       781/ADDM:239394037_1_539         03:02:46 (11/25)         17         17 AUTO  COMPLETED
SYS/ADDM       782/ADDM:239394037_1_540         04:00:24 (11/25)          1          1 AUTO  COMPLETED
SYS/ADDM       783/ADDM:239394037_1_541         05:00:42 (11/25)          0          1 AUTO  COMPLETED
SYS/ADDM       784/ADDM:239394037_1_542         06:01:02 (11/25)          0          1 AUTO  COMPLETED
SYS/ADDM       785/ADDM:239394037_1_543         07:00:17 (11/25)          1          1 AUTO  COMPLETED
SYS/ADDM       786/ADDM:239394037_1_544         08:00:26 (11/25)          1          2 AUTO  COMPLETED
SYS/ADDM       787/ADDM:239394037_1_545         09:00:37 (11/25)          0          2 AUTO  COMPLETED
SYS/ADDM       788/ADDM:239394037_1_546         10:00:47 (11/25)          0          1 AUTO  COMPLETED
SYS/Segment Ad 789/SYS_AUTO_SPCADV_474200261120 00:42:58 (11/26)         68         75 CMD   FATAL ERROR
               13

SYS/ADDM       790/ADDM:239394037_1_548         02:01:00 (11/26)          2          3 AUTO  COMPLETED
SYS/ADDM       791/ADDM:239394037_1_549         03:01:02 (11/26)          0          1 AUTO  COMPLETED
SYS/ADDM       792/ADDM:239394037_1_550         04:00:06 (11/26)          0          1 AUTO  COMPLETED
SYS/ADDM       793/ADDM:239394037_1_551         05:00:35 (11/26)          1          2 AUTO  COMPLETED
SYS/ADDM       794/ADDM:239394037_1_552         06:00:39 (11/26)          1          1 AUTO  COMPLETED
SYS/ADDM       795/ADDM:239394037_1_553         07:00:47 (11/26)          1          2 AUTO  COMPLETED
SYS/ADDM       796/ADDM:239394037_1_554         08:00:51 (11/26)          0          1 AUTO  COMPLETED
SYS/ADDM       797/ADDM:239394037_1_555         09:00:57 (11/26)          1          1 AUTO  COMPLETED
SYS/ADDM       798/ADDM:239394037_1_556         04:29:03 (11/29)          1          1 AUTO  COMPLETED
SYS/ADDM       799/ADDM:239394037_1_557         05:00:13 (11/29)          1          1 AUTO  COMPLETED
SYS/ADDM       800/ADDM:239394037_1_558         06:00:13 (11/29)          1          1 AUTO  COMPLETED
SYS/ADDM       801/ADDM:239394037_1_559         07:00:16 (11/29)          0          1 AUTO  COMPLETED
SYS/ADDM       802/ADDM:239394037_1_560         08:00:19 (11/29)          0          1 AUTO  COMPLETED
SYS/ADDM       803/ADDM:239394037_1_561         09:00:23 (11/29)          0          1 AUTO  COMPLETED
SYS/ADDM       804/ADDM:239394037_1_562         22:42:24 (12/01)          9         10 AUTO  COMPLETED
SYS/Segment Ad 805/SYS_AUTO_SPCADV_334222011220 22:42:33 (12/01)         35         36 CMD   FATAL ERROR
               13

SYS/ADDM       809/ADDM:239394037_1_563         07:10:44 (12/03)          3          3 AUTO  COMPLETED
SYS/ADDM       810/ADDM:239394037_1_564         08:00:31 (12/03)          1          2 AUTO  COMPLETED
SYS/ADDM       819/ADDM:239394037_1_566         06:50:23 (12/04)          5          6 AUTO  COMPLETED

**********************************
(2) Advisor Task - Oldest 5
**********************************

OWNER/ADVISOR  TASK_ID/NAME                     CREATED          EXE_DURATN EXE_CREATN HOW_C STATUS
-------------- -------------------------------- ---------------- ---------- ---------- ----- ------------
SYS/ADDM       615/ADDM:239394037_1_444         07:04:26 (11/12)          0          1 AUTO  COMPLETED
SYS/ADDM       616/ADDM:239394037_1_446         09:00:43 (11/12)          2          3 AUTO  COMPLETED
SYS/ADDM       617/ADDM:239394037_1_447         20:12:24 (11/12)          1          2 AUTO  COMPLETED
SYS/ADDM       618/ADDM:239394037_1_448         21:00:38 (11/12)          1          1 AUTO  COMPLETED
SYS/ADDM       620/ADDM:239394037_1_449         22:01:35 (11/12)          0          2 AUTO  COMPLETED

**********************************
(3) Advisor Tasks With Errors - Last 50
**********************************

OWNER/ADVISOR  TASK_ID/NAME                     CREATED          EXE_DURATN EXE_CREATN HOW_C STATUS
-------------- -------------------------------- ---------------- ---------- ---------- ----- ------------
TASK_DESC
--------------------------------------------------------------------------------------------------------------
ERROR_MSG
--------------------------------------------------------------------------------------------------------------
SYS/Segment Ad 619/SYS_AUTO_SPCADV_360022121120 22:00:36 (11/12)         63         64 CMD   FATAL ERROR
               13
Description: Auto Space Advisor for tablespace
Error Msg  : ORA-00376: file  cannot be read at this time

SYS/Segment Ad 656/SYS_AUTO_SPCADV_380022141120 22:00:52 (11/14)         60         78 CMD   FATAL ERROR
               13
Description: Auto Space Advisor for tablespace
Error Msg  : ORA-00376: file  cannot be read at this time

SYS/Segment Ad 669/SYS_AUTO_SPCADV_102401171120 01:24:11 (11/17)         45         47 CMD   FATAL ERROR
               13
Description: Auto Space Advisor for tablespace
Error Msg  : ORA-00376: file  cannot be read at this time

SYS/Segment Ad 674/SYS_AUTO_SPCADV_240006171120 06:00:25 (11/17)         38         38 CMD   FATAL ERROR
               13
Description: Auto Space Advisor for tablespace
Error Msg  : ORA-00376: file  cannot be read at this time

SYS/Segment Ad 679/SYS_AUTO_SPCADV_510000191120 00:00:55 (11/19)         71         74 CMD   FATAL ERROR
               13
Description: Auto Space Advisor for tablespace
Error Msg  : ORA-00376: file  cannot be read at this time

SYS/Segment Ad 693/SYS_AUTO_SPCADV_270022191120 22:00:29 (11/19)         75         79 CMD   FATAL ERROR
               13
Description: Auto Space Advisor for tablespace
Error Msg  : ORA-00376: file  cannot be read at this time

SYS/Segment Ad 719/SYS_AUTO_SPCADV_541300211120 00:13:55 (11/21)         22         25 CMD   FATAL ERROR
               13
Description: Auto Space Advisor for tablespace
Error Msg  : ORA-00376: file  cannot be read at this time

SYS/Segment Ad 745/SYS_AUTO_SPCADV_490022211120 22:00:59 (11/21)         44         47 CMD   FATAL ERROR
               13
Description: Auto Space Advisor for tablespace
Error Msg  : ORA-00376: file  cannot be read at this time

SYS/Segment Ad 768/SYS_AUTO_SPCADV_045223221120 23:52:12 (11/22)         31         34 CMD   FATAL ERROR
               13
Description: Auto Space Advisor for tablespace
Error Msg  : ORA-00376: file  cannot be read at this time

SYS/Segment Ad 774/SYS_AUTO_SPCADV_340006231120 06:00:38 (11/23)         73         74 CMD   FATAL ERROR
               13
Description: Auto Space Advisor for tablespace
Error Msg  : ORA-00376: file  cannot be read at this time

SYS/Segment Ad 780/SYS_AUTO_SPCADV_150910231120 10:09:16 (11/23)         25         25 CMD   FATAL ERROR
               13
Description: Auto Space Advisor for tablespace
Error Msg  : ORA-00376: file  cannot be read at this time

SYS/Segment Ad 789/SYS_AUTO_SPCADV_474200261120 00:42:58 (11/26)         68         75 CMD   FATAL ERROR
               13
Description: Auto Space Advisor for tablespace
Error Msg  : ORA-00376: file  cannot be read at this time

SYS/Segment Ad 805/SYS_AUTO_SPCADV_334222011220 22:42:33 (12/01)         35         36 CMD   FATAL ERROR
               13
Description: Auto Space Advisor for tablespace
Error Msg  : ORA-00376: file  cannot be read at this time



########################################################
(III) ASH Usage Info
########################################################

**********************************
(1a) ASH histogram (past 3 days)
**********************************

NUM_ACTIVE_SESSIONS   NUM_SAMPLES
-------------------- ------------
0000 - 0004                    60
0005 - 0009                     5

**********************************
(1b) ASH histogram (past 1 day)
**********************************

NUM_ACTIVE_SESSIONS   NUM_SAMPLES
-------------------- ------------
0000 - 0004                    25
0005 - 0009                     2

**********************************
(2a) ASH details (past 3 days)
**********************************

INST MIN_TIME         MAX_TIME          NUM_SAMPLES     NUM_ROWS AVG_ACTIVE
---- ---------------- ---------------- ------------ ------------ ----------
   1 22:42:52 (12/01) 09:15:30 (12/03)          981          113       0.12

**********************************
(2b) ASH details (past 1 day)
**********************************

INST MIN_TIME         MAX_TIME          NUM_SAMPLES     NUM_ROWS AVG_ACTIVE
---- ---------------- ---------------- ------------ ------------ ----------
   1 07:12:11 (12/03) 09:15:30 (12/03)          626           42       0.07

**********************************
(2c) ASH sessions (Fg Vs Bg) (past 1 day across all instances in RAC)
**********************************

Foreground %           21.4
Background %           78.6
MMNL %                  0.0

End of Report
Report written to awrinfo.txt

1
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:774296次
    • 积分:14646
    • 等级:
    • 排名:第790名
    • 原创:671篇
    • 转载:95篇
    • 译文:11篇
    • 评论:85条
    博客专栏
    oracle blog
    最新评论