— awrinfo.sql – Output

Ein exemplarischer Output von „awrinfo.sql“

~~~~~~~~~~~~~~~
AWR INFO Report
~~~~~~~~~~~~~~~

Report generated at
08:44:09 on Sep 07, 2017 ( Thursday ) in Timezone +02: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
———— ——— —————————————- —– —————– ———— —
* 3446032964 DBP dbp18 – Solaris[tm] OE (64-bit) 1 12:22:58 (07/23) 11601406 NO

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

*****************************************************
(1a) SYSAUX usage – Schema breakdown (dba_segments)
*****************************************************
|
| Total SYSAUX size 1,226.0 MB ( 31% of 3,999.0 MB MAX with AUTOEXTEND OFF )
|
| Schema SYS occupies 935.8 MB ( 76.3% )
| Schema XDB occupies 129.1 MB ( 10.5% )
| Schema MDSYS occupies 75.1 MB ( 6.1% )
| Schema ORDDATA occupies 29.6 MB ( 2.4% )
| Schema SYSTEM occupies 26.2 MB ( 2.1% )
| Schema WMSYS occupies 14.4 MB ( 1.2% )
| Schema CTXSYS occupies 7.6 MB ( 0.6% )
| Schema AUDSYS occupies 3.1 MB ( 0.2% )
| Schema GSMADMIN_INT occupies 2.8 MB ( 0.2% )
| Schema DBSNMP occupies 1.5 MB ( 0.1% )
| Schema ORDSYS occupies 0.9 MB ( 0.1% )
|
********************************************************
(1b) SYSAUX occupants space usage (v$sysaux_occupants)
********************************************************
|
| Occupant Name Schema Name Space Usage
| ——————– ——————– —————-
| SM/AWR SYS 388.9 MB
| SM/OPTSTAT SYS 274.5 MB
| XDB XDB 129.1 MB
| SDO MDSYS 75.1 MB
| SM/OTHER SYS 61.4 MB
| SM/ADVISOR SYS 31.4 MB
| ORDIM/ORDDATA ORDDATA 29.6 MB
| SMON_SCN_TIME SYS 22.8 MB
| LOGMNR SYSTEM 22.3 MB
| WM WMSYS 14.4 MB
| TEXT CTXSYS 7.6 MB
| SQL_MANAGEMENT_BASE SYS 4.9 MB
| AO SYS 3.9 MB
| XSOQHIST SYS 3.9 MB
| AUDSYS AUDSYS 3.1 MB
| LOGSTDBY SYSTEM 3.0 MB
| JOB_SCHEDULER SYS 2.3 MB
| STREAMS SYS 2.0 MB
| PL/SCOPE SYS 1.6 MB
| EM_MONITORING_USER DBSNMP 1.5 MB
| ORDIM ORDSYS 0.9 MB
| AUTO_TASK SYS 0.6 MB
| AUDIT_TABLES SYS 0.0 MB
| EM SYSMAN 0.0 MB
| EXPRESSION_FILTER EXFSYS 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
| XSAMD OLAPSYS 0.0 MB
|
| Others (Unaccounted space) 141.4 MB
|

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

| This section displays schemas that are not registered
| in V$SYSAUX_OCCUPANTS
|
| Schema GSMADMIN_INT occupies 2.8 MB
|
| Total space 2.8 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 138.6 MB
|
| Total space 138.6 MB
|
*************************************
(2) Size estimates for AWR snapshots
*************************************
|
| Estimates based on 60 mins snapshot INTERVAL:
| AWR size/day 46.7 MB (1,991 K/snap * 24 snaps/day)
| AWR size/wk 326.7 MB (size_per_day * 7) per instance
|
| Estimates based on 24 snaps in past 24 hours:
| AWR size/day 46.7 MB (1,991 K/snap and 24 snaps in past 24 hours)
| AWR size/wk 326.7 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 220.6 56.7 1,130 26.5 185.3 49% : 51%
EVENTS 59.7 15.3 306 7.2 50.1 41% : 59%
SQL 23.9 6.2 123 2.9 20.1 73% : 27%
ASH 21.6 5.6 111 2.6 18.2 87% : 13%
SPACE 17.8 4.6 91 2.1 14.9 54% : 46%
SQLPLAN 15.0 3.9 77 1.8 12.6 67% : 33%
SQLTEXT 2.1 0.5 11 0.3 1.8 94% : 6%
RAC 1.3 0.3 6 0.2 1.1 50% : 50%
SQLBIND 0.8 0.2 4 0.1 0.7 54% : 46%

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

