Oracle AWRINFO_UTIL
Version 19.3

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 12c and above, with the new container architecture, 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
Subprograms
 
CLASSIFY_COUNT
Returns the classify count awrinfo_util.classify_count(cnt IN NUMBER) RETURN VARCHAR2;
SQL> SELECT awrinfo_util.classify_count(42)
  2  FROM dual;

AWRINFO_UTIL.CLASSIFY_COUNT(42)
---------------------------------------------
0040 - 0044

SQL> SELECT awrinfo_util.classify_count(100)
  2 FROM dual;

AWRINFO_UTIL.CLASSIFY_COUNT(100)
---------------------------------------------
0100 - 0104
 
GET_PERC_USAGE
Returns the percentage of AWR space utilized 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', 'TAB$', 'TABLE', NULL)
FROM dual;
 
GET_TYPE
Returns the AWR table type awrinfo_util.get_type(segment_name IN VARCHAR2) RETURN VARCHAR2;
SQL> SELECT awrinfo_util.get_type('WRH$_ACTIVE_SESSION_HISTORY')
  2  FROM dual;

AWRINFO_UTIL.GET_TYPE('WRH$_ACTIVE_SESSION_HISTORY')
-----------------------------------------------------
ASH

SQL> SELECT awrinfo_util.get_type('WRI$_TOPN_METADATA')
  2 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

SQL> set define on
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: c:\temp\awrinfo.txt

Using the report name c:\temp\awrinfo.txt

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


Report generated at
14:17:54 on Sep 03, 2019 ( Tuesday ) in Timezone -05:00

Warning: Non Default AWR Setting!
---------------------------------------------------------
Snapshot interval is 20 minutes and Retention is 32 days


 DB_ID       DB_NAME  HOST_PLATFORM                           INST STARTUP_TIME     LAST_ASH_SID RAC VERSION
------------ -------- --------------------------------------- ---- ---------------- ------------ --- ----------
* 1863203691 ORABASEX PERRITO5 - Microsoft Windows x86 64-bit    1 22:55:27 (09/02) 2517074      NO  19.0.0.0.0

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


*****************************************************
(1a) SYSAUX usage - Schema breakdown (dba_segments)
*****************************************************

|
| Total SYSAUX size              1,960.4 MB ( 6% of 32,768.0 MB MAX with AUTOEXTEND ON )
|
| Schema SYS           occupies  1,693.1 MB ( 86.4% )
| Schema MDSYS         occupies    168.9 MB ( 8.6% )
| Schema XDB           occupies     68.4 MB ( 3.5% )
| Schema SYSTEM        occupies     12.6 MB ( 0.6% )
| Schema WMSYS         occupies      6.6 MB ( 0.3% )
| Schema DVSYS         occupies      4.6 MB ( 0.2% )
| Schema CTXSYS        occupies      2.8 MB ( 0.1% )
| Schema AUDSYS        occupies      1.9 MB ( 0.1% )
| Schema GSMADMIN_INT  occupies      0.9 MB ( 0.0% )
| Schema DBSNMP        occupies      0.6 MB ( 0.0% )
|
********************************************************
(1b) SYSAUX occupants space usage (v$sysaux_occupants)
********************************************************

|
| Occupant Name        Schema Name          Space Usage
| -------------------- -------------------- ----------------
| SM/AWR               SYS                   1,200.0 MB
| SM/OPTSTAT           SYS                     224.9 MB
| SDO                  MDSYS                   168.9 MB
| XDB                  XDB                      68.4 MB
| SM/OTHER             SYS                      50.8 MB
| AO                   SYS                      45.8 MB
| SM/ADVISOR           SYS                      21.1 MB
| LOGMNR               SYSTEM                   10.8 MB
| WM                   WMSYS                     6.6 MB
| JOB_SCHEDULER        SYS                       4.1 MB
| SQL_MANAGEMENT_BASE  SYS                       3.8 MB
| SMON_SCN_TIME        SYS                       3.3 MB
| PL/SCOPE             SYS                       2.9 MB
| TEXT                 CTXSYS                    2.8 MB
| AUDSYS               AUDSYS                    1.9 MB
| STREAMS              SYS                       1.7 MB
| LOGSTDBY             SYSTEM                    1.6 MB
| EM_MONITORING_USER   DBSNMP                    0.6 MB
| AUTO_TASK            SYS                       0.6 MB
| AUDIT_TABLES         SYS                       0.0 MB
| EM                   SYSMAN                    0.0 MB
| EXPRESSION_FILTER    EXFSYS                    0.0 MB
| ORDIM                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)                   139.9 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 GSMADMIN_INT occupies                   0.9 MB
|
| Total space                                    5.4 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              134.5 MB
|
| Total space                                  134.5 MB
|
*************************************
(2) Size estimates for AWR snapshots
*************************************
|
| Estimates based on 20 mins snapshot INTERVAL:
| AWR size/day                      94.0 MB (1,337 K/snap * 72 snaps/day)
| AWR size/wk                      658.1 MB (size_per_day * 7) per instance
|
| Estimates based on 27 snaps in past 24 hours:
| AWR size/day                      35.3 MB (1,337 K/snap and 27 snaps in past 24 hours)
| AWR size/wk                      246.8 MB (size_per_day * 7) per instance
|

**********************************
(3a) Space usage by AWR components (per database)
**********************************


