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

当前位置: 数据库>oracle

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

来源: 互联网发布时间：2017-05-29

本文导语: 如果把awr保存时间从默认的7天修改为30天，采样时间从1小时修改到更短，修改之后如何预估空间占用？------------------->用这个看下信息@$Oracle_home/rdbms/admin/AWRINFO.sql 以下为样本信息： SQL> @?/rdbms/admin/awrinfo This script will report general ...

如果把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 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
******************************************

*************************************************************
(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

您可能感兴趣的文章:

本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术，将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。