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
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
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