COMPONENT        MB  % AWR  KB_PER_SNAP MB_PER_DAY MB_PER_WEEK TABLE% : INDEX%
--------- --------- ------ ------------ ---------- ----------- ----------------
FIXED         769.8 64.1 858 22.6 158.3 44% : 56%
EVENTS        275.2 22.9 307 8.1 56.6 42% : 58%
SQL            42.2 3.5 47 1.2 8.7 61% : 39%
SPACE          38.8 3.2 43 1.1 8.0 60% : 40%
SQLPLAN        16.0 1.3 18 0.5 3.3 69% : 31%
ASH             9.4 0.8 10 0.3 1.9 71% : 29%
SQLTEXT         2.3 0.2 3 0.1 0.5 89% : 11%
SQLBIND         1.1 0.1 1 0.0 0.2 50% : 50%
RAC             0.6 0.1 1 0.0 0.1 50% : 50%

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


COMPONENT   MB SEGMENT_NAME - % SPACE_USED                              SEGMENT_TYPE
--------- ---- -------------------------------------------------------- ---------------
FIXED     18.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_1863203691_965 - 78% INDEX PARTITION
FIXED     15.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_1863203691_1120 - 79% INDEX PARTITION
FIXED     13.0 WRH$_SYSMETRIC_SUMMARY - 96% TABLE
FIXED     13.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_1863203691_1251 - 77% INDEX PARTITION
FIXED     13.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_1863203691_851 - 79% INDEX PARTITION
FIXED     12.0 WRH$_SYSSTAT.WRH$_SYSSTAT_1863203691_965 - 91% TABLE PARTITION
FIXED     12.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_1863203691_650 - 79% INDEX PARTITION
FIXED     11.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_1863203691_758 - 75% INDEX PARTITION
FIXED     11.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_1863203691_1364 - 78% INDEX PARTITION
FIXED     10.0 WRH$_LATCH.WRH$_LATCH_1863203691_965 - 95% TABLE PARTITION
FIXED     10.0 WRH$_LATCH_PK.WRH$_LATCH_1863203691_965 - 74% INDEX PARTITION
FIXED     10.0 WRH$_SYSSTAT.WRH$_SYSSTAT_1863203691_1120 - 94% TABLE PARTITION
FIXED      9.0 WRH$_SYSSTAT.WRH$_SYSSTAT_1863203691_650 - 83% TABLE PARTITION
FIXED      9.0 WRH$_CON_SYSMETRIC_SUMMARY - 83% TABLE
FIXED      9.0 WRH$_LATCH.WRH$_LATCH_1863203691_1120 - 84% TABLE PARTITION
FIXED      9.0 WRH$_SYSSTAT.WRH$_SYSSTAT_1863203691_1251 - 89% TABLE PARTITION
FIXED      9.0 WRH$_SYSSTAT.WRH$_SYSSTAT_1863203691_851 - 88% TABLE PARTITION
FIXED      8.0 WRH$_SYSSTAT.WRH$_SYSSTAT_1863203691_1364 - 85% TABLE PARTITION
FIXED      8.0 WRH$_LATCH_PK.WRH$_LATCH_1863203691_1120 - 77% INDEX PARTITION
FIXED      8.0 WRH$_LATCH.WRH$_LATCH_1863203691_851 - 82% TABLE PARTITION
FIXED      8.0 WRH$_LATCH.WRH$_LATCH_1863203691_1251 - 82% TABLE PARTITION
FIXED      8.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_1863203691_584 - 79% INDEX PARTITION
FIXED      8.0 WRH$_CON_SYSMET_SUMMARY_INDEX - 63% INDEX
FIXED      7.0 WRH$_SYSSTAT.WRH$_SYSSTAT_1863203691_758 - 97% TABLE PARTITION
FIXED      7.0 WRH$_LATCH_PK.WRH$_LATCH_1863203691_650 - 78% INDEX PARTITION
FIXED      7.0 WRH$_LATCH_PK.WRH$_LATCH_1863203691_1251 - 77% INDEX PARTITION
FIXED      7.0 WRH$_LATCH.WRH$_LATCH_1863203691_1364 - 79% TABLE PARTITION
FIXED      7.0 WRH$_LATCH.WRH$_LATCH_1863203691_650 - 95% TABLE PARTITION
FIXED      7.0 WRH$_LATCH_PK.WRH$_LATCH_1863203691_851 - 76% INDEX PARTITION
FIXED      6.0 WRH$_CON_SYSSTAT_PK.WRH$_CON_SYSSTAT_1863203691_965 - 66% INDEX PARTITION
EVENTS     16.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_1863203691_965 - 77% INDEX PARTITION
EVENTS     15.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_1863203691_1120 - 77% INDEX PARTITION
EVENTS     13.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_1863203691_1251 - 77% INDEX PARTITION
EVENTS     12.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_1863203691_650 - 82% INDEX PARTITION
EVENTS     11.0 WRH$_ENQUEUE_STAT_PK - 64% INDEX
EVENTS     11.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_1863203691_965 - 89% TABLE PARTITION
EVENTS     11.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_1863203691_1364 - 79% INDEX PARTITION
EVENTS     10.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_1863203691_1120 - 89% TABLE PARTITION
EVENTS     10.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_1863203691_851 - 78% INDEX PARTITION
EVENTS      9.0 WRH$_BG_EVENT_SUMMARY_PK - 66% INDEX
EVENTS      9.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_1863203691_1251 - 89% TABLE PARTITION
EVENTS      9.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_1863203691_650 - 82% TABLE PARTITION
EVENTS      9.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_1863203691_758 - 73% INDEX PARTITION
EVENTS      8.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_1863203691_1364 - 80% TABLE PARTITION
EVENTS      8.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_1863203691_584 - 77% INDEX PARTITION
EVENTS      7.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_1863203691_851 - 95% TABLE PARTITION
EVENTS      7.0 WRH$_ENQUEUE_STAT - 94% TABLE
EVENTS      6.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_1863203691_758 - 88% TABLE PARTITION
EVENTS      6.0 WRH$_BG_EVENT_SUMMARY - 93% TABLE
EVENTS      5.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_1863203691_584 - 90% TABLE PARTITION
EVENTS      4.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_1863203691_527 - 78% INDEX PARTITION
EVENTS      3.0 WRH$_CON_SYSTEM_EVENT_PK.WRH$_CON_SYSTEM_EVENT_1863203691_112 - 71% INDEX PARTITION
EVENTS      3.0 WRH$_CON_SYSTEM_EVENT.WRH$_CON_SYSTEM_EVENT_1863203691_965 - 61% TABLE PARTITION
EVENTS      3.0 WRH$_CON_SYSTEM_EVENT_PK.WRH$_CON_SYSTEM_EVENT_1863203691_965 - 69% INDEX PARTITION
EVENTS      3.0 WRH$_LIBRARYCACHE_PK - 65% INDEX
EVENTS      3.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_1863203691_527 - 59% TABLE PARTITION
EVENTS      3.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_1863203691_560 - 79% INDEX PARTITION
EVENTS      3.0 WRH$_LIBRARYCACHE - 54% TABLE
EVENTS      2.0 WRH$_CON_SYSTEM_EVENT.WRH$_CON_SYSTEM_EVENT_1863203691_1120 - 78% TABLE PARTITION
EVENTS      2.0 WRH$_CON_SYSTEM_EVENT.WRH$_CON_SYSTEM_EVENT_1863203691_1251 - 64% TABLE PARTITION
SQL         4.0 WRH$_SQLSTAT.WRH$_SQLSTAT_1863203691_965 - 74% TABLE PARTITION
SQL         3.0 WRH$_SQLSTAT.WRH$_SQLSTAT_1863203691_1251 - 66% TABLE PARTITION
SQL         3.0 WRH$_SQLSTAT.WRH$_SQLSTAT_1863203691_1120 - 96% TABLE PARTITION
SQL         3.0 WRH$_SQLSTAT.WRH$_SQLSTAT_1863203691_650 - 56% TABLE PARTITION
SQL         3.0 WRH$_SQLSTAT.WRH$_SQLSTAT_1863203691_1364 - 56% TABLE PARTITION
SQL         3.0 WRH$_SQLSTAT.WRH$_SQLSTAT_1863203691_851 - 72% TABLE PARTITION
SQL         2.0 WRH$_SQLSTAT_PK.WRH$_SQLSTAT_1863203691_965 - 75% INDEX PARTITION
SQL         2.0 WRH$_SQLSTAT.WRH$_SQLSTAT_1863203691_758 - 90% TABLE PARTITION
SQL         2.0 WRH$_SQLSTAT_PK.WRH$_SQLSTAT_1863203691_1120 - 59% INDEX PARTITION
SQL 2.0 WRH$_SQLSTAT.WRH$_SQLSTAT_1863203691_584 - 48% TABLE PARTITION
SQL 1.0 WRH$_SQLSTAT_PK.WRH$_SQLSTAT_1863203691_851 - 62% INDEX PARTITION
SQL 0.9 WRH$_SQLSTAT_PK.WRH$_SQLSTAT_1863203691_1251 - 63% INDEX PARTITION
SQL 0.9 WRH$_SQLSTAT.WRH$_SQLSTAT_1863203691_527 - 88% TABLE PARTITION
SQL 0.9 WRH$_SQLSTAT_INDEX.WRH$_SQLSTAT_1863203691_965 - 75% INDEX PARTITION
SQL 0.9 WRH$_SQLSTAT_PK.WRH$_SQLSTAT_1863203691_650 - 63% INDEX PARTITION
SQL 0.9 WRH$_SQLSTAT_PK.WRH$_SQLSTAT_1863203691_1364 - 62% INDEX PARTITION
SQL 0.8 WRH$_SQLSTAT_PK.WRH$_SQLSTAT_1863203691_758 - 63% INDEX PARTITION
SQL 0.8 WRH$_SQLSTAT_INDEX.WRH$_SQLSTAT_1863203691_1120 - 74% INDEX PARTITION
SQL 0.6 WRH$_SQLSTAT.WRH$_SQLSTAT_1863203691_560 - 88% TABLE PARTITION
SQL 0.6 WRH$_SQLSTAT_INDEX.WRH$_SQLSTAT_1863203691_851 - 76% INDEX PARTITION
SQL 0.6 WRH$_SQLSTAT_INDEX.WRH$_SQLSTAT_1863203691_1251 - 74% INDEX PARTITION
SQL         0.6 WRH$_SQLSTAT_INDEX.WRH$_SQLSTAT_1863203691_650 - 73% INDEX PARTITION
SQL         0.6 WRH$_SQL_WORKAREA_HISTOGRAM - 82% TABLE
SQL         0.6 WRH$_SQLSTAT_PK.WRH$_SQLSTAT_1863203691_584 - 64% INDEX PARTITION
SQL         0.6 WRH$_SQL_WORKAREA_HIST_PK - 85% INDEX
SQL         0.6 WRH$_SQLSTAT_INDEX.WRH$_SQLSTAT_1863203691_1364 - 75% INDEX PARTITION
SQL         0.5 WRH$_SQLSTAT_INDEX.WRH$_SQLSTAT_1863203691_758 - 73% INDEX PARTITION
SPACE 3.0 WRH$_SEG_STAT.WRH$_SEG_STAT_1863203691_965 - 58% TABLE PARTITION
SPACE 2.0 WRH$_SEG_STAT_PK.WRH$_SEG_STAT_1863203691_965 - 71% INDEX PARTITION
SPACE 2.0 WRH$_SEG_STAT_PK.WRH$_SEG_STAT_1863203691_1120 - 42% INDEX PARTITION
SPACE 2.0 WRH$_SEG_STAT.WRH$_SEG_STAT_1863203691_851 - 53% TABLE PARTITION
SPACE 2.0 WRH$_SEG_STAT.WRH$_SEG_STAT_1863203691_758 - 36% TABLE PARTITION
SPACE 2.0 WRH$_SEG_STAT.WRH$_SEG_STAT_1863203691_650 - 53% TABLE PARTITION
SPACE 2.0 WRH$_SEG_STAT.WRH$_SEG_STAT_1863203691_1364 - 42% TABLE PARTITION
SPACE 2.0 WRH$_SEG_STAT.WRH$_SEG_STAT_1863203691_1251 - 56% TABLE PARTITION
SPACE 2.0 WRH$_SEG_STAT.WRH$_SEG_STAT_1863203691_1120 - 76% TABLE PARTITION
SPACE 2.0 WRH$_IOSTAT_FILETYPE_PK - 74% INDEX
SPACE 2.0 WRH$_IOSTAT_FILETYPE - 43% TABLE
SPACE 0.9 WRH$_SEG_STAT.WRH$_SEG_STAT_1863203691_584 - 90% TABLE PARTITION
SPACE 0.9 WRH$_SEG_STAT_PK.WRH$_SEG_STAT_1863203691_1251 - 63% INDEX PARTITION
SPACE 0.9 WRH$_TABLESPACE_SPACE_USAGE - 82% TABLE
SPACE 0.9 WRH$_SEG_STAT_PK.WRH$_SEG_STAT_1863203691_650 - 63% INDEX PARTITION
SPACE 0.9 WRH$_SEG_STAT_PK.WRH$_SEG_STAT_1863203691_851 - 63% INDEX PARTITION
SPACE 0.8 WRH$_SEG_STAT_PK.WRH$_SEG_STAT_1863203691_758 - 65% INDEX PARTITION
SPACE 0.8 WRH$_SEG_STAT_PK.WRH$_SEG_STAT_1863203691_1364 - 62% INDEX PARTITION
SPACE 0.6 WRH$_SEG_STAT_PK.WRH$_SEG_STAT_1863203691_584 - 61% INDEX PARTITION
SPACE 0.5 WRH$_SEG_STAT_OBJ_INDEX - 44% INDEX
SPACE 0.5 WRH$_SEG_STAT.WRH$_SEG_STAT_1863203691_527 - 81% TABLE PARTITION
SQLPLAN 11.0 WRH$_SQL_PLAN - 71% TABLE
SQLPLAN 5.0 WRH$_SQL_PLAN_PK - 54% INDEX
ASH 1.0 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_SESSION_HISTORY_18632 - 83% TABLE PARTITION
ASH 0.8 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_SESSION_HISTORY_18632 - 84% TABLE PARTITION
ASH 0.8 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_SESSION_HISTORY_18632 - 88% TABLE PARTITION
ASH 0.8 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_SESSION_HISTORY_18632 - 90% TABLE PARTITION
ASH 0.7 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_SESSION_HISTORY_18632 - 89% TABLE PARTITION
ASH     0.6 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_SESSION_HISTORY_18632 - 76% TABLE PARTITION
ASH     0.6 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_SESSION_HISTORY_18632 - 80% TABLE PARTITION
ASH     0.6 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_SESSION_HISTORY_18632 - 85% TABLE PARTITION
ASH     0.5 WRH$_ACTIVE_SESSION_HISTORY.WRH$_ACTIVE_SESSION_HISTORY_18632 - 86% TABLE PARTITION
SQLTEXT 2.0 WRH$_SQLTEXT - 47% TABLE
SQLBIND 0.6 WRH$_SQL_BIND_METADATA - 79% TABLE
SQLBIND 0.6 WRH$_SQL_BIND_METADATA_PK - 69% INDEX

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


