*************************************************************
|
| This section displays unaccounted space in the registered
| schemas of V$SYSAUX_OCCUPANTS.
|
| Unaccounted space in SYS/SYSTEM -17.9 MB
|
| Total space -17.9 MB
|
*************************************
(2) Size estimates for AWR snapshots
*************************************
|
| Estimates based on 60 mins snapshot INTERVAL:
| AWR size/day 97.1 MB (4,143 K/snap * 24 snaps/day)
| AWR size/wk 679.8 MB (size_per_day * 7) per instance
|
| Estimates based on 4 snaps in past 24 hours:
| AWR size/day 16.2 MB (4,143 K/snap and 4 snaps in past 24 hours)
| AWR size/wk 113.3 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 51.7 55.5 2,301 9.0 62.9 59% : 41%
SQLPLAN 11.0 11.8 490 1.9 13.4 73% : 27%
SQL 6.1 6.5 270 1.1 7.4 66% : 34%
EVENTS 4.6 4.9 203 0.8 5.6 51% : 49%
SPACE 4.1 4.4 181 0.7 4.9 58% : 42%
SQLTEXT 2.1 2.3 95 0.4 2.6 94% : 6%
SQLBIND 1.0 1.1 45 0.2 1.2 56% : 44%
ASH 0.8 0.9 36 0.1 1.0 62% : 38%
RAC 0.6 0.7 28 0.1 0.8 50% : 50%
**********************************
(3b) Space usage within AWR Components (> 500K)
**********************************
COMPONENT MB SEGMENT_NAME - % SPACE_USED SEGMENT_TYPE
--------- --------- --------------------------------------------------------------------- ---------------
FIXED 7.0 WRH$_LATCH_CHILDREN.WRH$_LATCH__239394037_521 - 88% TABLE PARTITION
FIXED 5.0 WRH$_SYSMETRIC_HISTORY - 29% TABLE
FIXED 4.0 WRH$_SYSMETRIC_HISTORY_INDEX - 35% INDEX
FIXED 4.0 WRH$_LATCH_CHILDREN_PK.WRH$_LATCH__239394037_521 - 97% INDEX PARTITION
FIXED 2.0 WRH$_LATCH.WRH$_LATCH_239394037_521 - 52% TABLE PARTITION
FIXED 2.0 WRH$_LATCH_CHILDREN.WRH$_LATCH__239394037_559 - 67% TABLE PARTITION
FIXED 2.0 WRH$_LATCH_PARENT.WRH$_LATCH__239394037_521 - 59% TABLE PARTITION
FIXED 2.0 WRH$_SYSMETRIC_SUMMARY - 17% TABLE
FIXED 0.9 WRH$_LATCH_CHILDREN_PK.WRH$_LATCH__239394037_559 - 91% INDEX PARTITION
FIXED 0.9 WRH$_PARAMETER.WRH$_PARAME_239394037_521 - 88% TABLE PARTITION
FIXED 0.8 WRH$_SYSSTAT_PK.WRH$_SYSSTA_239394037_521 - 90% INDEX PARTITION
FIXED 0.8 WRH$_SYSSTAT.WRH$_SYSSTA_239394037_521 - 86% TABLE PARTITION
FIXED 0.7 WRH$_LATCH_PK.WRH$_LATCH_239394037_521 - 90% INDEX PARTITION
FIXED 0.7 WRH$_LATCH_PARENT_PK.WRH$_LATCH__239394037_521 - 90% INDEX PARTITION
FIXED 0.6 WRH$_PARAMETER_PK.WRH$_PARAME_239394037_521 - 90% INDEX PARTITION
FIXED 0.5 WRH$_SYSMETRIC_SUMMARY_INDEX - 32% INDEX
SQLPLAN 8.0 WRH$_SQL_PLAN - 58% TABLE
SQLPLAN 3.0 WRH$_SQL_PLAN_PK - 39% INDEX
SQL 3.0 WRH$_SQLSTAT.WRH$_SQLSTA_239394037_521 - 72% TABLE PARTITION
SQL 0.7 WRH$_SQLSTAT_PK.WRH$_SQLSTA_239394037_521 - 63% INDEX PARTITION
SQL 0.6 WRH$_SQLSTAT.WRH$_SQLSTA_239394037_559 - 88% TABLE PARTITION
SQL 0.5 WRH$_SQLSTAT_INDEX.WRH$_SQLSTA_239394037_521 - 66% INDEX PARTITION
EVENTS 0.8 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT__239394037_521 - 91% INDEX PARTITION
EVENTS 0.7 WRH$_EVENT_HISTOGRAM.WRH$_EVENT__239394037_521 - 89% TABLE PARTITION
SPACE 0.9 WRH$_SEG_STAT.WRH$_SEG_ST_239394037_521 - 85% TABLE PARTITION
SQLTEXT 2.0 WRH$_SQLTEXT - 59% TABLE
SQLBIND 0.6 WRH$_SQL_BIND_METADATA - 47% TABLE
*********************************