如何评估oracle AWR 的在oracle 中的存储情况(一)

2014-11-24 17:08:29 · 作者: · 浏览: 0

如何评估oracle AWR 的在oracle 中的存储情况

如果把awr保存时间从默认的7天修改为30天,采样时间从1小时修改到更短,修改之后如何预估空间占用?
------------------->用这个看下信息@$oracle_home/rdbms/admin/AWRINFO.sql

以下为样本信息:

SQL> @ /rdbms/admin/awrinfo

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 to continue, otherwise enter an alternative.

Enter value for report_name:

Using the report name awrinfo.txt
No errors.
No errors.
~~~~~~~~~~~~~~~
AWR INFO Report
~~~~~~~~~~~~~~~

Report generated at 06:54:12 on Dec 04, 2013 ( Wednesday ) in Timezone -05:00

Warning: Non Default AWR Setting!
--------------------------------------------------------------------------------
Snapshot interval is 60 minutes and Retention is 8 days


DB_ID DB_NAME HOST_PLATFORM INST STARTUP_TIME LAST_ASH_SID PAR
------------ --------- ---------------------------------------- ----- ----------------- ------------ ---
* 239394037 MYNEWDB oracle11g - Linux IA (32-bit) 1 08:17:27 (12/03) 1658805 NO

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

*****************************************************
(1a) SYSAUX usage - Schema breakdown (dba_segments)
*****************************************************
|
| Total SYSAUX size 561.6 MB ( 2% of 32,768.0 MB MAX with AUTOEXTEND ON )
|
| Schema SYS occupies 208.5 MB ( 37.1% )
| Schema XDB occupies 127.9 MB ( 22.8% )
| Schema APEX_030200 occupies 85.1 MB ( 15.1% )
| Schema MDSYS occupies 53.1 MB ( 9.4% )
| Schema SYSMAN occupies 46.6 MB ( 8.3% )
| Schema ORDDATA occupies 12.8 MB ( 2.3% )
| Schema SYSTEM occupies 9.3 MB ( 1.7% )
| Schema OLAPSYS occupies 7.3 MB ( 1.3% )
| Schema EXFSYS occupies 3.6 MB ( 0.6% )
| Schema CTXSYS occupies 3.5 MB ( 0.6% )
| Schema WMSYS occupies 3.1 MB ( 0.5% )
| Schema DBSNMP occupies 0.6 MB ( 0.1% )
| Schema ORDSYS occupies 0.4 MB ( 0.1% )
|
********************************************************
(1b) SYSAUX occupants space usage (v$sysaux_occupants)
********************************************************
|
| Occupant Name Schema Name Space Usage
| -------------------- -------------------- ----------------
| XDB XDB 127.9 MB
| SM/AWR SYS 93.1 MB
| SDO MDSYS 53.1 MB
| EM SYSMAN 46.6 MB
| SM/OPTSTAT SYS 37.8 MB
| AO SYS 33.0 MB
| XSOQHIST SYS 33.0 MB
| SM/ADVISOR SYS 13.2 MB
| ORDIM/ORDDATA ORDDATA 12.8 MB
| LOGMNR SYSTEM 7.9 MB
| SM/OTHER SYS 7.5 MB
| XSAMD OLAPSYS 7.3 MB
| EXPRESSION_FILTER EXFSYS 3.6 MB
| TEXT CTXSYS 3.5 MB
| SMON_SCN_TIME SYS 3.3 MB
| WM WMSYS 3.1 MB
| SQL_MANAGEMENT_BASE SYS 1.7 MB
| PL/SCOPE SYS 1.6 MB
| LOGSTDBY SYSTEM 1.4 MB
| JOB_SCHEDULER SYS 1.1 MB
| STREAMS SYS 1.0 MB
| EM_MONITORING_USER DBSNMP 0.6 MB
| ORDIM ORDSYS 0.4 MB
| AUTO_TASK SYS 0.3 MB
| AUDIT_TABLES SYS 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
|
| Others (Unaccounted space) 67.2 MB
|

******************************************
(1c) SYSAUX usage - Unregistered Schemas
******************************************

| This section displays schemas that are not registered
| in V$SYSAUX_OCCUPANTS
|
| Schema APEX_030200 occupies 85.1 MB
|
| Total space 85.1 MB
|

*************************************************************
(1d) SY