COMPONENT   MB SEGMENT_NAME                               SEGMENT_TYPE
--------- ---- ------------------------------------------ ---------------
NON_AWR   80.0 SYS.I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST         INDEX
NON_AWR   56.1 MDSYS.SYS_LOB0000064019C00006$$            LOBSEGMENT
NON_AWR   56.1 MDSYS.SYS_LOB0000067001C00006$$            LOBSEGMENT
NON_AWR   40.2 SYS.SYS_LOB0000011147C00038$$              LOBSEGMENT
NON_AWR   40.1 SYS.SYS_LOB0000007422C00004$$              LOBSEGMENT
NON_AWR   38.0 SYS.I_WRI$_OPTSTAT_H_ST                    INDEX
NON_AWR   24.2 SYS.SYS_LOB0000066364C00004$$              LOBSEGMENT
NON_AWR   16.2 MDSYS.SYS_LOB0000067285C00002$$            LOBSEGMENT
NON_AWR   12.0 SYS.PRIV_UNUSED_PATH$                      TABLE
NON_AWR   12.0 SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST          INDEX
NON_AWR    9.0 MDSYS.EXT_TAB_CS_SRS                       TABLE
NON_AWR    9.0 MDSYS.SDO_CS_SRS                           TABLE
NON_AWR    8.0 SYS.HEATMAP                                SYSTEM STATISTICS
NON_AWR    7.2 SYS.SYS_LOB0000066349C00004$$              LOBSEGMENT
NON_AWR    6.0 SYS.UNUSED_GRANT$                          TABLE
NON_AWR    6.0 SYS.I_WRI$_OPTSTAT_HH_ST                   INDEX
NON_AWR    5.1 SYS.SYS_LOB0000010461C00001$$              LOBSEGMENT
NON_AWR    4.2 SYS.SYS_LOB0000011139C00004$$              LOBSEGMENT
NON_AWR    4.0 SYS.WRI$_OPTSTAT_OPR_TASKS                 TABLE
NON_AWR    4.0 SYS.WRI$_ADV_PARAMETERS_PK                 INDEX
NON_AWR    4.0 SYS.PRIV_UNUSED$                           TABLE
NON_AWR    3.2 SYS.SYS_LOB0000066344C00004$$              LOBSEGMENT
NON_AWR    3.2 SYS.SYS_LOB0000066354C00004$$              LOBSEGMENT
NON_AWR    3.0 SYS.WRI$_ADV_PARAMETERS                    TABLE
NON_AWR    3.0 SYS.I_WRI$_OPTSTAT_OPR_TASKS_TGST          INDEX
NON_AWR    3.0 SYS.SMON_SCN_TO_TIME_AUX                   CLUSTER
NON_AWR 3.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1087 TABLE PARTITION
NON_AWR 3.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1043 TABLE PARTITION
NON_AWR 3.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1009 TABLE PARTITION
NON_AWR 3.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1000 TABLE PARTITION
NON_AWR 3.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P940 TABLE PARTITION
NON_AWR 3.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P913 TABLE PARTITION
NON_AWR 3.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P845 TABLE PARTITION
NON_AWR 3.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P808 TABLE PARTITION
NON_AWR 3.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P760 TABLE PARTITION
NON_AWR 2.2 SYS.SYS_LOB0000008766C00040$$ LOBSEGMENT
NON_AWR 2.2 SYS.SYS_LOB0000066369C00004$$ LOBSEGMENT
NON_AWR 2.2 SYS.SYS_LOB0000066359C00004$$ LOBSEGMENT
NON_AWR 2.0 SYS.SCHEDULER$_EVENT_LOG TABLE
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 XDB.XDB$ELEMENT TABLE
NON_AWR 2.0 SYS.I_WRI$_OPTSTAT_OPR_TASKS_OPOBJ INDEX
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1100 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1078 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1074 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1034 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P1020 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P985 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P981 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P967 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P958 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P904 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P883 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P874 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P865 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P829 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P785 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P754 TABLE PARTITION
NON_AWR 2.0 SYS.CAPTURED_PRIV$ TABLE
NON_AWR 1.2 SYS.SYS_LOB0000000352C00005$$ LOBSEGMENT
NON_AWR 1.2 MDSYS.SYS_LOB0000070532C00003$$ LOBSEGMENT
NON_AWR 1.2 MDSYS.SYS_LOB0000067006C00002$$ LOBSEGMENT
NON_AWR 1.2 MDSYS.SYS_LOB0000064820C00003$$ LOBSEGMENT
NON_AWR 1.2 XDB.SYS_LOB0000021719C00025$$ LOBSEGMENT
NON_AWR 1.2 XDB.SYS_LOB0000021665C00023$$ LOBSEGMENT
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P1068 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P1037 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P1023 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P1003 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P975 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P961 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P943 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P868 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P823 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P748 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P779 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P1028 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P1119 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P988 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P1081 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P970 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P899 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P1063 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P802 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P788 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P763 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P877 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P740 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P812 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P1090 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P1103 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P948 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P1012 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P797 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007451C00009$$.SYS_LOB_P907 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000009065C00008$$           LOBSEGMENT
NON_AWR 1.2 SYS.SYS_LOB0000007422C00005$$           LOBSEGMENT
NON_AWR    1.1 SYS.SYS_LOB0000009069C00005$$           LOBSEGMENT

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


