如何评估Oracle AWR 的在Oracle 中的存储情况
如何评估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.txtNo 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------------ --------- ---------------------------------------- ----- ----------------- ------------ ---* & 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)& & & & & & & & & & & &
　　******************************************(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& & & & & & & & & & & & & & &
　　*************************************************************(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__1& & & & & & & &
-& 88%& TABLE PARTITIONFIXED& & & & &
5.0 WRH$_SYSMETRIC_HISTORY& & & & & & & & & & & & & & & & & & & & -& 29%& TABLEFIXED& & & & &
4.0 WRH$_SYSMETRIC_HISTORY_INDEX& & & & & & & & & & & & & & & & & -& 35%& INDEXFIXED& & & & &
4.0 WRH$_LATCH_CHILDREN_PK.WRH$_LATCH__1& & & & & & & -& 97%& INDEX PARTITIONFIXED& & & & &
2.0 WRH$_LATCH.WRH$_LATCH_1& & & & & & & & & & & & &
-& 52%& TABLE PARTITIONFIXED& & & & &
2.0 WRH$_LATCH_CHILDREN.WRH$_LATCH__9& & & & & & & &
-& 67%& TABLE PARTITIONFIXED& & & & &
2.0 WRH$_LATCH_PARENT.WRH$_LATCH__1& & & & & & & & &
-& 59%& TABLE PARTITIONFIXED& & & & &
2.0 WRH$_SYSMETRIC_SUMMARY& & & & & & & & & & & & & & & & & & & & -& 17%& TABLEFIXED& & & & &
0.9 WRH$_LATCH_CHILDREN_PK.WRH$_LATCH__9& & & & & & & -& 91%& INDEX PARTITIONFIXED& & & & &
0.9 WRH$_PARAMETER.WRH$_PARAME_1& & & & & & & & & & & -& 88%& TABLE PARTITIONFIXED& & & & &
0.8 WRH$_SYSSTAT_PK.WRH$_SYSSTA_1& & & & & & & & & &
-& 90%& INDEX PARTITIONFIXED& & & & &
0.8 WRH$_SYSSTAT.WRH$_SYSSTA_1& & & & & & & & & & & & -& 86%& TABLE PARTITIONFIXED& & & & &
0.7 WRH$_LATCH_PK.WRH$_LATCH_1& & & & & & & & & & & & -& 90%& INDEX PARTITIONFIXED& & & & &
0.7 WRH$_LATCH_PARENT_PK.WRH$_LATCH__1& & & & & & & & -& 90%& INDEX PARTITIONFIXED& & & & &
0.6 WRH$_PARAMETER_PK.WRH$_PARAME_1& & & & & & & & &
-& 90%& INDEX PARTITIONFIXED& & & & &
0.5 WRH$_SYSMETRIC_SUMMARY_INDEX& & & & & & & & & & & & & & & & & -& 32%& INDEXSQLPLAN& & & &
8.0 WRH$_SQL_PLAN& & & & & & & & & & & & & & & & & & & & & & & &
-& 58%& TABLESQLPLAN& & & &
3.0 WRH$_SQL_PLAN_PK& & & & & & & & & & & & & & & & & & & & & & & -& 39%& INDEXSQL& & & & & &
3.0 WRH$_SQLSTAT.WRH$_SQLSTA_1& & & & & & & & & & & & -& 72%& TABLE PARTITIONSQL& & & & & &
0.7 WRH$_SQLSTAT_PK.WRH$_SQLSTA_1& & & & & & & & & &
-& 63%& INDEX PARTITIONSQL& & & & & &
0.6 WRH$_SQLSTAT.WRH$_SQLSTA_9& & & & & & & & & & & & -& 88%& TABLE PARTITIONSQL& & & & & &
0.5 WRH$_SQLSTAT_INDEX.WRH$_SQLSTA_1& & & & & & & & & -& 66%& INDEX PARTITIONEVENTS& & & & & 0.8 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__1& & & & & &
-& 91%& INDEX PARTITIONEVENTS& & & & & 0.7 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__1& & & & & & & & -& 89%& TABLE PARTITIONSPACE& & & & &
0.9 WRH$_SEG_STAT.WRH$_SEG_ST_1& & & & & & & & & & &
-& 85%& TABLE PARTITIONSQLTEXT& & & &
2.0 WRH$_SQLTEXT& & & & & & & & & & & & & & & & & & & & & & & & & -& 59%& TABLESQLBIND& & & &
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_LOBC00025$$& & & & & & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & & 26.0 MDSYS.SYS_LOBC00006$$& & & & & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & & 14.1 SYS.SYS_LOBC00004$$& & & & & & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & & 14.0 SYS.I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST& & & & & & & & & & & & & & & & & & INDEXNON_AWR& & & &
9.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY& & & & & & & & & & & & & & & & & & & TABLENON_AWR& & & &
8.0 SYS.SYS_LOBC00038$$& & & & & & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & &
7.2 SYS.SYS_LOBC00004$$& & & & & & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & &
7.0 MDSYS.SDO_CS_SRS& & & & & & & & & & & & & & & & & & & & & & & & & & & TABLENON_AWR& & & &
6.0 XDB.XDB$RESOURCE& & & & & & & & & & & & & & & & & & & & & & & & & & & TABLENON_AWR& & & &
6.0 SYS.I_WRI$_OPTSTAT_H_ST& & & & & & & & & & & & & & & & & & & & & & &
INDEXNON_AWR& & & &
6.0 APEX_030200.WWV_FLOW_PAGE_PLUGS& & & & & & & & & & & & & & & & & & &
TABLENON_AWR& & & &
5.0 APEX_030200.WWV_FLOW_STEP_ITEMS& & & & & & & & & & & & & & & & & & &
TABLENON_AWR& & & &
5.0 APEX_030200.WWV_FLOW_DICTIONARY$CAPED& & & & & & & & & & & & & & & &
INDEXNON_AWR& & & &
4.0 APEX_030200.WWV_FLOW_DICTIONARY$& & & & & & & & & & & & & & & & & & & TABLENON_AWR& & & &
4.0 APEX_030200.SYS_LOBC00010$$& & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & &
3.1 SYS.SYS_LOBC00004$$& & & & & & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & &
3.1 SYS.SYS_LOBC00004$$& & & & & & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & &
3.0 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY& & & & & & & & & & & & & & & & & &
TABLENON_AWR& & & &
3.0 SYS.SYS_LOBC00004$$& & & & & & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & &
3.0 APEX_030200.WWV_FLOW_DICTIONARY$SOUNDEX& & & & & & & & & & & & & & &
INDEXNON_AWR& & & &
3.0 APEX_030200.WWV_FLOW_DICTIONARY$WORDS& & & & & & & & & & & & & & & &
INDEXNON_AWR& & & &
3.0 SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST& & & & & & & & & & & & & & & & & &
INDEXNON_AWR& & & &
3.0 SYS.SMON_SCN_TO_TIME_AUX& & & & & & & & & & & & & & & & & & & & & & & CLUSTERNON_AWR& & & &
3.0 APEX_030200.WWV_FLOW_STEP_PROCESSING& & & & & & & & & & & & & & & & & TABLENON_AWR& & & &
3.0 XDB.XDB$H_INDEX& & & & & & & & & & & & & & & & & & & & & & & & & & &
TABLENON_AWR& & & &
2.0 SYS.WRI$_ADV_SQLT_PLANS& & & & & & & & & & & & & & & & & & & & & & &
TABLENON_AWR& & & &
2.0 APEX_030200.SYS_LOBC00009$$& & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & &
2.0 ORDDATA.SYS_LOBC00005$$& & & & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & &
2.0 SYS.SYS_LOBC00005$$& & & & & & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & &
2.0 APEX_030200.WWV_FLOW_DICTIONARY$_FKIDX& & & & & & & & & & & & & & & & INDEXNON_AWR& & & &
2.0 APEX_030200.WWV_FLOW_REGION_REPORT_COLUMN& & & & & & & & & & & & & &
TABLENON_AWR& & & &
2.0 APEX_030200.WWV_FLOW_STEP_ITEM_HELP& & & & & & & & & & & & & & & & &
TABLENON_AWR& & & &
2.0 SYSMAN.MGMT_METRICS& & & & & & & & & & & & & & & & & & & & & & & & &
TABLENON_AWR& & & &
2.0 MDSYS.SDO_COORD_REF_SYS& & & & & & & & & & & & & & & & & & & & & & &
TABLENON_AWR& & & &
2.0 XDB.XDB$ELEMENT& & & & & & & & & & & & & & & & & & & & & & & & & & &
TABLENON_AWR& & & &
1.2 SYS.SYS_LOBC00004$$& & & & & & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & &
1.1 SYS.SYS_LOBC00004$$& & & & & & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & &
1.0 SYS.WRI$_ADV_RATIONALE& & & & & & & & & & & & & & & & & & & & & & & & TABLENON_AWR& & & &
1.0 SYS.SYS_LOBC00040$$& & & & & & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & &
1.0 XDB.XDB$H_LINK& & & & & & & & & & & & & & & & & & & & & & & & & & & & TABLENON_AWR& & & &
1.0 SYS.SYS$SERVICE_METRICS_TAB& & & & & & & & & & & & & & & & & & & & &
TABLENON_AWR& & & &
0.9 SYSMAN.MGMT_METRICS_PK& & & & & & & & & & & & & & & & & & & & & & & & INDEXNON_AWR& & & &
0.9 SYSMAN.MGMT_METRICS_IDX_01& & & & & & & & & & & & & & & & & & & & & & INDEXNON_AWR& & & &
0.9 APEX_030200.WWV_FLOW_STEPS& & & & & & & & & & & & & & & & & & & & & & TABLENON_AWR& & & &
0.9 SYSMAN.MGMT_METRICS_IDX_03& & & & & & & & & & & & & & & & & & & & & & INDEXNON_AWR& & & &
0.9 SYS.I_WRI$_OPTSTAT_HH_ST& & & & & & & & & & & & & & & & & & & & & & & INDEXNON_AWR& & & &
0.8 APEX_030200.WWV_FLOW_STEP_VALIDATIONS& & & & & & & & & & & & & & & &
　　COMPONENT& & & & MB SEGMENT_NAME& & & & & & & & & & & & & & & & & & & & & & & & & & & & & SEGMENT_TYPE--------- --------- --------------------------------------------------------------------- ---------------NON_AWR& & & &
0.8 XDB.XDB$RESOURCE_ACLOID_IDX& & & & & & & & & & & & & & & & & & & & &
INDEXNON_AWR& & & &
0.8 APEX_030200.WWV_FLOW_LIST_ITEMS& & & & & & & & & & & & & & & & & & &
TABLENON_AWR& & & &
0.6 SYS.SCHEDULER$_EVENT_LOG& & & & & & & & & & & & & & & & & & & & & & & TABLENON_AWR& & & &
0.6 APEX_030200.WWV_FLOW_STEP_ITEMS_U_NAME& & & & & & & & & & & & & & & & INDEXNON_AWR& & & &
0.6 XDB.XDB_PK_H_LINK& & & & & & & & & & & & & & & & & & & & & & & & & &
INDEXNON_AWR& & & &
0.6 APEX_030200.WWV_FLOW_STEP_BRANCHES& & & & & & & & & & & & & & & & & & TABLENON_AWR& & & &
0.6 APEX_030200.WWV_FLOW_STEP_BUTTONS& & & & & & & & & & & & & & & & & &
TABLENON_AWR& & & &
0.6 SYSMAN.MGMT_IP_REPORT_ELEM_PARAMS& & & & & & & & & & & & & & & & & &
TABLENON_AWR& & & &
0.6 SYSMAN.MGMT_JOB_STEP_PARAMS& & & & & & & & & & & & & & & & & & & & &
TABLENON_AWR& & & &
0.6 XDB.XDB$COMPLEX_TYPE& & & & & & & & & & & & & & & & & & & & & & & & & TABLENON_AWR& & & &
0.6 SYSMAN.MGMT_POLICIES& & & & & & & & & & & & & & & & & & & & & & & & & TABLENON_AWR& & & &
0.6 ORDDATA.SYS_LOBC00005$$& & & & & & & & & & & & & & & & & &
LOBSEGMENTNON_AWR& & & &
0.6 SYSMAN.PK_MGMT_JOB_STEP_PARAMS& & & & & & & & & & & & & & & & & & & & INDEXNON_AWR& & & &
0.6 SYS.WRI$_ADV_PARAMETERS_PK& & & & & & & & & & & & & & & & & & & & & & INDEXNON_AWR& & & &
0.5 SYS.AW_OBJ$& & & & & & & & & & & & & & & & & & & & & & & & & & & & &
TABLENON_AWR& & & &
0.5 APEX_030200.WWV_FLOW_LIST_OF_VALUES_DATA& & & & & & & & & & & & & & & TABLENON_AWR& & & &
0.5 SYSMAN.SYS_LOBC00004$$& & & & & & & & & & & & & & & & & & & LOBSEGMENT
　　**********************************(5a) AWR snapshots - last 50**********************************
　　Total snapshots in DB
Instance 1 = 23
　　DBID& & SNAP_ID& INST FLUSH_ELAPSED& & & & ENDTM& & & & & &
STARTUP_TIME& & & STATUS ERRCNT---------- ---------- ----- -------------------- ----------------- ----------------- ------ ------&& & & & 544& &
1 +:04.2& & 08:00:21 (11/25)& 06:25:05 (11/21)& & &
0& & & 0&& & & & 545& &
1 +:04.2& & 09:00:31 (11/25)& 06:25:05 (11/21)& & &
0& & & 0&& & & & 546& &
1 +:04.4& & 10:00:42 (11/25)& 06:25:05 (11/21)& & &
0& & & 0&& & & & 547& &
1 +:18.4& & 00:50:45 (11/26)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 548& &
1 +:05.5& & 02:00:52 (11/26)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 549& &
1 +:04.7& & 03:00:57 (11/26)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 550& &
1 +:03.9& & 04:00:02 (11/26)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 551& &
1 +:04.9& & 05:00:30 (11/26)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 552& &
1 +:04.7& & 06:00:33 (11/26)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 553& &
1 +:05.5& & 07:00:40 (11/26)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 554& &
1 +:04.6& & 08:00:45 (11/26)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 555& &
1 +:04.3& & 09:00:51 (11/26)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 556& &
1 +:06.5& & 04:28:55 (11/29)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 557& &
1 +:09.4& & 05:00:01 (11/29)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 558& &
1 +:04.3& & 06:00:07 (11/29)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 559& &
1 +:03.1& & 07:00:11 (11/29)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 560& &
1 +:02.5& & 08:00:15 (11/29)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 561& &
1 +:02.8& & 09:00:19 (11/29)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 562& &
1 +:01.1& & 22:41:06 (12/01)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 563& &
1 +:22.1& & 07:10:16 (12/03)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 564& &
1 +:06.1& & 08:00:23 (12/03)& 00:39:23 (11/26)& & &
0& & & 0&& & & & 565& &
1 +:20.7& & 09:00:57 (12/03)& 08:17:27 (12/03)& & &
0& & & 0&& & & & 566& &
1 +:12.2& & 06:49:54 (12/04)& 08:17:27 (12/03)& & &
　　**********************************(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---------- ----- ---------- ----------------- ------ -----------&& &
1& & & & 544 08:00:21 (11/25)& & &
0& & & & &
　　**********************************(6) AWR Control Settings - interval, retention**********************************
　　DBID& LSNAPID LSPLITID LSNAPTIME& & & LPURGETIME& & & FLAG INTERVAL& & & & & RETENTION& & & &
VRSN----------- -------- -------- -------------- -------------- ----- ----------------- ----------------- ----& & & & 566& & & 556 12/04 06:50:07 12/03 07:32:00& &
2 +:00.0 +:00.0& & 4
　　**********************************(7a) AWR Contents - row counts for each snapshots**********************************
　　SNAP_ID& INST& & & & ASH& & & & SQL& & & SQBND& & & FILES& & & SEGST& &
SYSEVT---------- ----- ---------- ---------- ---------- ---------- ---------- ----------& & &
1& & & & & 6& & & & 193& & & & 586& & & & & 7& & & & 173& & & &
13& & & & 203& & & & 620& & & & & 7& & & & 173& & & &
34& & & & 295& & & & 886& & & & & 7& & & & 195& & & &
1& & & & 120& & & & 316& & & & 864& & & & & 7& & & & 121& & & &
16& & & & 194& & & & 589& & & & & 7& & & & 130& & & &
10& & & & 194& & & & 594& & & & & 7& & & & 125& & & &
1& & & & & 3& & & & 182& & & & 592& & & & & 7& & & & 122& & & &
1& & & & & 6& & & & 178& & & & 566& & & & & 7& & & & 120& & & &
1& & & & & 5& & & & 210& & & & 572& & & & & 7& & & & 133& & & &
14& & & & 175& & & & 546& & & & & 7& & & & 126& & & &
11& & & & 173& & & & 564& & & & & 7& & & & 121& & & &
1& & & & & 9& & & & 204& & & & 593& & & & & 7& & & & 133& & & &
11& & & & 197& & & & 609& & & & & 7& & & & 134& & & &
17& & & & 263& & &
1014& & & & & 7& & & & 191& & & &
10& & & & 203& & & & 610& & & & & 7& & & & 187& & & &
1& & & & & 3& & & & 181& & & & 568& & & & & 7& & & & 168& & & &
1& & & & & 4& & & & 179& & & & 593& & & & & 7& & & & 149& & & &
1& & & & & 4& & & & 178& & & & 578& & & & & 7& & & & 160& & & &
1& & & & & 7& & & & 271& & & & 802& & & & & 7& & & & 157& & & &
1& & & & 123& & & & 299& & & & 922& & & & & 7& & & & 208& & & &
13& & & & 236& & & & 798& & & & & 7& & & & 193& & & &
29& & & & 294& & & & 550& & & & & 7& & & & 103& & & &
1& & & & & 4& & & & 207& & & & 573& & & & & 7& & & & 129& & & &
　　**********************************(7b) AWR Contents - average row counts per snapshot**********************************
　　SNAP_COUNT& INST& & & & ASH& & SQLSTAT& & SQLBIND& & & FILES& & SEGSTAT&
SYSEVENT---------- ----- ---------- ---------- ---------- ---------- ---------- ----------& & & & 23& &
1& & & 20.52& &
660.39& & & & & 7& &
150.04& & & 83.43
　　**********************************(7c) AWR total item counts - names, text, plans**********************************
　　SQLTEXT& & SQLPLAN&
SQLBMETA& &
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& COMPLETEDSYS/ADDM& & &
760/ADDM:_521& & & &
04:00:18 (11/22)& & & & & 1& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
761/ADDM:_522& & & &
05:00:20 (11/22)& & & & & 1& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
762/ADDM:_523& & & &
06:00:30 (11/22)& & & & & 1& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
763/ADDM:_524& & & &
07:00:30 (11/22)& & & & & 0& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
764/ADDM:_525& & & &
08:00:35 (11/22)& & & & & 0& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
765/ADDM:_526& & & &
09:00:41 (11/22)& & & & & 0& & & & & 0 AUTO& COMPLETEDSYS/ADDM& & &
766/ADDM:_527& & & &
10:00:56 (11/22)& & & & & 1& & & & & 2 AUTO& COMPLETEDSYS/ADDM& & &
767/ADDM:_528& & & &
23:51:30 (11/22)& & & & & 2& & & & & 4 AUTO& COMPLETEDSYS/Segment Ad 768/SYS_AUTO_SPCADV_ 23:52:12 (11/22)& & & &
FATAL ERROR& & & & & & &
　　SYS/ADDM& & &
769/ADDM:_529& & & &
01:01:05 (11/23)& & & & & 4& & & & & 4 AUTO& COMPLETEDSYS/ADDM& & &
770/ADDM:_530& & & &
02:00:19 (11/23)& & & & & 1& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
771/ADDM:_531& & & &
03:00:28 (11/23)& & & & & 1& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
772/ADDM:_532& & & &
04:00:34 (11/23)& & & & & 1& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
773/ADDM:_533& & & &
05:00:49 (11/23)& & & & & 0& & & & & 0 AUTO& COMPLETEDSYS/Segment Ad 774/SYS_AUTO_SPCADV_ 06:00:38 (11/23)& & & &
FATAL ERROR& & & & & & &
　　SYS/ADDM& & &
775/ADDM:_534& & & &
06:01:49 (11/23)& & & & & 4& & & & & 4 AUTO& COMPLETEDSYS/ADDM& & &
776/ADDM:_535& & & &
07:00:20 (11/23)& & & & & 2& & & & & 2 AUTO& COMPLETEDSYS/ADDM& & &
777/ADDM:_536& & & &
08:00:23 (11/23)& & & & & 0& & & & & 0 AUTO& COMPLETEDSYS/ADDM& & &
778/ADDM:_537& & & &
09:00:30 (11/23)& & & & & 2& & & & & 3 AUTO& COMPLETEDSYS/ADDM& & &
779/ADDM:_538& & & &
10:00:37 (11/23)& & & & & 1& & & & & 1 AUTO& COMPLETEDSYS/Segment Ad 780/SYS_AUTO_SPCADV_ 10:09:16 (11/23)& & & &
FATAL ERROR& & & & & & &
　　SYS/ADDM& & &
781/ADDM:_539& & & &
03:02:46 (11/25)& & & &
17 AUTO& COMPLETEDSYS/ADDM& & &
782/ADDM:_540& & & &
04:00:24 (11/25)& & & & & 1& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
783/ADDM:_541& & & &
05:00:42 (11/25)& & & & & 0& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
784/ADDM:_542& & & &
06:01:02 (11/25)& & & & & 0& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
785/ADDM:_543& & & &
07:00:17 (11/25)& & & & & 1& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
786/ADDM:_544& & & &
08:00:26 (11/25)& & & & & 1& & & & & 2 AUTO& COMPLETEDSYS/ADDM& & &
787/ADDM:_545& & & &
09:00:37 (11/25)& & & & & 0& & & & & 2 AUTO& COMPLETEDSYS/ADDM& & &
788/ADDM:_546& & & &
10:00:47 (11/25)& & & & & 0& & & & & 1 AUTO& COMPLETEDSYS/Segment Ad 789/SYS_AUTO_SPCADV_ 00:42:58 (11/26)& & & &
FATAL ERROR& & & & & & &
　　SYS/ADDM& & &
790/ADDM:_548& & & &
02:01:00 (11/26)& & & & & 2& & & & & 3 AUTO& COMPLETEDSYS/ADDM& & &
791/ADDM:_549& & & &
03:01:02 (11/26)& & & & & 0& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
792/ADDM:_550& & & &
04:00:06 (11/26)& & & & & 0& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
793/ADDM:_551& & & &
05:00:35 (11/26)& & & & & 1& & & & & 2 AUTO& COMPLETEDSYS/ADDM& & &
794/ADDM:_552& & & &
06:00:39 (11/26)& & & & & 1& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
795/ADDM:_553& & & &
07:00:47 (11/26)& & & & & 1& & & & & 2 AUTO& COMPLETEDSYS/ADDM& & &
796/ADDM:_554& & & &
08:00:51 (11/26)& & & & & 0& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
797/ADDM:_555& & & &
09:00:57 (11/26)& & & & & 1& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
798/ADDM:_556& & & &
04:29:03 (11/29)& & & & & 1& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
799/ADDM:_557& & & &
05:00:13 (11/29)& & & & & 1& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
800/ADDM:_558& & & &
06:00:13 (11/29)& & & & & 1& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
801/ADDM:_559& & & &
07:00:16 (11/29)& & & & & 0& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
802/ADDM:_560& & & &
08:00:19 (11/29)& & & & & 0& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
803/ADDM:_561& & & &
09:00:23 (11/29)& & & & & 0& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
804/ADDM:_562& & & &
22:42:24 (12/01)& & & & & 9& & & &
10 AUTO& COMPLETEDSYS/Segment Ad 805/SYS_AUTO_SPCADV_ 22:42:33 (12/01)& & & &
FATAL ERROR& & & & & & &
　　SYS/ADDM& & &
809/ADDM:_563& & & &
07:10:44 (12/03)& & & & & 3& & & & & 3 AUTO& COMPLETEDSYS/ADDM& & &
810/ADDM:_564& & & &
08:00:31 (12/03)& & & & & 1& & & & & 2 AUTO& COMPLETEDSYS/ADDM& & &
819/ADDM:_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:_444& & & &
07:04:26 (11/12)& & & & & 0& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
616/ADDM:_446& & & &
09:00:43 (11/12)& & & & & 2& & & & & 3 AUTO& COMPLETEDSYS/ADDM& & &
617/ADDM:_447& & & &
20:12:24 (11/12)& & & & & 1& & & & & 2 AUTO& COMPLETEDSYS/ADDM& & &
618/ADDM:_448& & & &
21:00:38 (11/12)& & & & & 1& & & & & 1 AUTO& COMPLETEDSYS/ADDM& & &
620/ADDM:_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_ 22:00:36 (11/12)& & & &
FATAL ERROR& & & & & & &
13Description: Auto Space Advisor for tablespaceError Msg& : ORA-00376: file& cannot be read at this time
　　SYS/Segment Ad 656/SYS_AUTO_SPCADV_ 22:00:52 (11/14)& & & &
FATAL ERROR& & & & & & &
13Description: Auto Space Advisor for tablespaceError Msg& : ORA-00376: file& cannot be read at this time
　　SYS/Segment Ad 669/SYS_AUTO_SPCADV_ 01:24:11 (11/17)& & & &
FATAL ERROR& & & & & & &
13Description: Auto Space Advisor for tablespaceError Msg& : ORA-00376: file& cannot be read at this time
　　SYS/Segment Ad 674/SYS_AUTO_SPCADV_ 06:00:25 (11/17)& & & &
FATAL ERROR& & & & & & &
13Description: Auto Space Advisor for tablespaceError Msg& : ORA-00376: file& cannot be read at this time
　　SYS/Segment Ad 679/SYS_AUTO_SPCADV_ 00:00:55 (11/19)& & & &
FATAL ERROR& & & & & & &
13Description: Auto Space Advisor for tablespaceError Msg& : ORA-00376: file& cannot be read at this time
　　SYS/Segment Ad 693/SYS_AUTO_SPCADV_ 22:00:29 (11/19)& & & &
FATAL ERROR& & & & & & &
13Description: Auto Space Advisor for tablespaceError Msg& : ORA-00376: file& cannot be read at this time
　　SYS/Segment Ad 719/SYS_AUTO_SPCADV_ 00:13:55 (11/21)& & & &
FATAL ERROR& & & & & & &
13Description: Auto Space Advisor for tablespaceError Msg& : ORA-00376: file& cannot be read at this time
　　SYS/Segment Ad 745/SYS_AUTO_SPCADV_ 22:00:59 (11/21)& & & &
FATAL ERROR& & & & & & &
13Description: Auto Space Advisor for tablespaceError Msg& : ORA-00376: file& cannot be read at this time
　　SYS/Segment Ad 768/SYS_AUTO_SPCADV_ 23:52:12 (11/22)& & & &
FATAL ERROR& & & & & & &
13Description: Auto Space Advisor for tablespaceError Msg& : ORA-00376: file& cannot be read at this time
　　SYS/Segment Ad 774/SYS_AUTO_SPCADV_ 06:00:38 (11/23)& & & &
FATAL ERROR& & & & & & &
13Description: Auto Space Advisor for tablespaceError Msg& : ORA-00376: file& cannot be read at this time
　　SYS/Segment Ad 780/SYS_AUTO_SPCADV_ 10:09:16 (11/23)& & & &
FATAL ERROR& & & & & & &
13Description: Auto Space Advisor for tablespaceError Msg& : ORA-00376: file& cannot be read at this time
　　SYS/Segment Ad 789/SYS_AUTO_SPCADV_ 00:42:58 (11/26)& & & &
FATAL ERROR& & & & & & &
13Description: Auto Space Advisor for tablespaceError Msg& : ORA-00376: file& cannot be read at this time
　　SYS/Segment Ad 805/SYS_AUTO_SPCADV_ 22:42:33 (12/01)& & & &
FATAL ERROR& & & & & & &
13Description: Auto Space Advisor for tablespaceError 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& & & & & & & & & & 600005 - 0009& & & & & & & & & &
　　**********************************(1b) ASH histogram (past 1 day)**********************************
　　NUM_ACTIVE_SESSIONS&
NUM_SAMPLES-------------------- ------------0000 - 0004& & & & & & & & & & 250005 - 0009& & & & & & & & & &
　　**********************************(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& & &
　　**********************************(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& & & & &
　　**********************************(2c) ASH sessions (Fg Vs Bg) (past 1 day across all instances in RAC)**********************************
　　Foreground %& & & & &
21.4Background %& & & & &
78.6MMNL %& & & & & & & & & 0.0
　　End of ReportReport written to awrinfo.txt
H3C认证Java认证Oracle认证
基础英语软考英语项目管理英语职场英语
.NETPowerBuilderWeb开发游戏开发Perl
二级模拟试题一级模拟试题一级考试经验四级考试资料
港口与航道工程建设工程法规及相关知识建设工程经济考试大纲矿业工程市政公用工程通信与广电工程
操作系统汇编语言计算机系统结构人工智能数据库系统微机与接口
软件测试软件外包系统分析与建模敏捷开发
法律法规历年试题软考英语网络管理员系统架构设计师信息系统监理师
高级通信工程师考试大纲设备环境综合能力
路由技术网络存储无线网络网络设备
CPMP考试prince2认证项目范围管理项目配置管理项目管理案例项目经理项目干系人管理
Powerpoint教程WPS教程
电子政务客户关系管理首席信息官办公自动化大数据
职称考试题目
就业指导签约违约职业测评
招生信息考研政治
网络安全安全设置工具使用手机安全
3DMax教程Flash教程CorelDraw教程Director教程
Dreamwaver教程HTML教程网站策划网站运营Frontpage教程
生物识别传感器物联网传输层物联网前沿技术物联网案例分析
互联网电信IT业界IT生活
Java核心技术J2ME教程
Linux系统管理Linux编程Linux安全AIX教程
Windows系统管理Windows教程Windows网络管理Windows故障
组织运营财务资本
视频播放文件压缩杀毒软件输入法微博
数据库开发Sybase数据库Informix数据库
&&&&&&&&&&&&&&&
希赛网 版权所有 & &&