Oracle | AWRINFO

Oracle AWRINFO_UTIL Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose This is one of only two packages I have found in the Oracle database that is non-persistent. By that I mean Oracle builds it on the fly, uses it to create a single report, and then drops it.

The script, utilizing this package, estimates the amount of space required for the SYSAUX tablespace. It estimates based on the number of active sessions, files, tables, indexes, and other factors including ASH and AWR data.

If you edit the script and remove the DROP PACKAGE you will have it in your database for your own use whenever you wish.

The source file describes this package as follows:
"his script will output general Automatic Workload Repository (AWR) information such as the size, data distribution, etc. in AWR and SYSAUX. The intended use of this script is for diagnosing abnormalities in AWR and not for diagnosing issues in the database instance. Please look at addmrpt.sql and awrrpt.sql for diagnosing database issues."

Remember: With Container architecture, the database has one SYSAUX tablespace per container.

AUTHID DEFINER

Dependencies

DBMS_SPACE

Documented No

First Available 10.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/awrinfo.sql

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: 
      /home/oracle/awrinfo.out

Subprograms

CLASSIFY_COUNT	GET_TYPE	AWRINFO.SQL Report
GET_PERC_USAGE

CLASSIFY_COUNT

Returns the classify count awrinfo_util.classify_count(cnt IN NUMBER) RETURN VARCHAR2;

SELECT awrinfo_util.classify_count(42)

      FROM dual;

      

      AWRINFO_UTIL.CLASSIFY_COUNT(42)

      ---------------------------------------------

      0040 - 0044

      

      SELECT awrinfo_util.classify_count(100)

      FROM dual;

      

      AWRINFO_UTIL.CLASSIFY_COUNT(100)

      ---------------------------------------------

      0100 - 0104

GET_PERC_USAGE

Returns the percentage of AWR space utilized

This clearly does not indicate the percentage of the AWR so its purpose is unclear awrinfo_util.get_perc_usage( segment_owner IN VARCHAR2, segment_name IN VARCHAR2, segment_type IN VARCHAR2, partition_name IN VARCHAR2) RETURN NUMBER;

SELECT awrinfo_util.get_perc_usage('SYS', 'WRI$_TOPN_METADATA', 'TABLE', NULL)

      FROM dual;

      

      
      AWRINFO_UTIL.GET_PERC_USAGE('SYS','WRI$_TOPN_METADATA','TABLE',NULL)

      --------------------------------------------------------------------

                                                               32.3364258

GET_TYPE

Returns the AWR table type awrinfo_util.get_type(segment_name IN VARCHAR2) RETURN VARCHAR2;

SELECT awrinfo_util.get_type('WRH$_ACTIVE_SESSION_HISTORY')

      FROM dual;

      

      AWRINFO_UTIL.GET_TYPE('WRH$_ACTIVE_SESSION_HISTORY')

      -----------------------------------------------------

      ASH

      

      SELECT awrinfo_util.get_type('WRI$_TOPN_METADATA')

      FROM dual;

      

      AWRINFO_UTIL.GET_TYPE('WRI$_TOPN_METADATA')

      ------------------------------------------------------

      FIXED

AWRINFO.SQL Report