COMPONENT MB SEGMENT_NAME – % SPACE_USED SEGMENT_TYPE
——— ——— ——————————————————————— —————
FIXED 23.0 WRH$_SYSMETRIC_HISTORY_INDEX – 65% INDEX
FIXED 19.0 WRH$_SYSMETRIC_HISTORY – 89% TABLE
FIXED 5.0 WRH$_SYSMETRIC_SUMMARY – 59% TABLE
FIXED 2.0 WRH$_LATCH_PK.WRH$_LATCH_3446032964_3035 – 58% INDEX PARTITION
FIXED 2.0 WRH$_LATCH.WRH$_LATCH_3446032964_3203 – 54% TABLE PARTITION
FIXED 2.0 WRH$_LATCH.WRH$_LATCH_3446032964_3179 – 55% TABLE PARTITION
FIXED 2.0 WRH$_LATCH.WRH$_LATCH_3446032964_3155 – 54% TABLE PARTITION
FIXED 2.0 WRH$_LATCH.WRH$_LATCH_3446032964_3131 – 55% TABLE PARTITION
FIXED 2.0 WRH$_LATCH.WRH$_LATCH_3446032964_3107 – 55% TABLE PARTITION
FIXED 2.0 WRH$_SYSSTAT.WRH$_SYSSTA_3446032964_3203 – 50% TABLE PARTITION
FIXED 2.0 WRH$_SYSSTAT.WRH$_SYSSTA_3446032964_3179 – 50% TABLE PARTITION
FIXED 2.0 WRH$_SYSSTAT.WRH$_SYSSTA_3446032964_3155 – 50% TABLE PARTITION
FIXED 2.0 WRH$_SYSSTAT.WRH$_SYSSTA_3446032964_3131 – 50% TABLE PARTITION
FIXED 2.0 WRH$_SYSSTAT.WRH$_SYSSTA_3446032964_3107 – 50% TABLE PARTITION
FIXED 2.0 WRH$_SYSSTAT.WRH$_SYSSTA_3446032964_3083 – 50% TABLE PARTITION
FIXED 2.0 WRH$_SYSSTAT.WRH$_SYSSTA_3446032964_3059 – 50% TABLE PARTITION
FIXED 2.0 WRH$_SYSSTAT.WRH$_SYSSTA_3446032964_3035 – 50% TABLE PARTITION
FIXED 2.0 WRH$_SYSMETRIC_SUMMARY_INDEX – 65% INDEX
FIXED 2.0 WRH$_RSRC_CONSUMER_GROUP – 55% TABLE
FIXED 2.0 WRH$_MUTEX_SLEEP_PK – 68% INDEX
FIXED 2.0 WRH$_LATCH_PK.WRH$_LATCH_3446032964_3203 – 58% INDEX PARTITION
FIXED 2.0 WRH$_LATCH_PK.WRH$_LATCH_3446032964_3179 – 71% INDEX PARTITION
FIXED 2.0 WRH$_LATCH_PK.WRH$_LATCH_3446032964_3155 – 58% INDEX PARTITION
FIXED 2.0 WRH$_LATCH_PK.WRH$_LATCH_3446032964_3131 – 59% INDEX PARTITION
FIXED 2.0 WRH$_LATCH.WRH$_LATCH_3446032964_3035 – 54% TABLE PARTITION
FIXED 2.0 WRH$_LATCH.WRH$_LATCH_3446032964_3059 – 54% TABLE PARTITION
FIXED 2.0 WRH$_LATCH_PK.WRH$_LATCH_3446032964_3059 – 58% INDEX PARTITION
FIXED 2.0 WRH$_LATCH.WRH$_LATCH_3446032964_3083 – 54% TABLE PARTITION
FIXED 2.0 WRH$_LATCH_PK.WRH$_LATCH_3446032964_3107 – 58% INDEX PARTITION
FIXED 2.0 WRH$_LATCH_PK.WRH$_LATCH_3446032964_3083 – 58% INDEX PARTITION
EVENTS 3.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__3446032964_3203 – 61% INDEX PARTITION
EVENTS 3.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__3446032964_3179 – 69% INDEX PARTITION
EVENTS 3.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__3446032964_3155 – 61% INDEX PARTITION
EVENTS 3.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__3446032964_3131 – 70% INDEX PARTITION
EVENTS 3.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__3446032964_3107 – 69% INDEX PARTITION
EVENTS 3.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__3446032964_3083 – 69% INDEX PARTITION
EVENTS 3.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__3446032964_3059 – 61% INDEX PARTITION
EVENTS 3.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__3446032964_3035 – 61% INDEX PARTITION
EVENTS 3.0 WRH$_BG_EVENT_SUMMARY_PK – 42% INDEX
EVENTS 3.0 WRH$_ENQUEUE_STAT_PK – 43% INDEX
EVENTS 2.0 WRH$_BG_EVENT_SUMMARY – 60% TABLE
EVENTS 2.0 WRH$_ENQUEUE_STAT – 65% TABLE
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__3446032964_3155 – 63% TABLE PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__3446032964_3203 – 63% TABLE PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__3446032964_3179 – 63% TABLE PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__3446032964_3035 – 62% TABLE PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__3446032964_3131 – 63% TABLE PARTITION

