| 구분 | 항목 |
|---|---|
| AWR 스냅샷 정보 | DB 유저별 SYSAUX 테이블스페이스 사용 정보 기능별 SYSAUX 테이블스페이스 사용 정보 일반 DB 유저의 SYSAUX 테이블스페이스 사용 정보 일별과 주별 AWR 공간 사용 정보 AWR의 구성요소별 SYSAUX 테이블스페이스 사용 정보 비AWR의 구성요소별 SYSAUX 테이블스페이스 사용 정보 최근 50개의 AWR 스냅샷 수행 정보 AWR 수행 시 에러 발생 정보 AWR 설정 정보(수행 주기, 보존 기간) AWR 구성요소별 각 스냅샷에 저장된 행의 수 AWR 구성요소별 스냅샷에 저장된 평균 행의 수 AWR 스냅샷에 의해 수집되고 사용된 DB 구성요소의 개수 |
| 권고자 구성정보 | 권고자 관련 작업 수행 결과 (최근 50개) 권고자 관련 작업 수행 결과 (가장 오래된 5개) 에러가 발생한 권고자 관련 작업의 상세 정보 (최근 50개) |
| ASH 사용정보 | ASH 통계 정보 ASH 기록 세션 중 서버 프로세스와 백그라운드 프로세스 비율 |
SQL> @?/rdbms/admin/awrinfo.sql
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: awr_info.txt
Using the report name awr_info.txt
No errors.
No errors.
~~~~~~~~~~~~~~~
AWR INFO Report
~~~~~~~~~~~~~~~
Report generated at 03:51:49 on Dec 15, 2012 ( Saturday ) in Timezone +09:00
Warning: Non Default AWR Setting!
--------------------------------------------------------------------------------
Snapshot interval is 20 minutes and Retention is 30 days
DB_ID DB_NAME HOST_PLATFORM INST STARTUP_TIME LAST_ASH_SID PAR
------------ --------- ---------------------------------------- ----- ----------------- ------------ ---
* 1490765173 ORATEST dbowl - AIX-Based Systems (64-bit) 1 16:48:30 (11/30) 142782418 NO
########################################################
(I) AWR Snapshots Information
########################################################
*****************************************************
(1a) SYSAUX usage - Schema breakdown (dba_segments)
*****************************************************
|
| Total SYSAUX size 1,551.8 MB ( 39% of 3,999.9 MB MAX with AUTOEXTEND OFF )
|
| Schema SYS occupies 1,312.9 MB ( 84.6% )
| Schema SYSMAN occupies 135.8 MB ( 8.7% )
| Schema SYSTEM occupies 93.1 MB ( 6.0% )
| Schema WMSYS occupies 7.4 MB ( 0.5% )
| Schema DBSNMP occupies 2.4 MB ( 0.2% )
| Schema APPQOSSYS occupies 0.3 MB ( 0.0% )
|
********************************************************
(1b) SYSAUX occupants space usage (v$sysaux_occupants)
********************************************************
|
| Occupant Name Schema Name Space Usage
| -------------------- -------------------- ----------------
| SM/AWR SYS 1,124.8 MB
| EM SYSMAN 135.8 MB
| LOGMNR SYSTEM 91.6 MB
| SM/OPTSTAT SYS 78.8 MB
| SM/ADVISOR SYS 65.4 MB
| SM/OTHER SYS 18.7 MB
| WM WMSYS 7.4 MB
| SMON_SCN_TIME SYS 3.3 MB
| EM_MONITORING_USER DBSNMP 2.4 MB
| PL/SCOPE SYS 2.0 MB
| SQL_MANAGEMENT_BASE SYS 1.7 MB
| AO SYS 1.4 MB
| LOGSTDBY SYSTEM 1.4 MB
| XSOQHIST SYS 1.4 MB
| STREAMS SYS 1.0 MB
| JOB_SCHEDULER SYS 0.4 MB
| AUTO_TASK SYS 0.3 MB
| AUDIT_TABLES SYS 0.0 MB
| EXPRESSION_FILTER EXFSYS 0.0 MB
| ORDIM ORDSYS 0.0 MB
| ORDIM/ORDDATA ORDDATA 0.0 MB
| ORDIM/ORDPLUGINS ORDPLUGINS 0.0 MB
| ORDIM/SI_INFORMTN_SC SI_INFORMTN_SCHEMA 0.0 MB
| SDO MDSYS 0.0 MB
| STATSPACK PERFSTAT 0.0 MB
| TEXT CTXSYS 0.0 MB
| TSM TSMSYS 0.0 MB
| ULTRASEARCH WKSYS 0.0 MB
| ULTRASEARCH_DEMO_USE WK_TEST 0.0 MB
| XDB XDB 0.0 MB
| XSAMD OLAPSYS 0.0 MB
|
| Others (Unaccounted space) 14.2 MB
|
******************************************
(1c) SYSAUX usage - Unregistered Schemas
******************************************
| This section displays schemas that are not registered
| in V$SYSAUX_OCCUPANTS
|
| Schema APPQOSSYS occupies 0.3 MB
|
| Total space 0.3 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 13.9 MB
|
| Total space 13.9 MB
|
*************************************
(2) Size estimates for AWR snapshots
*************************************
|
| Estimates based on 20 mins snapshot INTERVAL:
| AWR size/day 39.5 MB (562 K/snap * 72 snaps/day)
| AWR size/wk 276.4 MB (size_per_day * 7) per instance
|
| Estimates based on 72 snaps in past 24 hours:
| AWR size/day 39.5 MB (562 K/snap and 72 snaps in past 24 hours)
| AWR size/wk 276.4 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 713.0 63.4 356 25.0 175.2 56% : 44%
EVENTS 179.1 15.9 89 6.3 44.0 54% : 46%
SQL 104.0 9.2 52 3.7 25.6 65% : 35%
SPACE 84.1 7.5 42 3.0 20.7 67% : 33%
ASH 19.9 1.8 10 0.7 4.9 83% : 17%
SQLPLAN 7.0 0.6 3 0.2 1.7 71% : 29%
SQLBIND 6.0 0.5 3 0.2 1.5 50% : 50%
SQLTEXT 2.1 0.2 1 0.1 0.5 94% : 6%
RAC 0.6 0.1 0 0.0 0.2 50% : 50%
**********************************
(3b) Space usage within AWR Components (> 500K)
**********************************
COMPONENT MB SEGMENT_NAME - % SPACE_USED SEGMENT_TYPE
--------- --------- --------------------------------------------------------------------- ---------------
FIXED 53.0 WRH$_SYSMETRIC_HISTORY - 87% TABLE
FIXED 39.0 WRH$_SYSMETRIC_HISTORY_INDEX - 88% INDEX
FIXED 34.0 WRH$_SYSMETRIC_SUMMARY - 77% TABLE
FIXED 26.0 WRH$_RSRC_CONSUMER_GROUP - 79% TABLE
FIXED 15.0 WRH$_SYSMETRIC_SUMMARY_INDEX - 74% INDEX
FIXED 15.0 WRM$_SNAPSHOT_DETAILS_INDEX - 64% INDEX
FIXED 14.0 WRM$_SNAPSHOT_DETAILS - 98% TABLE
FIXED 12.0 WRH$_RSRC_CONSUMER_GROUP_PK - 50% INDEX
FIXED 7.0 WRH$_LATCH.WRH$_LATCH_1490765173_36603 - 91% TABLE PARTITION
FIXED 7.0 WRH$_LATCH.WRH$_LATCH_1490765173_36819 - 91% TABLE PARTITION
FIXED 7.0 WRH$_LATCH.WRH$_LATCH_1490765173_37036 - 91% TABLE PARTITION
FIXED 7.0 WRH$_LATCH.WRH$_LATCH_1490765173_37252 - 91% TABLE PARTITION
FIXED 7.0 WRH$_LATCH.WRH$_LATCH_1490765173_37468 - 91% TABLE PARTITION
FIXED 7.0 WRH$_LATCH.WRH$_LATCH_1490765173_37853 - 90% TABLE PARTITION
FIXED 7.0 WRH$_LATCH.WRH$_LATCH_1490765173_38069 - 90% TABLE PARTITION
FIXED 7.0 WRH$_LATCH.WRH$_LATCH_1490765173_38285 - 90% TABLE PARTITION
FIXED 7.0 WRH$_LATCH.WRH$_LATCH_1490765173_38501 - 90% TABLE PARTITION
FIXED 6.0 WRH$_LATCH.WRH$_LATCH_1490765173_37684 - 82% TABLE PARTITION
FIXED 5.0 WRH$_SYSSTAT.WRH$_SYSSTA_1490765173_38501 - 81% TABLE PARTITION
FIXED 5.0 WRH$_SYSSTAT.WRH$_SYSSTA_1490765173_38285 - 81% TABLE PARTITION
FIXED 5.0 WRH$_SYSSTAT.WRH$_SYSSTA_1490765173_38069 - 81% TABLE PARTITION
FIXED 5.0 WRH$_SYSSTAT.WRH$_SYSSTA_1490765173_37853 - 81% TABLE PARTITION
FIXED 5.0 WRH$_SYSSTAT.WRH$_SYSSTA_1490765173_37468 - 82% TABLE PARTITION
FIXED 5.0 WRH$_SYSSTAT.WRH$_SYSSTA_1490765173_37252 - 82% TABLE PARTITION
FIXED 5.0 WRH$_SYSSTAT.WRH$_SYSSTA_1490765173_37036 - 82% TABLE PARTITION
FIXED 5.0 WRH$_SYSSTAT.WRH$_SYSSTA_1490765173_36819 - 82% TABLE PARTITION
FIXED 5.0 WRH$_SYSSTAT.WRH$_SYSSTA_1490765173_36603 - 82% TABLE PARTITION
FIXED 5.0 WRH$_PGASTAT_PK - 41% INDEX
FIXED 5.0 WRH$_MUTEX_SLEEP_PK - 81% INDEX
FIXED 5.0 WRH$_MUTEX_SLEEP - 86% TABLE
EVENTS 14.0 WRH$_ENQUEUE_STAT - 67% TABLE
EVENTS 10.0 WRH$_ENQUEUE_STAT_PK - 72% INDEX
EVENTS 7.0 WRH$_BG_EVENT_SUMMARY - 85% TABLE
EVENTS 6.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__1490765173_37853 - 93% INDEX PARTITION
EVENTS 6.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__1490765173_38069 - 97% INDEX PARTITION
EVENTS 6.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__1490765173_38501 - 97% INDEX PARTITION
EVENTS 6.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__1490765173_38501 - 84% TABLE PARTITION
EVENTS 6.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__1490765173_38285 - 97% INDEX PARTITION
EVENTS 6.0 WRH$_BG_EVENT_SUMMARY_PK - 84% INDEX
EVENTS 6.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__1490765173_38285 - 82% TABLE PARTITION
EVENTS 5.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__1490765173_36603 - 87% TABLE PARTITION
EVENTS 5.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__1490765173_36819 - 88% TABLE PARTITION
EVENTS 5.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__1490765173_37036 - 89% TABLE PARTITION
EVENTS 5.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__1490765173_37252 - 89% TABLE PARTITION
EVENTS 5.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__1490765173_37468 - 90% TABLE PARTITION
EVENTS 5.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__1490765173_37853 - 95% TABLE PARTITION
EVENTS 5.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__1490765173_36819 - 97% INDEX PARTITION
COMPONENT MB SEGMENT_NAME - % SPACE_USED SEGMENT_TYPE
--------- --------- --------------------------------------------------------------------- ---------------
EVENTS 5.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__1490765173_36603 - 94% INDEX PARTITION
EVENTS 5.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__1490765173_38069 - 97% TABLE PARTITION
EVENTS 5.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__1490765173_37036 - 97% INDEX PARTITION
EVENTS 5.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__1490765173_37252 - 97% INDEX PARTITION
EVENTS 5.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__1490765173_37468 - 97% INDEX PARTITION
EVENTS 4.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__1490765173_37684 - 90% TABLE PARTITION
EVENTS 4.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__1490765173_37684 - 97% INDEX PARTITION
EVENTS 4.0 WRH$_LIBRARYCACHE - 76% TABLE
EVENTS 4.0 WRH$_LIBRARYCACHE_PK - 54% INDEX
EVENTS 2.0 WRH$_SYSTEM_EVENT.WRH$_SYSTEM_1490765173_37252 - 55% TABLE PARTITION
EVENTS 2.0 WRH$_SYSTEM_EVENT.WRH$_SYSTEM_1490765173_37036 - 55% TABLE PARTITION
EVENTS 2.0 WRH$_SYSTEM_EVENT.WRH$_SYSTEM_1490765173_36819 - 55% TABLE PARTITION
EVENTS 2.0 WRH$_SYSTEM_EVENT.WRH$_SYSTEM_1490765173_36603 - 54% TABLE PARTITION
SQL 8.0 WRH$_SQLSTAT.WRH$_SQLSTA_1490765173_36603 - 86% TABLE PARTITION
SQL 7.0 WRH$_SQLSTAT.WRH$_SQLSTA_1490765173_37468 - 90% TABLE PARTITION
SQL 7.0 WRH$_SQLSTAT.WRH$_SQLSTA_1490765173_36819 - 97% TABLE PARTITION
SQL 7.0 WRH$_SQLSTAT.WRH$_SQLSTA_1490765173_37036 - 97% TABLE PARTITION
SQL 7.0 WRH$_SQLSTAT.WRH$_SQLSTA_1490765173_37252 - 96% TABLE PARTITION
SQL 6.0 WRH$_SQLSTAT.WRH$_SQLSTA_1490765173_38069 - 88% TABLE PARTITION
SQL 6.0 WRH$_SQLSTAT.WRH$_SQLSTA_1490765173_37853 - 88% TABLE PARTITION
SQL 6.0 WRH$_SQLSTAT.WRH$_SQLSTA_1490765173_38501 - 83% TABLE PARTITION
SQL 6.0 WRH$_SQLSTAT.WRH$_SQLSTA_1490765173_38285 - 84% TABLE PARTITION
SQL 5.0 WRH$_SQLSTAT.WRH$_SQLSTA_1490765173_37684 - 85% TABLE PARTITION
SQL 2.0 WRH$_SQLSTAT_PK.WRH$_SQLSTA_1490765173_36819 - 71% INDEX PARTITION
SQL 2.0 WRH$_SQLSTAT_PK.WRH$_SQLSTA_1490765173_37036 - 70% INDEX PARTITION
SQL 2.0 WRH$_SQLSTAT_PK.WRH$_SQLSTA_1490765173_36603 - 69% INDEX PARTITION
SQL 2.0 WRH$_SQLSTAT_INDEX.WRH$_SQLSTA_1490765173_38501 - 40% INDEX PARTITION
SQL 2.0 WRH$_SQLSTAT_INDEX.WRH$_SQLSTA_1490765173_38285 - 41% INDEX PARTITION
SQL 2.0 WRH$_SQLSTAT_INDEX.WRH$_SQLSTA_1490765173_38069 - 53% INDEX PARTITION
SQL 2.0 WRH$_SQLSTAT_INDEX.WRH$_SQLSTA_1490765173_37853 - 48% INDEX PARTITION
SQL 2.0 WRH$_SQLSTAT_PK.WRH$_SQLSTA_1490765173_37252 - 58% INDEX PARTITION
SQL 2.0 WRH$_SQL_WORKAREA_HIST_PK - 41% INDEX
SQL 2.0 WRH$_SQL_WORKAREA_HISTOGRAM - 52% TABLE
SQL 2.0 WRH$_SQLSTAT_PK.WRH$_SQLSTA_1490765173_38501 - 69% INDEX PARTITION
SQL 2.0 WRH$_SQLSTAT_PK.WRH$_SQLSTA_1490765173_37468 - 71% INDEX PARTITION
SQL 2.0 WRH$_SQLSTAT_PK.WRH$_SQLSTA_1490765173_37684 - 70% INDEX PARTITION
SQL 2.0 WRH$_SQLSTAT_PK.WRH$_SQLSTA_1490765173_37853 - 64% INDEX PARTITION
SQL 2.0 WRH$_SQLSTAT_PK.WRH$_SQLSTA_1490765173_38069 - 65% INDEX PARTITION
SQL 2.0 WRH$_SQLSTAT_PK.WRH$_SQLSTA_1490765173_38285 - 68% INDEX PARTITION
SQL 0.9 WRH$_SQLSTAT_INDEX.WRH$_SQLSTA_1490765173_36603 - 69% INDEX PARTITION
SQL 0.9 WRH$_SQLSTAT_INDEX.WRH$_SQLSTA_1490765173_37036 - 70% INDEX PARTITION
SQL 0.9 WRH$_SQLSTAT_INDEX.WRH$_SQLSTA_1490765173_36819 - 68% INDEX PARTITION
SQL 0.9 WRH$_SQLSTAT_INDEX.WRH$_SQLSTA_1490765173_37252 - 70% INDEX PARTITION
SPACE 4.0 WRH$_TABLESPACE_SPACE_USAGE - 57% TABLE
SPACE 3.0 WRH$_IOSTAT_FILETYPE - 62% TABLE
SPACE 3.0 WRH$_SEG_STAT.WRH$_SEG_ST_1490765173_36819 - 82% TABLE PARTITION
SPACE 3.0 WRH$_SEG_STAT.WRH$_SEG_ST_1490765173_37036 - 82% TABLE PARTITION
COMPONENT MB SEGMENT_NAME - % SPACE_USED SEGMENT_TYPE
--------- --------- --------------------------------------------------------------------- ---------------
SPACE 3.0 WRH$_SEG_STAT.WRH$_SEG_ST_1490765173_38501 - 79% TABLE PARTITION
SPACE 3.0 WRH$_SEG_STAT.WRH$_SEG_ST_1490765173_37468 - 82% TABLE PARTITION
SPACE 3.0 WRH$_SEG_STAT.WRH$_SEG_ST_1490765173_37853 - 80% TABLE PARTITION
SPACE 3.0 WRH$_SEG_STAT.WRH$_SEG_ST_1490765173_38069 - 80% TABLE PARTITION
SPACE 3.0 WRH$_SEG_STAT.WRH$_SEG_ST_1490765173_38285 - 81% TABLE PARTITION
SPACE 3.0 WRH$_SEG_STAT.WRH$_SEG_ST_1490765173_36603 - 81% TABLE PARTITION
SPACE 3.0 WRH$_SEG_STAT.WRH$_SEG_ST_1490765173_37252 - 82% TABLE PARTITION
SPACE 2.0 WRH$_FILESTATXS.WRH$_FILEST_1490765173_37036 - 50% TABLE PARTITION
SPACE 2.0 WRH$_FILESTATXS.WRH$_FILEST_1490765173_36819 - 50% TABLE PARTITION
SPACE 2.0 WRH$_FILESTATXS.WRH$_FILEST_1490765173_36603 - 50% TABLE PARTITION
SPACE 2.0 WRH$_FILESTATXS.WRH$_FILEST_1490765173_37252 - 50% TABLE PARTITION
SPACE 2.0 WRH$_TEMPSTATXS - 42% TABLE
SPACE 2.0 WRH$_FILESTATXS.WRH$_FILEST_1490765173_37468 - 50% TABLE PARTITION
SPACE 2.0 WRH$_SEG_STAT.WRH$_SEG_ST_1490765173_37684 - 80% TABLE PARTITION
SPACE 2.0 WRH$_SEG_STAT_PK.WRH$_SEG_ST_1490765173_36603 - 70% INDEX PARTITION
SPACE 2.0 WRH$_SEG_STAT_PK.WRH$_SEG_ST_1490765173_36819 - 70% INDEX PARTITION
SPACE 2.0 WRH$_SEG_STAT_PK.WRH$_SEG_ST_1490765173_37036 - 76% INDEX PARTITION
SPACE 2.0 WRH$_SEG_STAT_PK.WRH$_SEG_ST_1490765173_37252 - 51% INDEX PARTITION
SPACE 2.0 WRH$_SEG_STAT_PK.WRH$_SEG_ST_1490765173_37468 - 64% INDEX PARTITION
SPACE 2.0 WRH$_SEG_STAT_PK.WRH$_SEG_ST_1490765173_37853 - 63% INDEX PARTITION
SPACE 2.0 WRH$_SEG_STAT_PK.WRH$_SEG_ST_1490765173_38069 - 63% INDEX PARTITION
SPACE 2.0 WRH$_SEG_STAT_PK.WRH$_SEG_ST_1490765173_38285 - 63% INDEX PARTITION
SPACE 2.0 WRH$_SEG_STAT_PK.WRH$_SEG_ST_1490765173_38501 - 57% INDEX PARTITION
SPACE 0.9 WRH$_FILESTATXS.WRH$_FILEST_1490765173_38501 - 85% TABLE PARTITION
SPACE 0.9 WRH$_IOSTAT_FILETYPE_PK - 79% INDEX
SPACE 0.8 WRH$_FILESTATXS.WRH$_FILEST_1490765173_37853 - 91% TABLE PARTITION
ASH 3.0 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_1490765173_36603 - 76% TABLE PARTITION
ASH 3.0 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_1490765173_36819 - 81% TABLE PARTITION
ASH 3.0 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_1490765173_37036 - 73% TABLE PARTITION
ASH 3.0 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_1490765173_37252 - 81% TABLE PARTITION
ASH 3.0 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_1490765173_37468 - 74% TABLE PARTITION
ASH 0.6 WRH$_ACTIVE_SESSION_HISTORY_PK.WRH$_ACTIVE_1490765173_36819 - 61% INDEX PARTITION
ASH 0.6 WRH$_ACTIVE_SESSION_HISTORY_PK.WRH$_ACTIVE_1490765173_37252 - 59% INDEX PARTITION
ASH 0.5 WRH$_ACTIVE_SESSION_HISTORY_PK.WRH$_ACTIVE_1490765173_36603 - 58% INDEX PARTITION
ASH 0.5 WRH$_ACTIVE_SESSION_HISTORY_PK.WRH$_ACTIVE_1490765173_37468 - 60% INDEX PARTITION
ASH 0.5 WRH$_ACTIVE_SESSION_HISTORY_PK.WRH$_ACTIVE_1490765173_37036 - 60% INDEX PARTITION
SQLPLAN 5.0 WRH$_SQL_PLAN - 74% TABLE
SQLPLAN 2.0 WRH$_SQL_PLAN_PK - 53% INDEX
SQLBIND 3.0 WRH$_SQL_BIND_METADATA - 25% TABLE
SQLBIND 3.0 WRH$_SQL_BIND_METADATA_PK - 30% INDEX
SQLTEXT 2.0 WRH$_SQLTEXT - 44% TABLE
**********************************
(4) Space usage by non-AWR components (> 500K)
**********************************
COMPONENT MB SEGMENT_NAME SEGMENT_TYPE
--------- --------- --------------------------------------------------------------------- ---------------
NON_AWR 28.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY TABLE
NON_AWR 19.0 SYS.I_WRI$_OPTSTAT_H_ST INDEX
NON_AWR 13.0 SYS.WRI$_ADV_OBJECTS TABLE
NON_AWR 10.0 SYS.WRI$_ADV_PARAMETERS_PK INDEX
NON_AWR 9.0 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY TABLE
NON_AWR 8.0 SYSTEM.LOGMNR_SEED$.P_LESSTHAN100 TABLE PARTITION
NON_AWR 8.0 SYS.SYS_LOB0000008963C00038$$ LOBSEGMENT
NON_AWR 8.0 SYSTEM.LOGMNR_PARTOBJ$.P_LESSTHAN100 TABLE PARTITION
NON_AWR 8.0 SYSTEM.LOGMNR_REFCON$.P_LESSTHAN100 TABLE PARTITION
NON_AWR 8.0 SYSTEM.LOGMNR_ENC$.P_LESSTHAN100 TABLE PARTITION
NON_AWR 8.0 SYSTEM.LOGMNR_PROPS$.P_LESSTHAN100 TABLE PARTITION
NON_AWR 8.0 SYSTEM.LOGMNR_KOPM$.P_LESSTHAN100 TABLE PARTITION
NON_AWR 8.0 SYSTEM.LOGMNR_SUBCOLTYPE$.P_LESSTHAN100 TABLE PARTITION
NON_AWR 8.0 SYSTEM.LOGMNR_OPQTYPE$.P_LESSTHAN100 TABLE PARTITION
NON_AWR 8.0 SYSTEM.LOGMNR_NTAB$.P_LESSTHAN100 TABLE PARTITION
NON_AWR 8.0 SYSTEM.LOGMNR_LOGMNR_BUILDLOG.P_LESSTHAN100 TABLE PARTITION
NON_AWR 7.0 SYS.WRI$_ADV_PARAMETERS TABLE
NON_AWR 7.0 SYS.I_WRI$_OPTSTAT_HH_ST INDEX
NON_AWR 6.0 SYS.WRI$_ADV_MESSAGE_GROUPS TABLE
NON_AWR 5.0 SYS.SYS_LOB0000009256C00038$$ LOBSEGMENT
NON_AWR 4.0 SYS.WRI$_ADV_ACTIONS TABLE
NON_AWR 4.0 SYSTEM.SYS_LOB0000105756C00009$$ LOBSEGMENT
NON_AWR 4.0 SYS.WRI$_SQLSET_PLAN_LINES TABLE
NON_AWR 3.0 SYS.WRI$_ADV_RATIONALE TABLE
NON_AWR 3.0 SYSMAN.MGMT_METRICS_1HOUR_PK INDEX
NON_AWR 3.0 SYS.I_WRI$_OPTSTAT_TAB_OBJ#_ST INDEX
NON_AWR 3.0 SYS.WRI$_ADV_MSG_GRPS_IDX_01 INDEX
NON_AWR 3.0 SYS.WRI$_ADV_MESSAGE_GROUPS_PK INDEX
NON_AWR 3.0 SYS.SMON_SCN_TO_TIME_AUX CLUSTER
NON_AWR 3.0 SYS.WRI$_OPTSTAT_TAB_HISTORY TABLE
NON_AWR 2.0 SYS.WRI$_ADV_RECOMMENDATIONS TABLE
NON_AWR 2.0 SYSMAN.SYS_LOB0000110083C00004$$ LOBSEGMENT
NON_AWR 2.0 SYSMAN.MGMT_METRICS_IDX_03 INDEX
NON_AWR 2.0 SYSMAN.MGMT_METRICS_IDX_01 INDEX
NON_AWR 2.0 SYSMAN.MGMT_METRICS_PK INDEX
NON_AWR 2.0 SYSMAN.MGMT_METRICS_RAW_PK INDEX
NON_AWR 2.0 SYS.I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX
NON_AWR 2.0 SYS.I_WRI$_OPTSTAT_TAB_ST INDEX
NON_AWR 2.0 SYSMAN.MGMT_METRICS TABLE
NON_AWR 2.0 SYS.WRI$_ALERT_HISTORY TABLE
NON_AWR 1.0 SYS.SYS$SERVICE_METRICS_TAB TABLE
NON_AWR 1.0 SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST INDEX
NON_AWR 0.9 SYS.I_WRI$_OPTSTAT_IND_OBJ#_ST INDEX
NON_AWR 0.9 SYS.SYS_LOB0000106532C00005$$ LOBSEGMENT
NON_AWR 0.9 SYSMAN.MGMT_METRICS_1DAY_PK INDEX
NON_AWR 0.9 SYS.WRI$_ADV_FINDINGS TABLE
NON_AWR 0.9 SYSMAN.MGMT_IP_REPORT_ELEM_PARAMS TABLE
COMPONENT MB SEGMENT_NAME SEGMENT_TYPE
--------- --------- --------------------------------------------------------------------- ---------------
NON_AWR 0.9 SYSMAN.MGMT_STRING_METRIC_HISTORY TABLE
NON_AWR 0.8 SYSMAN.MGMT_VIOLATIONS TABLE
NON_AWR 0.8 SYS.SYS_LOB0000008957C00004$$ LOBSEGMENT
NON_AWR 0.8 SYS.I_PLSCOPE_SIG_ACTION$ INDEX
NON_AWR 0.7 SYSMAN.MGMT_JOB_STEP_PARAMS TABLE
NON_AWR 0.6 SYS.SYS_IOT_TOP_8826 INDEX
NON_AWR 0.6 SYS.WRI$_ADV_TASKS TABLE
NON_AWR 0.6 SYS.WRI$_ADV_REC_ACTIONS_PK INDEX
NON_AWR 0.6 SYS.WRI$_ADV_RATIONALE_PK INDEX
NON_AWR 0.6 SYSMAN.MGMT_POLICIES TABLE
NON_AWR 0.6 SYS.ALERT_QT TABLE
NON_AWR 0.6 SYS.WRI$_OPTSTAT_IND_HISTORY TABLE
NON_AWR 0.5 SYS.WRI$_ADV_ADDM_FDG TABLE
NON_AWR 0.5 SYS.WRI$_ADV_REC_ACTIONS TABLE
NON_AWR 0.5 SYS.WRI$_ADV_ACTIONS_PK INDEX
NON_AWR 0.5 SYS.I_WRI$_OPTSTAT_IND_ST INDEX
NON_AWR 0.5 SYSMAN.PK_MGMT_JOB_STEP_PARAMS INDEX
NON_AWR 0.5 SYSMAN.MGMT_IP_REPORT_ELEM_PARAMS_PK INDEX
**********************************
(5a) AWR snapshots - last 50
**********************************
Total snapshots in DB 1490765173 Instance 1 = 2051
DBID SNAP_ID INST FLUSH_ELAPSED ENDTM STARTUP_TIME STATUS ERRCNT
---------- ---------- ----- -------------------- ----------------- ----------------- ------ ------
1490765173 38675 1 +00000 00:00:01.8 11:20:48 (12/14) 16:48:30 (11/30) 0 0
1490765173 38676 1 +00000 00:00:03.1 11:40:54 (12/14) 16:48:30 (11/30) 0 0
1490765173 38677 1 +00000 00:00:02.8 12:00:59 (12/14) 16:48:30 (11/30) 0 0
1490765173 38678 1 +00000 00:00:01.9 12:20:03 (12/14) 16:48:30 (11/30) 0 0
1490765173 38679 1 +00000 00:00:02.1 12:40:09 (12/14) 16:48:30 (11/30) 0 0
1490765173 38680 1 +00000 00:00:02.1 13:00:10 (12/14) 16:48:30 (11/30) 0 0
1490765173 38681 1 +00000 00:00:02.9 13:20:24 (12/14) 16:48:30 (11/30) 0 0
1490765173 38682 1 +00000 00:00:03.0 13:40:27 (12/14) 16:48:30 (11/30) 0 0
1490765173 38683 1 +00000 00:00:02.8 14:00:38 (12/14) 16:48:30 (11/30) 0 0
1490765173 38684 1 +00000 00:00:02.9 14:20:51 (12/14) 16:48:30 (11/30) 0 0
1490765173 38685 1 +00000 00:00:02.9 14:40:01 (12/14) 16:48:30 (11/30) 0 0
1490765173 38686 1 +00000 00:00:02.9 15:00:08 (12/14) 16:48:30 (11/30) 0 0
1490765173 38687 1 +00000 00:00:02.9 15:20:12 (12/14) 16:48:30 (11/30) 0 0
1490765173 38688 1 +00000 00:00:03.1 15:40:15 (12/14) 16:48:30 (11/30) 0 0
1490765173 38689 1 +00000 00:00:05.1 16:00:28 (12/14) 16:48:30 (11/30) 0 0
1490765173 38690 1 +00000 00:00:03.8 16:20:36 (12/14) 16:48:30 (11/30) 0 0
1490765173 38691 1 +00000 00:00:04.0 16:40:42 (12/14) 16:48:30 (11/30) 0 0
1490765173 38692 1 +00000 00:00:04.2 17:00:50 (12/14) 16:48:30 (11/30) 0 0
1490765173 38693 1 +00000 00:00:04.4 17:20:57 (12/14) 16:48:30 (11/30) 0 0
1490765173 38694 1 +00000 00:00:08.4 17:40:04 (12/14) 16:48:30 (11/30) 0 0
1490765173 38695 1 +00000 00:00:05.4 18:00:09 (12/14) 16:48:30 (11/30) 0 0
1490765173 38696 1 +00000 00:00:04.0 18:20:26 (12/14) 16:48:30 (11/30) 0 0
1490765173 38697 1 +00000 00:00:04.1 18:40:26 (12/14) 16:48:30 (11/30) 0 0
1490765173 38698 1 +00000 00:00:04.2 19:00:30 (12/14) 16:48:30 (11/30) 0 0
1490765173 38699 1 +00000 00:00:06.1 19:20:40 (12/14) 16:48:30 (11/30) 0 0
1490765173 38700 1 +00000 00:00:04.3 19:40:47 (12/14) 16:48:30 (11/30) 0 0
1490765173 38701 1 +00000 00:00:05.3 20:00:48 (12/14) 16:48:30 (11/30) 0 0
1490765173 38702 1 +00000 00:00:04.3 20:20:49 (12/14) 16:48:30 (11/30) 0 0
1490765173 38703 1 +00000 00:00:04.4 20:40:56 (12/14) 16:48:30 (11/30) 0 0
1490765173 38704 1 +00000 00:00:04.4 21:00:06 (12/14) 16:48:30 (11/30) 0 0
1490765173 38705 1 +00000 00:00:03.4 21:20:13 (12/14) 16:48:30 (11/30) 0 0
1490765173 38706 1 +00000 00:00:04.6 21:40:26 (12/14) 16:48:30 (11/30) 0 0
1490765173 38707 1 +00000 00:00:04.6 22:00:33 (12/14) 16:48:30 (11/30) 0 0
1490765173 38708 1 +00000 00:00:03.5 22:20:40 (12/14) 16:48:30 (11/30) 0 0
1490765173 38709 1 +00000 00:00:03.6 22:40:50 (12/14) 16:48:30 (11/30) 0 0
1490765173 38710 1 +00000 00:00:03.4 23:01:00 (12/14) 16:48:30 (11/30) 0 0
1490765173 38711 1 +00000 00:00:03.6 23:20:07 (12/14) 16:48:30 (11/30) 0 0
1490765173 38712 1 +00000 00:00:02.8 23:40:11 (12/14) 16:48:30 (11/30) 0 0
1490765173 38713 1 +00000 00:00:03.8 00:00:21 (12/15) 16:48:30 (11/30) 0 0
1490765173 38714 1 +00000 00:00:02.6 00:20:31 (12/15) 16:48:30 (11/30) 0 0
1490765173 38715 1 +00000 00:00:02.5 00:40:35 (12/15) 16:48:30 (11/30) 0 0
1490765173 38716 1 +00000 00:00:02.5 01:00:36 (12/15) 16:48:30 (11/30) 0 0
1490765173 38717 1 +00000 00:00:02.5 01:20:43 (12/15) 16:48:30 (11/30) 0 0
1490765173 38718 1 +00000 00:00:02.6 01:40:56 (12/15) 16:48:30 (11/30) 0 0
1490765173 38719 1 +00000 00:00:02.6 02:00:12 (12/15) 16:48:30 (11/30) 0 0
1490765173 38720 1 +00000 00:00:03.6 02:20:22 (12/15) 16:48:30 (11/30) 0 0
1490765173 38721 1 +00000 00:00:02.8 02:40:29 (12/15) 16:48:30 (11/30) 0 0
DBID SNAP_ID INST FLUSH_ELAPSED ENDTM STARTUP_TIME STATUS ERRCNT
---------- ---------- ----- -------------------- ----------------- ----------------- ------ ------
1490765173 38722 1 +00000 00:00:02.8 03:00:36 (12/15) 16:48:30 (11/30) 0 0
1490765173 38723 1 +00000 00:00:02.7 03:20:40 (12/15) 16:48:30 (11/30) 0 0
1490765173 38724 1 +00000 00:00:02.7 03:40:44 (12/15) 16:48:30 (11/30) 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
---------- ----- ---------- ----------------- ------ -----------
1490765173 1 36674 00:40:06 (11/15) 0 0
**********************************
(6) AWR Control Settings - interval, retention
**********************************
DBID LSNAPID LSPLITID LSNAPTIME LPURGETIME FLAG INTERVAL RETENTION VRSN
----------- -------- -------- -------------- -------------- ----- ----------------- ----------------- ----
1490765173 38724 38714 12/15 03:40:47 12/15 00:35:55 2 +00000 00:20:00.0 +00030 00:00:00.0 5
**********************************
(7a) AWR Contents - row counts for each snapshots
**********************************
SNAP_ID INST ASH SQL SQBND FILES SEGST SYSEVT
---------- ----- ---------- ---------- ---------- ---------- ---------- ----------
38675 1 2 86 253 61 89 121
38676 1 4 93 299 61 89 121
38677 1 6 82 230 61 89 121
38678 1 2 89 245 61 89 121
38679 1 6 89 281 61 89 121
38680 1 2 83 256 61 89 121
38681 1 2 83 246 61 89 121
38682 1 3 91 269 61 89 121
38683 1 6 84 254 61 89 121
38684 1 2 88 261 61 89 121
38685 1 0 88 274 61 89 121
38686 1 4 84 251 61 89 121
38687 1 4 89 290 61 89 121
38688 1 3 90 299 61 89 121
38689 1 3 77 229 61 89 121
38690 1 1 83 267 61 89 121
38691 1 4 89 242 61 89 121
38692 1 9 92 250 61 88 121
38693 1 3 85 274 61 89 121
38694 1 5 82 195 61 88 127
38695 1 32 61 119 61 89 132
38696 1 29 79 167 61 89 133
38697 1 4 96 244 61 89 133
38698 1 7 97 260 61 89 133
38699 1 1 96 303 61 89 133
38700 1 1 99 305 61 89 133
38701 1 7 95 278 61 89 133
38702 1 6 95 292 61 89 133
38703 1 3 96 299 61 89 133
38704 1 7 94 268 61 89 133
38705 1 2 100 295 61 89 133
38706 1 6 98 284 61 89 133
38707 1 8 99 288 61 89 133
38708 1 2 87 283 61 89 133
38709 1 5 93 297 61 89 133
38710 1 8 92 251 61 89 133
38711 1 2 97 301 61 89 133
38712 1 1 96 322 61 89 133
38713 1 6 93 255 61 89 133
38714 1 6 95 264 61 89 133
38715 1 4 96 391 61 81 133
38716 1 1 91 220 61 89 133
38717 1 5 97 275 61 89 133
38718 1 2 77 237 61 89 133
38719 1 4 88 262 61 90 133
38720 1 4 92 257 61 90 133
38721 1 4 94 257 61 89 133
SNAP_ID INST ASH SQL SQBND FILES SEGST SYSEVT
---------- ----- ---------- ---------- ---------- ---------- ---------- ----------
38722 1 1 92 257 61 89 133
38723 1 7 101 352 61 89 133
38724 1 16 99 354 61 88 134
**********************************
(7b) AWR Contents - average row counts per snapshot
**********************************
SNAP_COUNT INST ASH SQLSTAT SQLBIND FILES SEGSTAT SYSEVENT
---------- ----- ---------- ---------- ---------- ---------- ---------- ----------
2051 1 17.09 84.68 380.31 61 86.33 112.01
**********************************
(7c) AWR total item counts - names, text, plans
**********************************
SQLTEXT SQLPLAN SQLBMETA SEGOBJ DATAFILE TEMPFILE
---------- ---------- ---------- ---------- ---------- ----------
975 8928 6040 1279 61 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 151350/SYS_AUTO_SQL_TUNING_TASK 04:21:21 (10/23) AUTO INITIAL
SYS/ADDM 161072/ADDM:1490765173_1_38676 11:40:58 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161082/ADDM:1490765173_1_38677 12:01:02 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161092/ADDM:1490765173_1_38678 12:20:06 (12/14) 0 0 AUTO COMPLETED
SYS/ADDM 161102/ADDM:1490765173_1_38679 12:40:12 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161112/ADDM:1490765173_1_38680 13:00:14 (12/14) 0 0 AUTO COMPLETED
SYS/ADDM 161122/ADDM:1490765173_1_38681 13:20:27 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161132/ADDM:1490765173_1_38682 13:40:31 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161142/ADDM:1490765173_1_38683 14:00:41 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161152/ADDM:1490765173_1_38684 14:20:54 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161162/ADDM:1490765173_1_38685 14:40:04 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161172/ADDM:1490765173_1_38686 15:00:11 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161182/ADDM:1490765173_1_38687 15:20:16 (12/14) 0 0 AUTO COMPLETED
SYS/ADDM 161192/ADDM:1490765173_1_38688 15:40:19 (12/14) 0 1 AUTO COMPLETED
SYS/ADDM 161202/ADDM:1490765173_1_38689 16:00:34 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161212/ADDM:1490765173_1_38690 16:20:41 (12/14) 0 0 AUTO COMPLETED
SYS/ADDM 161222/ADDM:1490765173_1_38691 16:40:47 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161232/ADDM:1490765173_1_38692 17:00:55 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161242/ADDM:1490765173_1_38693 17:21:02 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161252/ADDM:1490765173_1_38694 17:40:13 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161262/ADDM:1490765173_1_38695 18:00:15 (12/14) 0 1 AUTO COMPLETED
SYS/ADDM 161272/ADDM:1490765173_1_38696 18:20:31 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161282/ADDM:1490765173_1_38697 18:40:31 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161292/ADDM:1490765173_1_38698 19:00:35 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161302/ADDM:1490765173_1_38699 19:20:47 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161312/ADDM:1490765173_1_38700 19:40:52 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161322/ADDM:1490765173_1_38701 20:00:55 (12/14) 0 0 AUTO COMPLETED
SYS/ADDM 161332/ADDM:1490765173_1_38702 20:20:54 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161342/ADDM:1490765173_1_38703 20:41:02 (12/14) 0 0 AUTO COMPLETED
SYS/ADDM 161352/ADDM:1490765173_1_38704 21:00:11 (12/14) 0 1 AUTO COMPLETED
SYS/ADDM 161362/ADDM:1490765173_1_38705 21:20:18 (12/14) 0 0 AUTO COMPLETED
SYS/ADDM 161372/ADDM:1490765173_1_38706 21:40:31 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161382/ADDM:1490765173_1_38707 22:00:38 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161392/ADDM:1490765173_1_38708 22:20:44 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161402/ADDM:1490765173_1_38709 22:40:54 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161412/ADDM:1490765173_1_38710 23:01:04 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161422/ADDM:1490765173_1_38711 23:20:11 (12/14) 1 1 AUTO COMPLETED
SYS/ADDM 161432/ADDM:1490765173_1_38712 23:40:14 (12/14) 0 1 AUTO COMPLETED
SYS/ADDM 161442/ADDM:1490765173_1_38713 00:00:25 (12/15) 1 1 AUTO COMPLETED
SYS/ADDM 161452/ADDM:1490765173_1_38714 00:20:35 (12/15) 1 1 AUTO COMPLETED
SYS/ADDM 161462/ADDM:1490765173_1_38715 00:40:38 (12/15) 1 1 AUTO COMPLETED
SYS/ADDM 161472/ADDM:1490765173_1_38716 01:00:39 (12/15) 0 1 AUTO COMPLETED
SYS/ADDM 161482/ADDM:1490765173_1_38717 01:20:46 (12/15) 1 1 AUTO COMPLETED
SYS/ADDM 161483/ADDM:1490765173_1_38718 01:40:59 (12/15) 1 1 AUTO COMPLETED
SYS/ADDM 161492/ADDM:1490765173_1_38719 02:00:15 (12/15) 0 1 AUTO COMPLETED
SYS/ADDM 161502/ADDM:1490765173_1_38720 02:20:26 (12/15) 1 1 AUTO COMPLETED
SYS/ADDM 161512/ADDM:1490765173_1_38721 02:40:33 (12/15) 0 0 AUTO COMPLETED
SYS/ADDM 161522/ADDM:1490765173_1_38722 03:00:39 (12/15) 1 1 AUTO COMPLETED
SYS/ADDM 161532/ADDM:1490765173_1_38723 03:20:43 (12/15) 1 1 AUTO COMPLETED
SYS/ADDM 161542/ADDM:1490765173_1_38724 03:40:47 (12/15) 1 1 AUTO COMPLETED
**********************************
(2) Advisor Task - Oldest 5
**********************************
OWNER/ADVISOR TASK_ID/NAME CREATED EXE_DURATN EXE_CREATN HOW_C STATUS
-------------- -------------------------------- ---------------- ---------- ---------- ----- ------------
SYS/ADDM 152998/ADDM:1490765173_1_36674 00:40:07 (11/15) 1 1 AUTO COMPLETED
SYS/ADDM 152999/ADDM:1490765173_1_36675 01:00:08 (11/15) 1 1 AUTO COMPLETED
SYS/ADDM 153000/ADDM:1490765173_1_36676 01:20:27 (11/15) 0 0 AUTO COMPLETED
SYS/ADDM 153001/ADDM:1490765173_1_36677 01:40:28 (11/15) 0 0 AUTO COMPLETED
SYS/ADDM 153002/ADDM:1490765173_1_36678 02:00:32 (11/15) 0 0 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/SQL Tuning 151350/SYS_AUTO_SQL_TUNING_TASK 04:21:21 (10/23) 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 753
**********************************
(1b) ASH histogram (past 1 day)
**********************************
NUM_ACTIVE_SESSIONS NUM_SAMPLES
-------------------- ------------
0000 - 0004 304
**********************************
(2a) ASH details (past 3 days)
**********************************
INST MIN_TIME MAX_TIME NUM_SAMPLES NUM_ROWS AVG_ACTIVE
---- ---------------- ---------------- ------------ ------------ ----------
1 04:08:59 (12/12) 03:35:45 (12/15) 25,653 830 0.03
**********************************
(2b) ASH details (past 1 day)
**********************************
INST MIN_TIME MAX_TIME NUM_SAMPLES NUM_ROWS AVG_ACTIVE
---- ---------------- ---------------- ------------ ------------ ----------
1 04:05:11 (12/14) 03:35:45 (12/15) 8,441 340 0.04
**********************************
(2c) ASH sessions (Fg Vs Bg) (past 1 day across all instances in RAC)
**********************************
Foreground % 12.9
Background % 87.1
MMNL % 0.0
End of Report
Report written to awr_info.txt
SQL>