Total snapshots in DB 1863203691 Instance 1 = 919

      DBID  SNAP_ID  INST FLUSH_ELAPSED      ENDTM            STARTUP_TIME     STATUS ERRCNT
---------- -------- ----- ------------------ ---------------- ---------------- ------ ---
1863203691 1413 1 +00000 00:00:00.1 19:40:46 (09/01) 00:27:10 (08/15) 0 0
1863203691 1414 1 +00000 00:00:00.1 20:00:47 (09/01) 00:27:10 (08/15) 0 0
1863203691 1415 1 +00000 00:00:00.6 20:20:51 (09/01) 00:27:10 (08/15) 0 0
1863203691 1416 1 +00000 00:00:00.1 20:40:55 (09/01) 00:27:10 (08/15) 0 0
1863203691 1417 1 +00000 00:00:00.9 21:19:19 (09/01) 00:27:10 (08/15) 0 0
1863203691 1418 1 +00000 00:00:00.5 21:40:23 (09/01) 00:27:10 (08/15) 0 0
1863203691 1419 1 +00000 00:00:00.6 22:00:24 (09/01) 00:27:10 (08/15) 0 0
1863203691 1420 1 +00000 00:00:00.4 22:20:25 (09/01) 00:27:10 (08/15) 0 0
1863203691 1421 1 +00000 00:00:00.5 22:40:32 (09/01) 00:27:10 (08/15) 0 0
1863203691 1422 1 +00000 00:00:00.1 23:00:34 (09/01) 00:27:10 (08/15) 0 0
1863203691 1423 1 +00000 00:00:00.1 23:20:37 (09/01) 00:27:10 (08/15) 0 0
1863203691 1424 1 +00000 00:00:01.4 06:33:47 (09/02) 00:27:10 (08/15) 0 0
1863203691 1425 1 +00000 00:00:00.1 07:00:55 (09/02) 00:27:10 (08/15) 0 0
1863203691 1426 1 +00000 00:00:01.5 08:11:31 (09/02) 00:27:10 (08/15) 0 0
1863203691 1427 1 +00000 00:00:00.3 08:40:47 (09/02) 00:27:10 (08/15) 0 0
1863203691 1428 1 +00000 00:00:00.1 09:00:52 (09/02) 00:27:10 (08/15) 0 0
1863203691 1429 1 +00000 00:00:00.1 09:20:57 (09/02) 00:27:10 (08/15) 0 0
1863203691 1430 1 +00000 00:00:00.1 09:40:01 (09/02) 00:27:10 (08/15) 0 0
1863203691 1431 1 +00000 00:00:00.6 10:00:05 (09/02) 00:27:10 (08/15) 0 0
1863203691 1432 1 +00000 00:00:00.7 10:20:09 (09/02) 00:27:10 (08/15) 0 0
1863203691 1433 1 +00000 00:00:01.5 12:53:50 (09/02) 00:27:10 (08/15) 0 0
1863203691 1434 1 +00000 00:00:00.1 13:20:04 (09/02) 00:27:10 (08/15) 0 0
1863203691 1435 1 +00000 00:00:00.1 13:40:07 (09/02) 00:27:10 (08/15) 0 0
1863203691 1436 1 +00000 00:00:00.8 14:43:54 (09/02) 00:27:10 (08/15) 0 0
1863203691 1437 1 +00000 00:00:00.6 15:00:58 (09/02) 00:27:10 (08/15) 0 0
1863203691 1438 1 +00000 00:00:00.1 15:20:02 (09/02) 00:27:10 (08/15) 0 0
1863203691 1439 1 +00000 00:00:00.7 16:53:08 (09/02) 00:27:10 (08/15) 0 0
1863203691 1440 1 +00000 00:00:00.1 17:20:16 (09/02) 00:27:10 (08/15) 0 0
1863203691 1441 1 +00000 00:00:00.3 17:40:20 (09/02) 00:27:10 (08/15) 0 0
1863203691 1442 1 +00000 00:00:00.4 18:00:24 (09/02) 00:27:10 (08/15) 0 0
1863203691 1443 1 +00000 00:00:00.8 18:38:32 (09/02) 00:27:10 (08/15) 0 0
1863203691 1444 1 +00000 00:00:00.3 19:00:39 (09/02) 00:27:10 (08/15) 0 0
1863203691 1445 1 +00000 00:00:00.1 19:20:55 (09/02) 00:27:10 (08/15) 0 0
1863203691 1446 1 +00000 00:00:00.1 19:40:59 (09/02) 00:27:10 (08/15) 0 0
1863203691 1447 1 +00000 00:00:01.4 21:28:39 (09/02) 00:27:10 (08/15) 0 0
1863203691 1448 1 +00000 00:00:00.1 21:40:43 (09/02) 00:27:10 (08/15) 0 0
1863203691 1449 1 +00000 00:00:00.1 22:00:49 (09/02) 00:27:10 (08/15) 0 0
1863203691 1450 1 +00000 00:00:00.1 22:20:02 (09/02) 00:27:10 (08/15) 0 0
1863203691 1451 1 +00000 00:00:00.2 22:40:03 (09/02) 00:27:10 (08/15) 0 0
1863203691 1452 1 +00000 00:00:01.1 23:05:48 (09/02) 22:55:27 (09/02) 0 0
1863203691 1453 1 +00000 00:00:00.4 23:20:50 (09/02) 22:55:27 (09/02) 0 0
1863203691 1454 1 +00000 00:00:00.3 04:28:02 (09/03) 22:55:27 (09/02) 0 0
1863203691 1455 1 +00000 00:00:00.1 08:29:20 (09/03) 22:55:27 (09/02) 0 0
1863203691 1456 1 +00000 00:00:00.1 08:40:23 (09/03) 22:55:27 (09/02) 0 0
1863203691 1457 1 +00000 00:00:00.3 09:00:33 (09/03) 22:55:27 (09/02) 0 0
1863203691 1458 1 +00000 00:00:00.3 09:20:43 (09/03) 22:55:27 (09/02) 0 0
1863203691 1459 1 +00000 00:00:00.7 11:50:58 (09/03) 22:55:27 (09/02) 0 0
1863203691 1460 1 +00000 00:00:00.1 12:20:04 (09/03) 22:55:27 (09/02) 0 0
1863203691 1461 1 +00000 00:00:00.2 13:45:38 (09/03) 22:55:27 (09/02) 0 0
1863203691 1462 1 +00000 00:00:00.4 14:00:48 (09/03) 22:55:27 (09/02) 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
---------- ----- ------- ---------------- ------ -----------
1863203691     1     544 00:03:16 (08/02)      0           0

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


      DBID LSNAPID LSPLITID LSNAPTIME      LPURGETIME     FLAG INTERVAL          RETENTION         VRSN
---------- ------- -------- -------------- -------------- ---- ----------------- ----------------- ----
1863203691    1462     1364 09/03 14:00:49 09/02 23:24:36    2 +00000 00:20:00.0 +00032 00:00:00.0 30

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


 SNAP_ID  INST  ASH  SQL  SQBND  FILES  SEGST  SYSEVT
-------- ----- ---- ---- ------ ------ ------ -------
    1413     1   17   75    326      0     82     167
    1414     1   19   71    339      0     83     167
    1415 1 16 82 334 0 82 167
1416 1 22 81 324 0 81 167
1417 1 14 77 263 0 83 167
1418 1 37 96 1857 0 86 167
1419 1 14 74 317 0 84 167
1420 1 15 78 311 0 84 167
1421 1 15 75 349 0 80 167
1422 1 25 76 279 0 75 167
1423 1 28 73 317 0 84 167
1424 1 7 83 334 0 81 167
1425 1 20 75 303 0 84 167
1426 1 3 80 259 0 83 167
1427 1 33 74 302 0 81 167
1428 1 15 68 263 0 82 167
1429 1 14 75 258 0 83 167
1430 1 23 70 271 0 81 167
1431 1 28 69 306 0 82 167
1432 1 23 80 269 0 83 167
1433 1 6 89 324 0 87 167
1434 1 29 77 302 0 82 167
1435 1 26 68 269 0 82 167
1436 1 16 83 326 0 84 167
1437 1 41 74 251 0 85 168
1438 1 12 71 264 0 85 168
1439 1 5 77 297 0 82 168
1440 1 23 69 294 0 89 168
1441 1 17 73 283 0 80 168
1442 1 20 76 219 0 84 168
1443 1 13 67 271 0 84 168
1444 1 23 77 253 0 86 168
1445 1 22 72 293 0 82 168
1446 1 25 72 301 0 83 168
1447 1 2 73 205 0 84 168
1448 1 18 75 297 0 82 168
1449 1 24 100 1227 0 86 168
1450 1 14 76 771 0 83 168
1451 1 36 84 355 0 83 168
1452 1 23 101 267 0 58 95
1453 1 13 72 217 0 55 96
1454 1 16 79 234 0 50 97
1455 1 6 86 292 0 59 103
1456 1 13 70 255 0 52 104
1457 1 20 73 281 0 56 104
1458 1 16 68 213 0 54 105
1459 1 36 83 293 0 57 106
1460 1 24 85 701 0 72 110
1461 1 0 64 232 0 71 110
1462 1 18 69 219 0 70 110

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