COMPONENT MB SEGMENT_NAME – % SPACE_USED SEGMENT_TYPE
——— ——— ——————————————————————— —————
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__3446032964_3107 – 62% TABLE PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__3446032964_3083 – 62% TABLE PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__3446032964_3059 – 62% TABLE PARTITION
EVENTS 0.8 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__3446032964_3227 – 65% INDEX PARTITION
EVENTS 0.6 WRH$_LIBRARYCACHE_PK – 45% INDEX
EVENTS 0.6 WRH$_LIBRARYCACHE – 74% TABLE
EVENTS 0.5 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__3446032964_3227 – 83% TABLE PARTITION
SQL 2.0 WRH$_SQLSTAT.WRH$_SQLSTA_3446032964_3059 – 47% TABLE PARTITION
SQL 2.0 WRH$_SQLSTAT.WRH$_SQLSTA_3446032964_3107 – 49% TABLE PARTITION
SQL 2.0 WRH$_SQLSTAT.WRH$_SQLSTA_3446032964_3131 – 50% TABLE PARTITION
SQL 2.0 WRH$_SQLSTAT.WRH$_SQLSTA_3446032964_3155 – 49% TABLE PARTITION
SQL 2.0 WRH$_SQLSTAT.WRH$_SQLSTA_3446032964_3179 – 47% TABLE PARTITION
SQL 2.0 WRH$_SQLSTAT.WRH$_SQLSTA_3446032964_3035 – 47% TABLE PARTITION
SQL 2.0 WRH$_SQLSTAT.WRH$_SQLSTA_3446032964_3203 – 48% TABLE PARTITION
SQL 2.0 WRH$_SQLSTAT.WRH$_SQLSTA_3446032964_3083 – 51% TABLE PARTITION
ASH 4.0 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_3446032964_3083 – 82% TABLE PARTITION
ASH 2.0 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_3446032964_3035 – 68% TABLE PARTITION
ASH 2.0 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_3446032964_3059 – 81% TABLE PARTITION
ASH 2.0 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_3446032964_3107 – 53% TABLE PARTITION
ASH 2.0 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_3446032964_3131 – 79% TABLE PARTITION
ASH 2.0 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_3446032964_3155 – 46% TABLE PARTITION
ASH 2.0 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_3446032964_3179 – 53% TABLE PARTITION
ASH 2.0 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_3446032964_3203 – 77% TABLE PARTITION
ASH 0.5 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_3446032964_3227 – 73% TABLE PARTITION
ASH 0.5 WRH$_ACTIVE_SESSION_HISTORY_PK.WRH$_ACTIVE_3446032964_3083 – 83% INDEX PARTITION
SQLPLAN 10.0 WRH$_SQL_PLAN – 55% TABLE
SQLPLAN 5.0 WRH$_SQL_PLAN_PK – 36% INDEX
SQLTEXT 2.0 WRH$_SQLTEXT – 55% TABLE

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

COMPONENT MB SEGMENT_NAME SEGMENT_TYPE
——— ——— ——————————————————————— —————
NON_AWR 104.0 SYS.I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX
NON_AWR 48.0 SYS.I_WRI$_OPTSTAT_H_ST INDEX
NON_AWR 42.3 SYS.SYS_LOB0000006420C00005$$ LOBSEGMENT
NON_AWR 40.0 SYS.HEATMAP SYSTEM STATISTI
CS

