Oracle AWRINFO_UTIL
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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 10gR1
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
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

Related Topics
AWR Report
Built-in Functions
Built-in Packages
DBMS_AWR_REPORT_LAYOUT
DBMS_WORKLOAD_REPOSITORY
UTLSYXSZ_UTIL
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx