{"id":1069,"date":"2016-01-02T04:41:45","date_gmt":"2016-01-02T04:41:45","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1069"},"modified":"2016-01-02T04:41:45","modified_gmt":"2016-01-02T04:41:45","slug":"awr%ec%97%90-%ec%a0%80%ec%9e%a5%eb%90%9c-%ec%a0%95%eb%b3%b4-%ed%99%95%ec%9d%b8%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1069","title":{"rendered":"AWR\uc5d0 \uc800\uc7a5\ub41c \uc815\ubcf4 \ud655\uc778\ud558\uae30"},"content":{"rendered":"

$ORACLE_HOME\/rdbms\/admin\/awrinfo.sql <\/SPAN><\/P>
\n

awrinfo.sql\uc744 \ud1b5\ud574 AWR\uc5d0 \uc800\uc7a5\ub41c \uc815\ubcf4\ub97c \ud655\uc778 \ud560 \uc218 \uc788\ub2e4. <\/SPAN><\/P>
\n

(\uc5d0\ub7ec \uc815\ubcf4, \ud604\uc7ac \uc124\uc815 \uc815\ubcf4(interval, \ubcf4\uc874 \uae30\uac04 \ub4f1), \uc720\uc800 \ubcc4 SYSAUX \uc0ac\uc6a9 \uc815\ubcf4 \ub4f1) <\/SPAN><\/P>
\n

   <\/P>
\n

<\/SPAN><\/P>
\n

   <\/P>
\n

\uc804\ubb38 <\/SPAN><\/P>
\n

~~~~~~~~~~~~~~~ <\/SPAN><\/P>
\n

AWR INFO Report <\/SPAN><\/P>
\n

~~~~~~~~~~~~~~~ <\/SPAN><\/P>
\n

   <\/P>
\n

Report generated at 13:23:05 on Jan 02, 2016 ( Saturday ) in Timezone +09:00 <\/SPAN><\/P>
\n

   <\/P>
\n

Warning: Non Default AWR Setting! <\/SPAN><\/P>
\n

——————————————————————————– <\/SPAN><\/P>
\n

Snapshot interval is 60 minutes and Retention is 8 days <\/SPAN><\/P>
\n

   <\/P>
\n

   <\/P>
\n

DB_ID DB_NAME HOST_PLATFORM INST STARTUP_TIME LAST_ASH_SID PAR <\/SPAN><\/P>
\n

———— ——— —————————————- —– —————– ———— — <\/SPAN><\/P>
\n

* 1232455262 ORCL1 oracle.com – Linux x86 64-bit 1 12:23:21 (01\/02) 201085 NO <\/SPAN><\/P>
\n

   <\/P>
\n

######################################################## <\/SPAN><\/P>
\n

(I) AWR Snapshots Information <\/SPAN><\/P>
\n

######################################################## <\/SPAN><\/P>
\n

   <\/P>
\n

***************************************************** <\/SPAN><\/P>
\n

(1a) SYSAUX usage – Schema breakdown (dba_segments) <\/SPAN><\/P>
\n

***************************************************** <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

| Total SYSAUX size 516.8 MB ( 2% of 32,768.0 MB MAX with AUTOEXTEND ON ) <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

| Schema XDB occupies 157.5 MB ( 30.5% ) <\/SPAN><\/P>
\n

| Schema SYS occupies 122.8 MB ( 23.8% ) <\/SPAN><\/P>
\n

| Schema APEX_030200 occupies 77.4 MB ( 15.0% ) <\/SPAN><\/P>
\n

| Schema MDSYS occupies 65.8 MB ( 12.7% ) <\/SPAN><\/P>
\n

| Schema SYSMAN occupies 45.3 MB ( 8.8% ) <\/SPAN><\/P>
\n

| Schema SYSTEM occupies 13.7 MB ( 2.6% ) <\/SPAN><\/P>
\n

| Schema ORDDATA occupies 13.6 MB ( 2.6% ) <\/SPAN><\/P>
\n

| Schema OLAPSYS occupies 8.8 MB ( 1.7% ) <\/SPAN><\/P>
\n

| Schema CTXSYS occupies 3.8 MB ( 0.7% ) <\/SPAN><\/P>
\n

| Schema EXFSYS occupies 3.6 MB ( 0.7% ) <\/SPAN><\/P>
\n

| Schema WMSYS occupies 3.5 MB ( 0.7% ) <\/SPAN><\/P>
\n

| Schema DBSNMP occupies 0.5 MB ( 0.1% ) <\/SPAN><\/P>
\n

| Schema ORDSYS occupies 0.4 MB ( 0.1% ) <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

******************************************************** <\/SPAN><\/P>
\n

(1b) SYSAUX occupants space usage (v$sysaux_occupants) <\/SPAN><\/P>
\n

******************************************************** <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

| Occupant Name Schema Name Space Usage <\/SPAN><\/P>
\n

| ——————– ——————– —————- <\/SPAN><\/P>
\n

| XDB XDB 157.5 MB <\/SPAN><\/P>
\n

| SDO MDSYS 65.8 MB <\/SPAN><\/P>
\n

| EM SYSMAN 45.3 MB <\/SPAN><\/P>
\n

| SM\/AWR SYS 40.6 MB <\/SPAN><\/P>
\n

| AO SYS 36.3 MB <\/SPAN><\/P>
\n

| XSOQHIST SYS 36.3 MB <\/SPAN><\/P>
\n

| ORDIM\/ORDDATA ORDDATA 13.6 MB <\/SPAN><\/P>
\n

| LOGMNR SYSTEM 12.3 MB <\/SPAN><\/P>
\n

| SM\/OPTSTAT SYS 10.6 MB <\/SPAN><\/P>
\n

| XSAMD OLAPSYS 8.8 MB <\/SPAN><\/P>
\n

| SM\/ADVISOR SYS 7.8 MB <\/SPAN><\/P>
\n

| SM\/OTHER SYS 6.1 MB <\/SPAN><\/P>
\n

| TEXT CTXSYS 3.8 MB <\/SPAN><\/P>
\n

| EXPRESSION_FILTER EXFSYS 3.6 MB <\/SPAN><\/P>
\n

| WM WMSYS 3.5 MB <\/SPAN><\/P>
\n

| SMON_SCN_TIME SYS 2.1 MB <\/SPAN><\/P>
\n

| SQL_MANAGEMENT_BASE SYS 1.7 MB <\/SPAN><\/P>
\n

| PL\/SCOPE SYS 1.6 MB <\/SPAN><\/P>
\n

| LOGSTDBY SYSTEM 1.4 MB <\/SPAN><\/P>
\n

| STREAMS SYS 1.0 MB <\/SPAN><\/P>
\n

| EM_MONITORING_USER DBSNMP 0.5 MB <\/SPAN><\/P>
\n

| ORDIM ORDSYS 0.4 MB <\/SPAN><\/P>
\n

| JOB_SCHEDULER SYS 0.4 MB <\/SPAN><\/P>
\n

| AUTO_TASK SYS 0.3 MB <\/SPAN><\/P>
\n

| AUDIT_TABLES SYS 0.0 MB <\/SPAN><\/P>
\n

| ORDIM\/ORDPLUGINS ORDPLUGINS 0.0 MB <\/SPAN><\/P>
\n

| ORDIM\/SI_INFORMTN_SC SI_INFORMTN_SCHEMA 0.0 MB <\/SPAN><\/P>
\n

| STATSPACK PERFSTAT 0.0 MB <\/SPAN><\/P>
\n

| TSM TSMSYS 0.0 MB <\/SPAN><\/P>
\n

| ULTRASEARCH WKSYS 0.0 MB <\/SPAN><\/P>
\n

| ULTRASEARCH_DEMO_USE WK_TEST 0.0 MB <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

| Others (Unaccounted space) 55.7 MB <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

   <\/P>
\n

****************************************** <\/SPAN><\/P>
\n

(1c) SYSAUX usage – Unregistered Schemas <\/SPAN><\/P>
\n

****************************************** <\/SPAN><\/P>
\n

   <\/P>
\n

| This section displays schemas that are not registered <\/SPAN><\/P>
\n

| in V$SYSAUX_OCCUPANTS <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

| Schema APEX_030200 occupies 77.4 MB <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

| Total space 77.4 MB <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

   <\/P>
\n

************************************************************* <\/SPAN><\/P>
\n

(1d) SYSAUX usage – Unaccounted space in registered schemas <\/SPAN><\/P>
\n

************************************************************* <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

| This section displays unaccounted space in the registered <\/SPAN><\/P>
\n

| schemas of V$SYSAUX_OCCUPANTS. <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

| Unaccounted space in SYS\/SYSTEM -21.8 MB <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

| Total space -21.8 MB <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

************************************* <\/SPAN><\/P>
\n

(2) Size estimates for AWR snapshots <\/SPAN><\/P>
\n

************************************* <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

| Estimates based on 60 mins snapshot INTERVAL: <\/SPAN><\/P>
\n

| AWR size\/day 243.4 MB (10,384 K\/snap * 24 snaps\/day) <\/SPAN><\/P>
\n

| AWR size\/wk 1,703.6 MB (size_per_day * 7) per instance <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

| Estimates based on 4 snaps in past 24 hours: <\/SPAN><\/P>
\n

| AWR size\/day 60.8 MB (10,384 K\/snap and 4 snaps in past 16 hours) <\/SPAN><\/P>
\n

| AWR size\/wk 425.9 MB (size_per_day * 7) per instance <\/SPAN><\/P>
\n

| <\/SPAN><\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(3a) Space usage by AWR components (per database) <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

COMPONENT MB % AWR KB_PER_SNAP MB_PER_DAY MB_PER_WEEK TABLE% : INDEX% <\/SPAN><\/P>
\n

——— ——— —— ———— ———- ———– —————- <\/SPAN><\/P>
\n

FIXED 21.9 54.1 5,616 32.9 230.3 51% : 49% <\/SPAN><\/P>
\n

SQLPLAN 7.0 17.3 1,792 10.5 73.5 71% : 29% <\/SPAN><\/P>
\n

SPACE 2.6 6.3 656 3.8 26.9 51% : 49% <\/SPAN><\/P>
\n

SQL 1.9 4.8 496 2.9 20.3 55% : 45% <\/SPAN><\/P>
\n

EVENTS 1.6 4.0 416 2.4 17.1 50% : 50% <\/SPAN><\/P>
\n

SQLTEXT 1.0 2.5 256 1.5 10.5 88% : 13% <\/SPAN><\/P>
\n

SQLBIND 0.7 1.7 176 1.0 7.2 55% : 45% <\/SPAN><\/P>
\n

RAC 0.6 1.5 160 0.9 6.6 50% : 50% <\/SPAN><\/P>
\n

ASH 0.5 1.2 128 0.8 5.3 63% : 38% <\/SPAN><\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(3b) Space usage within AWR Components (> 500K) <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

COMPONENT MB SEGMENT_NAME – % SPACE_USED SEGMENT_TYPE <\/SPAN><\/P>
\n

——— ——— ——————————————————————— ————— <\/SPAN><\/P>
\n

FIXED 2.0 WRH$_LATCH_CHILDREN.WRH$_LATCH__1232455262_81 – 83% TABLE PARTITION <\/SPAN><\/P>
\n

FIXED 2.0 WRH$_LATCH_CHILDREN_PK.WRH$_LATCH__1232455262_81 – 58% INDEX PARTITION <\/SPAN><\/P>
\n

FIXED 0.9 WRH$_SYSMETRIC_HISTORY – 19% TABLE <\/SPAN><\/P>
\n

FIXED 0.8 WRH$_SYSMETRIC_HISTORY_INDEX – 26% INDEX <\/SPAN><\/P>
\n

SQLPLAN 5.0 WRH$_SQL_PLAN – 78% TABLE <\/SPAN><\/P>
\n

SQLPLAN 2.0 WRH$_SQL_PLAN_PK – 69% INDEX <\/SPAN><\/P>
\n

SQL 0.6 WRH$_SQLSTAT.WRH$_SQLSTA_1232455262_81 – 82% TABLE PARTITION <\/SPAN><\/P>
\n

SQLTEXT 0.9 WRH$_SQLTEXT – 84% TABLE <\/SPAN><\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(4) Space usage by non-AWR components (> 500K) <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

COMPONENT MB SEGMENT_NAME SEGMENT_TYPE <\/SPAN><\/P>
\n

——— ——— ——————————————————————— ————— <\/SPAN><\/P>
\n

NON_AWR 53.2 XDB.SYS_LOB0000057465C00025$$ LOBSEGMENT <\/SPAN><\/P>
\n

NON_AWR 18.0 MDSYS.SYS_LOB0000064008C00006$$ LOBSEGMENT <\/SPAN><\/P>
\n

NON_AWR 16.1 SYS.SYS_LOB0000065858C00004$$ LOBSEGMENT <\/SPAN><\/P>
\n

NON_AWR 8.0 XDB.XDB$RESOURCE TABLE <\/SPAN><\/P>
\n

NON_AWR 7.2 SYS.SYS_LOB0000065843C00004$$ LOBSEGMENT <\/SPAN><\/P>
\n

NON_AWR 7.0 MDSYS.SDO_CS_SRS TABLE <\/SPAN><\/P>
\n

NON_AWR 5.0 APEX_030200.WWV_FLOW_STEP_ITEMS TABLE <\/SPAN><\/P>
\n

NON_AWR 5.0 APEX_030200.WWV_FLOW_DICTIONARY$CAPED INDEX <\/SPAN><\/P>
\n

NON_AWR 5.0 APEX_030200.WWV_FLOW_PAGE_PLUGS TABLE <\/SPAN><\/P>
\n

NON_AWR 4.2 SYS.SYS_LOB0000065848C00004$$ LOBSEGMENT <\/SPAN><\/P>
\n

NON_AWR 4.0 APEX_030200.WWV_FLOW_DICTIONARY$ TABLE <\/SPAN><\/P>
\n

NON_AWR 4.0 SYSTEM.SYS_LOB0000001147C00009$$ LOBSEGMENT <\/SPAN><\/P>
\n

NON_AWR 3.2 SYS.SYS_LOB0000065838C00004$$ LOBSEGMENT <\/SPAN><\/P>
\n

NON_AWR 3.0 XDB.XDB$H_INDEX TABLE <\/SPAN><\/P>
\n

NON_AWR 3.0 APEX_030200.WWV_FLOW_DICTIONARY$SOUNDEX INDEX <\/SPAN><\/P>
\n

NON_AWR 3.0 APEX_030200.WWV_FLOW_DICTIONARY$WORDS INDEX <\/SPAN><\/P>
\n

NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY TABLE <\/SPAN><\/P>
\n

NON_AWR 2.0 SYS.SYS_LOB0000006339C00038$$ LOBSEGMENT <\/SPAN><\/P>
\n

NON_AWR 2.0 APEX_030200.WWV_FLOW_DICTIONARY$_FKIDX INDEX <\/SPAN><\/P>
\n

NON_AWR 2.0 SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST INDEX <\/SPAN><\/P>
\n

NON_AWR 2.0 SYS.SMON_SCN_TO_TIME_AUX CLUSTER <\/SPAN><\/P>
\n

NON_AWR 2.0 APEX_030200.WWV_FLOW_REGION_REPORT_COLUMN TABLE <\/SPAN><\/P>
\n

NON_AWR 2.0 APEX_030200.WWV_FLOW_STEP_PROCESSING TABLE <\/SPAN><\/P>
\n

NON_AWR 2.0 APEX_030200.WWV_FLOW_STEP_ITEM_HELP TABLE <\/SPAN><\/P>
\n

NON_AWR 2.0 SYSMAN.MGMT_METRICS TABLE <\/SPAN><\/P>
\n

NON_AWR 2.0 MDSYS.SDO_COORD_REF_SYS TABLE <\/SPAN><\/P>
\n

NON_AWR 2.0 XDB.XDB$ELEMENT TABLE <\/SPAN><\/P>
\n

NON_AWR 1.2 ORDDATA.SYS_LOB0000059327C00005$$ LOBSEGMENT <\/SPAN><\/P>
\n

NON_AWR 1.2 SYS.SYS_LOB0000065863C00004$$ LOBSEGMENT <\/SPAN><\/P>
\n

NON_AWR 1.2 SYS.SYS_LOB0000065853C00004$$ LOBSEGMENT <\/SPAN><\/P>
\n

NON_AWR 1.2 ORDDATA.SYS_LOB0000059475C00005$$ LOBSEGMENT <\/SPAN><\/P>
\n

NON_AWR 1.0 SYS.SYS$SERVICE_METRICS_TAB TABLE <\/SPAN><\/P>
\n

NON_AWR 1.0 XDB.XDB$H_LINK TABLE <\/SPAN><\/P>
\n

NON_AWR 0.9 SYS.I_WRI$_OPTSTAT_HH_ST INDEX <\/SPAN><\/P>
\n

NON_AWR 0.9 SYSMAN.MGMT_METRICS_IDX_01 INDEX <\/SPAN><\/P>
\n

NON_AWR 0.9 SYSMAN.MGMT_METRICS_PK INDEX <\/SPAN><\/P>
\n

NON_AWR 0.9 SYSMAN.MGMT_METRICS_IDX_03 INDEX <\/SPAN><\/P>
\n

NON_AWR 0.8 SYS.I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX <\/SPAN><\/P>
\n

NON_AWR 0.8 APEX_030200.WWV_FLOW_STEP_VALIDATIONS TABLE <\/SPAN><\/P>
\n

NON_AWR 0.8 XDB.XDB$RESOURCE_ACLOID_IDX INDEX <\/SPAN><\/P>
\n

NON_AWR 0.8 APEX_030200.WWV_FLOW_LIST_ITEMS TABLE <\/SPAN><\/P>
\n

NON_AWR 0.7 APEX_030200.WWV_FLOW_STEPS TABLE <\/SPAN><\/P>
\n

NON_AWR 0.6 XDB.XDB$COMPLEX_TYPE TABLE <\/SPAN><\/P>
\n

NON_AWR 0.6 APEX_030200.WWV_FLOW_STEP_ITEMS_U_NAME INDEX <\/SPAN><\/P>
\n

NON_AWR 0.6 XDB.XDB_PK_H_LINK INDEX <\/SPAN><\/P>
\n

NON_AWR 0.6 APEX_030200.WWV_FLOW_STEP_BRANCHES TABLE <\/SPAN><\/P>
\n

NON_AWR 0.6 APEX_030200.WWV_FLOW_STEP_BUTTONS TABLE <\/SPAN><\/P>
\n

   <\/P>
\n

COMPONENT MB SEGMENT_NAME SEGMENT_TYPE <\/SPAN><\/P>
\n

——— ——— ——————————————————————— ————— <\/SPAN><\/P>
\n

NON_AWR 0.6 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY TABLE <\/SPAN><\/P>
\n

NON_AWR 0.6 APEX_030200.SYS_LOB0000072729C00010$$ LOBSEGMENT <\/SPAN><\/P>
\n

NON_AWR 0.6 SYS.SYS_LOB0000006331C00004$$ LOBSEGMENT <\/SPAN><\/P>
\n

NON_AWR 0.6 SYSMAN.MGMT_POLICIES TABLE <\/SPAN><\/P>
\n

NON_AWR 0.6 SYS.AW_OBJ$ TABLE <\/SPAN><\/P>
\n

NON_AWR 0.5 SYSMAN.MGMT_JOB_STEP_PARAMS TABLE <\/SPAN><\/P>
\n

NON_AWR 0.5 SYSMAN.MGMT_IP_REPORT_ELEM_PARAMS TABLE <\/SPAN><\/P>
\n

NON_AWR 0.5 APEX_030200.WWV_FLOW_LIST_OF_VALUES_DATA TABLE <\/SPAN><\/P>
\n

NON_AWR 0.5 SYSMAN.PK_MGMT_JOB_STEP_PARAMS INDEX <\/SPAN><\/P>
\n

NON_AWR 0.5 SYS.SYS_LOB0000005097C00005$$ LOBSEGMENT <\/SPAN><\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(5a) AWR snapshots – last 50 <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

Total snapshots in DB 1232455262 Instance 1 = 4 <\/SPAN><\/P>
\n

   <\/P>
\n

DBID SNAP_ID INST FLUSH_ELAPSED ENDTM STARTUP_TIME STATUS ERRCNT <\/SPAN><\/P>
\n

———- ———- —– ——————– —————– —————– —— —— <\/SPAN><\/P>
\n

1232455262 84 1 +00000 00:00:09.6 21:34:47 (01\/01) 21:24:42 (01\/01) 0 0 <\/SPAN><\/P>
\n

1232455262 85 1 +00000 00:00:05.7 23:00:50 (01\/01) 21:41:34 (01\/01) 0 0 <\/SPAN><\/P>
\n

1232455262 86 1 +00000 00:00:01.0 00:00:06 (01\/02) 21:41:34 (01\/01) 0 0 <\/SPAN><\/P>
\n

1232455262 87 1 +00000 00:00:05.3 12:34:16 (01\/02) 12:23:21 (01\/02) 0 0 <\/SPAN><\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(5b) AWR snapshots with errors or invalid <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

no rows selected <\/SPAN><\/P>
\n

   <\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(5c) AWR snapshots — OLDEST Non-Baselined snapshots <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

DBID INST SNAP_ID ENDTM STATUS ERROR_COUNT <\/SPAN><\/P>
\n

———- —– ———- —————– —— ———– <\/SPAN><\/P>
\n

1232455262 1 84 21:34:47 (01\/01) 0 0 <\/SPAN><\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(6) AWR Control Settings – interval, retention <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

DBID LSNAPID LSPLITID LSNAPTIME LPURGETIME FLAG INTERVAL RETENTION VRSN <\/SPAN><\/P>
\n

———– ——– ——– ————– ————– —– —————– —————– —- <\/SPAN><\/P>
\n

1232455262 87 78 01\/02 12:34:22 01\/01 22:11:32 2 +00000 01:00:00.0 +00008 00:00:00.0 5 <\/SPAN><\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(7a) AWR Contents – row counts for each snapshots <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

SNAP_ID INST ASH SQL SQBND FILES SEGST SYSEVT <\/SPAN><\/P>
\n

———- —– ———- ———- ———- ———- ———- ———- <\/SPAN><\/P>
\n

84 1 10 296 523 12 103 42 <\/SPAN><\/P>
\n

85 1 175 301 835 12 123 62 <\/SPAN><\/P>
\n

86 1 42 173 452 12 128 64 <\/SPAN><\/P>
\n

87 1 37 326 878 12 109 73 <\/SPAN><\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(7b) AWR Contents – average row counts per snapshot <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

SNAP_COUNT INST ASH SQLSTAT SQLBIND FILES SEGSTAT SYSEVENT <\/SPAN><\/P>
\n

———- —– ———- ———- ———- ———- ———- ———- <\/SPAN><\/P>
\n

4 1 66 274 672 12 115.75 60.25 <\/SPAN><\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(7c) AWR total item counts – names, text, plans <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

SQLTEXT SQLPLAN SQLBMETA SEGOBJ DATAFILE TEMPFILE <\/SPAN><\/P>
\n

———- ———- ———- ———- ———- ———- <\/SPAN><\/P>
\n

1167 17898 4723 403 12 1 <\/SPAN><\/P>
\n

   <\/P>
\n

   <\/P>
\n

######################################################## <\/SPAN><\/P>
\n

(II) Advisor Framework Info <\/SPAN><\/P>
\n

######################################################## <\/SPAN><\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(1) Advisor Tasks – Last 50 <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

OWNER\/ADVISOR TASK_ID\/NAME CREATED EXE_DURATN EXE_CREATN HOW_C STATUS <\/SPAN><\/P>
\n

————– ——————————– —————- ———- ———- —– ———— <\/SPAN><\/P>
\n

SYS\/SQL Tuning 1\/SYS_AUTO_SQL_TUNING_TASK 09:52:13 (09\/17) 16 ########## AUTO COMPLETED <\/SPAN><\/P>
\n

SYS\/Segment Ad 193\/SYS_AUTO_SPCADV_190022010120 22:00:19 (01\/01) 170 171 CMD COMPLETED <\/SPAN><\/P>
\n

16 <\/SPAN><\/P>
\n

   <\/P>
\n

SYS\/ADDM 194\/ADDM:1232455262_1_86 00:00:08 (01\/02) 0 0 AUTO COMPLETED <\/SPAN><\/P>
\n

SYS\/Segment Ad 203\/SYS_AUTO_SPCADV_192412020120 12:24:19 (01\/02) 3 4 CMD COMPLETED <\/SPAN><\/P>
\n

16 <\/SPAN><\/P>
\n

   <\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(2) Advisor Task – Oldest 5 <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

OWNER\/ADVISOR TASK_ID\/NAME CREATED EXE_DURATN EXE_CREATN HOW_C STATUS <\/SPAN><\/P>
\n

————– ——————————– —————- ———- ———- —– ———— <\/SPAN><\/P>
\n

SYS\/SQL Tuning 1\/SYS_AUTO_SQL_TUNING_TASK 09:52:13 (09\/17) 16 ########## AUTO COMPLETED <\/SPAN><\/P>
\n

SYS\/Segment Ad 193\/SYS_AUTO_SPCADV_190022010120 22:00:19 (01\/01) 170 171 CMD COMPLETED <\/SPAN><\/P>
\n

16 <\/SPAN><\/P>
\n

   <\/P>
\n

SYS\/ADDM 194\/ADDM:1232455262_1_86 00:00:08 (01\/02) 0 0 AUTO COMPLETED <\/SPAN><\/P>
\n

SYS\/Segment Ad 203\/SYS_AUTO_SPCADV_192412020120 12:24:19 (01\/02) 3 4 CMD COMPLETED <\/SPAN><\/P>
\n

16 <\/SPAN><\/P>
\n

   <\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(3) Advisor Tasks With Errors – Last 50 <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

no rows selected <\/SPAN><\/P>
\n

   <\/P>
\n

   <\/P>
\n

   <\/P>
\n

######################################################## <\/SPAN><\/P>
\n

(III) ASH Usage Info <\/SPAN><\/P>
\n

######################################################## <\/SPAN><\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(1a) ASH histogram (past 3 days) <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

NUM_ACTIVE_SESSIONS NUM_SAMPLES <\/SPAN><\/P>
\n

——————– ———— <\/SPAN><\/P>
\n

0000 – 0004 163 <\/SPAN><\/P>
\n

0005 – 0009 2 <\/SPAN><\/P>
\n

0010 – 0014 1 <\/SPAN><\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(1b) ASH histogram (past 1 day) <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

NUM_ACTIVE_SESSIONS NUM_SAMPLES <\/SPAN><\/P>
\n

——————– ———— <\/SPAN><\/P>
\n

0000 – 0004 163 <\/SPAN><\/P>
\n

0005 – 0009 2 <\/SPAN><\/P>
\n

0010 – 0014 1 <\/SPAN><\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(2a) ASH details (past 3 days) <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

INST MIN_TIME MAX_TIME NUM_SAMPLES NUM_ROWS AVG_ACTIVE <\/SPAN><\/P>
\n

—- —————- —————- ———— ———— ———- <\/SPAN><\/P>
\n

1 21:41:40 (01\/01) 12:31:24 (01\/02) 872 254 0.29 <\/SPAN><\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(2b) ASH details (past 1 day) <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

INST MIN_TIME MAX_TIME NUM_SAMPLES NUM_ROWS AVG_ACTIVE <\/SPAN><\/P>
\n

—- —————- —————- ———— ———— ———- <\/SPAN><\/P>
\n

1 21:41:40 (01\/01) 12:31:24 (01\/02) 872 254 0.29 <\/SPAN><\/P>
\n

   <\/P>
\n

********************************** <\/SPAN><\/P>
\n

(2c) ASH sessions (Fg Vs Bg) (past 1 day across all instances in RAC) <\/SPAN><\/P>
\n

********************************** <\/SPAN><\/P>
\n

   <\/P>
\n

Foreground % 24.8 <\/SPAN><\/P>
\n

Background % 75.2 <\/SPAN><\/P>
\n

MMNL % 0.0 <\/SPAN><\/P>
\n

   <\/P>
\n

End of Report <\/SPAN><\/P>
\n

  <\/SPAN> <\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

$ORACLE_HOME\/rdbms\/admin\/awrinfo.sql awrinfo.sql\uc744 \ud1b5\ud574 AWR\uc5d0 \uc800\uc7a5\ub41c \uc815\ubcf4\ub97c \ud655\uc778 \ud560 \uc218 \uc788\ub2e4. (\uc5d0\ub7ec \uc815\ubcf4, \ud604\uc7ac \uc124\uc815 \uc815\ubcf4(interval, \ubcf4\uc874 \uae30\uac04 \ub4f1), \uc720\uc800 \ubcc4 SYSAUX \uc0ac\uc6a9 \uc815\ubcf4 \ub4f1)         \uc804\ubb38 ~~~~~~~~~~~~~~~ AWR INFO Report ~~~~~~~~~~~~~~~     Report generated at 13:23:05 on Jan 02, 2016 ( Saturday ) in Timezone +09:00     Warning: Non Default […]<\/p>\n","protected":false},"author":1,"featured_media":1070,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[3],"tags":[567,568],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile1.uf.2444A9425687550832FAF9.png?fit=744%2C467","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1069"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1069"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1069\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1070"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1069"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1069"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1069"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}