NON_AWR 36.3 MDSYS.SYS_LOB0000084168C00006$$ LOBSEGMENT
NON_AWR 22.0 SYS.SMON_SCN_TO_TIME_AUX CLUSTER
NON_AWR 19.3 SYS.SYS_LOB0000008311C00038$$ LOBSEGMENT
NON_AWR 9.0 SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST INDEX
NON_AWR 9.0 MDSYS.SDO_CS_SRS TABLE
NON_AWR 6.3 SYS.SYS_LOB0000010987C00001$$ LOBSEGMENT
NON_AWR 6.3 SYS.SYS_LOB0000008303C00004$$ LOBSEGMENT
NON_AWR 5.0 SYS.I_WRI$_OPTSTAT_HH_ST INDEX
NON_AWR 4.3 SYS.SYS_LOB0000006420C00004$$ LOBSEGMENT
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2244 TABLE PARTITION
NON_AWR 4.0 SYSTEM.SYS_LOB0000001339C00009$$ LOBSEGMENT
NON_AWR 4.0 SYS.WRI$_OPTSTAT_OPR_TASKS TABLE
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2088 TABLE PARTITION
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2103 TABLE PARTITION
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2263 TABLE PARTITION
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1748 TABLE PARTITION
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1943 TABLE PARTITION
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1924 TABLE PARTITION
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1732 TABLE PARTITION
NON_AWR 3.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1603 TABLE PARTITION
NON_AWR 3.0 SYS.I_WRI$_OPTSTAT_OPR_TASKS_TGST INDEX
NON_AWR 3.0 SYS.WRI$_ADV_PARAMETERS TABLE
NON_AWR 3.0 SYS.WRI$_ADV_PARAMETERS_PK INDEX
NON_AWR 2.3 SYS.SYS_LOB0000008105C00008$$ LOBSEGMENT
NON_AWR 2.3 MDSYS.SYS_LOB0000084734C00003$$ LOBSEGMENT
NON_AWR 2.3 ORDDATA.SYS_LOB0000078166C00005$$ LOBSEGMENT
NON_AWR 2.3 ORDDATA.SYS_LOB0000078349C00005$$ LOBSEGMENT
NON_AWR 2.3 AUDSYS.SYS_LOB0000086040C00014$$.SYS_LOB_P241 LOB PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2223 TABLE PARTITION
NON_AWR 2.0 MDSYS.SDO_COORD_REF_SYS TABLE
NON_AWR 2.0 SYS.WRI$_ADV_ACTIONS TABLE
NON_AWR 2.0 SYS.WRI$_ADV_MESSAGE_GROUPS TABLE
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1783 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2083 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1883 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1843 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2003 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2023 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1723 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2183 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1643 TABLE PARTITION

COMPONENT MB SEGMENT_NAME SEGMENT_TYPE
——— ——— ——————————————————————— —————
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1703 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2383 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2143 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1903 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2063 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2303 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1663 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1823 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2343 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2163 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P2203 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1983 TABLE PARTITION
NON_AWR 1.3 SYS.SYS_LOB0000006449C00009$$.SYS_LOB_P2206 LOB PARTITION
NON_AWR 1.3 XDB.SYS_LOB0000019044C00023$$ LOBSEGMENT
NON_AWR 1.3 XDB.SYS_LOB0000019098C00025$$ LOBSEGMENT
NON_AWR 1.3 SYS.SYS_LOB0000006449C00009$$.SYS_LOB_P2186 LOB PARTITION
NON_AWR 1.3 SYS.SYS_LOB0000006449C00009$$.SYS_LOB_P2166 LOB PARTITION
NON_AWR 1.3 SYS.SYS_LOB0000006449C00009$$.SYS_LOB_P2247 LOB PARTITION
NON_AWR 1.3 SYS.SYS_LOB0000006449C00009$$.SYS_LOB_P2322 LOB PARTITION
NON_AWR 1.3 SYS.SYS_LOB0000006449C00009$$.SYS_LOB_P2362 LOB PARTITION
NON_AWR 1.3 SYS.SYS_LOB0000006449C00009$$.SYS_LOB_P2266 LOB PARTITION
NON_AWR 1.3 SYS.SYS_LOB0000006449C00009$$.SYS_LOB_P2386 LOB PARTITION
NON_AWR 1.3 SYS.SYS_LOB0000006449C00009$$.SYS_LOB_P2282 LOB PARTITION
NON_AWR 1.0 SYS.SYS$SERVICE_METRICS_TAB TABLE
NON_AWR 1.0 XDB.XDB$ELEMENT TABLE
NON_AWR 1.0 SYS.WRI$_ADV_RATIONALE TABLE
NON_AWR 1.0 SYS.WRI$_ADV_MSG_GRPS_IDX_01 INDEX
NON_AWR 1.0 SYS.LTXID_TRANS.LTXID_TRANS_1 TABLE PARTITION
NON_AWR 0.9 SYS.SCHEDULER$_EVENT_LOG TABLE
NON_AWR 0.9 SYS.I_WRI$_OPTSTAT_OPR_TASKS_OPOBJ INDEX
NON_AWR 0.9 SYS.WRI$_ADV_MESSAGE_GROUPS_PK INDEX
NON_AWR 0.9 XDB.XDB$H_INDEX TABLE
NON_AWR 0.8 SYS.WRP$_REPORTS_DETAILS.SYS_P2361 TABLE PARTITION
NON_AWR 0.7 SYS.WRP$_REPORTS_DETAILS.SYS_P2205 TABLE PARTITION
NON_AWR 0.7 MDSYS.SDO_COORD_OPS TABLE
NON_AWR 0.7 SYS.I_WRI$_OPTSTAT_TAB_OBJ#_ST INDEX
NON_AWR 0.7 SYS.WRI$_OPTSTAT_IND_HISTORY TABLE
NON_AWR 0.7 SYS.I_WRI$_OPTSTAT_OPR_TASKS_STIME INDEX
NON_AWR 0.7 SYS.WRP$_REPORTS_DETAILS.SYS_P2185 TABLE PARTITION
NON_AWR 0.7 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P2241 TABLE PARTITION
NON_AWR 0.6 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P1729 TABLE PARTITION
NON_AWR 0.6 SYS.I_WRI$_OPTSTAT_IND_OBJ#_ST INDEX
NON_AWR 0.6 SYS.I_WRI$_OPTSTAT_OPR_TASKS_OPID INDEX
NON_AWR 0.6 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P1940 TABLE PARTITION
NON_AWR 0.6 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P2100 TABLE PARTITION
NON_AWR 0.6 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P2260 TABLE PARTITION
NON_AWR 0.6 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P2085 TABLE PARTITION