Report produced by running the awrinfo.sql script -- before logging into SQL*Plus, edit the source script -- $ORACLE_HOME/rdbms/admin/awrinfo.sql, line 1346, and comment out the "DROP PACKAGE" -- line. This demo was run on a Windows laptop used at Oracle conferences for live demos -- so the number of tables and user is quite low and some of the defaults optimized using -- the DBMS_WORKLOAD_REPOSITORY package. conn / as sysdba set define on set define on @?/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: c:\temp\awrinfo.txt Using the report name c:\temp\awrinfo.txt ~~~~~~~~~~~~~~~ AWR INFO Report ~~~~~~~~~~~~~~~ Report generated at 01:22:15 on Jun 21, 2021 ( Monday ) in Timezone +00:00 Warning: Abnormal ASH Status! -------------------------------------------------------------------------------- Enabled (Latest flush had errors) DB_ID DB_NAME HOST_PLATFORM INST STARTUP_TIME LAST_ASH_SID RAC VERSION ------------ --------- ------------------------- ---- ---------------- ------------ --- ---------- * 2140826538 TEST21DB test21 - Linux x86 64-bit 1 02:22:01 (01/17) 12601841 NO 21.0.0.0.0 ######################################################## (I) AWR Snapshots Information ######################################################## ***************************************************** (1a) SYSAUX usage - Schema breakdown (dba_segments) ***************************************************** | | Total SYSAUX size 1,921.8 MB ( 6% of 32,768.0 MB MAX with AUTOEXTEND ON ) | | Schema SYS occupies 1,535.2 MB ( 79.9% ) | Schema MDSYS occupies 169.9 MB ( 8.8% ) | Schema XDB occupies 102.4 MB ( 5.3% ) | Schema AUDSYS occupies 81.6 MB ( 4.2% ) | Schema SYSTEM occupies 13.1 MB ( 0.7% ) | Schema WMSYS occupies 7.3 MB ( 0.4% ) | Schema DVSYS occupies 4.6 MB ( 0.2% ) | Schema CTXSYS occupies 2.8 MB ( 0.1% ) | Schema C##UWCLASS occupies 2.7 MB ( 0.1% ) | Schema GSMADMIN_INT occupies 1.3 MB ( 0.1% ) | Schema DBSNMP occupies 0.9 MB ( 0.0% ) | ******************************************************** (1b) SYSAUX occupants space usage (v$sysaux_occupants) ******************************************************** | | Occupant Name Schema Name Space Usage | -------------------- -------------------- ------------ | SM/AWR SYS 548.8 MB | SM/OPTSTAT SYS 395.1 MB | SDO MDSYS 169.9 MB | SM/OTHER SYS 136.2 MB | XDB XDB 102.4 MB | AUDSYS AUDSYS 81.6 MB | SM/ADVISOR SYS 62.1 MB | AO SYS 48.4 MB | LOGMNR SYSTEM 11.0 MB | JOB_SCHEDULER SYS 7.7 MB | WM WMSYS 7.3 MB | SQL_MANAGEMENT_BASE SYS 3.8 MB | SMON_SCN_TIME SYS 3.3 MB | PL/SCOPE SYS 3.0 MB | TEXT CTXSYS 2.8 MB | STREAMS SYS 1.9 MB | LOGSTDBY SYSTEM 1.8 MB | EM_MONITORING_USER DBSNMP 0.9 MB | AUTO_TASK SYS 0.7 MB | AUDIT_TABLES SYS 0.0 MB | EM SYSMAN 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 | 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 | XSOQHIST SYS 0.0 MB | | Others (Unaccounted space) 333.0 MB | ****************************************** (1c) SYSAUX usage - Unregistered Schemas ****************************************** | This section displays schemas that are not registered | in V$SYSAUX_OCCUPANTS | | Schema DVSYS occupies 4.6 MB | Schema C##UWCLASS occupies 2.7 MB | Schema GSMADMIN_INT occupies 1.3 MB | | Total space 8.5 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 324.5 MB | | Total space 324.5 MB | begin * ERROR at line 1: ORA-01403: no data found ORA-06512: at line 21 ********************************** (3a) Space usage by AWR components (per database) ********************************** COMPONENT MB % AWR KB_PER_SNAP MB_PER_DAY MB_PER_WEEK TABLE% : INDEX% --------- ------- ------ ------------ ---------- ----------- ---------------- FIXED 362.6 66.1 45% : 55% EVENTS 95.4 17.4 43% : 57% SQLPLAN 34.4 6.3 68% : 32% SPACE 24.3 4.4 50% : 50% SQL 15.1 2.8 53% : 47% SQLTEXT 8.0 1.5 84% : 16% SQLBIND 3.4 0.6 41% : 59% ASH 2.8 0.5 70% : 30% RAC 2.8 0.5 50% : 50% ********************************** (3b) Space usage within AWR Components (> 500K) ********************************** COMPONENT MB SEGMENT_NAME - % SPACE_USED SEGMENT_TYPE --------- ---- ------------------------------------------------------------------- --------------- FIXED 4.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_2140826538_3415 - 71% INDEX PARTITION FIXED 4.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_2140826538_3391 - 68% INDEX PARTITION FIXED 4.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_2140826538_3367 - 77% INDEX PARTITION FIXED 4.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_2140826538_3343 - 74% INDEX PARTITION FIXED 4.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_2140826538_3319 - 68% INDEX PARTITION FIXED 4.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_2140826538_3489 - 68% INDEX PARTITION FIXED 4.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_2140826538_3465 - 77% INDEX PARTITION FIXED 4.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_2140826538_3441 - 78% INDEX PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_2140826538_3489 - 58% TABLE PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_214082653 - 64% INDEX PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_214082653 - 64% INDEX PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_214082653 - 64% INDEX PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_214082653 - 64% INDEX PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_214082653 - 64% INDEX PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_214082653 - 64% INDEX PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_214082653 - 64% INDEX PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_214082653 - 64% INDEX PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_214082653 - 70% INDEX PARTITION FIXED 3.0 WRH$_SYSSTAT.WRH$_SYSSTAT_2140826538_3319 - 58% TABLE PARTITION FIXED 3.0 WRH$_SYSSTAT.WRH$_SYSSTAT_2140826538_3343 - 58% TABLE PARTITION FIXED 3.0 WRH$_SYSSTAT.WRH$_SYSSTAT_2140826538_3367 - 55% TABLE PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_2140826538_3465 - 55% TABLE PARTITION FIXED 3.0 WRH$_SYSSTAT.WRH$_SYSSTAT_2140826538_3391 - 58% TABLE PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_2140826538_3415 - 55% TABLE PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_2140826538_3391 - 58% TABLE PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_2140826538_3367 - 55% TABLE PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_2140826538_3343 - 58% TABLE PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_2140826538_3319 - 57% TABLE PARTITION FIXED 3.0 WRH$_LATCH.WRH$_LATCH_2140826538_3441 - 60% TABLE PARTITION FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_2140826538_3441 - 55% TABLE PARTITION EVENTS 4.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_2140826538_3319 - 68% INDEX PARTITION EVENTS 4.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_2140826538_3343 - 80% INDEX PARTITION EVENTS 4.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_2140826538_3367 - 80% INDEX PARTITION EVENTS 4.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_2140826538_3391 - 69% INDEX PARTITION EVENTS 4.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_2140826538_3415 - 72% INDEX PARTITION EVENTS 4.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_2140826538_3441 - 80% INDEX PARTITION EVENTS 4.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_2140826538_3465 - 80% INDEX PARTITION EVENTS 4.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_2140826538_3489 - 73% INDEX PARTITION EVENTS 3.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_2140826538_3319 - 62% TABLE PARTITION EVENTS 3.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_2140826538_3343 - 54% TABLE PARTITION EVENTS 3.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_2140826538_3367 - 52% TABLE PARTITION EVENTS 3.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_2140826538_3391 - 59% TABLE PARTITION EVENTS 3.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_2140826538_3415 - 57% TABLE PARTITION EVENTS 3.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_2140826538_3441 - 64% TABLE PARTITION EVENTS 3.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_2140826538_MXSN - 75% INDEX PARTITION EVENTS 3.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_2140826538_3465 - 53% TABLE PARTITION EVENTS 3.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_2140826538_3489 - 56% TABLE PARTITION COMPONENT MB SEGMENT_NAME - % SPACE_USED SEGMENT_TYPE --------- ---- ------------------------------------------------------------------- --------------- EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_2140826538_MXSN - 92% TABLE PARTITION EVENTS 0.7 WRH$_CON_SYSTEM_EVENT_PK.WRH$_CON_SYSTEM_EVENT_2140826538_344 - 70% INDEX PARTITION EVENTS 0.6 WRH$_CON_SYSTEM_EVENT_PK.WRH$_CON_SYSTEM_EVENT_2140826538_331 - 68% INDEX PARTITION EVENTS 0.6 WRH$_CON_SYSTEM_EVENT_PK.WRH$_CON_SYSTEM_EVENT_2140826538_348 - 67% INDEX PARTITION EVENTS 0.6 WRH$_CON_SYSTEM_EVENT_PK.WRH$_CON_SYSTEM_EVENT_2140826538_346 - 67% INDEX PARTITION EVENTS 0.6 WRH$_CON_SYSTEM_EVENT_PK.WRH$_CON_SYSTEM_EVENT_2140826538_341 - 69% INDEX PARTITION EVENTS 0.6 WRH$_CON_SYSTEM_EVENT_PK.WRH$_CON_SYSTEM_EVENT_2140826538_339 - 69% INDEX PARTITION EVENTS 0.6 WRH$_CON_SYSTEM_EVENT_PK.WRH$_CON_SYSTEM_EVENT_2140826538_334 - 69% INDEX PARTITION EVENTS 0.6 WRH$_CON_SYSTEM_EVENT_PK.WRH$_CON_SYSTEM_EVENT_2140826538_336 - 69% INDEX PARTITION EVENTS 0.6 WRH$_CON_SYSTEM_EVENT.WRH$_CON_SYSTEM_EVENT_2140826538_3343 - 74% TABLE PARTITION EVENTS 0.6 WRH$_CON_SYSTEM_EVENT.WRH$_CON_SYSTEM_EVENT_2140826538_3319 - 74% TABLE PARTITION EVENTS 0.6 WRH$_CON_SYSTEM_EVENT.WRH$_CON_SYSTEM_EVENT_2140826538_3391 - 74% TABLE PARTITION EVENTS 0.6 WRH$_CON_SYSTEM_EVENT.WRH$_CON_SYSTEM_EVENT_2140826538_3367 - 74% TABLE PARTITION SQLPLAN 6.0 WRH$_SQL_PLAN.WRH$_SQL_PLAN_2140826538_3491 - 82% TABLE PARTITION SQLPLAN 5.0 WRH$_SQL_PLAN.WRH$_SQL_PLAN_2140826538_3515 - 64% TABLE PARTITION SQLPLAN 3.0 WRH$_SQL_PLAN_PK.WRH$_SQL_PLAN_2140826538_3515 - 57% INDEX PARTITION SQLPLAN 3.0 WRH$_SQL_PLAN_PK.WRH$_SQL_PLAN_2140826538_3491 - 67% INDEX PARTITION SQLPLAN 3.0 WRH$_SQL_PLAN.WRH$_SQL_PLAN_2140826538_3441 - 34% TABLE PARTITION SQLPLAN 2.0 WRH$_SQL_PLAN.WRH$_SQL_PLAN_2140826538_3345 - 11% TABLE PARTITION SQLPLAN 2.0 WRH$_SQL_PLAN.WRH$_SQL_PLAN_2140826538_3297 - 3% TABLE PARTITION SQLPLAN 1.0 WRH$_SQL_PLAN_PK.WRH$_SQL_PLAN_2140826538_3441 - 58% INDEX PARTITION SQLPLAN 1.0 WRH$_SQL_PLAN.WRH$_SQL_PLAN_2140826538_3369 - 31% TABLE PARTITION SQLPLAN 1.0 WRH$_SQL_PLAN.WRH$_SQL_PLAN_2140826538_3417 - 40% TABLE PARTITION SQLPLAN 0.8 WRH$_SQL_PLAN.WRH$_SQL_PLAN_2140826538_3539 - 83% TABLE PARTITION SQLPLAN 0.8 WRH$_SQL_PLAN.WRH$_SQL_PLAN_2140826538_3465 - 48% TABLE PARTITION SQLPLAN 0.7 WRH$_SQL_PLAN.WRH$_SQL_PLAN_2140826538_3393 - 19% TABLE PARTITION SQLPLAN 0.6 WRH$_SQL_PLAN.WRH$_SQL_PLAN_2140826538_3321 - 25% TABLE PARTITION SQLPLAN 0.6 WRH$_SQL_PLAN.WRH$_SQL_PLAN_2140826538_MXSN - 80% TABLE PARTITION SQLPLAN 0.6 WRH$_SQL_PLAN_PK.WRH$_SQL_PLAN_2140826538_3369 - 51% INDEX PARTITION SQLPLAN 0.5 WRH$_SQL_PLAN_PK.WRH$_SQL_PLAN_2140826538_3345 - 47% INDEX PARTITION SQLPLAN 0.5 WRH$_SQL_PLAN_PK.WRH$_SQL_PLAN_2140826538_3417 - 53% INDEX PARTITION SQLPLAN 0.5 WRH$_SQL_PLAN_PK.WRH$_SQL_PLAN_2140826538_3297 - 38% INDEX PARTITION SPACE 0.5 WRH$_SEG_STAT.WRH$_SEG_STAT_2140826538_3441 - 73% TABLE PARTITION SQL 0.8 WRH$_SQLSTAT.WRH$_SQLSTAT_2140826538_3391 - 79% TABLE PARTITION SQL 0.8 WRH$_SQLSTAT.WRH$_SQLSTAT_2140826538_3441 - 78% TABLE PARTITION SQL 0.7 WRH$_SQLSTAT.WRH$_SQLSTAT_2140826538_3415 - 90% TABLE PARTITION SQL 0.6 WRH$_SQLSTAT.WRH$_SQLSTAT_2140826538_3465 - 75% TABLE PARTITION SQL 0.6 WRH$_SQLSTAT.WRH$_SQLSTAT_2140826538_3367 - 73% TABLE PARTITION SQL 0.6 WRH$_SQLSTAT.WRH$_SQLSTAT_2140826538_3319 - 74% TABLE PARTITION SQL 0.6 WRH$_SQLSTAT.WRH$_SQLSTAT_2140826538_3489 - 84% TABLE PARTITION SQL 0.6 WRH$_SQLSTAT.WRH$_SQLSTAT_2140826538_3343 - 90% TABLE PARTITION SQL 0.5 WRH$_SQLSTAT.WRH$_SQLSTAT_2140826538_MXSN - 72% TABLE PARTITION SQLTEXT 4.0 WRH$_SQLTEXT.WRH$_SQLTEXT_2140826538_3297 - 88% TABLE PARTITION SQLTEXT 0.5 WRH$_SQLTEXT_PK.WRH$_SQLTEXT_2140826538_3297 - 63% INDEX PARTITION SQLTEXT 0.5 WRH$_SQLTEXT.WRH$_SQLTEXT_2140826538_3491 - 39% TABLE PARTITION ********************************** (4) Space usage by non-AWR components (> 500K) ********************************** COMPONENT MB SEGMENT_NAME SEGMENT_TYPE --------- ------ ---------------------------------------------- ----------------- NON_AWR 176.0 SYS.I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX NON_AWR 88.0 SYS.I_WRI$_OPTSTAT_H_ST INDEX NON_AWR 64.3 SYS.SYS_LOB0000009564C00039$$ LOBSEGMENT NON_AWR 56.3 MDSYS.SYS_LOB0000067845C00006$$ LOBSEGMENT NON_AWR 56.3 MDSYS.SYS_LOB0000067945C00006$$ LOBSEGMENT NON_AWR 24.3 SYS.SYS_LOB0000007725C00005$$ LOBSEGMENT NON_AWR 24.3 AUDSYS.SYS_LOB0000019845C00030$$.SYS_LOB_P522 LOB PARTITION NON_AWR 24.3 SYS.SYS_LOB0000066974C00004$$ LOBSEGMENT NON_AWR 19.0 SYS.I_ACTIVITY_TABLE$_OBJ INDEX NON_AWR 19.0 SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST INDEX NON_AWR 16.3 SYS.SYS_LOB0000007725C00004$$ LOBSEGMENT NON_AWR 16.3 SYS.SYS_LOB0000011802C00038$$.SYS_LOB_P4047 LOB PARTITION NON_AWR 16.3 SYS.SYS_LOB0000011802C00038$$.SYS_LOB_P4021 LOB PARTITION NON_AWR 16.3 MDSYS.SYS_LOB0000070507C00002$$ LOBSEGMENT NON_AWR 16.3 SYS.SYS_LOB0000008931C00040$$ LOBSEGMENT NON_AWR 13.0 SYS.WRI$_SQLSET_PLAN_LINES TABLE NON_AWR 12.0 SYS.WRI$_ADV_SQLT_PLANS TABLE NON_AWR 12.0 AUDSYS.AUD$UNIFIED.SYS_P521 TABLE PARTITION NON_AWR 9.0 SYS.WRI$_OPTSTAT_OPR_TASKS TABLE NON_AWR 9.0 SYS.I_WRI$_OPTSTAT_HH_ST INDEX NON_AWR 9.0 MDSYS.EXT_TAB_CS_SRS TABLE NON_AWR 9.0 MDSYS.SDO_CS_SRS TABLE NON_AWR 7.3 SYS.SYS_LOB0000066959C00004$$ LOBSEGMENT NON_AWR 7.3 SYS.SYS_LOB0000011802C00038$$.SYS_LOB_P3966 LOB PARTITION NON_AWR 6.0 SYS.I_WRI$_OPTSTAT_OPR_TASKS_TGST INDEX NON_AWR 5.3 SYS.SYS_LOB0000010858C00001$$ LOBSEGMENT NON_AWR 5.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4306 TABLE PARTITION NON_AWR 4.3 SYS.SYS_LOB0000066954C00004$$ LOBSEGMENT NON_AWR 4.3 SYS.SYS_LOB0000011782C00004$$.SYS_LOB_P3821 LOB PARTITION NON_AWR 4.0 SYS.WRI$_ADV_RATIONALE TABLE NON_AWR 4.0 SYS.WRI$_ADV_PARAMETERS_PK INDEX NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4405 TABLE PARTITION NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4301 TABLE PARTITION NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4264 TABLE PARTITION NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4259 TABLE PARTITION NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4208 TABLE PARTITION NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4203 TABLE PARTITION NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4368 TABLE PARTITION NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4363 TABLE PARTITION NON_AWR 4.0 SYS.SCHEDULER$_EVENT_LOG TABLE NON_AWR 3.3 SYS.SYS_LOB0000066964C00004$$ LOBSEGMENT NON_AWR 3.3 SYS.SYS_LOB0000011802C00038$$.SYS_LOB_P4069 LOB PARTITION NON_AWR 3.3 SYS.SYS_LOB0000011802C00038$$.SYS_LOB_P3988 LOB PARTITION NON_AWR 3.3 SYS.SYS_LOB0000011802C00038$$.SYS_LOB_P3935 LOB PARTITION NON_AWR 3.3 SYS.SYS_LOB0000011802C00038$$.SYS_LOB_P3892 LOB PARTITION NON_AWR 3.3 SYS.SYS_LOB0000011802C00038$$.SYS_LOB_P3913 LOB PARTITION NON_AWR 3.3 SYS.SYS_LOB0000011802C00038$$.SYS_LOB_P3869 LOB PARTITION COMPONENT MB SEGMENT_NAME SEGMENT_TYPE --------- ------ ---------------------------------------------- ----------------- NON_AWR 3.3 SYS.SYS_LOB0000011802C00038$$.SYS_LOB_P3825 LOB PARTITION NON_AWR 3.0 SYS.WRI$_ADV_PARAMETERS TABLE NON_AWR 3.0 SYS.SMON_SCN_TO_TIME_AUX CLUSTER NON_AWR 3.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4410 TABLE PARTITION NON_AWR 3.0 SYS.WRI$_SQLSET_PLANS TABLE NON_AWR 2.3 SYS.SYS_LOB0000066969C00004$$ LOBSEGMENT NON_AWR 2.3 SYS.SYS_LOB0000011782C00004$$.SYS_LOB_P4017 LOB PARTITION NON_AWR 2.3 SYS.SYS_LOB0000011802C00038$$.SYS_LOB_P3847 LOB PARTITION NON_AWR 2.3 SYS.SYS_LOB0000011802C00038$$.SYS_LOB_P4070 LOB PARTITION NON_AWR 2.3 SYS.SYS_LOB0000066979C00004$$ LOBSEGMENT NON_AWR 2.0 SYS.WRI$_OPTSTAT_IND_HISTORY TABLE NON_AWR 2.0 SYS.I_WRI$_OPTSTAT_OPR_TASKS_OPOBJ INDEX NON_AWR 2.0 SYS.WRI$_SQLSET_PLAN_LINES_PK INDEX NON_AWR 2.0 SYS.I_WRI$_OPTSTAT_OPR_TASKS_STIME INDEX NON_AWR 2.0 SYS.I_WRI$_OPTSTAT_OPR_TASKS_OPID INDEX NON_AWR 2.0 SYS.I_WRI$_OPTSTAT_IND_OBJ#_ST INDEX NON_AWR 2.0 SYS.I_WRI$_OPTSTAT_TAB_OBJ#_ST INDEX NON_AWR 2.0 C##UWCLASS.UW_CLUSTER CLUSTER NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4280 TABLE PARTITION NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4238 TABLE PARTITION NON_AWR 2.0 MDSYS.EXT_TAB_REF_SYS_1 TABLE NON_AWR 2.0 MDSYS.EXT_TAB_REF_SYS TABLE NON_AWR 2.0 MDSYS.SDO_COORD_REF_SYS TABLE NON_AWR 2.0 SYS.WRI$_ADV_OBJECTS TABLE NON_AWR 1.3 SYS.SYS_LOB0000008873C00014$$ LOBSEGMENT NON_AWR 1.3 SYS.SYS_LOB0000007754C00009$$.SYS_LOB_P4040 LOB PARTITION NON_AWR 1.3 AUDSYS.SYS_LOB0000019845C00030$$.SYS_LOB_P4007 LOB PARTITION NON_AWR 1.3 SYS.SYS_LOB0000011782C00004$$.SYS_LOB_P3843 LOB PARTITION NON_AWR 1.3 SYS.SYS_LOB0000011782C00004$$.SYS_LOB_P3888 LOB PARTITION NON_AWR 1.3 SYS.SYS_LOB0000011782C00004$$.SYS_LOB_P4043 LOB PARTITION NON_AWR 1.3 SYS.SYS_LOB0000011782C00004$$.SYS_LOB_P4065 LOB PARTITION NON_AWR 1.3 SYS.SYS_LOB0000011782C00004$$.SYS_LOB_P3984 LOB PARTITION NON_AWR 1.3 SYS.SYS_LOB0000007754C00009$$.SYS_LOB_P4058 LOB PARTITION NON_AWR 1.3 SYS.SYS_LOB0000011782C00004$$.SYS_LOB_P3962 LOB PARTITION NON_AWR 1.3 SYS.SYS_LOB0000011782C00004$$.SYS_LOB_P3931 LOB PARTITION NON_AWR 1.3 SYS.SYS_LOB0000011782C00004$$.SYS_LOB_P3909 LOB PARTITION NON_AWR 1.3 SYS.SYS_LOB0000007754C00009$$.SYS_LOB_P3946 LOB PARTITION NON_AWR 1.3 SYS.SYS_LOB0000007754C00009$$.SYS_LOB_P3999 LOB PARTITION NON_AWR 1.3 SYS.SYS_LOB0000007754C00009$$.SYS_LOB_P3902 LOB PARTITION NON_AWR 1.3 SYS.SYS_LOB0000007754C00009$$.SYS_LOB_P3977 LOB PARTITION NON_AWR 1.3 SYS.SYS_LOB0000011782C00004$$.SYS_LOB_P3865 LOB PARTITION NON_AWR 1.3 SYS.SYS_LOB0000007754C00009$$.SYS_LOB_P3924 LOB PARTITION NON_AWR 1.3 AUDSYS.SYS_LOB0000019845C00030$$.SYS_LOB_P4309 LOB PARTITION NON_AWR 1.3 MDSYS.SYS_LOB0000073760C00003$$ LOBSEGMENT NON_AWR 1.3 MDSYS.SYS_LOB0000068662C00003$$ LOBSEGMENT NON_AWR 1.3 SYS.SYS_LOB0000009373C00008$$ LOBSEGMENT NON_AWR 1.3 SYS.SYS_LOB0000009377C00005$$ LOBSEGMENT COMPONENT MB SEGMENT_NAME SEGMENT_TYPE --------- ------ ---------------------------------------------- ----------------- NON_AWR 1.3 XDB.SYS_LOB0000023400C00023$$ LOBSEGMENT NON_AWR 1.0 SYS.WRI$_OPTSTAT_TAB_HISTORY TABLE NON_AWR 1.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4349 TABLE PARTITION NON_AWR 1.0 SYS.LTXID_TRANS.LTXID_TRANS_1 TABLE PARTITION NON_AWR 1.0 XDB.XDB$ELEMENT TABLE NON_AWR 1.0 SYS.SYS$SERVICE_METRICS_TAB TABLE ********************************** (5a) AWR snapshots - last 50 ********************************** Total snapshots in DB 2140826538 Instance 1 = 215 DBID SNAP_ID INST FLUSH_ELAPSED ENDTM STARTUP_TIME STATUS ERRCNT ---------- -------- ----- ------------------ ---------------- ---------------- ------- ------- 2140826538 3460 1 +00000 00:00:02.3 19:58:45 (05/04) 02:22:01 (01/17) 0 0 2140826538 3461 1 +00000 00:00:01.4 20:58:49 (05/04) 02:22:01 (01/17) 0 0 2140826538 3462 1 +00000 00:00:01.9 21:58:52 (05/04) 02:22:01 (01/17) 0 0 2140826538 3463 1 +00000 00:00:14.8 22:58:58 (05/04) 02:22:01 (01/17) 0 0 2140826538 3464 1 +00000 00:00:02.1 23:58:02 (05/04) 02:22:01 (01/17) 0 0 2140826538 3465 1 +00000 00:00:02.3 00:58:05 (05/05) 02:22:01 (01/17) 0 0 2140826538 3466 1 +00000 00:00:01.6 01:58:09 (05/05) 02:22:01 (01/17) 0 0 2140826538 3467 1 +00000 00:00:01.7 02:58:12 (05/05) 02:22:01 (01/17) 0 0 2140826538 3468 1 +00000 00:00:01.8 03:58:16 (05/05) 02:22:01 (01/17) 0 0 2140826538 3469 1 +00000 00:00:01.5 04:58:19 (05/05) 02:22:01 (01/17) 0 0 2140826538 3470 1 +00000 00:00:01.4 05:58:22 (05/05) 02:22:01 (01/17) 0 0 2140826538 3471 1 +00000 00:00:01.6 06:58:25 (05/05) 02:22:01 (01/17) 0 0 2140826538 3472 1 +00000 00:00:01.9 07:58:29 (05/05) 02:22:01 (01/17) 0 0 2140826538 3473 1 +00000 00:00:01.5 08:58:32 (05/05) 02:22:01 (01/17) 0 0 2140826538 3474 1 +00000 00:00:01.7 09:58:35 (05/05) 02:22:01 (01/17) 0 0 2140826538 3475 1 +00000 00:00:01.6 10:58:38 (05/05) 02:22:01 (01/17) 0 0 2140826538 3476 1 +00000 00:00:01.4 11:58:42 (05/05) 02:22:01 (01/17) 0 0 2140826538 3477 1 +00000 00:00:02.1 12:58:45 (05/05) 02:22:01 (01/17) 0 0 2140826538 3478 1 +00000 00:00:01.8 13:58:49 (05/05) 02:22:01 (01/17) 0 0 2140826538 3479 1 +00000 00:00:01.6 14:58:52 (05/05) 02:22:01 (01/17) 0 0 2140826538 3480 1 +00000 00:00:01.6 15:58:55 (05/05) 02:22:01 (01/17) 0 0 2140826538 3481 1 +00000 00:00:01.5 16:58:59 (05/05) 02:22:01 (01/17) 0 0 2140826538 3482 1 +00000 00:00:01.2 17:58:02 (05/05) 02:22:01 (01/17) 0 0 2140826538 3483 1 +00000 00:00:01.4 18:58:05 (05/05) 02:22:01 (01/17) 0 0 2140826538 3484 1 +00000 00:00:01.3 19:58:09 (05/05) 02:22:01 (01/17) 0 0 2140826538 3485 1 +00000 00:00:01.4 20:58:12 (05/05) 02:22:01 (01/17) 0 0 2140826538 3486 1 +00000 00:00:01.4 21:58:15 (05/05) 02:22:01 (01/17) 0 0 2140826538 3487 1 +00000 00:00:01.8 22:58:19 (05/05) 02:22:01 (01/17) 0 0 2140826538 3488 1 +00000 00:00:01.9 23:58:23 (05/05) 02:22:01 (01/17) 0 0 2140826538 3489 1 +00000 00:00:02.3 00:58:26 (05/06) 02:22:01 (01/17) 0 0 2140826538 3490 1 +00000 00:00:01.5 01:58:29 (05/06) 02:22:01 (01/17) 0 0 2140826538 3491 1 +00000 00:00:01.4 02:58:33 (05/06) 02:22:01 (01/17) 0 0 2140826538 3492 1 +00000 00:00:01.3 03:58:36 (05/06) 02:22:01 (01/17) 0 0 2140826538 3493 1 +00000 00:00:01.4 04:58:39 (05/06) 02:22:01 (01/17) 0 0 2140826538 3494 1 +00000 00:00:01.6 05:58:43 (05/06) 02:22:01 (01/17) 0 0 2140826538 3495 1 +00000 00:00:02.8 06:58:46 (05/06) 02:22:01 (01/17) 0 0 2140826538 3496 1 +00000 00:00:01.8 07:58:49 (05/06) 02:22:01 (01/17) 0 0 2140826538 3497 1 +00000 00:00:01.7 08:58:53 (05/06) 02:22:01 (01/17) 0 0 2140826538 3498 1 +00000 00:00:01.3 09:58:56 (05/06) 02:22:01 (01/17) 0 0 2140826538 3499 1 +00000 00:00:01.5 10:58:59 (05/06) 02:22:01 (01/17) 0 0 2140826538 3500 1 +00000 00:00:01.5 11:58:02 (05/06) 02:22:01 (01/17) 0 0 2140826538 3501 1 +00000 00:00:01.4 12:58:06 (05/06) 02:22:01 (01/17) 0 0 2140826538 3502 1 +00000 00:00:01.5 13:58:09 (05/06) 02:22:01 (01/17) 0 0 2140826538 3503 1 +00000 00:00:01.4 14:58:13 (05/06) 02:22:01 (01/17) 0 0 2140826538 3504 1 +00000 00:00:01.4 15:58:16 (05/06) 02:22:01 (01/17) 0 0 2140826538 3505 1 +00000 00:00:01.5 16:58:19 (05/06) 02:22:01 (01/17) 0 0 2140826538 3506 1 +00000 00:00:01.3 17:58:23 (05/06) 02:22:01 (01/17) 0 0 DBID SNAP_ID INST FLUSH_ELAPSED ENDTM STARTUP_TIME STATUS ERRCNT ---------- -------- ----- ------------------ ---------------- ---------------- ------- ------- 2140826538 3507 1 +00000 00:00:01.4 18:58:26 (05/06) 02:22:01 (01/17) 0 0 2140826538 3508 1 +00000 00:00:01.5 19:58:29 (05/06) 02:22:01 (01/17) 0 0 2140826538 3509 1 +00000 00:00:01.4 20:58:33 (05/06) 02:22:01 (01/17) 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 ---------- ----- ------- ----------------- ------ ----------- 2140826538 1 3295 00:58:47 (04/28) 0 0 ********************************** (6) AWR Control Settings - interval, retention ********************************** ********************************** (7a) AWR Contents - row counts for each snapshots ********************************** SNAP_ID INST ASH SQL SQBND FILES SEGST SYSEVT ------- ----- --------- ---------- ---------- ------ ------- ------- 3460 1 14 66 634 0 86 212 3461 1 19 71 637 0 79 212 3462 1 8 66 633 0 87 212 3463 1 567 140 906 0 92 212 3464 1 27 71 703 0 82 212 3465 1 14 79 721 0 84 212 3466 1 15 63 630 0 84 212 3467 1 7 71 621 0 84 212 3468 1 14 74 628 0 86 212 3469 1 6 63 625 0 87 212 3470 1 9 63 622 0 86 212 3471 1 13 68 608 0 85 212 3472 1 16 60 614 0 85 212 3473 1 20 70 630 0 77 212 3474 1 6 62 619 0 87 212 3475 1 13 64 624 0 87 212 3476 1 9 61 616 0 86 212 3477 1 18 65 624 0 85 212 3478 1 7 66 627 0 85 212 3479 1 12 68 625 0 79 212 3480 1 13 62 617 0 88 212 3481 1 9 63 626 0 85 212 3482 1 16 62 616 0 86 212 3483 1 9 64 628 0 84 212 3484 1 13 64 595 0 84 212 3485 1 10 69 636 0 80 212 3486 1 15 65 624 0 85 212 3487 1 95 116 2923 0 92 212 3488 1 13 73 638 0 85 212 3489 1 30 77 676 0 85 212 3490 1 11 67 625 0 86 212 3491 1 9 69 616 0 84 212 3492 1 23 74 632 0 87 212 3493 1 17 66 625 0 87 212 3494 1 17 60 611 0 87 212 3495 1 11 67 606 0 87 212 3496 1 11 65 619 0 86 212 3497 1 11 66 608 0 86 212 3498 1 15 62 615 0 87 212 3499 1 11 62 617 0 87 212 3500 1 19 62 620 0 87 212 3501 1 9 62 619 0 87 212 3502 1 13 65 616 0 87 212 3503 1 10 64 617 0 84 212 3504 1 18 67 602 0 87 212 3505 1 11 62 619 0 86 212 3506 1 17 62 617 0 87 212 SNAP_ID INST ASH SQL SQBND FILES SEGST SYSEVT ------- ----- --------- ---------- ---------- ------ ------- ------- 3507 1 10 71 361 0 85 212 3508 1 3 60 613 0 85 212 3509 1 13 65 618 0 87 212 ********************************** (7b) AWR Contents - average row counts per snapshot ********************************** SNAP_COUNT INST ASH SQLSTAT SQLBIND FILES SEGSTAT SYSEVENT ---------- ----- ---------- ---------- ---------- ---------- --------- --------- 215 1 19.27 75.33 764.44 .13 87.9 210.66 **********************************. (7c) AWR total item counts - names, text, plans ********************************** SQLTEXT SQLPLAN SQLBMETA SEGOBJ DATAFILE TEMPFILE -------- -------- --------- ------- --------- --------- 5864 74744 3375 1962 11 6 ######################################################## (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 09:33:46 (11/03) 2 ########## AUTO COMPLETED SYS/SPM Evolve 2/SYS_AUTO_SPM_EVOLVE_TASK 09:33:47 (11/03) AUTO INITIAL SYS/SQL Perfor 4/SYS_AI_VERIFY_TASK 09:33:48 (11/03) AUTO INITIAL SYS/SPM Evolve 3/SYS_AI_SPM_EVOLVE_TASK 09:33:48 (11/03) AUTO INITIAL SYS/SQL Access 5/SYS_AUTO_INDEX_TASK 09:33:48 (11/03) AUTO INITIAL SYS/Zonemap Ad 7/ZMAP_TASK1 09:33:51 (11/03) CMD INITIAL SYS/Statistics 8/AUTO_STATS_ADVISOR_TASK 09:35:00 (11/03) 105 ########## CMD COMPLETED SYS/Statistics 9/INDIVIDUAL_STATS_ADVISOR_TASK 09:35:00 (11/03) CMD SYS/SQL Access 493/SYS_AUTO_MV_TASK 15:32:15 (12/31) AUTO INITIAL ********************************** (2) Advisor Task - Oldest 5 ********************************** OWNER/ADVISOR TASK_ID/NAME CREATED EXE_DURATN EXE_CREATN HOW_C STATUS -------------- -------------------------------- ---------------- ---------- ---------- ----- --------- SYS/SQL Tuning 1/SYS_AUTO_SQL_TUNING_TASK 09:33:46 (11/03) 2 ########## AUTO COMPLETED SYS/SPM Evolve 2/SYS_AUTO_SPM_EVOLVE_TASK 09:33:47 (11/03) AUTO INITIAL SYS/SPM Evolve 3/SYS_AI_SPM_EVOLVE_TASK 09:33:48 (11/03) AUTO INITIAL SYS/SQL Access 5/SYS_AUTO_INDEX_TASK 09:33:48 (11/03) AUTO INITIAL SYS/SQL Perfor 4/SYS_AI_VERIFY_TASK 09:33:48 (11/03) AUTO INITIAL SYS/Zonemap Ad 7/ZMAP_TASK1 09:33:51 (11/03) CMD INITIAL SYS/Statistics 8/AUTO_STATS_ADVISOR_TASK 09:35:00 (11/03) 105 ########## CMD COMPLETED SYS/Statistics 9/INDIVIDUAL_STATS_ADVISOR_TASK 09:35:00 (11/03) CMD SYS/SQL Access 493/SYS_AUTO_MV_TASK 15:32:15 (12/31) AUTO INITIAL ********************************** (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 09:33:47 (11/03) AUTO INITIAL Description: Automatic SPM Evolve Task Error Msg : SYS/SPM Evolve 3/SYS_AI_SPM_EVOLVE_TASK 09:33:48 (11/03) AUTO INITIAL Description: Automatic SPM Evolve Task Error Msg : SYS/SQL Perfor 4/SYS_AI_VERIFY_TASK 09:33:48 (11/03) AUTO INITIAL Description: Error Msg : SYS/SQL Access 5/SYS_AUTO_INDEX_TASK 09:33:48 (11/03) AUTO INITIAL Description: Error Msg : SYS/Zonemap Ad 7/ZMAP_TASK1 09:33:51 (11/03) CMD INITIAL Description: zonemap task Error Msg : SYS/SQL Access 493/SYS_AUTO_MV_TASK 15:32:15 (12/31) AUTO INITIAL Description: Error Msg : ######################################################## (III) ASH Usage Info ######################################################## ********************************** (1a) ASH histogram (past 3 days) ********************************** ********************************** (1b) ASH histogram (past 1 day) ********************************** ********************************** (2a) ASH details (past 3 days) ********************************** ********************************** (2b) ASH details (past 1 day) ********************************** ********************************** (2c) ASH sessions (Fg Vs Bg) (past 1 day across all instances in RAC) ********************************** Foreground % Background % MMNL % End of Report Report written to /home/oracle/awrinfo.out