SNAP_COUNT  INST   ASH  SQLSTAT  SQLBIND  FILES  SEGSTAT  SYSEVENT
---------- ----- ----- -------- -------- ------ -------- ---------
       919     1 22.99    76.85   446.13      0     81.4    159.49

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


 SQLTEXT  SQLPLAN  SQLBMETA  SEGOBJ  DATAFILE  TEMPFILE
-------- -------- --------- ------- --------- ---------
    1632    40360      6104    1602        12         0


########################################################
(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 03:38:41 (05/30) 15 8,274,096 AUTO COMPLETED
SYS/SPM Evolve 2/SYS_AUTO_SPM_EVOLVE_TASK 03:38:42 (05/30) AUTO INITIAL
SYS/SPM Evolve 3/SYS_AI_SPM_EVOLVE_TASK 03:38:42 (05/30) AUTO INITIAL
SYS/Statistics 7/INDIVIDUAL_STATS_ADVISOR_TASK 03:38:54 (05/30) CMD INITIAL
SYS/Statistics 6/AUTO_STATS_ADVISOR_TASK 03:38:54 (05/30) 58 8,274,174 CMD COMPLETED
SYS/ADDM 1476/ADDM:1863203691_1_1417 21:19:20 (09/01) 0 0 AUTO COMPLETED
SYS/ADDM 1477/ADDM:1863203691_1_1418 21:40:24 (09/01) 0 0 AUTO COMPLETED
SYS/ADDM 1478/ADDM:1863203691_1_1419 22:00:25 (09/01) 0 0 AUTO COMPLETED
SYS/ADDM 1479/ADDM:1863203691_1_1420 22:20:26 (09/01) 0 0 AUTO COMPLETED
SYS/ADDM 1480/ADDM:1863203691_1_1421 22:40:33 (09/01) 0 0 AUTO COMPLETED
SYS/ADDM 1481/ADDM:1863203691_1_1422 23:00:34 (09/01) 0 0 AUTO COMPLETED
SYS/ADDM 1482/ADDM:1863203691_1_1423 23:20:37 (09/01) 0 0 AUTO COMPLETED
SYS/ADDM 1483/ADDM:1863203691_1_1424 06:33:49 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1484/ADDM:1863203691_1_1425 07:00:55 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1485/ADDM:1863203691_1_1426 08:11:33 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1486/ADDM:1863203691_1_1427 08:40:48 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1487/ADDM:1863203691_1_1428 09:00:53 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1488/ADDM:1863203691_1_1429 09:20:58 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1489/ADDM:1863203691_1_1430 09:40:02 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1490/ADDM:1863203691_1_1431 10:00:06 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1491/ADDM:1863203691_1_1432 10:20:10 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1492/ADDM:1863203691_1_1433 12:53:52 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1493/ADDM:1863203691_1_1434 13:20:04 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1494/ADDM:1863203691_1_1435 13:40:07 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1495/ADDM:1863203691_1_1436 14:43:55 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1496/ADDM:1863203691_1_1437 15:00:59 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1497/ADDM:1863203691_1_1438 15:20:02 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1498/ADDM:1863203691_1_1439 16:53:09 (09/02) 1 1 AUTO COMPLETED
SYS/ADDM 1499/ADDM:1863203691_1_1440 17:20:17 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1500/ADDM:1863203691_1_1441 17:40:21 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1501/ADDM:1863203691_1_1442 18:00:25 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1502/ADDM:1863203691_1_1443 18:38:33 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1503/ADDM:1863203691_1_1444 19:00:40 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1504/ADDM:1863203691_1_1445 19:20:55 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1505/ADDM:1863203691_1_1446 19:41:00 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1506/ADDM:1863203691_1_1447 21:28:41 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1507/ADDM:1863203691_1_1448 21:40:43 (09/02) 1 1 AUTO COMPLETED
SYS/ADDM 1508/ADDM:1863203691_1_1449 22:00:50 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1509/ADDM:1863203691_1_1450 22:20:03 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1510/ADDM:1863203691_1_1451 22:40:04 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1511/ADDM:1863203691_1_1453 23:20:51 (09/02) 0 0 AUTO COMPLETED
SYS/ADDM 1512/ADDM:1863203691_1_1454 04:28:03 (09/03) 0 0 AUTO COMPLETED
SYS/ADDM 1513/ADDM:1863203691_1_1455 08:29:20 (09/03) 0 0 AUTO COMPLETED
SYS/ADDM 1514/ADDM:1863203691_1_1456 08:40:24 (09/03) 0 0 AUTO COMPLETED
SYS/ADDM 1515/ADDM:1863203691_1_1457 09:00:34 (09/03) 0 0 AUTO COMPLETED
SYS/ADDM 1516/ADDM:1863203691_1_1458 09:20:44 (09/03) 0 0 AUTO COMPLETED
SYS/ADDM 1517/ADDM:1863203691_1_1459 11:50:59 (09/03) 0 0 AUTO COMPLETED
SYS/ADDM 1518/ADDM:1863203691_1_1460 12:20:04 (09/03) 0 0 AUTO COMPLETED
SYS/ADDM 1519/ADDM:1863203691_1_1461 13:45:39 (09/03) 0 1 AUTO COMPLETED
SYS/ADDM 1520/ADDM:1863203691_1_1462 14:00:49 (09/03) 0 0 AUTO COMPLETED


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


OWNER/ADVISOR  TASK_ID/NAME                CREATED          EXE_DURATN EXE_CREATN HOW_C STATUS
-------------- --------------------------- ---------------- ---------- ---------- ----- ----------
SYS/ADDM       616/ADDM:1863203691_1_561   06:06:40 (08/04)          0          0 AUTO  COMPLETED
SYS/ADDM       617/ADDM:1863203691_1_562   07:01:00 (08/04)          0          0 AUTO COMPLETED
SYS/ADDM       618/ADDM:1863203691_1_563   08:00:30 (08/04)          0          0 AUTO COMPLETED
SYS/ADDM       619/ADDM:1863203691_1_564   09:05:51 (08/04)          0          0 AUTO COMPLETED
SYS/ADDM       620/ADDM:1863203691_1_565   10:00:59 (08/04)          0          0 AUTO COMPLETED

**********************************
(3) Advisor Tasks With Errors - Last 50
**********************************


OWNER/ADVISOR  TASK_ID/NAME               CREATED EXE_DURATN EXE_CREATN HOW_C STATUS   TASK_DESC   ERROR_MSG
-------------- -------------------------- ---------------- ---------- ---------- ----- ------------
SYS/SPM Evolve 2/SYS_AUTO_SPM_EVOLVE_TASK 03:38:42 (05/30) AUTO INITIAL
Description: Automatic SPM Evolve Task
Error Msg :

SYS/SPM Evolve 3/SYS_AI_SPM_EVOLVE_TASK 03:38:42 (05/30) AUTO INITIAL
Description: Automatic SPM Evolve Task
Error Msg :

SYS/Statistics 7/INDIVIDUAL_STATS_ADVISOR_TASK 03:38:54 (05/30) CMD INITIAL
Description:
Error Msg :


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

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

NUM_ACTIVE_SESSIONS   NUM_SAMPLES
-------------------- ------------
0000 - 0004                   212
0005 - 0009                     7

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

NUM_ACTIVE_SESSIONS   NUM_SAMPLES
-------------------- ------------
0000 - 0004                    69
0005 - 0009                     2

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

INST MIN_TIME         MAX_TIME          NUM_SAMPLES  NUM_ROWS AVG_ACTIVE
---- ---------------- ---------------- ------------ --------- ----------
   1 08:04:41 (11/25) 04:53:32 (11/28)       19,229       309       0.02

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

INST MIN_TIME         MAX_TIME          NUM_SAMPLES  NUM_ROWS AVG_ACTIVE
---- ---------------- ---------------- ------------ --------- ----------
1 08:05:41 (11/27)    04:53:32 (11/28)        5,251        92       0.02

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

Foreground %           13.0
Background %           87.0
MMNL %                  0.0
End of Report

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

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