COMPONENT MB SEGMENT_NAME SEGMENT_TYPE
——— ——— ——————————————————————— —————
NON_AWR 0.6 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P1745 TABLE PARTITION
NON_AWR 0.6 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P1921 TABLE PARTITION
NON_AWR 0.6 SYS.WRP$_REPORTS_DETAILS.SYS_P2165 TABLE PARTITION
NON_AWR 0.6 SYS.WRP$_REPORTS_DETAILS.SYS_P2265 TABLE PARTITION
NON_AWR 0.6 MDSYS.SDO_COORD_OP_PARAM_VALS TABLE
NON_AWR 0.6 MDSYS.COORD_OP_PARA_VAL_PRIM INDEX
NON_AWR 0.6 XDB.XDB$COMPLEX_TYPE TABLE
NON_AWR 0.5 SYS.WRI$_OPTSTAT_TAB_HISTORY TABLE

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

Total snapshots in DB 3446032964 Instance 1 = 200

DBID SNAP_ID INST FLUSH_ELAPSED ENDTM STARTUP_TIME STATUS ERRCNT
———- ———- —– ——————– —————– —————– —— ——
3446032964 3185 1 +00000 00:00:02.3 07:00:09 (09/05) 12:22:58 (07/23) 0 0
3446032964 3186 1 +00000 00:00:03.8 08:00:24 (09/05) 12:22:58 (07/23) 0 0
3446032964 3187 1 +00000 00:00:03.2 09:00:38 (09/05) 12:22:58 (07/23) 0 0
3446032964 3188 1 +00000 00:00:02.9 10:00:54 (09/05) 12:22:58 (07/23) 0 0
3446032964 3189 1 +00000 00:00:03.4 11:00:08 (09/05) 12:22:58 (07/23) 0 0
3446032964 3190 1 +00000 00:00:03.5 12:00:23 (09/05) 12:22:58 (07/23) 0 0
3446032964 3191 1 +00000 00:00:03.9 13:00:39 (09/05) 12:22:58 (07/23) 0 0
3446032964 3192 1 +00000 00:00:02.7 14:00:55 (09/05) 12:22:58 (07/23) 0 0
3446032964 3193 1 +00000 00:00:02.8 15:00:09 (09/05) 12:22:58 (07/23) 0 0
3446032964 3194 1 +00000 00:00:02.5 16:00:23 (09/05) 12:22:58 (07/23) 0 0
3446032964 3195 1 +00000 00:00:03.1 17:00:37 (09/05) 12:22:58 (07/23) 0 0
3446032964 3196 1 +00000 00:00:02.0 18:00:52 (09/05) 12:22:58 (07/23) 0 0
3446032964 3197 1 +00000 00:00:02.6 19:00:06 (09/05) 12:22:58 (07/23) 0 0
3446032964 3198 1 +00000 00:00:02.1 20:00:20 (09/05) 12:22:58 (07/23) 0 0
3446032964 3199 1 +00000 00:00:02.5 21:00:35 (09/05) 12:22:58 (07/23) 0 0
3446032964 3200 1 +00000 00:00:01.7 22:00:49 (09/05) 12:22:58 (07/23) 0 0
3446032964 3201 1 +00000 00:00:02.7 23:00:03 (09/05) 12:22:58 (07/23) 0 0
3446032964 3202 1 +00000 00:00:02.6 00:00:17 (09/06) 12:22:58 (07/23) 0 0
3446032964 3203 1 +00000 00:00:02.4 01:00:31 (09/06) 12:22:58 (07/23) 0 0
3446032964 3204 1 +00000 00:00:02.1 02:00:45 (09/06) 12:22:58 (07/23) 0 0
3446032964 3205 1 +00000 00:00:02.4 03:00:01 (09/06) 12:22:58 (07/23) 0 0
3446032964 3206 1 +00000 00:00:02.5 04:00:15 (09/06) 12:22:58 (07/23) 0 0
3446032964 3207 1 +00000 00:00:02.4 05:00:29 (09/06) 12:22:58 (07/23) 0 0
3446032964 3208 1 +00000 00:00:02.2 06:00:43 (09/06) 12:22:58 (07/23) 0 0
3446032964 3209 1 +00000 00:00:02.3 07:00:57 (09/06) 12:22:58 (07/23) 0 0
3446032964 3210 1 +00000 00:00:03.1 08:00:11 (09/06) 12:22:58 (07/23) 0 0
3446032964 3211 1 +00000 00:00:04.0 09:00:26 (09/06) 12:22:58 (07/23) 0 0
3446032964 3212 1 +00000 00:00:03.9 10:00:42 (09/06) 12:22:58 (07/23) 0 0
3446032964 3213 1 +00000 00:00:03.1 11:00:56 (09/06) 12:22:58 (07/23) 0 0
3446032964 3214 1 +00000 00:00:04.1 12:00:10 (09/06) 12:22:58 (07/23) 0 0
3446032964 3215 1 +00000 00:00:03.3 13:00:25 (09/06) 12:22:58 (07/23) 0 0
3446032964 3216 1 +00000 00:00:02.7 14:00:41 (09/06) 12:22:58 (07/23) 0 0
3446032964 3217 1 +00000 00:00:02.9 15:00:56 (09/06) 12:22:58 (07/23) 0 0
3446032964 3218 1 +00000 00:00:02.5 16:00:10 (09/06) 12:22:58 (07/23) 0 0
3446032964 3219 1 +00000 00:00:02.0 17:00:24 (09/06) 12:22:58 (07/23) 0 0
3446032964 3220 1 +00000 00:00:02.5 18:00:39 (09/06) 12:22:58 (07/23) 0 0
3446032964 3221 1 +00000 00:00:02.6 19:00:54 (09/06) 12:22:58 (07/23) 0 0
3446032964 3222 1 +00000 00:00:01.9 20:00:09 (09/06) 12:22:58 (07/23) 0 0
3446032964 3223 1 +00000 00:00:02.5 21:00:23 (09/06) 12:22:58 (07/23) 0 0
3446032964 3224 1 +00000 00:00:02.4 22:00:37 (09/06) 12:22:58 (07/23) 0 0
3446032964 3225 1 +00000 00:00:01.8 23:00:52 (09/06) 12:22:58 (07/23) 0 0
3446032964 3226 1 +00000 00:00:02.9 00:00:06 (09/07) 12:22:58 (07/23) 0 0
3446032964 3227 1 +00000 00:00:02.5 01:00:20 (09/07) 12:22:58 (07/23) 0 0
3446032964 3228 1 +00000 00:00:02.3 02:00:35 (09/07) 12:22:58 (07/23) 0 0
3446032964 3229 1 +00000 00:00:03.0 03:00:52 (09/07) 12:22:58 (07/23) 0 0
3446032964 3230 1 +00000 00:00:02.3 04:00:05 (09/07) 12:22:58 (07/23) 0 0
3446032964 3231 1 +00000 00:00:02.2 05:00:19 (09/07) 12:22:58 (07/23) 0 0

