- 论坛徽章:
- 0
|
本文摘自
Oracle® Database Administrator's Guide
10g Release 2 (10.2)
Part Number B14231-02
控制SYSAUX的体积(Controlling the Size of the SYSAUX Tablespace)
SYS表空间中组件的数量(见表Table 2-2),还有这些组件占用的总空间量,这是组件占用的空间,反之,数据库工作负载的性质取决于所使用的特性或功能。
(The SYSAUX tablespace is occupied by a number of database components (see Table 2-2), and its total size is governed by the space consumed by those components. The space consumed by the components, in turn, depends on which features or functionality are being used and on the nature of the database workload.)
占用SYSAUX表空间最多的是自动负载信息库(Automatic Workload Repository,AWR)。AWR占用的空间取决于几个因素,特定时间内系统中的活动会话数,快照的间隔,历史数据保留周期。典型情况,平均30个并发活动会话的AWR大约需要200MB到300MB的空间。通过修改快照的间隔和历史记录的保留周期你可以控制AWR的体积。管理AWR快照间隔和保留时间的更多资料参考Oracle 数据库性能调优手册。
(The largest portion of the SYSAUX tablespace is occupied by the Automatic Workload Repository (AWR). The space consumed by the AWR is determined by several factors, including the number of active sessions in the system at any given time, the snapshot interval, and the historical data retention period. A typical system with an average of 30 concurrent active sessions may require approximately 200 to 300 MB of space for its AWR data. You can control the size of the AWR by changing the snapshot interval and historical data retention period. For more information on managing the AWR snapshot interval and retention period, please refer to Oracle Database Performance Tuning Guide.)
另一个占用SYSAUX表空间较多的是EM信息库,这个仓库是用于Oracle EM数据库控制来存储元数据,信息库的体积取决于数据库的活动情况和信息库中存储的相关配置信息。
(Another major occupant of the SYSAUX tablespace is the embedded Enterprise Manager (EM) repository. This repository is used by Oracle Enterprise Manager Database Control to store its metadata. The size of this repository depends on database activity and on configuration-related information stored in the repository.)
在SYSAUX表空间中其它数据库组件占用空间增长与它们相关的特性(例如,Oracle UltraSearch, Oracle文本, Oracle流)是否使用有关。如果这些特性没有被使用,这些组件对于SYSAUX空间没有显著影响。
(Other database components in the SYSAUX tablespace will grow in size only if their associated features (for example, Oracle UltraSearch, Oracle Text, Oracle Streams) are in use. If the features are not used, then these components do not have any significant effect on the size of the SYSAUX tablespace.) |
|