DBID SNAP_ID INST FLUSH_ELAPSED ENDTM STARTUP_TIME STATUS ERRCNT
———- ———- —– ——————– —————– —————– —— ——
3446032964 3232 1 +00000 00:00:02.2 06:00:33 (09/07) 12:22:58 (07/23) 0 0
3446032964 3233 1 +00000 00:00:02.1 07:00:47 (09/07) 12:22:58 (07/23) 0 0
3446032964 3234 1 +00000 00:00:02.7 08:00:02 (09/07) 12:22:58 (07/23) 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
———- —– ———- —————– —— ———–
3446032964 1 3035 01:00:33 (08/30) 0 0

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

DBID LSNAPID LSPLITID LSNAPTIME LPURGETIME FLAG INTERVAL RETENTION VRSN
———– ——– ——– ————– ————– —– —————– —————– —-
3446032964 3234 3227 09/07 08:00:05 09/07 00:12:36 2 +00000 01:00:00.0 +00008 00:00:00.0 11

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

SNAP_ID INST ASH SQL SQBND FILES SEGST SYSEVT
———- —– ———- ———- ———- ———- ———- ———-
3185 1 59 121 398 34 82 172
3186 1 416 134 2239 34 85 172
3187 1 351 140 2250 34 82 172
3188 1 140 118 375 34 84 172
3189 1 256 116 370 34 85 172
3190 1 187 124 2243 34 83 172
3191 1 261 134 407 34 79 172
3192 1 193 140 2259 34 82 172
3193 1 99 130 2260 34 79 172
3194 1 116 124 2229 34 77 172
3195 1 74 110 353 34 79 172
3196 1 70 114 359 34 81 172
3197 1 84 120 2223 34 75 172
3198 1 66 110 343 34 81 172
3199 1 60 115 406 34 83 172
3200 1 67 123 820 34 81 172
3201 1 95 134 2271 34 84 172
3202 1 72 111 391 34 83 172
3203 1 70 120 352 34 83 172
3204 1 59 110 351 34 78 172
3205 1 304 112 413 34 82 172
3206 1 220 111 340 34 81 172
3207 1 95 116 398 34 78 172
3208 1 52 111 351 34 80 172
3209 1 48 124 2195 34 78 172
3210 1 458 131 2246 34 81 172
3211 1 543 125 2230 34 83 172
3212 1 586 122 2225 34 81 172
3213 1 669 133 2247 34 84 172
3214 1 501 127 2225 34 79 172
3215 1 136 130 2252 34 87 172
3216 1 107 137 2241 34 82 172
3217 1 98 112 346 34 79 172
3218 1 123 112 405 34 85 172
3219 1 88 115 355 34 80 172
3220 1 62 109 347 34 77 172
3221 1 113 120 2210 34 76 172
3222 1 61 119 2209 34 76 172
3223 1 92 114 396 34 79 172
3224 1 57 124 1023 34 87 172
3225 1 71 133 2252 34 83 172
3226 1 70 114 405 34 80 172
3227 1 61 114 331 34 78 172
3228 1 46 114 349 34 78 172
3229 1 365 118 399 34 84 172
3230 1 142 110 327 34 83 172
3231 1 34 117 389 34 83 172

SNAP_ID INST ASH SQL SQBND FILES SEGST SYSEVT
———- —– ———- ———- ———- ———- ———- ———-
3232 1 59 112 341 34 78 172
3233 1 65 123 397 34 81 172
3234 1 380 133 2241 34 79 172

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

SNAP_COUNT INST ASH SQLSTAT SQLBIND FILES SEGSTAT SYSEVENT
———- —– ———- ———- ———- ———- ———- ———-
200 1 197.1 123.54 1044.48 34 81.91 172

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

SQLTEXT SQLPLAN SQLBMETA SEGOBJ DATAFILE TEMPFILE
———- ———- ———- ———- ———- ———-
957 18505 3286 912 34 5

########################################################
(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 11:05:28 (04/25) AUTO INITIAL
SYS/SPM Evolve 2/SYS_AUTO_SPM_EVOLVE_TASK 11:05:28 (04/25) AUTO INITIAL
SYS/ADDM 3198/ADDM:3446032964_1_3187 09:00:42 (09/05) 0 0 AUTO COMPLETED
SYS/ADDM 3199/ADDM:3446032964_1_3188 10:00:57 (09/05) 0 0 AUTO COMPLETED
SYS/ADDM 3200/ADDM:3446032964_1_3189 11:00:12 (09/05) 0 0 AUTO COMPLETED
SYS/ADDM 3201/ADDM:3446032964_1_3190 12:00:27 (09/05) 0 0 AUTO COMPLETED
SYS/ADDM 3202/ADDM:3446032964_1_3191 13:00:43 (09/05) 0 0 AUTO COMPLETED
SYS/ADDM 3203/ADDM:3446032964_1_3192 14:00:58 (09/05) 0 0 AUTO COMPLETED
SYS/ADDM 3204/ADDM:3446032964_1_3193 15:00:12 (09/05) 0 0 AUTO COMPLETED
SYS/ADDM 3205/ADDM:3446032964_1_3194 16:00:26 (09/05) 0 0 AUTO COMPLETED
SYS/ADDM 3206/ADDM:3446032964_1_3195 17:00:41 (09/05) 0 0 AUTO COMPLETED
SYS/ADDM 3207/ADDM:3446032964_1_3196 18:00:54 (09/05) 0 0 AUTO COMPLETED
SYS/ADDM 3208/ADDM:3446032964_1_3197 19:00:09 (09/05) 0 0 AUTO COMPLETED
SYS/ADDM 3209/ADDM:3446032964_1_3198 20:00:23 (09/05) 1 1 AUTO COMPLETED
SYS/ADDM 3210/ADDM:3446032964_1_3199 21:00:38 (09/05) 0 0 AUTO COMPLETED
SYS/ADDM 3211/ADDM:3446032964_1_3200 22:00:51 (09/05) 1 1 AUTO COMPLETED
SYS/ADDM 3212/ADDM:3446032964_1_3201 23:00:06 (09/05) 0 0 AUTO COMPLETED
SYS/ADDM 3213/ADDM:3446032964_1_3202 00:00:20 (09/06) 1 1 AUTO COMPLETED
SYS/ADDM 3214/ADDM:3446032964_1_3203 01:00:34 (09/06) 1 1 AUTO COMPLETED
SYS/ADDM 3215/ADDM:3446032964_1_3204 02:00:48 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3216/ADDM:3446032964_1_3205 03:00:04 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3217/ADDM:3446032964_1_3206 04:00:18 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3218/ADDM:3446032964_1_3207 05:00:32 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3219/ADDM:3446032964_1_3208 06:00:46 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3220/ADDM:3446032964_1_3209 07:01:00 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3221/ADDM:3446032964_1_3210 08:00:15 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3222/ADDM:3446032964_1_3211 09:00:31 (09/06) 1 1 AUTO COMPLETED
SYS/ADDM 3223/ADDM:3446032964_1_3212 10:00:46 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3224/ADDM:3446032964_1_3213 11:01:00 (09/06) 1 1 AUTO COMPLETED
SYS/ADDM 3225/ADDM:3446032964_1_3214 12:00:15 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3226/ADDM:3446032964_1_3215 13:00:29 (09/06) 1 1 AUTO COMPLETED
SYS/ADDM 3227/ADDM:3446032964_1_3216 14:00:44 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3228/ADDM:3446032964_1_3217 15:00:59 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3229/ADDM:3446032964_1_3218 16:00:13 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3230/ADDM:3446032964_1_3219 17:00:27 (09/06) 1 1 AUTO COMPLETED
SYS/ADDM 3231/ADDM:3446032964_1_3220 18:00:42 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3232/ADDM:3446032964_1_3221 19:00:57 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3233/ADDM:3446032964_1_3222 20:00:11 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3234/ADDM:3446032964_1_3223 21:00:26 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3235/ADDM:3446032964_1_3224 22:00:40 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3236/ADDM:3446032964_1_3225 23:00:55 (09/06) 0 0 AUTO COMPLETED
SYS/ADDM 3237/ADDM:3446032964_1_3226 00:00:09 (09/07) 0 0 AUTO COMPLETED
SYS/ADDM 3238/ADDM:3446032964_1_3227 01:00:23 (09/07) 0 0 AUTO COMPLETED
SYS/ADDM 3239/ADDM:3446032964_1_3228 02:00:38 (09/07) 0 0 AUTO COMPLETED
SYS/ADDM 3240/ADDM:3446032964_1_3229 03:00:55 (09/07) 0 0 AUTO COMPLETED
SYS/ADDM 3241/ADDM:3446032964_1_3230 04:00:08 (09/07) 0 0 AUTO COMPLETED
SYS/ADDM 3242/ADDM:3446032964_1_3231 05:00:22 (09/07) 0 0 AUTO COMPLETED
SYS/ADDM 3243/ADDM:3446032964_1_3232 06:00:36 (09/07) 0 0 AUTO COMPLETED
SYS/ADDM 3244/ADDM:3446032964_1_3233 07:00:50 (09/07) 0 0 AUTO COMPLETED
SYS/ADDM 3245/ADDM:3446032964_1_3234 08:00:05 (09/07) 0 0 AUTO COMPLETED

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

OWNER/ADVISOR TASK_ID/NAME CREATED EXE_DURATN EXE_CREATN HOW_C STATUS
————– ——————————– —————- ———- ———- —– ————
SYS/ADDM 2517/ADDM:3446032964_1_2507 01:00:11 (08/08) 1 1 AUTO COMPLETED
SYS/ADDM 2518/ADDM:3446032964_1_2508 02:00:26 (08/08) 0 0 AUTO COMPLETED
SYS/ADDM 2519/ADDM:3446032964_1_2509 03:00:43 (08/08) 1 1 AUTO COMPLETED
SYS/ADDM 2520/ADDM:3446032964_1_2510 04:00:57 (08/08) 1 1 AUTO COMPLETED
SYS/ADDM 2521/ADDM:3446032964_1_2511 05:00:11 (08/08) 1 1 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/SPM Evolve 2/SYS_AUTO_SPM_EVOLVE_TASK 11:05:28 (04/25) AUTO INITIAL
Description: Automatic SPM Evolve Task
Error Msg :

SYS/SQL Tuning 1/SYS_AUTO_SQL_TUNING_TASK 11:05:28 (04/25) AUTO INITIAL
Description: Automatic SQL Tuning Task
Error Msg :

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

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

NUM_ACTIVE_SESSIONS NUM_SAMPLES
——————– ————
0000 – 0004 6,153
0005 – 0009 271
0010 – 0014 22
0015 – 0019 1

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

NUM_ACTIVE_SESSIONS NUM_SAMPLES
——————– ————
0000 – 0004 2,281
0005 – 0009 99
0010 – 0014 7

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

INST MIN_TIME MAX_TIME NUM_SAMPLES NUM_ROWS AVG_ACTIVE
—- —————- —————- ———— ———— ———-
1 09:00:56 (09/04) 07:59:46 (09/07) 25,522 10,940 0.43

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

INST MIN_TIME MAX_TIME NUM_SAMPLES NUM_ROWS AVG_ACTIVE
—- —————- —————- ———— ———— ———-
1 09:00:24 (09/06) 07:59:46 (09/07) 8,266 3,986 0.48

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

Foreground % 71.0
Background % 29.0
MMNL % 0.0

End of Report